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

Doctrine\DBAL\DBALException An exception occurred

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: No Feedback
    • Affects Version/s: 15
    • Fix Version/s: None
    • Component/s: EPM
    • Labels:
      None
    • Bug Tracker:
      Customer Issue
    • Asterisk Version:
      16.15.1
    • Distro Version:
      12.7.8-2012-1.sng7
    • Distro:
      FreePBX Distro

      Description

      Versions:

      MariaDB: mysql Ver 15.1 Distrib 5.5.65-MariaDB, for Linux (x86_64) using readline 5.1

      Sangoma: 7.8.2003

      PBX: 12.7.8-2012-1.sng7

      Attempting to upgrade EPM - need to accommodate more than 10 chars in OID column:

      Doctrine\DBAL\DBALException thrown with message "An exception occurred while executing 'ALTER TABLE endpoint_basefiles CHANGE brand brand VARCHAR(20) DEFAULT '0', CHANGE template template VARCHAR(45) DEFAULT NULL, CHANGE model model VARCHAR(512) DEFAULT '0', CHANGE type type VARCHAR(20) DEFAULT '0', CHANGE file file VARCHAR(40) DEFAULT NULL, CHANGE define define VARCHAR(80) DEFAULT '0', CHANGE param param VARCHAR(120) DEFAULT '0', CHANGE attrib attrib VARCHAR(60) DEFAULT '0', CHANGE value value VARCHAR(2048) DEFAULT '0', CHANGE edited edited VARCHAR(1) DEFAULT NULL, CHANGE description description VARCHAR(1024) DEFAULT NULL, CHANGE OID OID VARCHAR(10) DEFAULT NULL':

      SQLSTATE[01000]: Warning: 1265 Data truncated for column 'OID' at row 36293"

      Stacktrace:
      #13 Doctrine\DBAL\DBALException in /var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:131
      #12 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1046
      #11 PDOException in /var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1044
      #10 PDO:exec in /var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1044
      #9 Doctrine\DBAL\Connection:exec in /var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Synchronizer/AbstractSchemaSynchronizer.php:62
      #8 Doctrine\DBAL\Schema\Synchronizer\AbstractSchemaSynchronizer:processSql in /var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Synchronizer/SingleDatabaseSynchronizer.php:158
      #7 Doctrine\DBAL\Schema\Synchronizer\SingleDatabaseSynchronizer:updateSchema in /var/www/html/admin/libraries/BMO/Database/Migration.class.php:188
      #6 FreePBX\Database\Migration:modifyMultiple in /var/www/html/admin/libraries/BMO/Database/Migration.class.php:210
      #5 FreePBX\Database\Migration:modify in /var/www/html/admin/modules/endpoint/install.php:172
      #4 include_once in /var/www/html/admin/libraries/modulefunctions.class.php:2652
      #3 module_functions:_doinclude in /var/www/html/admin/libraries/modulefunctions.class.php:2568
      #2 module_functions:_runscripts in /var/www/html/admin/libraries/modulefunctions.class.php:2034
      #1 module_functions:install in /var/www/html/admin/page.modules.php:288
      #0 include in /var/www/html/admin/config.php:477

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jasonl Jason
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Feedback Requested:

                  NextupJiraPlusStatus

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