Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 -You have an error in your SQL syntax


Recommended Posts

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 ' products_ordered = products_ordered - where products_id = '0'


update products set products_quantity = products_quantity + , products_ordered = products_ordered - where products_id = '0'




I have been trying to fix it and read a lot of topics, but I could not find the answer..... Could someone please help me?

The problem comes when I try to delete an order....



Link to comment
Share on other sites


I have been trying to find the code, but with no success.

The php is admin/orders.php

(installed edit orders) first it worked fine.


Now I did find another problem.

When something is sold from the product attributes the stock amount

is increased from the total stock but not from the option that what choosed.

This also did aldo work a while ago :( I must have done something stupid!!!!

For some reason I think they are related to eachother....???


I hope you could help me fix it?



Link to comment
Share on other sites


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

  • Create New...