I am trying to move my vb2 install to a new server so that I can upgrade to the latest Vb3
I have tried setting the sql mode to 4.0 without luck.
Am I out of options other than upgrading?
Database error in vBulletin 2.3.9:
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='173372'
AND subscribethread.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'20'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1217945799'
mysql error: Unknown column 'user.styleid' in 'on clause'
mysql error number: 1054
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='173372'
AND subscribethread.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'20'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1217945799'
mysql error: Unknown column 'user.styleid' in 'on clause'
mysql error number: 1054
Am I out of options other than upgrading?
Comment