View Full Version : logged in OK, not db error
bulbasnore
12-29-2004, 04:47 PM
If I'm logged in (say by going to forums) I can load the cmps_index.php just fine. If not, I get the db error:
There seems to have been a slight problem with the PokeGym Forum database.
Please try again by pressing the refresh button in your browser.
Is this characteristic of a common problem?
Any pointers?
Brian
12-29-2004, 04:56 PM
View the source of that page and then post it here.
bulbasnore
12-30-2004, 12:34 AM
Wow! That's a nice debug:
<html><head><title>PokeGym Forum Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </p><p class="error"><b>There seems to have been a slight problem with the PokeGym Forum database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:onederlnd@pokegym.net">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
<!--
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT
thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, post.pagetext AS preview
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(40,41,2,18,23,24,42,43) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10
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 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost D
mysql error number: 1064
Date: Wednesday 29th of December 2004 11:31:02 PM
Script: http://pokegym.net/cmps_index.php
Referer:
Username: Unregistered
IP Address: 137.159.134.35
-->
</body></html>
bulbasnore
12-30-2004, 09:40 AM
As a followup to this, I can't see the home page as a registered user, either.
That is, I can log in to the forums, then try to go to the home page and I get this message.
Brian
12-30-2004, 09:57 AM
Please try the fix posted in this thread (http://www.vbadvanced.com/forum/showthread.php?t=830).
bulbasnore
12-30-2004, 10:11 AM
Bingo! Thanks so much.
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.