Modules- database query error

any idea how to fix this?  I'm looking at sys_localization_keys in database.. not sure what's the problem. :/

 

This error is what i get when I try to install "Group" for example.

Query:
INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('133', '_bx_groups')
Mysql error:
Duplicate entry '65535' for key 1

Found error in the file '/var/www/html/inc/classes/BxDolInstaller.php' at line 622.
Called 'db_res' function with erroneous argument #0.

Quote · 27 Oct 2010

That error should not occure. In this case the duplicate entry error is becuse you have reached the limit of the smallint value for the ID field in the table sys_localization_keys.

65535 is the upper limit.

This should not occur.

This table is where all the language keys are stored. I have uninstalled and reinstalled modules many times during testing of my own mods. I only have 5270 entries in this table. My current ID value is at 47623.

So for this to happen you either have installed and reinstalled modules so many times that its maxed this out, or something has gone wrong with the table.

I see only one way of fixing it at this point and that would be to change the smallint(5) to a standard int in the ID field of the sys_localization_keys table and the IDKey field of the table sys_localization_strings

But that fix will cause problems when you go to upgrade dolphin.

The proper fix is to renumber, but because 2 tables are involved, that process will be very difficult because the ID field of one table has to match up to the IDKey field of the other.

https://www.deanbassett.com
Quote · 27 Oct 2010

ahhhhh now you got me thinking.  I went to my "fresh" database and exported sys_localization_categories, sys_localization_keys, and sys_localization_strings and imported them in my current database and then deleted/imported default english in admin panel/settings/language and it works! I think it should be okay.  Thanks so much for your help, deano!! Laughing

Quote · 27 Oct 2010

Hmm, yea, a import from a clean database would work to. Ok, thats was easy enough.



https://www.deanbassett.com
Quote · 27 Oct 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.