Database error on search New Posts

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dxflw
    Senior Member
    • Jun 2008
    • 138

    Database error on search New Posts

    Database error in vBulletin 3.8.0 Alpha 2:

    Invalid SQL:

    SELECT post.pagetext AS preview,post.thankscache,
    thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
    thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
    thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,

    thread.replycount, IF(thread.views<=thread.replycount, replycount+1, thread.views) AS views,
    thread.lastpost, thread.lastposter, thread.lastpostid
    ,
    deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
    user.userid AS postuserid
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , threadread.readtime AS threadread
    , firstpostid, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
    FROM thread AS thread
    LEFT JOIN user AS user ON(user.userid = thread.postuserid)

    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
    LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 402)
    LEFT JOIN subscribethread AS subscribethread
    ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 402 AND canview = 1)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

    LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
    WHERE thread.threadid IN
    (2806, 3845, 4814, 3111, 5001, 914, 5492, 5497, 5495, 5494, 5493, 4807, 5342, 672, 3892, 4419, 2418, 3467, 5489, 5491, 5375, 5490, 5347, 5487, 5486);

    MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
    Error Number : 1140
    Request Date : Friday, February 20th 2009 @ 04:12:01 PM
    Error Date : Friday, February 20th 2009 @ 04:12:02 PM
    Script : http://+++++++++.com/forum/search.php?searchid=16292
    Referrer : http://++++++++.com/forum/search.php?do=process
    IP Address : #######
    Username : +++++++++
    Classname : vB_Database
    MySQL Version : 5.0.32-Debian_7etch6-log
    Last edited by dxflw; Fri 20 Feb '09, 6:22am.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    You need to upgrade to 3.8.0 gold or 3.8.1. The version you are running is not supported.

    When vBulletin creates a new table in the upgrade process, it asks MySQL what the default collation for the database is and then uses that. Most MySQL installations default to latin1_swedish_ci. If you have changed collations for any reason on tables in the past then you should change the database to use that as the default to prevent this issue from happening in the future.

    You will find more information in the MySQL manual here:


    You will need to use phpMyAdmin and make sure that all tables and fields within them have the same collation. Make sure your database collations are appropriate and consistent throughout the entire database. You need to use program like phpmyadmin to view your collations:



    When you click your database name in phpmyadmin it will list all tables, their collations, as well as the collation of the database itself at the bottom. And when you click the name of a table on the left it will list the collations of individual fields within that table.

    1) To edit the collation of the database itself you need to click the database name on the left and then click "Operations" on the top.

    2) To edit the collation of an individual table you need to click its name on the left and then click "Operations" on the top.

    3) To edit the collation of an individual field within a table you need to click the table name on the left and then click the edit image (a little pencil icon) for that field.

    For more information please see: http://www.vbulletin.com/forum/showt...ight=collation

    Note: It is very very very important to make full database backups before proceeding if you are ever manually making any changes to your database, let it be issuing queries, or editing it via phpMyAdmin or any other interface. If done incorrectly, manually modifying the database can potentially cause irreversible damage to your database, and there is no way to perform a "partial restore" to restore just the part you may break.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • dxflw
      Senior Member
      • Jun 2008
      • 138

      #3
      I have login to phpmyadmin my i dont understand what i have to do and how...

      The collation is:
      latin1_swedish_ci

      and:
      utf8_general_ci

      some tables have utf8_general_ci and some latin1_swedish_ci

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...