Love the product but 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

I disable this product it's fine any help?



NVR Mind found the fix few pages back :)

Yea, I found this out like a minute after. >_> Hah. Thanks anyways.

Oh, by the way, in AdminCP, when I donate to a user, the user doesn't get it.
I'm using VbCredits Deluxe II

So mayhem has dropped the free vborg version, and only supports the paid version.

Kinda sucks. Didnt see this coming till weeks after no support here.

I'm fine if that's the case, but some sort of official announcement might be nice...

Database error in vBulletin 4.1.6:

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 > 1316366937



GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Monday, September 19th 2011 @ 12:08:57 PM
Error Date : Monday, September 19th 2011 @ 12:08:58 PM
Script : http://www.ellinofatsa.info/forums/online.php
Referrer : http://www.ellinofatsa.info/forums/forum.php
IP Address : xxxxxxxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.1.52

^Please search. The fix for that was posted a few pages back.

Under maintenance for this product, I am getting an error for the VBexperience addon. It is not validating and is spitting out: The point field has been entered but no data exists in this field name

I tried market_xperience but it's not working.

Ughh.... I move to South Carolina and take a small break from programming to find vBulletin has changed everything under the son and now I have to redo a bunch of stuff...........just great :P

Can anyone get me up to date on what is no longer working with the newer vBulletin versions?

When going to the 'Who's Online' page, you get this error:
Though, there is a simple temporary fix someone posted a few pages back, which was to disable Point Market: Users Online Colors Query in the Plugin Manager.

I am not sure if this is related to this mod, but TheMayem needs to take a look at this.

http://www.exploit-db.com/exploits/17141/