09-12-2005, 12:43 AM
|
 |
|
|
Join Date: Jun 2004
Location: San Francisco
Posts: 2,575
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I used this in online.php (after putting it in the right spots in online.php) and it works fine as long as there are no guests online. The second a guest comes online i get this.
Quote:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo,
NOT ISNULL(customprofilepic.userid) AS haspic,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN customprofilepic AS customprofilepic ON(customprofilepic.userid=user.userid)
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1126487892
ORDER BY user.username asc
mysql error: Cross dependency found in OUTER JOIN. Examine your ON conditions
mysql error number: 1120
Date: Sunday 11th of September 2005 09:33:12 PM
Script: http://www.net-fam.com/online.php?
Referer: http://www.net-fam.com/forums.php
Username: gio~logist
IP Address: xx.xxx.xxx.xx
|
|
Linear Mode
