v2.8 upgrade issue

FreePBX Installation / Upgrade
1

I went to install v2.8 using the upgrade module. Then I upgraded the Core from 2.7 to 2.8. The install hung up and now my reload won’t work.

Here is what I get when I reload:

exit: 1

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`
1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.

If you have any knowledge of how to fix this, your help is greatly appreciated. Thanks.

Josh

2

It would appear that it somehow managed to be done partially out of sequence or otherwise some portions of the migration failed.

How did you upgrade, with the module or with the tarball?

If with the module, did you first upgrade the Framework before updating the other components? If not, are you able to upgrade the framework or force upgrade the framework and try again.

3

It would appear that something was messed up from my first attempt at upgrade. I was able to resolve this by using the tarball method of upgrading. Upon completion of a successful tarball upgrade, I am now able to reload my configs.

I was a little worried there for a second.

Upgrade Method Information:
http://www.freepbx.org/news/2010-05-24/freepbx-2-8-beta2

Thanks for all your help.

Josh

4

Asterisk installed from source.asterisk-1.6.2.9.
then 2.8.0 FBX

at fbx login

1- no modules were listed as installed. there were 8-9 locally avail

2- installed those and got this error when I tried to apply the changes.

the following output is i think from cli

/var/lib/asterisk/bin/module_admin reload

[FATAL] SELECT * FROM `trunk_dialpatterns` ORDER BY `trunkid`, `seq` [nativecode=1146 ** Table 'asterisk.trunk_dialpatterns' d oesn'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.tr unk_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
            )

    )

)
5

using freepbx-2.8.0rc1 on a fresh install we did not have that problem [ 3± days ago].

6

I had the same problem which occurred after I broke the installation of sipstation which was hanging at “checking for phantoms”. I fixed it by updating the “FreePBX Framework” and reload worked fine.

asterisk-1.6.2.10
freepbx-2.8.0

Blaise

7