Cannot Load List of SCCP Phones

[rikyenns4]

When opening the SCCP Phone Manager, I receive an error message:

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' File:/var/www/html/admin/modules/sccp_manager/sccpManClasses/dbinterface.class.php:171

The SCCP Extensions tab seems to work fine, but when I add new SCCP Phones, they seem to add fine, but don't populate in the list of SCCP phones (they do however, show as associated devices when listing the SCCP extensions).

This is on a brand new installation of FreePBX 16 and the chan-sccp version 4.3.5. I tried both the latest release of SCCP Manager (at the time 14.5.0.4) as well as the current codebase in the develop branch (at the time commit: 5752d9f).

Any help with this would be appreciated.

My Sccp Manager Info is below, I can provide additional information if required

Thanks,

[MrAmazoni]

Experience the same one.

[TheCranston]

I had to do the following VERY DESTRUCTIVE steps to resolve:
In my case it was on a fresh install with no devices setup...

drop all the sccp tables from the database, and remove the foreign key in buttonconfig.

alter table buttonconfig drop foreign key buttonconfig_ibfk_1;
drop view sccpdeviceconfig;
drop view sccplineconfig;
drop table sccpbuttonconfig;
drop table sccpdevice;
drop table sccpdevmodel;
drop table sccpline;
drop table sccpsettings;
drop table sccpuser

Then I was able to install sccp_manager develop version and it worked without issue. I suspect the chan-sccp driver instructions to run:

mysql -u root asterisk < mysql-v5_enum.sql

were the setup for the failure on a FreePBX distro installation. For a sources install, I've not run into this issue. It's my understanding the sccp_manager in its current release does all that work for you upon installation.