1064 -You have an error in your SQL syntax

[lemmikkijengi]

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'

 

[TEP STOP]

 

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

 

-Carola

[ruizerwin]

Hii

 

Do you have the file where can i c the code

Or tell me the php file on your system

[lemmikkijengi]

Hi,

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?

 

-Carola