I've integrated the QTpro contrinb into my system with help from coffman, but i've got what i think is a bug.
I can't reproduce this all the time for some reason.
I have a product Black, Size: 16, quantity of 1.
I'm trying to change the sizes from 16 to Large, and to do that i wan't to delete the stock. Usually I change the stock to zero - sometimes it disapears from the list, and sometimes it set the quantity on the list to 0.
When i do this today, i get the following 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 'where products_id=53' at line 1
update products set products_quantity= where products_id=53
As a temporary measure, where can i make the changes in the database to delete this stock entry?
Any ideas would be very much appreciated, i'd really like to sort this out.