View Full Version : Brand New Board getting a Search Error when I test it out?
Shmaba
08-28-2008, 12:32 AM
Just doing some test searches and its giving me a database error?
What could this be, its a brand new board?
nexialys
08-28-2008, 12:34 AM
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
Shmaba
08-28-2008, 12:58 AM
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.
nexialys
08-28-2008, 01:02 AM
ok, read the source of the page, you will see the error in a hidden spot of the page...
Shmaba
08-28-2008, 03:34 AM
!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>
Marco van Herwaarden
08-28-2008, 08:43 AM
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.
Shmaba
09-02-2008, 02:38 PM
Still doing it.
--------------- Added 1220370050 at 1220370050 ---------------
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
Marco van Herwaarden
09-02-2008, 02:46 PM
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.
Shmaba
09-02-2008, 06:10 PM
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
Lynne
09-02-2008, 07:57 PM
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.
Shmaba
09-02-2008, 07:59 PM
./
billspaypal.php File not recognized as part of vBulletin
billspaypal_donated.php File not recognized as part of vBulletin
gdform.php File not recognized as part of vBulletin
itrader.php File not recognized as part of vBulletin
itrader_detail.php File not recognized as part of vBulletin
itrader_feedback.php File not recognized as part of vBulletin
itrader_global.php File not recognized as part of vBulletin
itrader_report.php File not recognized as part of vBulletin
missing.html File not recognized as part of vBulletin
webformmailer.php File not recognized as part of vBulletin
welcome.html File not recognized as part of vBulletin
Scanned 59 files
./admincp
duplicator.php File not recognized as part of vBulletin
itrader_misc.php File not recognized as part of vBulletin
threadfields_admin.php File not recognized as part of vBulletin
Scanned 3 files
./archive
Scanned 45 files
./clientscript
Scanned 4 files
./clientscript/yui
Scanned 2 files
./clientscript/yui/connection
Scanned 2 files
./clientscript/yui/yahoo-dom-event
Scanned 2 files
./images/regimage/fonts
Scanned 127 files
./includes
class_dm_itrader.php File not recognized as part of vBulletin
functions_itrader.php File not recognized as part of vBulletin
Scanned 18 files
./includes/cron
Scanned 8 files
./includes/paymentapi
Scanned 11 files
./includes/xml
bitfield_itrader.xml File not recognized as part of vBulletin
cpnav_duplicator_b3.xml File not recognized as part of vBulletin
cpnav_extra_threadfields.xml File not recognized as part of vBulletin
cpnav_itrader.xml File not recognized as part of vBulletin
Scanned 82 files
./install
Scanned 10 files
./modcp
Lynne
09-02-2008, 09:35 PM
Try removing the files related to itrader (at least. I know that is a modification.)
When installing modifications, you need to add one at a time and test your board inbetween adding each one. That way, when you get errors, you know which modification is causing it. At that point, you should go back over all the installation instructions and make sure you didn't miss a step. If you still have errors, then when you disable the modification, you need to remove all of the files and template edits also.
Shmaba
09-03-2008, 02:07 PM
Removed I trader and still doing it.
Lynne
09-03-2008, 04:21 PM
Removed I trader and still doing it.
You need to remove all the files from modifications, especially ones in the includes and below includes folders.
Shmaba
09-03-2008, 05:38 PM
You need to remove all the files from modifications, especially ones in the includes and below includes folders.
Just removed every file and still doing it.
Lynne
09-03-2008, 07:42 PM
OK, if you have removed all files from modifications, turned off all plugins/products, are using a totally default style, then the only thing left to do is to reupload all the original vb files.
If that doesn't work, then I suggest you put in a Support Ticket.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.