Guest Posted January 26, 2005 Share Posted January 26, 2005 B) I am receiveing thte following error in the admin section when I click gift voucher queue. 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 '-10, 10' at line 1 select c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from customers c, coupon_gv_queue gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N') limit -10, 10 What do I need to do to rectify this? TIA Tom :'( Quote Link to comment Share on other sites More sharing options...
OceanRanch Posted January 26, 2005 Share Posted January 26, 2005 Looks like bug.....from http://www.oscommerce.com/community/bugs,1605 **************** Easiest solution: edit /includes/classes/split_page_results.php find $this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page; (line about 66) insert before it if($offset <0 ) $offset = 0; the same in admin//includes/classes/split_page_results.php do the same, but this time it's line about 38 ****************************** HTH Tom Quote Link to comment Share on other sites More sharing options...
Guest Posted January 27, 2005 Share Posted January 27, 2005 Thanks oh...... what does HTH mean? Quote Link to comment Share on other sites More sharing options...
OceanRanch Posted January 27, 2005 Share Posted January 27, 2005 Hope This Helps :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.