Database Error 1054 in vB 3.7.0 RC3

[Breathex]

Hi all,

I get this error since 3.6.8 and don't remember when it started to show up. When my moderator try to enter "sent messages" in their inbox, this error shows up;

Database error in vBulletin 3.7.0 Release Candidate 3:
Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = cc;
MySQL Error : Unknown column 'cc' in 'where clause'
Error Number : 1054
Date : Sunday, May 11th 2008 @ 05:37:29 PM
Script : http://xxxx/private.php?s=&pp=&folderid=-1
Referrer : http://xxxx/private.php?
IP Address : 85.107.33.1
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.58

I searched this error in this forum and in Google but couldn't find anything to solve this problem. This error shows up for only moderator usergroup in my forum.

I'm using 3.7.0 RC3 and i hope you can give me the key to solve this problem.

Regards,
Breathex

[Jose Amaral Rego]

List #2 in this thread...


Try uploading original vBulletin version non-image files in ASCII mode (except install.php and images folder) to overwrite those on server

http://files.vbulletin.com/doc_images/uploadpackage/upload_start.png (http://www.vbulletin.com/docs/html/uploadpackage)

You can just try this to see if you have any files that do not belong or have not been overwritten from an upgrade.
Admin Control Panel > Maintenance > Diagnostics > Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Disable plugins from file includes/config.php and add this right under <?php on the next empty line or uninstall any modification(s) that have not been updated to work with new vBulletin stable release


<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 3.7.0 - Licence Number 1a2b3c4
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ©2000-2007 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| ################################################## ################## ||
\*================================================ ======================*/




<?php
define('DISABLE_HOOKS', true);
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 3.7.0 - Licence Number 1a2b3c4
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ©2000-2007 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| ################################################## ################## ||


/*================================================= =====================*\


To create a new style, click the [Add New Style] link underneath the main body of the Style Manager.

This will bring up the Add New Style interface. You then choose [No Parent Style], next view using new style and do you still get this issue.
http://files.vbulletin.com/doc_images/styles/stylemanager_add.png (http://www.vbulletin.com/docs/html/stylemanager_add_new_style)


If the above steps do not resolve issue, then please create a user with administrators permission to edit vBulletin options / forum permission and private message me with the details and I will see what is going on or if Staff ask then let them in.

Enable these option, so I can poke around. I do not have 3.7.0, but I have been working on other members site and know about some of the new functions added since 3.7.0 Beta 5.

Can Administer Styles
Can Administer Forums
Can Administer Threads
Can Administer Plugins

[Breathex]

Jose Amaral Rego, thanks for the reply but it didn't work.

I was looking for a basic solution like in this thread;

http://www.vbulletin.com/forum/showthread.php?t=173006

These two errors are similar and i thought that a query entry could be a solution for this.

How can i solve the problem with this line? ;

WHERE user.userid = cc;
MySQL Error : Unknown column 'cc' in 'where clause'


What is "cc"?

p.s: Some of my old moderators who are in member usergroup now, view this error message when they try to reach "sent messages" area in their inbox.

[Jose Amaral Rego]

Bot this was hard to get some answer on this one. Still stands on what I said in my post #2.
http://www.vbulletin.org/forum/showthread.php?t=147291