Jump to content

Geen datum en taal probleem


Recommended Posts

In mijn facturen staat geen datum. De oorzaak opgezocht en ik vond bij talen een probleem.

Ik kan geen aanpassingen opslaan ik krijg deze foutmelding.

Dat zal mijn datum probleem ook zijn.

Maar wat is de oplossing?

Unknown column 'date_format_lite' in 'field list'

Link to comment
Share on other sites

Probleem is opgelost

Dit script uitgevoerd

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';

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...