Database error in languages

Hello

i got this when i try to upload new languages in Admin Panel:

 


 

Database error in

Query:

INSERT INTO `sys_localization_languages` (`Name`, `Flag`, `Title`) VALUES ('en', 'gb', 'English')

Mysql error: Duplicate entry '255' for key 1

Found error in the file '/home/lior155/public_html/administration/lang_file.php' at line 536.
Called 'query' function with erroneous argument #0.


Quote · 2 Apr 2010

This means the entry already exist in the database.  Hence the error call out "Duplicate entry" as MySQL doesn't let you overwrite existing data in tables. 

INSERT INTO `sys_localization_languages` (`Name`, `Flag`, `Title`) VALUES ('en', 'gb', 'English')

Mysql error: Duplicate entry '255' for key 1

I would guess the command at line 536 is an entry that already exist in the database.  If you are uploading a new language, perhaps you forgot to change the language for this line.

Found error in the file '/home/lior155/public_html/administration/lang_file.php' at line 536.
Called 'query' function with erroneous argument #0.

:-)
Quote · 2 Apr 2010

 

This means the entry already exist in the database.  Hence the error call out "Duplicate entry" as MySQL doesn't let you overwrite existing data in tables. 

  but i have only one languages  and i see the languages file on the server (by FTP SmartFTP Client) in the lang folder.

what sould i do then?

there any solution to fix it ?

Quote · 2 Apr 2010

You said you are trying to upload a new language.  In the new language file, there must be a duplicate entry.  Look on line 536 and compare it to what is in the database in the table `sys_localization_languages`   for the values   (`Name`, `Flag`, `Title`) VALUES ('en', 'gb', 'English')  If it is exactly the same in the database as it is in the language file you are trying to load onto your site, then you will need to change the vaule to something different such as the type of language you are trying to upload so there won't be a duplicate entry being the English language already has this entry.

:-)
Quote · 2 Apr 2010

 

You said you are trying to upload a new language.  In the new language file, there must be a duplicate entry.  Look on line 536 and compare it to what is in the database in the table `sys_localization_languages`   for the values   (`Name`, `Flag`, `Title`) VALUES ('en', 'gb', 'English')  If it is exactly the same in the database as it is in the language file you are trying to load onto your site, then you will need to change the vaule to something different such as the type of language you are trying to upload so there won't be a duplicate entry being the English language already has this entry.

 

i see where the error is, in the lang file on the DB missing and the file of the lan is destroyed. is start like this:

 

<?
$LANG = array(
 '_sys_module_aqb_autoonline' => 'Autoonline',
 '_FieldCaption_Weight_Search' => 'משקל',
 '_adm_txt_mp_cecelover' => 'cecelover',
 '_FieldCaption_child_Join' => 'child',
 '_adm_txt_mp_צוות באד בויז' => 'צוות באד בויז',
 '_FieldError_child_Mandatory' => 'באיזה איזור אתה נמצא',
 '_FieldError_Alcohol_Mandatory' => 'באיזה איזור אתה נמצא',
 '_FieldValues_לעתים קרובות' => 'לעתים קרובות',

and in my backup lang file i have on my computer is start like this:

<?php
$aLangInfo=array (
  'Name' => 'he',
  'Flag' => 'il',
  'Title' => 'עברית',
);
$aLangC alt=array (
  '_adm_admtools_Perm_description' => 'Dolphin needs special access for certain files and directories. Please, change permissions as specified in the chart below. Helpful info about permissions is <a href="
http://www.boonex.com/trac/dolphin/wiki/DetailedInstall#Permissions" target="_blank">available here</a>.',
  '_adm_admtools_Show_all_files' => 'Show all files and directories',
  '_adm_admtools_Only_bad_files' => 'Show only troubled files and directories with inappropriate permissions',
  '_adm_admtools_Bad_files' => 'Next files and directories have inappropriate permissions',
  '_adm_admtools_Desired_level' => 'Desired level',
  '_adm_admtools_Current_level' => 'Current level',
  '_adm_admtools_Flash' => 'Flash',

so i try to deleted the lang file from the folder on the server (by FTP SmartFTP Client) but got no luck!

it is get many error on the site and i do not see the hope Cry

all the lang file on the DB destroyed!

Quote · 2 Apr 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.