Junior
26.10.2005, 18:08
Hallo
Ich habe gerade die Anzahl der Newseinstellungen des vba CMPS verändert, als daraufhin auf der index.php (ist inzwischen die Portal-Indexseite) folgende Fehlermeldung kommt.
Datenbankfehler in vBulletin 3.5.0:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN forum AS forum USING (forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN icon USING (iconid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(178,184,239,364,574,589,630,867,972)
GROUP BY post.postid
ORDER BY sticky DESC,
LIMIT 10;
MySQL-Fehler : 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 'LIMIT 10' at line 24
Fehler-Nr. : 1064
Datum : Wednesday, October 26th 2005 @ 06:04:46 PM
Skript : http://www.typo3forum.net/testvb/
Referrer : http://www.typo3forum.net/testvb/
IP-Adresse : 83.79.157.211
Benutzername : Junior
Klassenname : vb_database
Irgendwas funktioniert wohl mit der Anzahl der 10 Themen nicht. Mhm.
Ins AdminCP komme ich noch. Nur die frontseite hats zerschossen...
Bin über jeden Denkanstoss glücklich :o
Danke und lieben Gruss
Junior
Ich habe gerade die Anzahl der Newseinstellungen des vba CMPS verändert, als daraufhin auf der index.php (ist inzwischen die Portal-Indexseite) folgende Fehlermeldung kommt.
Datenbankfehler in vBulletin 3.5.0:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN forum AS forum USING (forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN icon USING (iconid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(178,184,239,364,574,589,630,867,972)
GROUP BY post.postid
ORDER BY sticky DESC,
LIMIT 10;
MySQL-Fehler : 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 'LIMIT 10' at line 24
Fehler-Nr. : 1064
Datum : Wednesday, October 26th 2005 @ 06:04:46 PM
Skript : http://www.typo3forum.net/testvb/
Referrer : http://www.typo3forum.net/testvb/
IP-Adresse : 83.79.157.211
Benutzername : Junior
Klassenname : vb_database
Irgendwas funktioniert wohl mit der Anzahl der 10 Themen nicht. Mhm.
Ins AdminCP komme ich noch. Nur die frontseite hats zerschossen...
Bin über jeden Denkanstoss glücklich :o
Danke und lieben Gruss
Junior