Affiliates Page error

[rolucus20]

Im getting these errors under my affiliates section in the admin its some errors in the code that i need to know how to fix under the affiliate_affiliates.php page when i click it this pops up "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 '-12, 12' at line 1

 

select * from affiliate_affiliate order by affiliate_lastname limit -12, 12

 

[TEP STOP]"

 

when i click the affiliate_payment.php i get 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 '-12, 12' at line 1

 

select p.* , s.affiliate_payment_status_name from affiliate_payment p , affiliate_payment_status s where p.affiliate_payment_status = s.affiliate_payment_status_id and s.affiliate_language_id = '1' order by p.affiliate_payment_id DESC limit -12, 12

 

[TEP STOP]"

 

its more pages under this section with the same or similiar error pls help..

[Guest]

see the bug fix at the end of this page.

http://www.oscommerce.com/community/bugs,1605

[rolucus20]

see the bug fix at the end of this page.

http://www.oscommerce.com/community/bugs,1605

 

 

Thanks alot worked great!!