PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : MySQL Fehler 1109


M_A_D
08.03.2006, 22:20
Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 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<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, threadread.readtime AS threadread
,post.pagetext
FROM thread AS thread

LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 39 AND canview = 1)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 39)



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

MySQL-Fehler : Unknown table 'post' in field list
Fehler-Nr. : 1109
Datum : Wednesday, March 8th 2006 @ 05:24:34 PM
Skript : http://www.japanation.at/forum/forumdisplay.php?f=16
Referrer : http://www.japanation.at/forum/index.php?
IP-Adresse : 195.116.23.153
Benutzername : tompat13
Klassenname : vb_database

Die Frage ist jetzt: Warum tritt dieser Fehler auf?
Die Tabelle "post" existiert natürlich... Und ich selbst erhalte auch keinen Datenbankfehler beim Aufruf des betreffenden Skripts.

Mystics
08.03.2006, 23:09
Deaktiviere das Plug-in, das den Einstiegspunkt forumdisplay_query verwendet. Darin steht vermutlich:$hook_query_fields = ',post.pagetext';

M_A_D
08.03.2006, 23:20
danke