CDR Reports - Upgrade Error. 13.0.29.4 to 13.0.29.5 - ERR: SQLSTATE[42S21]: Column already exists

General Help
1

Updating one of our FreePBX boxes tonight night. (FreePBX 13.0.167)

Getting Error during Enable & Update Operation for ‘CDR Reprots’ module

ERR: SQLSTATE[42S21]: Column already exists 1060
Duplicate column name ‘cnum’

1530×1113 238 KB

Tried uninstalling. Received Error

h**p://i.imgur.com/hyJfRYW.jpg

Upon reloading Module Admin ‘CDR Reports’ now show install option.

h**p://i.imgur.com/4WAe6T6.jpg

Tried installing. Fail. Same DB Error as above.

Any help is greatly appreciated.

2

Your machine is reporting an error when the install tries to query the cdr database. It’s probably corrupt.

Log into the machine as root and run this:

mysqlcheck -A --auto-repair

That’ll fix it.