PDA

View Full Version : SQL Error When Clicking all Users Online


BlipHost
11-30-2011, 04:51 PM
When I click "28 Users Online" in the stats at the bottom of the forum, I get this SQL Error:

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT userid
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1322674527;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Wednesday, November 30th 2011 @ 12:50:27 PM
Error Date : Wednesday, November 30th 2011 @ 12:50:27 PM
Script : [Link to my forums/online.php]
Referrer : [Link to my forums/forum.php]
IP Address : 184.14.182.141
Username : Deity
Classname : vB_Database
MySQL Version : 5.0.91-log

From the invalid query I'm guessing it's a problem with the market, is there any way to solve this without removing the plug-in? Some of my users have collected a large number of points, and I'm trying to solve this without taking those away.

kh99
11-30-2011, 05:06 PM
It's possible that you could reinstall the mod and retain any points users have, but it depends on how the install code works. Or you could try just creating a column with that name in your user table.

You should ask questions about mods in the mod thread.