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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Announcements
    • Labels:
      None
    • ToDo:
    • Asterisk Version:
      13.26.0
    • Distro Version:
      15.0.16.4
    • Distro:
      FreePBX Distro

      Description

      
      PDOException thrown with message "SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'allow_skip' at row 1"
      
      Stacktrace:
      #5 PDOException in /var/www/html/admin/modules/announcement/Announcement.class.php:160
      #4 PDOStatement:execute in /var/www/html/admin/modules/announcement/Announcement.class.php:160
      #3 FreePBX\modules\Announcement:addAnnouncement in /var/www/html/admin/modules/announcement/Announcement.class.php:226
      #2 FreePBX\modules\Announcement: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:418
      

      The error occurs both when creating and when updating an existing Announcement.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                vsc55 VSC55
              • 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.