Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Alter a product (name) and past orders have error...


Recommended Posts

Hi all


When I change an item (products) name by even one letter... and go into an order that had that item on it I get this 1046 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 'and pta.products_text_attributes_id = ota.products_text_attributes_id' at line 1


select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 1676 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id


ANY ideas???


Thanks, KJ

define('PROJECTS', 'Something that goes on forever!');

Link to comment
Share on other sites

I believe the problem is here


and ota.products_id = and


you should have a valid products id to check against.

Link to comment
Share on other sites


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

  • Create New...