The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Brand New Board getting a Search Error when I test it out?
Just doing some test searches and its giving me a database error?
What could this be, its a brand new board? |
#2
|
|||
|
|||
we can't help if we have no details...
what error (what is on the screen --copy/paste) and a url to test it out if possible |
#3
|
|||
|
|||
Database error
The .com database has encountered a problem. Please try the following: * Load the page again by clicking the Refresh button in your web browser. * Open the shmaba.com home page, then try to open another page. * Click the Back button to try another link. The .com forum technical staff have been notified of the error, though you may contact them if the problem persists. We apologise for any inconvenience. Thats all it shows. |
#4
|
|||
|
|||
ok, read the source of the page, you will see the error in a hidden spot of the page...
|
#5
|
|||
|
|||
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html> <head> <title>ShMaBa.com Database Error</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" /> <style type="text/css"> <!-- body { background-color: white; color: black; } #container { width: 400px; } #message { width: 400px; color: black; background-color: #FFFFCC; } #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; } .bodytext { font: 8pt/11pt verdana, arial, sans-serif; } a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; } a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; } --> </style> </head> <body> <table cellpadding="3" cellspacing="5" id="container"> <tr> <td><img src="http://shmaba.com//image.php?type=dberror" alt="Database Error" width="48" height="48" /></td> <td id="bodytitle" width="100%">Database error</td> </tr> <tr> <td class="bodytext" colspan="2">The ShMaBa.com database has encountered a problem.</td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td class="bodytext" colspan="2"> Please try the following: <ul> <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li> <li>Open the <a href="/">shmaba.com</a> home page, then try to open another page.</li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> </td> </tr> <tr> <td class="bodytext" colspan="2">The shmaba.com forum technical staff have been notified of the error, though you may <a href="mailto:subdizzle@gmail.com">contact them</a> if the problem persists.</td> </tr> <tr> <td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td> </tr> </table> <!-- Database error in vBulletin 3.7.2: Invalid SQL: SELECT post.pagetext AS preview, 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, replycount, IF(views<=replycount, replycount+1, views) AS views, thread.lastpost, thread.lastposter, thread.lastpostid , user.userid AS postuserid , thread.field1 AS field1, thread.field2 AS field2, 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 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 (17, 13); 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 : Wednesday, August 27th 2008 @ 09:34:12 PM Error Date : Wednesday, August 27th 2008 @ 09:34:13 PM Script : http://shmaba.com/search.php?searchid=12 Referrer : http://shmaba.com/search.php?do=process IP Address : 76.239.27.127 Username : Unregistered Classname : vb_database MySQL Version : --> </body> </html> |
#6
|
|||
|
|||
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php define('DISABLE_HOOKS', true); If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. |
#7
|
|||
|
|||
Still doing it.
--------------- Added [DATE]1220370050[/DATE] at [TIME]1220370050[/TIME] --------------- Heres a error I get when I try to search a membert Database error in vBulletin 3.7.2: Invalid SQL: SELECT post.pagetext AS preview, 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, replycount, IF(views<=replycount, replycount+1, 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 , thread.field1 AS field1, thread.field2 AS field2, 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 subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 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 (19, 18); 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 : Tuesday, September 2nd 2008 @ 08:40:06 AM Error Date : Tuesday, September 2nd 2008 @ 08:40:07 AM |
#8
|
|||
|
|||
Do you get this error with all modifications diabled and original source files?
I really doubt it as the offending part of the query does not look like a default vB query to me. |
#9
|
|||
|
|||
Ive Disabled them all. Im still getting it. The Member search worked right when I turned the Paypal donate feature off but I still cant do a regular search.
Database error in vBulletin 3.7.2: Invalid SQL: SELECT post.pagetext AS preview, 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, replycount, IF(views<=replycount, replycount+1, 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 , 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 subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 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 (17, 13); 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 : Tuesday, September 2nd 2008 @ 12:08:38 PM Error Date : Tuesday, September 2nd 2008 @ 12:08:38 PM Script : http://shmaba.com/search.php?searchid=19 Referrer : http://shmaba.com/search.php IP Address : 68.78.69.175 Username : ShMaBa Classname : vb_database MySQL Version : 4.1.22-max-log |
#10
|
||||
|
||||
Go to Maintenance > Diagnostics > Suspect File Versions and I'll bet some files show up that are part of a modificaiton. Remove those files (if they are not vb files) or replace those files (if they are vb files) and see if you still get the error.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|