[TheMayhem]

Originally Posted by jazan

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

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 Budget101

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).

Go to the Admin CP, Point Market, Under Market Settings make sure that the store part is enabled. If if is, please pm me and we will see what is going on.