SQL Error in admin/orders.php

[mc_exotics]

I installed two contributions into my store, including the SQL in my database for:

 

Hide Price if $0 v.2 and

Download_Controllev5.4 MS2.2

 

and now in admin/orders.php I am getting this 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 'limit 0, 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 = '1' and ot.class = 'ot_total' order by limit 0, 20

 

[TEP STOP]

 

I can't figure out what file has this error in it though, or how to fix it. Is the error in my SQL database, or one of my PHP files? Can anyone please help me figure out how to fix it?

 

Thanks!

[Guest]

You can find the solution at: http://www.oscommerce.com/community/bugs,1...2B%28General%29

[mc_exotics]

You can find the solution at: http://www.oscommerce.com/community/bugs,1...2B%28General%29

<{POST_SNAPBACK}>

That bug-fix seems to be something for negative values but my error is:

 

Check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 20' at line 1

 

I don't have a problem with negative values, so how would this bug-fix work? Again, I've only had the problem since I installed the two contributions, not before.