Database error help plz

[SPEEDKILLZ]

I get this when i click the whos online (12users) link


Database error in vBulletin 4.1.5:

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 session as session

WHERE session.lastactivity > 1316390092



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Monday, September 19th 2011 @ 04:09:52 AM
Error Date : Monday, September 19th 2011 @ 04:09:52 AM
Script : http://www.yourdomain.com/online.php
Referrer : http://www.yourdomain.com/forum.php
IP Address : xx.xx.xx.xxx
Username : xxxxx
Classname : vB_Database
MySQL Version : xxxxx

[HMBeaty]

That error is from a modification. Possibly the vBBux/VBPlaza mod? or some type of market modification....

[SPEEDKILLZ]

I have ucash? what should i do?

But when i disable it and reload there is still an error

[HMBeaty]

Disable it and ask/search in the modifications thread for a fix

[SPEEDKILLZ]

ok it is the point market thanks

[wheretobet]

Originally Posted by SPEEDKILLZ

I get this when i click the whos online (12users) link


Database error in vBulletin 4.1.5:

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 session as session

WHERE session.lastactivity > 1316390092



GROUP BY isuser;

this bug is caused by Point Market. You can disable the plugin OR you can comment/delete the hook causing the error in the online.php


open online.php

at line 280 remove this line of code


$hook_query_fields

thats it!

and boom goes the dynamite