I attempted to upgrade FreePBX from 2.2.0 to 2.4.0 today and it failed running the PHP script /usr/src/freepbx-2.4.0/upgrades/2.2.3/tables.php.
Here’s the console display after starting the script:
Upgrading to 2.2.0rc2…OK
Upgrading to 2.2.3…
-> Running PHP script /usr/src/freepbx-2.4.0/upgrades/2.2.3/tables.php
Alter tables sip, iax, zap to increase field length… Altered
Creating module_xml table…Not Required
Adding id to module_xml table…DB Error: unknown error[root@asterisk freepbx-2.4.0]# amportal stop
When I open the web administration page, I see the new page with the green frog. If I select FreePBX Administration, I get:
FATAL ERROR
DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPDBPASS’ [nativecode=1146 ** Table ‘asterisk.notifications’ doesn’t exist]SQL -
DELETE FROM notifications WHERE module = ‘core’ AND id = ‘AMPDBPASS’
How can I recover from this?
Thanks!
Ken Morley