Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Top_Speed

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

Archived

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

×
×
  • Create New...