[solved]reduction from - sql query

[guest*]

Today I installed the modul ventes flash and this modul has reseted in the DB the tables "reduction_from "and "reduction_to" to 0000-00-00 00:00:00.
Now it is not possible to copy or edit any product without changing this into a valid date/time. It comes: "Fatal error (Product -> reduction_from = 0000-00-00 00:00:00)"

Is there any SQL-query I can set the reduction_from and reduction_to to a valid date (ex. 2010-12-15 00:00:00 for both tables ?)

[superprg]

Please try this query:

UPDATE PS_PRODUCT SET reduction_from = '2010-12-15 00:00:00' and reduction_to='2010-12-15 00:00:00';

[guest*]

Thx. Sorry I'm a really nooby in codes..
I tried your code and also this:

UPDATE 'ps_product' SET 'reduction_from' = '2010-10-01 00:00:00', 'reduction_to' = '2010-10-01 00:00:00';

UPDATE 'ps_product' SET 'reduction_from' = '2010-12-15 00:00:00';

UPDATE 'ps_product' SET reduction_from = '2010-12-15 00:00:00';

all with error in SQL syntax.

[superprg]

The given query is correct
Please check the name of the table in the database before running

[guest*]

Finally this one work: ps_product in capital letters do not find the table:

UPDATE ps_product SET reduction_from = '2010-12-15 00:00:00'

Thxs for your help.

[superprg]

oh, werent you using phpmyadmin?

[guest*]

No. I don't like phpmyadmin. I prefer Heidi SQL.

[vestax]

hello,

I'm having the same problem exists there a solution please?

UPDATE prestashop_product SET reduction_from = '2011-01-13 00:00:00' and reduction_to='2011-01-13 00:00:00'

0 ligne(s) affectée(s). ( Traitement en 0.0121 sec. )

[guest*]

??? The code stated below worked for me. What is your problem ?

0 ligne(s) affectée(s). ( Traitement en 0.0121 sec. ) - says that no line is affected, because you don't have any line matching the code you have typed. Try to type this in capital letters:

UPDATE PRESTASHOP_PRODUCT SET 

[evandrulbt]

I use this form..

UPDATE ps_product SET reduction_to = '2012-12-15 00:00:00'

UPDATE ps_product SET reduction_from = '2012-12-15 00:00:00' 

and now is working normal..

phpMyAdmin
Version: 3.3.3