[Forum] umm this bug...

[Hall of Famer]

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

WHERE session.lastactivity > 1310041461



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Thursday, July 7th 2011 @ 07:24:21 AM
Error Date : Thursday, July 7th 2011 @ 07:24:21 AM
Script : http://www.pokemonmysidia.com/forum/...e&pp=20&page=1
Referrer : http://www.pokemonmysidia.com/forum/forum.php
IP Address : 206.217.66.43
Username : Hall of Famer
Classname : vB_Database
MySQL Version : 5.1.56-community-log

Anyone knows how to fix it?

[Trevor Hannant]

That's from Point Market System modification. You'll either need to uninstall and remove all files for this or contact the author for support.

[Hall of Famer]

I see, I will contact the point market mod owner for info, thanks.

[Rahstyles]

I see, I will contact the point market mod owner for info, thanks.

thanks