Database error in sys_localization_keys URGENT

Database error in

Query:

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

So this is the error when i try to compile modules languages.

Can any one help me ?

There is only one way this can occur that i am aware of.

You must have a hell of a lot of modules installed, or you have experimented with different language keys so much that you have a ton of unused language keys in the database.

This error indicates you have exhausted all 65535 available entries for language keys.

So how this can be resolved ? i tried to empty the table & recompile modules but this is not working.

Here is the modules that i have 25 modules but i had more than 30 modules installed with no problems.

If i had a solution i would have posted one.

But emptying the tables was most likely a mistake. That would wipe out all of your stored language keys.

Thank you any way :( what i have to do ? do i have to contact the boonex support ?

Good luck on asking for boonex support, you might be better off finding a magic wand to help you..

65,535 is the maximum number of keys that can be stored in this table.  If you empty the table, you also need to reset the auto increment counter.  In phpmyadmin, select the sys_localization_keys table, then click on the 'Operations' tab,  Replace the value 65,535 in the AUTO_INCREMENT field with '1' and then click go.

HOWEVER..... it appears as though you installed Dolhin into the same database more than once.   Doing so, will probably do the same thing to every auto increment counter.  You really should consider reinsalling Dolphin into a new database.

Oh i have 5000 members with photos videos articles and so on :=) i think reinstalling dolphin is not a good idea :=)

How many languages do you have installed. If just the english language i could most likley create a SQL file you can run in phpMyAdmin that would restore the language tables back to the defaults.

I have the same problem avec Advanced Video MOD

i wait for a answer of Rayz

No i have 4 languages and about 25 modules so if i would like to have more languages boonex must have a solution :D

Changing the field type from smallint(5) to mediumint(7) of both sys_localization_keys and sys_localization_strings database tables will increase the number of possible records from 65535 to 16777215...

Thank you it's done now no database error but when i compile languages i have just the keys shown in the site :)

So what do you think ? what is the solution ?