[Forum] online.php errors

[DAMINK]

Upgrade to 4.1.12

Noticed after upgrade some usergroups are getting a database error now when viewing who is online.
This was not happening before upgrade.

	Database error
The FTW Forum database has encountered a problem.
Please try the following: Load the page again by clicking the Refresh button in your web browser. Open the www.ftw.net.au home page, then try to open another page. Click the Back button to try another link.
The www.ftw.net.au forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.

[DAMINK]

Ok i have obviously tried disabling all mods and that did not help.
I then tried other usergroups and found some worked just fine so started editing the usergroups that were failing.
Turns out i have to have have the below selected in order for it to stop errors.

"Can 'See' Users Who Have Chosen to be Invisible While Online" selected to yes or it will give this database error.

[AusPhotography]

Sounds like a bug -- jira time

[McGyver]

I haven't upgraded my Live forum yet, but I tested what you say in my Test environment and can't replicate it.
When a user is invisible, the members of a usergroup with "Can 'See' Users Who Have Chosen to be Invisible While Online" OFF simply don't see the user in the who's online page.

The exact database error (should have been logged or sent via email) could be useful.

[DAMINK]

I haven't upgraded my Live forum yet, but I tested what you say in my Test environment and can't replicate it.
When a user is invisible, the members of a usergroup with "Can 'See' Users Who Have Chosen to be Invisible While Online" OFF simply don't see the user in the who's online page.

The exact database error (should have been logged or sent via email) could be useful.

Thanks for the reply mate. Appreciate you testing to check.
Here is the database error.

Database error in vBulletin 4.1.12:  
Invalid SQL:     
    SELECT session.userid     , 
    IF(user.options & 512, 1, 0) AS invisible               
    FROM vbsession AS session     
    LEFT JOIN user AS user USING (userid)               
    WHERE session.lastactivity > 1334058668;  
    MySQL Error   : Table 'XXXXXXX_vbulletin.user' doesn't exist 
    Error Number  : 1146 
    Request Date  : Tuesday, April 10th 2012 @ 10:06:08 PM 
    Error Date    : Tuesday, April 10th 2012 @ 10:06:08 PM 
    Script        : http://www.ftw.net.au/online.php?ord...e&pp=20&page=1 
    Referrer      : http://www.ftw.net.au/online.php 
    IP Address    : XXXXXXXXX 
    Username      : XXXXXXXXX 
    Classname     : vB_Database 
    MySQL Version :

[zny_pan]

Getting the same:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT session.userid
, IF(user.options & 512, 1, 0) AS invisible


FROM vb_session AS session
LEFT JOIN user AS user USING (userid)


WHERE session.lastactivity > 1334060443;

MySQL Error : Table 'xxx_vbulletin.user' doesn't exist
Error Number : 1146
Request Date : Tuesday, April 10th 2012 @ 12:30:43 PM
Error Date : Tuesday, April 10th 2012 @ 12:30:44 PM
Script : http://www.xxx/online.php
Referrer : http://www.xxx/forum.php
IP Address : 71.183.xxx.xxx
Username : AS
Classname : vB_Database_MySQLi
MySQL Version :

[McGyver]

Looks like you are using a table prefix (I don't).

There's something mentioned here about this.
Probably something was missed...

Perhaps you could remedy this yourself until someone from vB staff joins the thread.

[ENF]

Edit:

I couldn't reproduce this error with a vb4.1.12 file set using a database with or without prefixes.

Strange...

[McGyver]

A JIRA ticket should be opened for this as soon as possible.
You shouldn't rely on the forum to remedy bugs, as JIRA the first thing the vB staff looks at.

[Ezswo]

I can confirm this error. I also upgraded to 4.1.12 and got the exact same database error.
As Administrator I can still see the online.php file without errors, but "normal" users get the error.

Looking forward to a solution for this. Meanwhile I will disable the option.

[punchbowl]

http://tracker.vbulletin.com/browse/VBIV-14659

This fix was added to 4.1.12 https://www.vbulletin.com/forum/show...=1#post2282142

[DAMINK]

http://tracker.vbulletin.com/browse/VBIV-14659

This fix was added to 4.1.12 https://www.vbulletin.com/forum/showthread.php/399363-vBulletin-4-1-12-FULL-has-been-released-(vBulletin-com-upgraded)?p=2282142&viewfull=1#post2282142

Thankyou mate. Weird no staff took the time to let the people here know or specifically reply to this thread.
Not surprised though to be honest. Why would they want to reply to a paid customer that has a problem with THERE product.

[DAMINK]

https://www.vbulletin.com/forum/show...=1#post2282142
Seems it was posted over a day after i posted this thread. Damn why not reply to this thread so myself and others will know there is a problem with Q&A?
Again its not my problem here but VB. There paid staff screwed up. Why not atleast notify the paid users to this so we can fix it?
Instead i have to sort through posts that were posted after my thread regarding the exact issue.

[McGyver]

https://www.vbulletin.com/forum/show...=1#post2282142
Seems it was posted over a day after i posted this thread. Damn why not reply to this thread so myself and others will know there is a problem with Q&A?
Again its not my problem here but VB. There paid staff screwed up. Why not atleast notify the paid users to this so we can fix it?
Instead i have to sort through posts that were posted after my thread regarding the exact issue.

I'd humbly suggest to subscribe to the Announcement forum and also monitor the Tracker (perhaps via a filter subscription on new tickets).
It was the first thing I did when I was appointed as a vB forum administrator and it makes my life a lot easier...

We can't expect vB staff to be our personal assistants .

[DAMINK]

I'd humbly suggest to subscribe to the Announcement forum and also monitor the Tracker (perhaps via a filter subscription on new tickets).
It was the first thing I did when I was appointed as a vB forum administrator and it makes my life a lot easier...

We can't expect vB staff to be our personal assistants .

Thankyou for the reply mate but i think i have overstayed my welcome here now.
I wont bother anyone anymore.