PDA

View Full Version : Online User List error


DTingley
Mon 16th Jun '03, 2:36pm
I cannot view the Online User List on my forums, it gives this error:

Database error in vBulletin 3.0.0 Beta 3:
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,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb3_session AS session
,user
WHERE session.lastactivity > 1055783575
AND session.userid = user.userid
ORDER BY user.username asc

mysql error: Table 'twoblock_vb3.user' doesn't exist

mysql error number: 1146
Date: Monday 16th of June 2003 12:27:56 PM
Script: http://www.twoblock.com/vb3/online.php?
Referer: http://www.twoblock.com/vb3/index.php?
Username: DTingley
IP Address: xx.xx.xx.xx

It worked for a while after the forum was first installed (it was a fresh install), but it has stopped working. I'm currently trying to work out what had changed between the times it was working and now.

Chris M
Mon 16th Jun '03, 2:41pm
I cannot view the Online User List on my forums, it gives this error:

Database error in vBulletin 3.0.0 Beta 3:
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,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb3_session AS session
,user
WHERE session.lastactivity > 1055783575
AND session.userid = user.userid
ORDER BY user.username asc

mysql error: Table 'twoblock_vb3.user' doesn't exist

mysql error number: 1146
Date: Monday 16th of June 2003 12:27:56 PM
Script: http://www.twoblock.com/vb3/online.php?
Referer: http://www.twoblock.com/vb3/index.php?
Username: DTingley
IP Address: xx.xx.xx.xx

It worked for a while after the forum was first installed (it was a fresh install), but it has stopped working. I'm currently trying to work out what had changed between the times it was working and now.
Have you modified the database or files in any way?

Satan

DTingley
Mon 16th Jun '03, 2:45pm
The only changes made to files was the BB Code Fix (http://www.vbulletin.com/forum/showthread.php?threadid=73814) that Kier posted, which wouldn't really be related to the Online User List.

Chris M
Mon 16th Jun '03, 2:50pm
Have you applied any other fixes to your files?

Satan

Freddie Bingham
Mon 16th Jun '03, 2:52pm
Have you applied any other fixes to your files?

SatanAccording to the message your user table is 'gone'. You should find more than that Who's Online not working. Is that not the case?

DTingley
Mon 16th Jun '03, 2:55pm
Who's Online seems to be the only thing that isn't working.

Everything else seems to be absolutely fine.

Freddie Bingham
Mon 16th Jun '03, 3:01pm
Yeah my fault..

find this line in online.php (around line 124) .. or you could turn Guests back online on Who's Online

". iif($vboptions['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ",user") ."

Replace with

". iif($vboptions['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."

DTingley
Mon 16th Jun '03, 3:07pm
Thanks freddie, works perfectly now.

Chris M
Mon 16th Jun '03, 3:34pm
Yeah my fault..

find this line in online.php (around line 124) .. or you could turn Guests back online on Who's Online

". iif($vboptions['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ",user") ."

Replace with

". iif($vboptions['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
Thanks for the fix freddie:)

Satan