Customers/Orders broken after sql upgrade

[ashsama]

Upgraded sql to 4.1.14 just now, following the guide under gentoo's docs, everything went smooth,

re-imported the database and while reconfiguring under the admin controlpanel when I enter Customers / Orders I get the following 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 '-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 = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

[TEP STOP]

 

I know my way around linux in general but this is my first oscommerce project and I've never used mysql before, any ideas how to smoothly fix this error? Any help appreciated!

[ashsama]

Cancel that, found a sollution, cheers!

[MarcoZorro]

Maybe you could post the solution in case others have the same problem?

[Guest]

Would you like to share I have a similar problem.

[Guest]

Here is a solution to the error

 

http://www.oscommerce.com/forums/index.php?showtopic=144095