search

chan-sccp / sccp_manager

SCCP Manager
21 stars 13 forks source link

Cannot Load List of SCCP Phones #84

Open rikyenns4 opened 2 years ago

rikyenns4 commented 2 years ago

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: https://github.com/chan-sccp/sccp_manager/commit/5752d9f393fc551165e6a290023ed1b1ce9d3a6c).

Any help with this would be appreciated.

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

image

Thanks,

MrAmazoni commented 2 years ago

Experience the same one.

TheCranston commented 1 year ago

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.