
09-09-2011, 03:42 PM
|
|
|
Join Date: Oct 2010
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Refreshing des not work and this database fault is in the output!
Whats wrong??
Quote:
Datenbankfehler in vBulletin 4.1.5:
Invalid SQL:
SELECT stream.lastmsgid AS lastmsgid, stream.lastchatmsgid AS lastchatmsgid, COUNT(ulist.relationid) AS friendsonline
FROM midaka61iwt_chat_updatestream AS stream
LEFT JOIN midaka61userlist AS ulist ON (ulist.userid=stream.uid AND ulist.friend='yes' AND ulist.relationid IN (
SELECT stream2.uid
FROM midaka61iwt_chat_updatestream AS stream2
WHERE stream2.lasttouch > 1315586019
))
WHERE stream.uid=2;
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 : Friday, 09.09.2011 @ 16:37:39
Datum : Friday, 09.09.2011 @ 16:37:39
Skript : http://www.4wheelfreestyle.com/ideal...ate_stream.php
Referrer : http://www.4wheelfreestyle.com/onlin...e&pp=20&page=1
IP-Adresse : 80.131.69.216
Benutzername : thomas
Klassenname : vB_Database
MySQL-Version : 5.0.51a-3ubuntu5.8
|
Thanks for your help
|