Vbet Error online users Vb 4.1.4

[vBET]

When you go to What's Going On at the bottom of the main forum page and want to see who's online, it gives an error message: SaabWorld

I noticed it also shows an error on your site: http://www.vbenterprisetranslator.com/forum/online.php

Please see here for solution: http://www.vbenterprisetranslator.co....html#post9251

[Wulf]

Thanks so much, fix worked great.

[Schmike]

Got the following error after upgrading to VB4.1.5:

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.vbet_def_lang AS vbet_def_lang
FROM session as session

WHERE session.lastactivity > 1312876228



GROUP BY isuser;

MySQL Error : Unknown column 'user.vbet_def_lang' in 'field list'
Error Number : 1054
Request Date : Tuesday, August 9th 2011 @ 04:20:28 PM
Error Date : Tuesday, August 9th 2011 @ 04:20:28 PM
Script : PredatoryFishKeepers.com
Referrer : PredatoryFishKeepers.com
IP Address :
Username : Schmike
Classname : vB_Database
MySQL Version : 5.0.92-community

[vBET]

Got the following error after upgrading to VB4.1.5:

Please see here for solution: http://www.vbenterprisetranslator.co....html#post9251

[Schmike]

I did raise an issue on this in vBulletin support forum and was told that this is a vBet plugin bug.

[vBET]

I did raise an issue on this in vBulletin support forum and was told that this is a vBet plugin bug.

Of course this is caused by vBET, but because of vBulletin bug which was added by vBulletin team in vB4.1.4 (as I remember). The root cause is confirmed vBulletin bug. Just fallow the link send before and you will find:
1. Quick fix
2. Link to vBulletin bug report (status: confirmed)

In other words – vBET uses here vBulletin hook which has bug. So not using the hook will eliminate the issue. And it is not vBET bug - it affects EACH mod which is trying to use the hook and add own query statement with user columns. Please fallow quick fix instructions which will disable one vBET functionality. This functionality (showing user flag on who is online) will be able to use again after vBulletin team fix their bug.

[Schmike]

Have applied the workaround. Thanks.