Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error messages at the admin section. Help!


Guest

Recommended Posts

Error messages at the admin section

 

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 '-6, 6' 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 -6, 6

 

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 '-6, 6' 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 -6, 6

Link to comment
Share on other sites

Best Products Purchased
Best Customer Orders-Total

 

That's not a part of any osCommerce that I know. Are you sure you're not using another shoppig cart?

 

As far as the error goes look below my name.

 

Vger

Link to comment
Share on other sites

That's not a part of any osCommerce that I know. Are you sure you're not using another shoppig cart?

 

As far as the error goes look below my name.

 

Vger

 

Hi! Yes. It is a osCommerce that I am using. Could be possible that it is a modified shopping cart. Thanks!!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...