Hi, I just installed freePBX, I complete install_amp without problems, but when I ran reload, or script retrieve_conf i got this error:
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
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib/asterisk/modules
Added to globals: ASTVARLIBDIR = /var/lib/asterisk
Added to globals: ASTAGIDIR = /var/lib/asterisk/agi-bin
Added to globals: ASTSPOOLDIR = /var/spool/asterisk
Added to globals: ASTRUNDIR = /var/run/asterisk
Added to globals: ASTLOGDIR = /var/log/asterisk
Added to globals: CWINUSEBUSY = true
Added to globals: AMPMGRUSER = admin
Added to globals: AMPMGRPASS = soksdejfr
[FATAL]
SELECT cidlookup_id, a.extension extension, a.cidnum cidnum, pricid FROM cidlookup_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
[nativecode=1054 ** Unknown column ‘pricid’ in ‘field list’]SQL -
SELECT cidlookup_id, a.extension extension, a.cidnum cidnum, pricid FROM cidlookup_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
1 error(s) occured, you should view the notification log on the dashboard or main screen to check for more details.
I check inside asterisk database, and I found the tables:
mysql> desc cidlookup_incoming;
±-------------±------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±-------------±------------±-----±----±--------±------+
| cidlookup_id | int(11) | NO | | NULL | |
| extension | varchar(50) | YES | | NULL | |
| cidnum | varchar(30) | YES | | NULL | |
±-------------±------------±-----±----±--------±------+
3 rows in set (0.00 sec)
mysql> desc incoming;
±-------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±-------------±-------------±-----±----±--------±------+
| cidnum | varchar(20) | YES | | NULL | |
| extension | varchar(20) | YES | | NULL | |
| destination | varchar(50) | YES | | NULL | |
| faxexten | varchar(20) | YES | | NULL | |
| faxemail | varchar(50) | YES | | NULL | |
| answer | tinyint(1) | YES | | NULL | |
| wait | int(2) | YES | | NULL | |
| privacyman | tinyint(1) | YES | | NULL | |
| alertinfo | varchar(255) | YES | | NULL | |
| ringing | varchar(20) | YES | | NULL | |
| mohclass | varchar(80) | NO | | default | |
| description | varchar(80) | YES | | NULL | |
| grppre | varchar(80) | YES | | NULL | |
| delay_answer | int(2) | YES | | NULL | |
±-------------±-------------±-----±----±--------±------+
14 rows in set (0.00 sec)
pricid column doesn’t appear in these tables.
any help or hint to solve this issue?
Thanks in advanced
Alexis
==========Solved================
I change the table using this command:
ALTER TABLE incoming ADD pricid VARCHAR(20) DEFAULT NULL;
it’s working fine!!