[Datenpapst]

Datenbankfehler in vBulletin 4.1.4:

Invalid SQL:

SELECT stream.lastmsgid AS lastmsgid, stream.lastchatmsgid AS lastchatmsgid, COUNT(ulist.relationid) AS friendsonline
FROM iwt_chat_updatestream AS stream
LEFT JOIN userlist AS ulist ON (ulist.userid=stream.uid AND ulist.friend='yes' AND ulist.relationid IN (
SELECT stream2.uid
FROM iwt_chat_updatestream AS stream2
WHERE stream2.lasttouch > 1314894854
))
WHERE stream.uid=144;

MySQL-Fehler : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Fehler-Nr. : 1140
Fehler-Zeit : Thursday, 01.09.2011 @ 18:38:14
Datum : Thursday, 01.09.2011 @ 18:38:15
Skript : http://www.c-arena.com/ideal_chat_update_stream.php
Referrer : http://www.c-arena.com/forum.php
IP-Adresse : XXXXXX
Benutzername : XXXXX
Klassenname : vB_Database
MySQL-Version :