Zen Cart Logo
Forums / General Questions / Fatal error with adding products (v1.1.x)

Fatal error with adding products (v1.1.x)

Locked

Views: 1,568

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
4 Jun 2006, 8:41 AM
#1
zalokar avatar

zalokar

New Zenner

Join Date:
Feb 2004
Posts:
11
Plugin Contributions:
1

Fatal error with adding products (v1.1.x)

Hi!

When i click on the "products" in a admin to add new one, i get this:

Fatal 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 '-10, 10' at line 13] in EXECUTE("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_model, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.products_quantity_order_max from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id in /home/users/www/solvere01/www.solvere.si/trgovina/includes/classes/adodb/adodb-errorhandler.inc.php on line 142

O know it's an old version, that needs upgrading, but it was working before and I don't have much time for upgrading right now.

How can i solve this until i upgrade? Thank you very much.

6 Jun 2006, 7:18 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Fatal error with adding products (v1.1.x)

If it was "working before", then perhaps going back to a backup of your site may help.
Downloading a copy of your server's files and comparing them to what it's "supposed to" have may be a good way to identify where problems may exist (such as a file getting corrupted on the server somehow, etc).

Otherwise, I suggest you work on upgrading. I don't imagine you'll find much help for troubleshooting v1.1.x code when there's been more than 10 releases of bugfixes, updates, new features, faster code, etc since your version came out 2-3 years ago.