Urgent: Can't Add New Language- Unknown Column 'date_Format_Lite' In 'field List'

[Guest]

Hi,

 

I am trying to add a new Language(Vietnamese) to my Shop.(Version 1.4.6) but I get an error "An error occurred while creating object. lang (Unknown column 'date_format_lite' in 'field list')"

 

I used the default values for these fields:

Date Format: Y-m-d

Date Format(full): Y-m-d H:i:s

 

Please help I need to fix this on my production shop.

[tomerg3]

Did you make a clean install of PS 1.4.6, or was it an upgrade from an older version? if so, which version and how did you do the upgrade?

[Guest]

Did you make a clean install of PS 1.4.6, or was it an upgrade from an older version? if so, which version and how did you do the upgrade?

Hi, it's a clean install of "prestashop_1.4.6.2"

 

Error Screenshot:

[Guest]

Hi, I have just been trying to reproduce what I have done on my PS Shop with the Prestashop Live Demo to know if it works. But I got a bug there too, here is my report topic on that bug: http://www.prestasho...-live-demo-bug/

[Highlive]

Hi,

 

I had the same bug with my dutch translation. It seems that in some cases there are missing tables in de database. This script helped me out with my problem (maybe u have to alter the script for your needs )

 

Execute this SQL script in your phpMyAdmin (This wil add the missing tables and values to your database

 

ALTER TABLE `ps_lang` ADD `date_format_lite` char(32) NOT NULL DEFAULT

'Y-m-d' AFTER language_code;

ALTER TABLE `ps_lang` ADD `date_format_full` char(32) NOT NULL DEFAULT

'Y-m-d H:i:s' AFTER date_format_lite;

UPDATE `ps_lang` SET `date_format_lite` = 'd/m/Y' WHERE `iso_code` IN

('fr', 'es', 'it');

UPDATE `ps_lang` SET `date_format_full` = 'd/m/Y H:i:s' WHERE `iso_code`

IN ('fr', 'es', 'it');

UPDATE `ps_lang` SET `date_format_lite` = 'd.m.Y' WHERE `iso_code` =

'de';

UPDATE `ps_lang` SET `date_format_full` = 'd.m.Y H:i:s' WHERE `iso_code`

= 'de';

UPDATE `ps_lang` SET `date_format_lite` = 'm/d/Y' WHERE `iso_code` =

'en';

UPDATE `ps_lang` SET `date_format_full` = 'm/d/Y H:i:s' WHERE `iso_code`

= 'en';

 

Grtz Highlive

[avihay]

Hi I have this problem in Hebrew

 

this is the message i receive -

An error occurred while creating object.

lang (Unknown column 'date_format_lite' in 'field list').

 

i need sum help with this

 

please

[yusufzulkarnain]

Hi,

 

I had the same bug with my dutch translation. It seems that in some cases there are missing tables in de database. This script helped me out with my problem (maybe u have to alter the script for your needs )

 

Execute this SQL script in your phpMyAdmin (This wil add the missing tables and values to your database

 

ALTER TABLE `ps_lang` ADD `date_format_lite` char(32) NOT NULL DEFAULT

'Y-m-d' AFTER language_code;

ALTER TABLE `ps_lang` ADD `date_format_full` char(32) NOT NULL DEFAULT

'Y-m-d H:i:s' AFTER date_format_lite;

UPDATE `ps_lang` SET `date_format_lite` = 'd/m/Y' WHERE `iso_code` IN

('fr', 'es', 'it');

UPDATE `ps_lang` SET `date_format_full` = 'd/m/Y H:i:s' WHERE `iso_code`

IN ('fr', 'es', 'it');

UPDATE `ps_lang` SET `date_format_lite` = 'd.m.Y' WHERE `iso_code` =

'de';

UPDATE `ps_lang` SET `date_format_full` = 'd.m.Y H:i:s' WHERE `iso_code`

= 'de';

UPDATE `ps_lang` SET `date_format_lite` = 'm/d/Y' WHERE `iso_code` =

'en';

UPDATE `ps_lang` SET `date_format_full` = 'm/d/Y H:i:s' WHERE `iso_code`

= 'en';

 

Grtz Highlive

Unfortunately, It was not work at my PS. Error message is "duplicate date_format_lite"