I have already seen the same issue discussed in another thread, but was asked to make a new thread for the issue.
Version of vbulletin: 2.3.0 (with patches)
Version of mysql: 5.0.38
Version of php: 5.2.1
1 example of problem:
Going to User Control Panel (usercp.php), creates this error:
Database error in vBulletin 2.3.0:
Reply to thread makes this error:
I saw somebody talked about inserting some () in the code to get this to work. Could anybody give me some tips what to change to get this running?
PS: vb3 upgrade is not an option at this moment and neither is any change of mysql.
Version of vbulletin: 2.3.0 (with patches)
Version of mysql: 5.0.38
Version of php: 5.2.1
1 example of problem:
Going to User Control Panel (usercp.php), creates this error:
Database error in vBulletin 2.3.0:
Code:
Invalid SQL: SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='1' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 ORDER BY dateline DESC mysql error: Unknown column 'privatemessage.iconid' in 'on clause' mysql error number: 1054
Code:
Database error in vBulletin 2.3.0: Invalid SQL: SELECT user.*, style.templatesetid FROM subscribethread,user,usergroup LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid) WHERE subscribethread.threadid='5421' AND subscribethread.userid=user.userid AND usergroup.usergroupid=user.usergroupid AND user.userid<>'1' AND user.usergroupid<>'3' AND usergroup.canview = 1 AND user.lastactivity>'1188147895' mysql error: Unknown column 'user.styleid' in 'on clause' mysql error number: 1054
PS: vb3 upgrade is not an option at this moment and neither is any change of mysql.
Comment