MySQL problem

[calle]

I have a problem in admin and i think it has to do with MySQL. For example when i try to look at "products reviews" I get this message:


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 reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20


What should I do? Re-install MySQL? Please help....

[red_fraggle]

YIKES !!! DO NOT RE-INSTALL MYSQL

It's a syntax error, meaning the query is incorrect. I would have to look at the code to tell you whats wrong though.

[sargenle]

Originally Posted by red_fraggle

YIKES !!! DO NOT RE-INSTALL MYSQL

It's a syntax error, meaning the query is incorrect. I would have to look at the code to tell you whats wrong though.

Hi.

I also am having a similiar problem except my error is -5, 5

Could you shed some light on my problems as well.

A little background information.

I was in admin deleting manufactures as I don't use them and when I deleted the last one I got the same error message in Manufactures, Reviews and specials.

Do you need to look at the associated PHP files to find the problem.

I can email them to you if you are interested in taking a look.

Sincerely.

Leon

[Lord]

What version of MySQL are you using? Check Server Info in Admin under Tools.

I have the same problem for Specials, Reviews, Orders, Products Expected, Newsletters if they are "empty". I manually added a newsletter via MySQL and the error dissapeared. BUT - this means that you always needs to have a product inserted in Specials, Products Expected and so on.
Looks like this happends when you use MySQL 4.16 or newer? The webhosting company using MySQL 4.17 on the shops where I have this problems (3 shops).
Have other shops on other webhosting companies that runs MySQL 4.0.16 - No problems with this version.

Is it anyone that has a clue on whats wrong?

In the forums on Oscommerce.com there is a lot of posting regarding this problem. Can't see any solution so far.