[Forum] Who's Online Broken after 4.1.4 Upgrade

[CeleronXT]

After upgrading to 4.1.4, Who's Online is broken. I get this error:

Database error in vBulletin 4.1.4:


Invalid SQL:


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

WHERE session.lastactivity > 1307673533



GROUP BY isuser;


MySQL Error : Unknown column 'user.steam' in 'field list'
Error Number : 1054
Request Date : Thursday, June 9th 2011 @ 11:08:53 PM
Error Date : Thursday, June 9th 2011 @ 11:09:15 PM
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-community

This error goes away if I re-upload the old 4.1.3 PL1 online.php file. I see some changes between the files in WinMerge. Any ideas on a fix?

Thanks

[Steve Machol]

There is no such column in the default vB.

To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Next, disable all products (except vB Blog, vB CMS and Skimlinks if you have them.)

Admin CP -> Plugins & Products -> Manage Products -> Disable

Then manually uncheck all plugins that are not for 'vBulletin Blog' and vBulletin CMS' here:

Admin CP -> Plugins & Products -> Plugin Manager

You must do BOTH of those steps in order to disable all non vBulletin Modifications.

Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

Do you have the same problem?

[CeleronXT]

I guess it was one of my plugins. Actually, the Steam plugin. Had I not misread the error message as "stream," I might have noticed. WGO is working again.

However, several files show up as suspect even though I've reuploaded them directly from the stock vbulletin zip, including index.php, forum.php, /clientscript/yui/history/assets/blank.html and /includes/class_editor_override.php and includes/functions_wysiwyg.php.

[Trevor Hannant]

/includes/class_editor_override.php and includes/functions_wysiwyg.php were removed as per the announcement here:

https://www.vbulletin.com/forum/showthread.php/381438-vBulletin-4.1.4-now-available-for-download?p=2169041&viewfull=1#post2169041

The others should be OK.

[CeleronXT]

/includes/class_editor_override.php and includes/functions_wysiwyg.php were removed as per the announcement here:

https://www.vbulletin.com/forum/showthread.php/381438-vBulletin-4.1.4-now-available-for-download?p=2169041&viewfull=1#post2169041

The others should be OK.

Ah thanks, deleted those. Not sure what's up with forum.php and index.php though.

[Trevor Hannant]

Not sure - they don't show up as suspect on my test install.