Online User List error [Archive] - vBulletin Community Forum

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