An Error Occurred While Creating Object. Lang (Unknown Column 'is_Rtl' In 'field List')

[Methylen]

Downloaded PS yesterday and installed a custom template and imported the dump.sql

 

An error occurred while creating object. lang (Unknown column 'is_rtl' in 'field list') everytime i try to add a language

 

the template is 1.4.3 could this be the cause? or is it the dump.sql?

 

 

I've read in another topic that

 

"Delete from dump.sql

 

/* Table structure for table `ps_lang` */

DROP TABLE IF EXISTS `ps_lang`;

 

CREATE TABLE `ps_lang` (

`id_lang` int(10) unsigned NOT NULL auto_increment,

`name` varchar(32) NOT NULL,

`active` tinyint(3) unsigned NOT NULL default '0',

`iso_code` char(2) NOT NULL,

`language_code` char(5) NOT NULL,

PRIMARY KEY (`id_lang`),

KEY `lang_iso_code` (`iso_code`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

 

/* dumping data for table `ps_lang` */

INSERT INTO `ps_lang` VALUES

(1,'English (English)',1,'en','en-us'),

(2,'Français (French)',1,'fr','fr'),

(3,'Español (Spanish)',1,'es','es'),

(4,'Deutsch (German)',0,'de','de'),

(5,'Italiano (Italian)',0,'it','it');

 

would be a fix, but when i do this and reimport the dump.sql i get an error message something about #1033 or duplicate K2 something

 

What i've tried is adding a line below the last

(6,'Dansk (Danish)',0,'da',dan');

 

this sort of worked.. it prompted a new error when adding the language manually but did add the language to the website, but only has a few select translations working and it does not change a thing adding the translations manually. so something has gotta give

 

 

might be related to this guys problem too

 

http://www.prestasho...d-new-language/

 

The stock PS contains danish language by default, so i can't tell you if this problem is true for the stock PS install, or only my template

[Methylen]

Idle hands are the devils playground, so i messed around and reinstalled it

 

 

used the built in ADD / UPDATE language in translations tab, selectded danish, and added

 

Translation added successfully but the language has not been created

 

as far as the tutorials go, i should see the language i just added in the language tab but without flags right? no dice, just the 5 languages mentioned in the dump.sql

 

I've tried moveing the da.php file from themes/prestashop/lang to themes/theme119/lang but it's still not showing

 

and it's not working if u try and manually add the language

[Methylen]

Resolved the issue, it's the prestashop version and the template that are not alligned, so for me the solution was to get an older version of prestashop that matched my template (1.4.3) this worked well

 

but i would be very interested in knowing how to convert my 1.4.3 template to the currenty 1.4.6 PS version available

[Methylen]

This will work too, changing one of the languages in the dump.sql like (5,'Italiano (Italian)',0,'it','it');

to the desired language (5, 'Dansk (Danish)',1,'da',da'); and then entering the admin under tools, languages edit the 5'th language and change the language flag (upload a new one)

[Methylen]

just needed to add this bit of information, you can't change the language icon with the back office/admin system, you have to replace the icon located in folder img/l/5.jpg in this case i replaced that with the correct language icon and now it's working

 

this is my newbie fix (having only had my hands on PS for less then 24 hours) if there is a proper fix, please share

[Guest]

Resolved the issue, it's the prestashop version and the template that are not alligned, so for me the solution was to get an older version of prestashop that matched my template (1.4.3) this worked well

 

but i would be very interested in knowing how to convert my 1.4.3 template to the currenty 1.4.6 PS version available

 

Hi Methylen, I have the same problem with my site now. I'll try to downgrade my PS version as you did. Hope this will work for me!

[Guest]

This will work too, changing one of the languages in the dump.sql like (5,'Italiano (Italian)',0,'it','it');

to the desired language (5, 'Dansk (Danish)',1,'da',da'); and then entering the admin under tools, languages edit the 5'th language and change the language flag (upload a new one)

I'll try this one too.

[Guest]

Another way, Go to phpMyAdmin -> Datbase -> ps_lang -> edit one of the existing language to your new language. In my case. I edited Danish to Vietnamese so: (5, 'Dansk (Danish)',1,'da',da'); - > (5, 'Tieng Viet (Vietnamese)',1,'vi',vi');

 

If you edit in the dump.sql then you will have to import it again, but edit it through phpMyAdmin is much easier.

 

Then Because my ps template didn't support Vietnamese so I had to create a file named "vi.php" in the theme/lang/vi.php (just made a copy of other language file such as da.php)

 

-- then go to back office -> tools -> translations -> edit the front office translation for Vietnamese.

[Methylen]

Another way, Go to phpMyAdmin -> Datbase -> ps_lang -> edit one of the existing language to your new language. In my case. I edited Danish to Vietnamese so: (5, 'Dansk (Danish)',1,'da',da'); - > (5, 'Tieng Viet (Vietnamese)',1,'vi',vi');

 

If you edit in the dump.sql then you will have to import it again, but edit it through phpMyAdmin is much easier.

 

Then Because my ps template didn't support Vietnamese so I had to create a file named "vi.php" in the theme/lang/vi.php (just made a copy of other language file such as da.php)

 

-- then go to back office -> tools -> translations -> edit the front office translation for Vietnamese.

 

 

Yes, exactly as i did, i just downloaded the danish language pack, extracted it and put it in the theme/lang folder

 

I've realized that you won't have the back office language supported, i haven't figured out how to change this so if i chose danish for my back office language, i get italian thank god i can manage with english

[Guest]

For other newbies like me: If you find there are translations that you want to edit but you can't find it in the Front Office Translation, => Go to Back Office -> Module and click on the Flag of yours to go to the Translations Editor page for translations of Modules--> For me I spent almost one day to find that a simple translation was in these address! I thought they were all in the Front Office Translation.

[ideagift]

Or you can do a SQL command like :

alter table `ps_lang` add column is_rtl tinyint (1);

And all will work ok.

[airbag]

Or you can do a SQL command like :

alter table `ps_lang` add column is_rtl tinyint (1);

And all will work ok.

 

I just found this answer, having spent most of the day figuring it out also. By adding the new column into the field in the database, it allowed me to save the new language and proceed with things. I also had to check my theme to make sure the language file was listed under /themes/yourtheme/lang/language file name.php as it was pulling an error that no file was available under my theme.

[yusufzulkarnain]

This will work too, changing one of the languages in the dump.sql like (5,'Italiano (Italian)',0,'it','it'); to the desired language (5, 'Dansk (Danish)',1,'da',da'); and then entering the admin under tools, languages edit the 5'th language and change the language flag (upload a new one)

Hi Methylen!

Unfortunately. It can not work. I ve just changed (5,'Italiano (Italian)',0,'it','it') to (5,'Indonesian',1,'id','id'), but I still get the error message

 

An error occurred while updating object. lang (Unknown column 'is_rtl' in 'field list')

 

after I upload Indonesian flag icon.

[yusufzulkarnain]

I just found this answer, having spent most of the day figuring it out also. By adding the new column into the field in the database, it allowed me to save the new language and proceed with things. I also had to check my theme to make sure the language file was listed under /themes/yourtheme/lang/language file name.php as it was pulling an error that no file was available under my theme.

Thanks AIRBAG!

I have just done your advise to write SQL command like :

alter table `ps_lang` add column is_rtl tinyint (1);

It works OK. Unfortunately, now I get new error message like this :

An error occurred while updating object. lang (Unknown column 'date_format_lite' in 'field list')

What can I do?