SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9000-2147483647-details' for key 'PRIMARY'

The GUI broke after updating an extension and I see this when I try to run fwconsole reload from the CLI. From doing some searching it should be an easy fix if I can find where in the database this entry is, but I have no idea what table to look in. Anyone know? Is it a CEL entry?

I found 2147483647 in the cisco basefiles that arent even being used, but nothing with 9000.

Searching elsewhere on the internet, it seems that that that number is the largest integer value that mysql can handle, but i dont think the users table is my problem here.

Mysql insert query returns ERROR 1062 (23000): Duplicate entry ‘2147483647’ for key ‘PRIMARY’ - Stack Overflow

mysqlcheck claims that all tables in both the asterisk and asteriskcdrdb databases are fine. Took copies of both and rebooted the server and it came back up but with a bunch of stuff disabled, namely the endpoint manager. Had to downgrade the EPM and then everything else re-enabled OK. So far everything is wokring.

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.