You Have An Error In Your Sql Syntax

[ktiss]

hello

Having the following problem on:

 

Banner Manager

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 * from affiliate_banners order by affiliate_banners_title, affiliate_banners_group limit -20, 20

 

Affiliate Manager]

 

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 * from affiliate_affiliate order by affiliate_lastname limit -20, 20

 

This Happened after our server was hacked a few months back.

Everything else works

[Jack_mcs]

Download the latest oscommerce package (above menu, Solutions->Downlaods) and look at the update doc for split_page_result for the fix.

 

Jack