Results 1 to 4 of 4

MySQL problem

This is a discussion on MySQL problem within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; I have a problem in admin and i think it has to do with MySQL. For example when i try ...

      
  1. #1
    Member
    Join Date
    Sep 2004
    Posts
    31
    Rep Power
    0


    Default MySQL problem

    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....

  2. #2
    Active Member red_fraggle's Avatar
    Join Date
    Feb 2004
    Location
    wilmington, NC
    Posts
    343
    Rep Power
    8


    Default

    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.

  3. #3
    Lurker
    Join Date
    Sep 2004
    Posts
    2
    Rep Power
    0


    Default 1064 Error

    Quote 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

  4. #4
    New Member
    Join Date
    Apr 2004
    Posts
    20
    Rep Power
    0


    Default

    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.

Similar Threads

  1. Compatible with PHP 4.33 and mysql 3.23
    By the_error_king in forum osCmax v2 Installation issues
    Replies: 6
    Last Post: 06-15-2005, 08:19 PM
  2. Problem with MySQL 4
    By SpongeBob in forum osCMax v1.7 Installation
    Replies: 2
    Last Post: 04-14-2005, 12:47 PM
  3. MySQL? Please help!
    By extremenewb in forum osCommerce 2.2 Installation Help
    Replies: 3
    Last Post: 09-22-2004, 08:31 AM
  4. mySQL database
    By mattias2 in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 10-23-2003, 07:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •