Property Category->date_add is not valid

[hmisland]

Hi

I have imported 500 categories using csv file, thanx to prestashop 1.6 everythings goes well, but when i want to edit any of categories i get error Property Category->date_add is not valid

How can i solve this?there was no such field in csv.

Because i have edited and added photoes manually , dont ask me to import again, its a month of work.

Thank you

[bellini13]

You would likely need to edit the ps_category database table and provide a value in the date_add field.  Set the value equal to the date/time you imported the data

[hmisland]

Table exist, but no such field in whole database!unfortunatly!

Plz help

[bellini13]

and what exact version of PS are you using?  and are you sure you are looking at the right information, the ps_category table has both date_add and date_upd, as do many other tables.

[hmisland]

and what exact version of PS are you using?  and are you sure you are looking at the right information, the ps_category table has both date_add and date_upd, as do many other tables.

U r right, sorry for my mistake, they exist as you say, now can u please tell me how to change them all toghether?

They are all set on 00.00.00 00:00 but they have update date and time, just one field need to be changed in 500 rows!

[bellini13]

you could try this command, which will update only those records where the date_add is '00.00.00 00:00'.  The date_add will be updated to the value in date_upd

update ps_category set date_add = date_upd where date_add = '00.00.00 00:00'

Or you could run this command which will update every single category record.

update ps_category set date_add = date_upd

[hmisland]

 

you could try this command, which will update only those records where the date_add is '00.00.00 00:00'.  The date_add will be updated to the value in date_upd

update ps_category set date_add = date_upd where date_add = '00.00.00 00:00'

Or you could run this command which will update every single category record.

update ps_category set date_add = date_upd

Thanx a million!

that works perfect.