New Posts
Welcome guest, is this your first visit?
  • Login:
Closed Thread
Results 1 to 2 of 2

Thread: Comment Error

  1. #1
    PAL Red Pro
    My Status
     
    ----
     

    Add as a friend
    Join Date
    Nov 2008
    Location
    USSA
    Posts
    5,123
    Blog Entries
    358
    Feedback Score
    6 (100%)

    Default Comment Error

    I tried to make a comment on one of the test auctions up now and got the following error.

    Tommy once these things are fixed just write fixed and lock the thread.

    Database error in vBulletin 4.1.2:

    Invalid SQL:

    SELECT COUNT(DISTINCT(userid)) AS usercount, COUNT(*) AS usercountall, rating
    FROM vb_itrader
    WHERE rateduserid =
    GROUP BY rating;

    MySQL Error : 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 'GROUP BY rating' at line 4
    Error Number : 1064
    Request Date : Tuesday, June 21st 2011 @ 05:21:54 PM
    Error Date : Tuesday, June 21st 2011 @ 05:21:54 PM
    Script : http://www.pokeraffiliatelistings.co...o=showpost&id=
    Referrer : http://www.pokeraffiliatelistings.co...place_show.php
    IP Address : 67.165.138.81
    Username : Jeremy
    Classname : vB_Database
    MySQL Version : 5.0.92-community

  2. #2
    vB Guru
    Test
     
    ----
     

    Add as a friend
    Join Date
    Jan 2009
    Location
    Michigan
    Posts
    298
    Feedback Score
    2 (100%)

    Default

    Fixed


 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Powered by vBulletin® Version 4.1.5
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
SEO by vBSEO 3.6.0