Vbet Error online users Vb 4.1.4

[Maciej]

VBET causes an error on my website:

Online users: the link at the bottom of the page show error datebase initiated by vBET

Database error in vBulletin 4.1.4:

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> 1307804989



GROUP BY isuser;

MySQL Error: Unknown column 'user.vbet_def_lang' in 'field list'
Error Number: 1054
Request Date: Saturday, June 11th 2011 @ 11:39:49 AM
Error Date: Saturday, June 11th 2011 @ 11:39:49 AM
Script: http://gooutdoor.co/online.php
Referrer: gooutdoor.co
IP Address: xxxxxxxx
Username: xxxxxxxx
Classname: vB_Database
MySQL Version: 5.0.91-log

The problem arose after upgrading from vb 4.1.3 to 4.1.4 of

Help

[vBET]

Hi. First please check do you have column vbet_def_lang in your user table. Also is it User or user? If the column doesn't exists, please import vBET product file again. It should be created during installation.

As I see in your query there is no table user taken at all.. We tested it on vB4.1.2 - I'm checking vB sources right now, also I will test it on 4.1.4. Please tell how to reproduce - on which page you see this issue?

[vBET]

I just checked vBET and vBulletin codes. vBET adds this column to query by hook online_query. And vBulltin 4.2.1 uses there query:

SELECT user.username, session.useragent, session.location, session.lastactivity, 
	user.userid, user.options, 
	session.host, session.badlocation, session.incalendar, session.inthread,  
	user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid, user.usergroupid
$hook_query_fields
FROM " . TABLE_PREFIX . "session AS session
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
$hook_query_joins
WHERE session.lastactivity > $datecut
	". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ."
	$hook_query_where
ORDER BY $sqlsort $sortorder

I will check how it looks in vB4.1.4 in few minutes.

[vBET]

OK. Just checked vB4.1.4 source and it looks similar:

	SELECT user.username, session.useragent, session.location, session.lastactivity, 
		user.userid, user.options, 
		session.host, session.badlocation, session.incalendar, session.inthread,  
		user.aim, user.icq, user.msn, user.yahoo, user.skype,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid, user.usergroupid
	". iif($showmembers AND $showguests AND $showspiders, ", IF(ISNULL(user.username), 1, 0) as isguest", "") ."
	$hook_query_fields
	FROM " . TABLE_PREFIX . "session AS session
	". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
	$hook_query_joins
	WHERE session.lastactivity > $datecut
		". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") . 
		   iif(!$showmembers, " AND ISNULL(user.username)", "") ."
		$hook_query_where
		$where
	ORDER BY ". iif($showmembers AND $showguests AND $showspiders, "isguest,", "") ." $sqlsort $sortorder LIMIT $limitlower, $perpage

But I just realized that user table is not always joined. And this i the thing. You must have turned on option WOLguests. Then it should be alright.

Please turn the option on and tell is it ok.

For next release I will made changes in vBET code so it will not crash when someone will have the option turned off.

[Maciej]

The problem is when she wants to go see who is active on the board at the bottom you can check it out. When you want to see a list of crashes me a problem ..
How to enable WOLguests?

[vBET]

Options should be as follows (read to the end):
a) You can disable a plugin called vBET Get olin language users
b) You can modify the plugin code Get olin language users at:

if ($vbulletin->options['WOLguests']) {
$hook_query_fields .= ', user.vbet_def_lang AS vbet_def_lang';
} 

Options modify the plugins can be found in CP Admin -> Plugins & Products -> Plugin Manager
c) You can turn on the option that operates with parameter WOLguests ieAdmin CP -> Setting -> Options -> Who's Online Options set the parameter Who's Online Display Guests.

Nevertheless, I looked at this very closely and I see that the table user is used anyway - just with either merging to the left or without. So the error that you should not take place (only a pity that does not know )
Therefore, the options 'b' and 'c' should not work. For this option 'a' is degrading because it excludes one of the features ... We can not reproduce this error on our server. Please podeślij the PM data access the Admin CP and FTP is a problem we will spot and solve it instead of off functionality.

[vBET]

No need to send details of access. I forgot that it was concerned 4.1.4 - I did a test forum and update zreprodukowałem error. Soon will post a quick solution.

[vBET]

Now I know why the error is. It's the next question. As for me, looks like a bug vBulletin, because the two queries using the variable $ Hook_query_fieldsAnd the second query is not available all the columns.

Officially opened a bug in the system of vBulletin: Link to bug
We'll see how to react - whether they are improving or not they consider as an error.

At the moment the solution is to turn off the plugin: Get olin language users. If vBulletin considers it his mistake and correct the matter is closed - the next update you will need to enable the plugin. If vBulletin agrees that this is not an error, we will combine.

[wowglider.de]

Hello,
i installed latest Vbulletin, Vbseo, Vbseo Sitemap and now vbet, everything works perfect, except of the online.php.

Thanks for Help


http://www.bitcoins-deutschland.de/
http://forum.bitcoins-deutschland.de/

Database error in vBulletin 4.1.4:

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 > 1307997785
	
	
	
	GROUP BY isuser;

MySQL Error   : Unknown column 'user.vbet_def_lang' in 'field list'
Error Number  : 1054
Request Date  : Monday, June 13th 2011 @ 10:58:05 PM
Error Date    : Monday, June 13th 2011 @ 10:58:05 PM
Script        : http://forum.bitcoins-deutschland.de/online.php
Referrer      : http://forum.bitcoins-deutschland.de/online.php
IP Address    : 178.25.151.181
Username      : admin
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.51a-24+lenny5

[vBET]

Thanks fro note. We are already aware about this (thread merged). We noted it as official vBulletin bug and we are waiting to see will vBulletin admit it is their bug and correct it or we will have to fight with it on our side (vBulletin bug report).

Quick fix for now: please just disable plugin Get oline users language.