Zen Cart Logo
Forums / General Questions / mySql Error (PLEASE HELP!)

mySql Error (PLEASE HELP!)

Locked

Views: 1,227

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
19 Feb 2007, 10:00 PM
#1
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

mySql Error (PLEASE HELP!)

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 :)

19 Feb 2007, 10:06 PM
#2
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: mySql Error (PLEASE HELP!)

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

20 Feb 2007, 12:21 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: mySql Error (PLEASE HELP!)

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 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

21 Feb 2007, 4:08 PM
#4
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: mySql Error (PLEASE HELP!)

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

21 Feb 2007, 8:21 PM
#5
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: mySql Error (PLEASE HELP!)

Do you have QuickBooks contribution installed?

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!