Trying to upgrade Vb2 (I know I know)

[Dave#]

I am trying to move my vb2 install to a new server so that I can upgrade to the latest Vb3

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

I have tried setting the sql mode to 4.0 without luck.

Am I out of options other than upgrading?

[Steve Machol]

That error means that you server is running a newer version of MySQL that is not compatible with vB 2.3.9, which was written many years before your version of MySQL was available. You would have to either downgrade MySQL and possibly PHP, or upgrade vB.

[Dave#]

That error means that you server is running a newer version of MySQL that is not compatible with vB 2.3.9, which was written many years before your version of MySQL was available. You would have to either downgrade MySQL and possibly PHP, or upgrade vB.

With respect isn't this just repeating what my post says?

[Steve Machol]

My apologies. I assumed that I was answering your question directly:

Am I out of options other than upgrading?

It won't happen again.

[Dave#]

will vb 3.7 run on mysql 4.0.27 and php 4.3?

[RS_Jelle]

will vb 3.7 run on mysql 4.0.27 and php 4.3?

The minimum system requirements of vBulletin 3.7 are PHP 4.3.3 and MySQL 4.0.16

http://www.vbulletin.com/features.php

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