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
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
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
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.
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 (c) 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.