EXTRA IMAGES 1.4 - SQL SYNTAX ERROR IN ADMIN PANEL

[Guest]

Hi I am using the contribution for Extra Images 1.4 posted by Kaiser and ***orchid***. Thanks.

 

However, I am having a problem. I haved used it on another server and it works fine. But now I am trying to run it on a server with MySQL 4.1.11 and I keep getting the following SQL Syntax error in the ADMIN/CATALOG/EXTRA IMAGES link:

 

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 pei.products_extra_image, pei.products_extra_images_id, pei.products_id, p.products_model,p.products_image from products_extra_images pei left join products p ON pei.products_id = p.products_id order by p.products_model limit -20, 20

 

THIS IS THE LINE IN QUESTION:

 

$products_extra_images_query_raw = "select pei.products_extra_image, pei.products_extra_images_id, pei.products_id, p.products_model,p.products_image from " . TABLE_PRODUCTS_EXTRA_IMAGES . " pei left join " . TABLE_PRODUCTS . " p ON pei.products_id = p.products_id order by p.products_model";

 

Can anyone tell me what the error is as I am very new to PHP. Very new. Thanks in advance for any help you may be able to provide.