Originally Posted by jazan (Post 2104793)

Hello
i get this error when uninstall the mod

Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
session.userid, session.inforum, session.lastactivity, session.badlocation,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1285781970

ORDER BY username ASC;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Script : http://xxx.com/vb/forum.php
Referrer : http://xxx.com/vb/market_bank.php
Classname : vB_Database
MySQL Version : 5.1.50

Originally Posted by Budget101 (Post 2104810)

installed this on a Test Frm to take a look and decide if I want to try it on my live site, however, the Shop part of the Market doesnt showm despite having several items set up in it (with qty of 10 each).

Originally Posted by TheMayhem (Post 2104880)

This is caused by an upgrade that didn't work correctly. To fix this, please go to the Admin CP, Point Market, and underneath the Maintenance section there are two things you should run. First is the table checker, which will ensure all tables are installed with the latest settings, the second is a field checker, which will check all fields. This will add any fields that haven't been added yet.

Originally Posted by TheMayhem (Post 2103689)

vb 4 will have a maintenance release probably today