Upgrading from 2.3.11 to 3.6

[Bob Zale]

I am currently running 2.3.11 with 254,000 plus threads in IIS. I am looking to upgrade to 2.3.11. My PHP is version 4.4.2 and my MySQL is version 3.51. My question is do I first upgrade MySQL to version 5 (as 3.51 is not supported by VB3.6)? If so, do I also have to migrate by current database to the MySQL 5 format before running the upgrade scripts?

Thanks.

[Floris]

Yes. Now that you are on 2.3.11 and have a working forum. Make a 100% backup of your forum and the files.

Then upgrade your MySQL to a version that vBulletin 3.6 supports.

Then upload the 3.6.7pl1 files and run upgrade.php

[Bob Zale]

Hi Floris,

Thanks for the quick answer. I uninstalled MySQL 3.51 and then installed MySQL 5.0.41. PHPAdmin stopped working and from what I can tell PHP 4.2.2 does not work with MySQL 5, so I installed PHP 5.2.3. PHPAdmin is now working but displays (as does php info test.php script):

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\ext\php_netools.dll' - The specified procedure could not be found. in Unknown on line 0

I remember this from installing vBulletin 2.3.11 with the same error message and this was because I missing the dependentcies for php_netools.dll. So I am going through this again and am having a problem finding the correct version of lcrzo.dll for the php_netools.dll in PHP 5.2.3. I have version 3.1.0.27 of Packet.dll and wpcap.dll (tried version 4.x also) but using the visual studio dependcy walker I still shows that lcrzo is missing the PacketGetNetInfo routine. Do you have any suggestions on what version of lcrzo.dll (packet.dll and wpcap.dll) I should be using and if possible where I can obtain these dlls? I know this is a PHP problem and not a vBulletin problem, but any help would be greatly appreciated. Thanks.

[Wayne Luke]

Unless you need this for some other script you can comment this out of your php.ini file by finding the line that states:

extension=php_netools.dll

And changing it to:

;extension=php_netools.dll

Save your php.ini file and restart your webserver using your Services control panel.

[Bob Zale]

Thanks Wayne. I guess I mistakenly assumed that php_netools was needed by vBulletin. The vb_test.php script now says that everything passed. I will try the database_conflicts.php script and then start the upgrade to 3.6. Thanks again.

[Bob Zale]

The database_conflicts.php script executed fine, but I ran into problems with the upgrade.php script at step 1:

• Creating calendar table
• Creating calendarmoderator table
• Creating calendarpermission table
• Creating calendarcustomfield table
• Creating holiday table
• Creating subscribeevent table
• Creating ranks table
• Creating usertextfield table
• Creating imagecategory table
• Creating imagecategorypermission table
• Creating postparsed table
• Creating strikes table
• Creating passwordhistory table
• Creating moderatorlog table
• Creating usernote table
• Creating customprofilepic table
• Removing search table
• Creating search table

Database error The database has encountered a problem.

Database error in vBulletin :

Invalid SQL:

CREATE TABLE search (
searchid int unsigned NOT NULL auto_increment,
userid int unsigned NOT NULL DEFAULT '0',
ipaddress char(15) NOT NULL DEFAULT '',
personal smallint unsigned NOT NULL DEFAULT '0',
query varchar(200) NOT NULL DEFAULT '',
searchuser varchar(200) NOT NULL DEFAULT '',
forumchoice mediumtext,
sortby varchar(200) NOT NULL DEFAULT '',
sortorder varchar(4) NOT NULL DEFAULT '',
searchtime float NOT NULL DEFAULT '0',
showposts smallint unsigned NOT NULL DEFAULT '0',
orderedids mediumtext,
dateline int unsigned NOT NULL DEFAULT '0',
searchterms mediumtext,
displayterms mediumtext,
searchhash varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (searchid),
UNIQUE KEY searchunique (searchhash, sortby, sortorder)
);

MySQL Error : Can't create table '.\test\search.frm' (errno: 121)
Error Number : 1005
Date : Friday, July 6th 2007 @ 09:45:11 AM
Script : http://stevexp/forums/install/upgrade_300b3.php?step=1
Referrer : http://stevexp/forums/install/upgrade_300b3.php?rand=74
IP Address : 192.168.0.201
Username :
Classname : vB_Database

Any ideas on what I am doing wrong? Thanks.

[Floris]

MySQL error code 121: Duplicate key on write or update

I am not sure how to fix this.

[Floris]

You can remove the rows of data with truncate from the search database. And run the script again.

[Bob Zale]

Hi, Thanks for the reply.
I have a table called 'searchindex' is this the table that I should truncate?
I do not have a table titled 'search'.

Thanks.

[Wayne Luke]

You can delete the contents of all the search tables:

search, searchindex, and word.

The search table contains recent searches and is emptied hourly anyway. The other two can be repopulated in the control panel after the upgrade or you can implement FullText search which makes them obsolete.

The error you are getting above means it is trying to create the search table and cannot. Make sure that you have sufficient storage space on the device to run that step. You may try to create the table manually but I am not sure what else is done in that step of the process off hand.

[Bob Zale]

Hi Wayne,

Thanks for the info.
Just to make sure that I do this correctly, I should truncate the searchindex and word tables. I do not have a search table. Then try to run the upgrade.php script again. If this fails then try and create the table search table manualy and run the upgrade.php script again.

Do I need to go back to my original 2.3.11 version of the board before running the upgrade.php script again or will it know that the calendar and other tables have already been created and not try to do them again?

Thanks.

[Floris]

Reverting back to the original working backup does decrease risk of more failures. If you do that, you can do that first, then truncate and then run upgrade again.