Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Major error is admin - Please help


tim_ver

Recommended Posts

Posted

I installed the latest version of oscommerce and had no problems at all smooth install. I the went into admin and went through all options to make sure they worked, all good. I started to add products and delete the default categories and change some also. all seemed fine until I went to Catalog and then reviews which gave me an error also so did specials and products expected. Also under reports for the items "products purchased and customer orders totals and under tools the newsletter options" I get same errors. The errors are as follows:

 

 

Reviews: Reviews

 

Products Rating Date Added Action

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 '-20, 20' at line 1

 

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

 

[TEP STOP]

 

 

 

Specials: Specials

 

Products Products Price Status Action

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 '-20, 20' at line 1

 

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

 

[TEP STOP]

 

 

Products expected: Products Expected

 

Products Date Expected Action

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 '-20, 20' at line 1

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

 

[TEP STOP]

 

 

 

 

Product purchased: Best Products Purchased

 

No. Products Purchased

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 '-20, 20' at line 1

 

select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20

 

[TEP STOP]

 

 

Customer orders totals: Best Customer Orders-Total

 

No. Customers Total Purchased

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 '-20, 20' at line 1

 

select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC limit -20, 20

 

[TEP STOP]

 

 

newsletter manager: Newsletter Manager

 

Newsletters Size Module Sent Status Action

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 '-20, 20' at line 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]

 

 

 

 

 

 

These had no error on first install. What do I need to do to fix this? Please someone help me out I just entered a ton of items.

 

 

If this helps. Ths os is: Linux 2.4.21-27.0.1.ELsmp and php is: 4.4.2 (Zend: 1.3.0)

 

 

Thanks :)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...