SQL Error when tabels are empty...?

[runweb]

Hi, there !

When i have empty MySQL-tables (without any entries), than I get an error in my Webshop/Admin-Area when I klick on a link which is connected to these empty tables. When I insert 1 entry to the tabels, the error message is gone...

 

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 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 = '2' order by p.affiliate_payment_id DESC limit -20, 20

 

This is only a sample - it is always coming up, when tables are empty (not only at the osc affiliate contrib)

 

My System:

Server Host: Server072 (xx.xx.xx.xx.) Datenbank Host: localhost (xxx.x.x.x.)

Server OS: Linux 2.6.8-2-386 Datenbank: MySQL 4.1.11-Debian_4sarge2-log

Server Datum: 24.04.2006 06:54:37 Datenbank Datum: 24.04.2006 06:54:37

Server Up Time: 06:54:37 up 60 days, 15:53, 0 users, load average: 0.00, 0.00, 0.00

HTTP Server: Apache/2.0.54 (Debian GNU/Linux) DAV/2 SVN/1.1.4 PHP/4.3.10-16

PHP Version: 4.3.10-16 (Zend: 1.3.0)

 

Any Idea what there could be wrong with the code ?