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

Error migrating to new directory 2.9 RC1.3

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Works For Me
    • Affects Version/s: 2.9
    • Fix Version/s: None
    • Component/s: Directory
    • Labels:
    • Asterisk Version:
      1.6.2.17

      Description

      Not sure if this it a module issue, or related to new 2.9 code.

      Just upgraded to 2.9.0rc1.4

      Was able to upgrade all the modules except directory, when I select it for upgrade/proceed, it gives the following SQL errors in the orange box:

      {noformat}
      Please wait while module actions are performed
      Adding directory tables if needed
      Migrating Directory
      FATAL ERROR
      Error migrating to new directory! ERROR: Could not create new Directory.INSERT INTO directory_details (dirname, description, announcement, callid_prefix, alert_info, repeat_loops, repeat_recording, invalid_recording, invalid_destination, retivr, say_extension) VALUES ('Migrated Directory', '', '0', '', '', '2', '0', '0', 'app-blackhole,hangup,1', '', '1') [nativecode=1054 ** Unknown column 'retivr' in 'field list']
      Trace Back
      /var/www/html/admin/modules/directory/install.php:137 die_freepbx()
      [0]: Error migrating to new directory! ERROR: Could not create new Directory.INSERT INTO directory_details (dirname, description, announcement, callid_prefix, alert_info, repeat_loops, repeat_recording, invalid_recording, invalid_destination, retivr, say_extension) VALUES ('Migrated Directory', '', '0', '', '', '2', '0', '0', 'app-blackhole,hangup,1', '', '1') [nativecode=1054 ** Unknown column 'retivr' in 'field list']

      /var/www/html/admin/libraries/module.functions.php:1356 include_once()
      [0]: /var/www/html/admin/modules/directory/install.php

      /var/www/html/admin/libraries/module.functions.php:1328 _modules_doinclude()
      [0]: /var/www/html/admin/modules/directory/install.php
      [1]: directory

      /var/www/html/admin/libraries/module.functions.php:1011 _module_runscripts()
      [0]: directory
      [1]: install

      /var/www/html/admin/page.modules.php:230 module_install()
      [0]: directory

      /var/www/html/admin/config.php:289 include()
      [0]: /var/www/html/admin/page.modules.php
      {noformat}

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                totalimpact totalimpact
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  NextupJiraPlusStatus

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