CID Superfecta - Reload failed because retrieve_conf encountered an error: 1

Hi guys,

After updating freepbx 2.11 to 12. I get this error when installing CID Superfecta.
Reload failed because retrieve_conf encountered an error: 1
exit: 1
Added to globals: ASTETCDIR = /etc/asterisk
Added to globals: ASTMODDIR = /usr/lib64/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 =
Added to globals: AMPDBENGINE = mysql
Added to globals: AMPDBHOST = 172.16.1.3
Added to globals: AMPDBNAME = asterisk
Added to globals: AMPDBUSER = freepbxuser
Added to globals: AMPDBPASS =
Added to globals: VMX_CONTEXT = from-internal
Added to globals: VMX_PRI = 1
Added to globals: VMX_TIMEDEST_CONTEXT =
Added to globals: VMX_TIMEDEST_EXT = dovm
Added to globals: VMX_TIMEDEST_PRI = 1
Added to globals: VMX_LOOPDEST_CONTEXT =
Added to globals: VMX_LOOPDEST_EXT = dovm
Added to globals: VMX_LOOPDEST_PRI = 1
Added to globals: MIXMON_DIR =
Added to globals: MIXMON_POST =
Added to globals: DIAL_OPTIONS = Ttr
Added to globals: TRUNK_OPTIONS = Tt
Added to globals: TRUNK_RING_TIMER = 300
Added to globals: MIXMON_FORMAT = wav
Added to globals: REC_POLICY = caller
Added to globals: RINGTIMER_DEFAULT = 15
Added to globals: TRANSFER_CONTEXT = from-internal-xfer
[FATAL]
SELECT superfecta_to_incoming_id, a.extension extension, a.cidnum cidnum, pricid, scheme FROM superfecta_to_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
[nativecode=1267 ** Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation ‘=’]SQL -

SELECT superfecta_to_incoming_id, a.extension extension, a.cidnum cidnum, pricid, scheme FROM superfecta_to_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
Trace Back:
/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT superfecta_to_incoming_id, a.extension extension, a.cidnum cidnum, pricid, scheme FROM superfecta_to_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
[nativecode=1267 ** Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation ‘=’]SQL -
SELECT superfecta_to_incoming_id, a.extension extension, a.cidnum cidnum, pricid, scheme FROM superfecta_to_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
/var/www/html/admin/modules/superfecta/functions.inc.php:146 sql()
[0]: SELECT superfecta_to_incoming_id, a.extension extension, a.cidnum cidnum, pricid, scheme FROM superfecta_to_incoming a
INNER JOIN incoming b
ON a.extension = b.extension AND a.cidnum = b.cidnum
[1]: getAll
[2]: 2
/var/www/html/admin/modules/superfecta/functions.inc.php:89 superfecta_did_list()
/var/www/html/admin/libraries/BMO/DialplanHooks.class.php:79 superfecta_hookGet_config()
[0]: asterisk
/var/lib/asterisk/bin/retrieve_conf:719 DialplanHooks->processHooks()
[0]: asterisk
[1]:

How can I fix this?

Thanks,
Alex

Uninstall superfecta.

Thanks very helpful… But i want to use it, so…

Uninstall and reinstall. Unless you have something important already in there. Do you?

From the mysql cli, issue

use asterisk;
show table status like ‘superfecta%’ ;

and

show table status like ‘extensions’;

the collation must be the same to “join” tables, to change collation on mismatched tables you can for example :-

alter table superfecta_to_incoming collate latin1_swedish_ci;

I tried disabling and enabling, uninstalling and installing and removing and reinstalling, neither one of them worked.

Thanks dicko,

That was the solution.

I tried uninstalling and installing. Remove and reinstall, also tried disabling and enabling, all without any luck.

Thanks,
Alex