Error on sync FreePBX MySQL table

Configuring synchronization, sensors, and optimizations
Post Reply
User avatar
CRM User
Posts: 132
Joined: Sun Nov 27, 2016 3:41 pm

Error on sync FreePBX MySQL table

Post by CRM User » Mon Jun 25, 2018 2:59 am

My cluster seems to be synchronizing the FreePBX MySql database, but I see this error in the haast log:

Code: Select all

System Command, Warning during interface with database sync for id 'freepbx-mysql'.   Result code '0'; Error code '5'; Exit code '3'.  Check debug log for further details
What's going wrong?
Account for questions transferred from CRM system
User avatar
Telium Support
Posts: 173
Joined: Sun Nov 27, 2016 3:27 pm

Re: Error on sync FreePBX MySQL table

Post by Telium Support » Mon Jun 25, 2018 5:43 am

Some versions of FreePBX contain tables without indices. Although this is not valid SQL, MySQL allows it and so FreePBX can operate with this poorly designed table.

HAAst is complaining that it can't sync a table without a unique index. (Although this is likely an unimportant table as Sangoma seems to be cleaning up their tables slowly). The best solution is to wait for an update to FreePBX which fixes the table.
Post Reply