Mysql error: Duplicate entry 'Name' for key 'Key'

Hi there. When I try to install module with translation, I got this error:

Query:

INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('3', 'Name')

Mysql error: Duplicate entry 'Name' for key 'Key'

Found error in the file '/home/blacksno/public_html/.../inc/classes/BxDolInstaller.php' at line 622.
Called 'db_res' function with erroneous argument #0.

Can somebody hellp me?

It seems the language file you try to import contains the entry "name" twice.

If I remember right, the installer will point to the line in the language file where the error is, so in this case ... Check line 622 of the language file and see if that is where the duplicate entry is.

Any help, feel free to contact me

INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('3', 'Name')

What module did you tried to install ?

Avatar - INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('4', 'Name')

News - INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('3', 'Name')

The Photos module is working. The other modules don't have translations (and they are working).

The language files (for modules) don't have 622 line, they are shorter.

The 622 line of BxDolInstaller.php is - db_res("INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('" . $iCategoryId . "', '" . $sKey . "')");

The 622 line of the main language file is nothing related - <p align="justify">&nbsp;</p>

When the database error occur, in the mail I got and looong "Debug backtrace:"

Sorry I "misslead" you in my first reply. I did not read correctly and therefore spplied incorrect information.

The error means that the installer is trying to insert a new localization key in to the table sys_localization_keys but the value it is trying to insert is already there. Did you try to install this mod before?

If the mod shows up in the list of installed mods, uninstall it and re-install it. If it is not showing in the list you most likely manually have to remove the key before running the installer again. The trace should give you all the information you need to find it.