HiGhLaNdeRPT Posted December 9, 2004 Share Posted December 9, 2004 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '4' and s.orders_status_id = '2' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [TEP STOP] The only working tab is the pending, the rest won't work, I get this error, anyone knows a fix for this ? Using: PHP 5.0.2 Mysql 4.1.7-standard Thanks Link to comment Share on other sites More sharing options...
♥ozcsys Posted December 9, 2004 Share Posted December 9, 2004 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '4' and s.orders_status_id = '2' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [TEP STOP] The only working tab is the pending, the rest won't work, I get this error, anyone knows a fix for this ? Using: PHP 5.0.2 Mysql 4.1.7-standard Thanks <{POST_SNAPBACK}> Have you applied the php5 fix yet. If not that would be a good place to start. The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right?? Link to comment Share on other sites More sharing options...
HiGhLaNdeRPT Posted December 9, 2004 Author Share Posted December 9, 2004 hmm where is that fix? can you point it? I think i've applied something a few weeks ago can't remember if it was for osc or phpbb :P prolly phpbb. Thanks Link to comment Share on other sites More sharing options...
HiGhLaNdeRPT Posted December 9, 2004 Author Share Posted December 9, 2004 I reverted back to php4.3.9 and i got the same error, only processing works, pending and delivered won't work! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.