No announcement yet.

DB Error in online.php after upgrading

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] DB Error in online.php after upgrading

    Hello, I upgraded from 4.0.2 to 4.0.4 patch 2 and I am getting a Database error when I open online.php

    Database error in vBulletin 4.1.4:
    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
    	FROM vb_session as session
    	WHERE session.lastactivity > 1311438462
    	GROUP BY isuser;
    MySQL Error   : Unknown column 'user.market_username_color' in 'field list'
    Error Number  : 1054
    Request Date  : Saturday, July 23rd 2011 @ 10:42:42 AM
    Error Date    : Saturday, July 23rd 2011 @ 10:42:42 AM
    Script        : /forum/online.php
    Referrer      : /forum/forum.php
    IP Address    : *********
    Username      : ******
    Classname     : vB_Database
    MySQL Version : 5.1.56
    Please help

  • #2
    There is no 'market_username_color' filld in the default vB. That query and error is from an add-on you installed. You need to either remove that add-on or contact the author for a fix.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.