error in virtual mall v1.2

[leeching]

Hi,

 

I downloaded the virtualMall V1.2 module, and also followed the instructions and updated the codes. I

deleted the existing oscommerce database, created new db. I got the error after I did the follwing:

 

1) In the administrative/configuration/catalog section, click on the stores link and enter in all

the information for each store that you wish to have.

 

the error message is as follows:

"

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 store_id, store_name, store_image, date_added,

last_modified, store_owner_fname, store_owner_lname,

store_email_address, store_add_one, store_add_two,

store_city, store_state, store_country, store_zipcode,

store_telephone, store_fax from stores order by

store_name limit -20, 20

"

 

the MYsql version I use is mysql-4.1.14-win32.

 

Can anyone advise how to fix the error? Thanks.

 

lee ching