SQL syntax error from a fresh installation

[BrentonV]

I have just installed AABox.com osCMax V1.7 (September 2004) and am getting the following error when using the admin panel with an empty database.

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 '-10, 10' at line 1

select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -10, 10

This error is being reported from:

Catalog -> Manufacturers
Catalog -> Reviews
Catalog -> Specials
Catalog -> Products Expected

From memory it is also apprearing in a few other places.

This is occurring on a fresh install of Apache, PHP, MySQL and osCMax.
All install files were downloaded in the last 24-hours and should be the latest available. I am not sure if I’ve got everything “tweaked” just right although it does seem to work with the exception of this error. This install is on Win-XP and in-house.

This is my first install of all of these programs so I'm a little confused.
Can anyone offer any suggestion as to where I should start looking?

[BrentonV]

A little more playing and I have worked out that both osC and oscMAX do this when there is no record in a table.

Is this normal ?
Is there something I can or should modify in the code to stop this occuring ?

Sorry if this sounds like a dumb question.
Yes, I'm a newbie :P

[BrentonV]

I found the problem. It is an old bug in osCommerce which will hit people who attempt a clean install on the latest versions of MySQL. There was also a bug in versions of MySQL prior to 4.0 which allowed the bug in osCommerce to work sorta-kinda This glitch also exists in oscMAX

The fix can be found HERE

Can I suggest that the Mods make this thread sticky as new people like myself with current versions of everything will keep getting hit by this.

[groggory]

Just put it in the wiki

http://www.oscdox.com/modules.php?op...name=Ms2MaxFAQ