The 'database error' reporting topic

[Wayne]

A database error can be caused by a faulty mod, a failed or incomplete upgrade, or a break in the coding of some aspect of the site.

http://www.vanityedge.com/forum/images/databaseerror.PNG



This is an example of what a database error looks like. Please use this topic to report any database errors you come across, no matter how frequent or sporadic they are. The likelihood of a database error being part of a more serious, and wide ranging issue is high. We've been compromised before, and these sorts of errors can cause similar compromises in the future.

So please take the time to report any you come across. There are two ways you should report these errors:


By print screening the error, and posting it in the topic - as above
Or - the more preferable and easy method - copying ALL of the code inside of the yellow box and pasting it in this topic, inside of the [code] or [quote] tags, so it looks like this:

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



GROUP BY isuser;


MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 26th 2011 @ 11:31:30 PM
Error Date : Tuesday, July 26th 2011 @ 11:31:31 PM
Script : http://www.vanityedge.com/forum/online.php
Referrer : http://www.vanityedge.com/forum/forum.php
IP Address : 86.184.155.128
Username : Wayne
Classname : vB_Database
MySQL Version : 5.0.92-community

Many thanks!