Guest Posted December 24, 2005 Share Posted December 24, 2005 Hi, I seem to have developed an error... I had some offers for Christmas and deleted them on 23rd as the offers stopped. I just deleted the category containing the products and it said that there were items in this category, was i sure i wanted to delete it.. So i click yes as i didn?t need them anymore... Now in the orders i have the following under products: 1 x Christmas Package - Special Delivery?: No1064 - 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_attribut select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 141 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id [TEP STOP] Any clues? Cheers, Neil Link to comment Share on other sites More sharing options...
tina_boots Posted December 24, 2005 Share Posted December 24, 2005 Hi, I seem to have developed an error... I had some offers for Christmas and deleted them on 23rd as the offers stopped. I just deleted the category containing the products and it said that there were items in this category, was i sure i wanted to delete it.. So i click yes as i didn?t need them anymore... Now in the orders i have the following under products: 1 x Christmas Package - Special Delivery?: No1064 - 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_attribut select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 141 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id [TEP STOP] Any clues? Cheers, Neil I can see the error in the SQL statement: ota.products_id = and It's missing the right side of that statement. What you will have to do is find that code and try to determine why its rendering that particular way. I know not a lot of help, but maybe a clue. Be well, Tina If you're not having fun you're not doing it right Teach a person to fish rather than give them a loaf of bread or however that saying goes. Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2005 Share Posted December 31, 2005 Hi Tina, Thanks for the reply.. The only way I could get the information back was to add the category and then add the products that were deleted and set them to inactive. Cheers, Neil Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.