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 when creating the store:

 

1) In the administrative/configuration/catalog section, click on the stores link.

 

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.

 

I've emailed this error to one of the developers, but I was told that the mail should be sent to the last person who updated the module. But I got the email from the install-instructions. It's quite disappointing. So I can only post the message to the forum, hopefully the developer who updated this module could see it. or anyone can advise how to fix the error? Thanks.

 

 

lee ching

[♥Vger]

Read the "1064" link below my signature.

 

Vger