PDA

View Full Version : Database error


Bratz-Designs
02-27-2006, 09:37 AM
Hey all,

Sorry for yet again a problem but this one is really buggin me and my members.
I have the forum set up that guests can see the forums but cant see the topics. If the guests click the forum anyway they can a database error

There seems to have been a problem with the Bratz-Designs.com database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.


Any ideas how to solve that?

Marco van Herwaarden
02-27-2006, 09:39 AM
You would need to post the full error message that is sent to your technical mail.

Alternative is to right click on the page and then View Source to see the full error.

Bratz-Designs
02-27-2006, 09:43 AM
Dankje,

Hier is de complete error:

<!--
Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT
IF(votenum &gt;= 1, votenum, 0) AS votenum,
IF(votenum &gt;= 1 AND votenum &gt; 0, votetotal / votenum, 0) AS voteavg,

thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views&lt;=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount


,post.pagetext
FROM vb3_thread AS thread






WHERE thread.threadid IN (0)
ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Monday, February 27th 2006 @ 12:42:50 PM
Script : http://www.bratz-designs.com/forums/forumdisplay.php?f=144
Referrer : http://www.bratz-designs.com/forums/index.php
IP Address : ******
Username : Unregistered
Classname : vb_database
-->

Marco van Herwaarden
02-27-2006, 12:17 PM
You probably have a Hide hack installed that is causing this. Uninstall that hack and it should be solved.

ibuddy
05-02-2006, 02:33 PM
man i been looking all over for help on this! Finally you are right it was the HIDE HACK I disabled that and it worked! thanks