Error! close Reload failed because retrieve_conf encountered an error: 1 FreePBX 12.0.45


(Tharaka) #1

exit: 1
found language dir fr for directory, not installed on system, skipping
[FATAL] SELECT * FROM cidlookup [nativecode=1146 ** Table ‘asterisk.cidlookup’ doesn’t exist]SQL -
SELECT * FROM cidlookup

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT * FROM cidlookup [nativecode=1146 ** Table ‘asterisk.cidlookup’ doesn’t exist]SQL -
SELECT * FROM cidlookup

/var/www/html/admin/modules/cidlookup/functions.inc.php:305 sql()
[0]: SELECT * FROM cidlookup
[1]: getAll
[2]: 2

/var/www/html/admin/modules/cidlookup/functions.inc.php:138 cidlookup_list()
[0]: 1

/var/www/html/admin/libraries/BMO/DialplanHooks.class.php:79 cidlookup_get_config()
[0]: asterisk

/var/lib/asterisk/bin/retrieve_conf:727 DialplanHooks->processHooks()
[0]: asterisk
[1]:

Please Help me to solve this issue Thanks


(Lorne Gaetz) #2

You’re missing a mysql table, which could be a simple fault with the module or something more serious with database corruption.

fwconsole ma install cidlookup

(Tharaka) #3

its get error
-bash: fwconsole: command not found


(Lorne Gaetz) #4
amportal a ma install cidlookup

Your FreePBX version is past end of life. Now might be an excellent opportunity to restore a backup to a new 15 install.


(Tharaka) #5

But this version works fine with last year due to hard disk damage my pc newly install again this is first time i got error like this . My pc has 32 bit processor with 2 GB ram is that possible to run latest version with this configuration ? better if we can recover this error its a big help for me

[root@localhost ~]# amportal a ma install cidlookup

Fetching FreePBX settings with gen_amp_conf.php…

Module cidlookup successfully installed

SETTING FILE PERMISSIONS…Done
Removing any dangling symlinks
Dangling symlinks removed


(Tharaka) #6

any other solution please ?


(Itzik) #7

As mentioned above, your FreePBX is EOL. If it’s a bug, you’ll need to fix it on your own.


(Tharaka) #8

[root@localhost ~]# amportal a ma install cidlookup

Fetching FreePBX settings with gen_amp_conf.php…

Module cidlookup successfully installed

SETTING FILE PERMISSIONS…Done
Removing any dangling symlinks
Dangling symlinks removed

cidlookup installed but still cant apply config


(Itzik) #9

Do you still get the same error?
As Lorne mentioned, it might be something more that’s with your DB.


(Tharaka) #10

yes still i cant apply config


(Itzik) #11

Well, can you confirm that the table exists?


(Tharaka) #12

exit: 1
found language dir fr for directory, not installed on system, skipping
[FATAL] SELECT * FROM cidlookup [nativecode=1146 ** Table ‘asterisk.cidlookup’ doesn’t exist]SQL -
SELECT * FROM cidlookup

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT * FROM cidlookup [nativecode=1146 ** Table ‘asterisk.cidlookup’ doesn’t exist]SQL -
SELECT * FROM cidlookup

/var/www/html/admin/modules/cidlookup/functions.inc.php:305 sql()
[0]: SELECT * FROM cidlookup
[1]: getAll
[2]: 2

/var/www/html/admin/modules/cidlookup/functions.inc.php:138 cidlookup_list()
[0]: 1

/var/www/html/admin/libraries/BMO/DialplanHooks.class.php:79 cidlookup_get_config()
[0]: asterisk

/var/lib/asterisk/bin/retrieve_conf:727 DialplanHooks->processHooks()
[0]: asterisk
[1]:


(Itzik) #13

can you confirm if the table exists?


(Tharaka) #14

please tell me how to get Table ?


(Dave Burgess) #15

With that configuration of hardware, you may not be able to move forward from where you are. In spite of that, as long as you don’t do anything crazy you should be able to recreate the database table by hand.

First, log into the console as ‘root’.

Next, execute the ‘mysql’ program and select the Asterisk database:

mysql asterisk

Once mysql is running, check the table:

describe cidlookup

The table description should appear on the screen. If your table doesn’t exist, let us know and one of us will tell you how to recreate the table by hand.

To be clear, though, reinstalling the cidlookup module should have recreated this table, so you may have a more serious problem than this one table not existing.


(Tharaka) #16

I followed the steps but there is empty please check below

[root@localhost ~]# amportal a ma install cidlookup

Fetching FreePBX settings with gen_amp_conf.php…

Module cidlookup successfully installed

SETTING FILE PERMISSIONS…Done
Removing any dangling symlinks
Dangling symlinks removed
[root@localhost ~]# mysql asterisk
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 107
Server version: 5.1.73 Source distribution

Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> describe cidlookup
->


(Itzik) #17

You need to run it like this, with a semicolon at the end

describe cidlookup;

(Tharaka) #18

yes i wrote same like that but not showing anything

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> describe cidlookup
->


(Itzik) #19

You are again missing a semicolon


(Tharaka) #20

got like this

mysql> describe cidlookup;
ERROR 1146 (42S02): Table ‘asterisk.cidlookup’ doesn’t exist
mysql>