[MNNLeafre]

Originally Posted by TheMayhem

Ughh.... I move to South Carolina and take a small break from programming to find vBulletin has changed everything under the son and now I have to redo a bunch of stuff...........just great :P

Can anyone get me up to date on what is no longer working with the newer vBulletin versions?

When going to the 'Who's Online' page, you get this error:

Database error in vBulletin 4.1.6:

Invalid SQL:

	SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
	, user.market_username_color, 
user.market_username_glow, market_username_subscript, session.inthread, session.inforum, session.inwiki
	FROM session as session
	
	WHERE session.lastactivity > 1317092471
	
	
	
	GROUP BY isuser;

MySQL Error   : Unknown column 'user.market_username_color' in 'field list'
Error Number  : 1054
Request Date  : Monday, September 26th 2011 @ 08:16:11 PM
Error Date    : Monday, September 26th 2011 @ 08:16:11 PM
Script        : http://site.com/online.php
Referrer      : http://site.com/forum.php

Though, there is a simple temporary fix someone posted a few pages back, which was to disable Point Market: Users Online Colors Query in the Plugin Manager.