mySql Error (PLEASE HELP!)

[yellowdaises]

I am getting an error:

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '11.4900" ,manufacturers_id=1 , products_status=1
WHERE
(products_id' at line 3
When executing:
UPDATE zen_products
SET
products_price="19.95" ,products_image="../catalogartwork/VP-DCM10B2VP.jpg", products_weight="0", products_tax_class_id="", products_date_available= NULL, products_date_added= "2007-02-01 08:53:29", products_last_modified=CURRENT_TIMESTAMP, products_quantity="20, products_price_w="11.4900" ,manufacturers_id=1 , products_status=1

does anyone have ANY idea how i can fix it? i've been trying to fix it on my own for the past 2 hours and even posted in the 'other contributions' folder but have had no success or help. i've even re-installed the files... PLEASE ANYONE :)

[yellowdaises]

and for the record i have checked my "max. values" and none are "0"

[Ajeh]

Where are you when you see this error?

What version Zen Cart?

What version php and MySQL?

What add-ons?

Go to the Admin and look in Tools ... Developer's Tool Kit ...

In the bottom input box type in:
CURRENT_TIMESTAMP

Select Catalog/Admin from the dropdown and click Search ...

What shows up?

Are you running EasyPopulate? If so you might look for the support threads on that add-on or go to the author's site for help ...

[yellowdaises]

when I look up "current_timestamp" i get:


Line #994 : expires_date < CURRENT_TIMESTAMP

Line #1797 : CURRENT_TIMESTAMP,

Line #1798 : CURRENT_TIMESTAMP

Line #1850 : CURRENT_TIMESTAMP,

Line #1851 : CURRENT_TIMESTAMP

Line #1889 : $v_date_added = ($v_date_added == 'NULL') ? CURRENT_TIMESTAMP : $v_date_added;

Line #1919 : CURRENT_TIMESTAMP,

Line #1946 : $v_date_added = zen_not_null($v_date_added) ? $v_date_added : CURRENT_TIMESTAMP; // if updating, but date added is null, we use today's date

Line #1960 : ', products_last_modified=CURRENT_TIMESTAMP' .

[superprg]

Do you have QuickBooks contribution installed?