Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-16031

PDOException SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'time_group_id' at row 1

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 14
    • Fix Version/s: None
    • Component/s: Core
    • Labels:
      None
    • ToDo:
    • Asterisk Version:
      14
    • Distro:
      Self Install Ubuntu

      Description

      Following failure occurs if in an Outbound route no Time Match Time Group is set. If I choose something else instead of "—Permanent Route—", no exception is thrown.

      Insert NULL instead of ''

      PDOException thrown with message "SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'time_group_id' at row 1"

      Stacktrace:
      #5 PDOException in /var/www/html/admin/modules/core/functions.inc.php:5439
      #4 PDOStatement:execute in /var/www/html/admin/modules/core/functions.inc.php:5439
      #3 core_routing_editbyid in /var/www/html/admin/modules/core/Core.class.php:1070
      #2 FreePBX\modules\Core:doConfigPageInit in /var/www/html/admin/libraries/BMO/GuiHooks.class.php:290
      #1 FreePBX\GuiHooks:doBMOConfigPage in /var/www/html/admin/libraries/BMO/GuiHooks.class.php:252
      #0 FreePBX\GuiHooks:doConfigPageInits in /var/www/html/admin/config.php:358

        Gliffy Diagrams

          Attachments

            Issue Links

            duplicates

            Bug - A problem which impairs or prevents the functions of the product. FREEPBX-16086 PDOException SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'time_group_id' at row 1

            • Minor - Minor loss of function, or other problem where easy workaround is present.
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. FREEPBX-12845 Cannot create queue due to database errors

            • Minor - Minor loss of function, or other problem where easy workaround is present.
            • Closed

              Activity

                People

                • Assignee:
                  tm1000 Andrew Nagy
                  Reporter:
                  fdanard Franck Danard [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    NextupJiraPlusStatus

                    Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.