Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    2
    Plugin Contributions
    0

    Default read review button - sql error

    Hi everyone,

    Have the following problem. When you click the read reviews button
    on the bottom of the product page i get an sql error

    http://www.gigagood.com/index.php?ma...cb0ceaa492e6f2

    ( recensies buttom , bottom left)

    The error is

    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 '-0, 0' at line 6
    in:
    [SELECT r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name FROM reviews r, reviews_description rd WHERE r.products_id = 481 AND r.reviews_id = rd.reviews_id AND rd.languages_id = 2 and r.status = 1 ORDER BY r.reviews_id desc limit -0, 0]

    specs:
    zen 1.3.5
    php 4.4.4
    MySQL 4.1.20

    Thanks in advance,
    Dave

  2. #2
    Join Date
    Jan 2007
    Posts
    2
    Plugin Contributions
    0

    Default Re: read review button - sql error

    bump. Help is very much appreciated.

 

 

Similar Threads

  1. Mod Authors: Please read if you are creating install.sql files
    By swguy in forum Contribution-Writing Guidelines
    Replies: 2
    Last Post: 1 Dec 2014, 01:42 AM
  2. Dgreviews mod support required read review should = write review
    By limelites in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 13 Aug 2013, 06:34 PM
  3. read review button gone after upgrade
    By simpledomaining in forum Upgrading to 1.5.x
    Replies: 6
    Last Post: 6 Feb 2013, 05:03 AM
  4. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  5. Sql error when email button selected in Coupons
    By Ryk in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 9
    Last Post: 6 Oct 2006, 05:29 PM

Posting Permissions

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