This error came up when trying to run the orange apply configuration changes button
it looks like maybe my database is missing a table?
Asterisk 1.6.2.10
ubuntu 10.0.4
FreePBX 2.8.0.1
exit: 1
PHP Deprecated: Comments starting with ‘#’ are deprecated in /etc/php5/cli/conf.d/mcrypt.ini on line 1 in Unknown on line 0
Checking for PEAR DB…OK
Checking for PEAR Console::Getopt…OK
Checking for /etc/amportal.conf …OK
Bootstrapping /etc/amportal.conf …OK
Parsing /etc/amportal.conf …OK
Parsing /etc/asterisk/asterisk.conf …OK
Connecting to database…OK
Connecting to Asterisk manager interface…OK
[FATAL] SELECT * FROM trunk_dialpatterns
ORDER BY trunkid
, seq
[nativecode=1146 ** Table ‘asterisk.trunk_dialpatterns’ doesn’t exist]SQL -
SELECT * FROM trunk_dialpatterns
ORDER BY trunkid
, seq
Array
(
[0] => Array
(
[file] => /var/www/admin/functions.inc.php
[line] => 1449
[function] => die_freepbx
[args] => Array
(
[0] => SELECT * FROM trunk_dialpatterns
ORDER BY trunkid
, seq
[nativecode=1146 ** Table ‘asterisk.trunk_dialpatterns’ doesn’t exist]SQL -
SELECT * FROM trunk_dialpatterns
ORDER BY trunkid
, seq
)
)
[1] => Array
(
[file] => /var/www/admin/modules/core/functions.inc.php
[line] => 5017
[function] => sql
[args] => Array
(
[0] => SELECT * FROM `trunk_dialpatterns` ORDER BY `trunkid`, `seq`
[1] => getAll
[2] => 2
)
)
[2] => Array
(
[file] => /var/www/admin/modules/core/functions.inc.php
[line] => 4901
[function] => core_trunks_get_dialrules
[args] => Array
(
)
)
[3] => Array
(
[file] => /var/www/admin/modules/core/functions.inc.php
[line] => 1477
[function] => core_trunks_list_dialrules
[args] => Array
(
)
)
[4] => Array
(
[file] => /var/lib/asterisk/bin/retrieve_conf
[line] => 615
[function] => core_get_config
[args] => Array
(
[0] => asterisk
)
)
)
1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.
this is the tables I got form the newinstall.sql
tables in asterisk
mysql> show tables;
±------------------------+
| Tables_in_asterisk |
±------------------------+
| admin |
| ampusers |
| callback |
| cronmanager |
| custom_destinations |
| custom_extensions |
| dahdi |
| daynight |
| devices |
| disa |
| extensions |
| fax_details |
| fax_incoming |
| fax_users |
| featurecodes |
| freepbx_log |
| globals |
| iax |
| iaxsettings |
| incoming |
| language_incoming |
| languages |
| manager |
| miscapps |
| miscdests |
| module_xml |
| modules |
| notifications |
| outbound_route_patterns |
| outbound_route_sequence |
| outbound_route_trunks |
| outbound_routes |
| paging_autoanswer |
| paging_config |
| paging_groups |
| phpagiconf |
| pinset_usage |
| pinsets |
| queueprio |
| recordings |
| sip |
| sipsettings |
| timeconditions |
| timegroups_details |
| timegroups_groups |
| trunks |
| trunks_dialpatterns |
| users |
| vmblast |
| vmblast_groups |
| zap |
| zapchandids |
±------------------------+
52 rows in set (0.01 sec)