nickeswede73 Posted November 30, 2004 Share Posted November 30, 2004 Hello! I have installed the Order IP Recorder v1.0 contribution. Everything works but when I change the order status to deliverd I get this answer: 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 ' ipaddy orders where orders_id = '119'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased from, ipaddy orders where orders_id = '119' [TEP STOP] Obviosly there is something wrong with the contribution pack, good for others to know if thats the case. Do anybody know how to fix the above problem in SQL? Niklas, Sweden Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2004 Share Posted December 1, 2004 I do. Just remove the ",ipaddy, ipisp" from /admin/orders.php when instructed to add it to: $order_updated = false; $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased, it doesn't belong there. Greetings from Laurel, MD, USA, Steve Carbin Link to comment Share on other sites More sharing options...
nickeswede73 Posted December 1, 2004 Author Share Posted December 1, 2004 Thanks for your answer, I will do it tonight and see if it works out! Niklas, Sweden 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.