Upgrade from 2.3.2 to 3.0.0

[DanGarion]

First my upgrade hung at step 28. I skipped to step 29 and things worked fine the rest of the upgrade till it wanted to proceed to Upgrade2.php and now I get this error.

Warning: Invalid argument supplied for foreach() in /homepages/26/d93153274/htdocs/300/includes/sessions.php on line 266

Unable to add cookies, header already sent.
File: N/A
Line: 0

So any help would be appreciated. Could this be because of Mods I have installed?

[Wayne Luke]

You cannot skip steps in the installation. You will have to revert to your database backup and start over...

What was the issue with step 28?

[DanGarion]

Yeah I know I can't skip them. But my problem with step 28 is that it would just sit there.

I let it sit for nearly 30 minutes every other process went by flawlessly and quickly but 28 just sat there saying.

"Please wait"

I have no problem redoing it with a backup I just though I might try skipping first. Any suggestions with step 28?

[Martin]

Step 28 is the language import. You cannot run your vbulletin without completing this step.

In installations and upgrades I have sometimes run into problems here because of OLD MySQL versions, particularly on Yahoo! Hosting. They run MySQL 3.23.49, which is ancient and buggy as all get out.

Who is your hosting company? Do you know what MySQL version you are running?

[DanGarion]

I'm using 1and1 hosting MySQL 4.0.17

I installed the tools in the extras folder and it appears to have imported what step 28 should have done originally. But then I was being stupid before that an I dropped the whole sessions table and I'm looking around for a the sql queries to put back in the DB and see if I can get this going.

[Wayne Luke]

The schema for all the tables are in install/mysql_schema.php.

[DanGarion]

The schema for all the tables are in install/mysql_schema.php.

Yeah I took care of that but it still didn't work.

So I redid the old DB and I'm doing the upgrade but it's still just stopping at Step 28.

I went ahead and reverted all my templates to their original forms before I upgraded to see if that might be causing a hang up.

Basically all I get is this...

vBulletin 3.0 Upgrade System
(Please be patient as some parts may take some time)

Step 28) Import vbulletin-language.xml (Step 28 of 42) XML File Versions:

vbulletin-style.xml
vbulletin-settings.xml
vbulletin-language.xml

3.0.0
3.0.0
3.0.0
Step 28) Import vbulletin-language.xml

MASTER LANGUAGE

Please Wait

And it just sits there. If I was to do the import of vbulletin-language.xml in the tools.php file in extras and then go to step 29 would that work? Because that one works...

[Wayne Luke]

You can try that. I am not sure why one XML import would fail and the other wouldn't unless PHP is timing out for some reason.

[Martin]

Try it that way. It can't hurt. I would let 1&1 know of your problem, too. It's got to be something on their MySQL config, and I know they want to promote themselves as a vBulletin host, so they should probably fix it.

[DanGarion]

Well the import all finished but I'm still getting the error when going to upgrade2.php about line 266 in sessions.php

[GeoffE]

I just had exactly the same thing (I'm with One&One as well).. I didn't get any errors, it went through all the stages OK, but then I got the sessions.php error running upgrade2.php. I noticed that the languages table was empty, so I inserted the data for that table from my test vb3 rc4 board and reran upgrade2.php, and it ran through the rest of the upgrades fine after that ..

[DanGarion]

# phpMyAdmin SQL Dump
# version 2.5.3
# [url="http://www.phpmyadmin.net/"]http://www.phpmyadmin.net[/url]
#
# Host: xxxxx.xxxxx.xxx
# Generation Time: Mar 20, 2004 at 06:27 PM
# Server version: 4.0.17
# PHP Version: 4.2.3
# 
# Database : `xxxxxxxxx`
# 
 
# --------------------------------------------------------
 
#
# Table structure for table `language`
#
 
CREATE TABLE `language` (
`languageid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`userselect` smallint(5) unsigned NOT NULL default '1',
`options` smallint(5) unsigned NOT NULL default '1',
`languagecode` varchar(12) NOT NULL default '',
`charset` varchar(15) NOT NULL default '',
`imagesoverride` varchar(150) NOT NULL default '',
`dateoverride` varchar(20) NOT NULL default '',
`timeoverride` varchar(20) NOT NULL default '',
`registereddateoverride` varchar(20) NOT NULL default '',
`calformat1override` varchar(20) NOT NULL default '',
`calformat2override` varchar(20) NOT NULL default '',
`logdateoverride` varchar(20) NOT NULL default '',
`decimalsep` char(1) NOT NULL default '.',
`thousandsep` char(1) NOT NULL default ',',
`phrasegroup_global` mediumtext NOT NULL,
`phrasegroup_cpglobal` mediumtext NOT NULL,
`phrasegroup_cppermission` mediumtext NOT NULL,
`phrasegroup_forum` mediumtext NOT NULL,
`phrasegroup_calendar` mediumtext NOT NULL,
`phrasegroup_attachment_image` mediumtext NOT NULL,
`phrasegroup_style` mediumtext NOT NULL,
`phrasegroup_logging` mediumtext NOT NULL,
`phrasegroup_cphome` mediumtext NOT NULL,
`phrasegroup_promotion` mediumtext NOT NULL,
`phrasegroup_user` mediumtext NOT NULL,
`phrasegroup_help_faq` mediumtext NOT NULL,
`phrasegroup_sql` mediumtext NOT NULL,
`phrasegroup_subscription` mediumtext NOT NULL,
`phrasegroup_language` mediumtext NOT NULL,
`phrasegroup_bbcode` mediumtext NOT NULL,
`phrasegroup_stats` mediumtext NOT NULL,
`phrasegroup_diagnostic` mediumtext NOT NULL,
`phrasegroup_maintenance` mediumtext NOT NULL,
`phrasegroup_profilefield` mediumtext NOT NULL,
`phrasegroup_thread` mediumtext NOT NULL,
`phrasegroup_timezone` mediumtext NOT NULL,
`phrasegroup_banning` mediumtext NOT NULL,
`phrasegroup_reputation` mediumtext NOT NULL,
`phrasegroup_wol` mediumtext NOT NULL,
`phrasegroup_threadmanage` mediumtext NOT NULL,
`phrasegroup_pm` mediumtext NOT NULL,
`phrasegroup_cpuser` mediumtext NOT NULL,
`phrasegroup_accessmask` mediumtext NOT NULL,
`phrasegroup_cron` mediumtext NOT NULL,
`phrasegroup_moderator` mediumtext NOT NULL,
`phrasegroup_cpoption` mediumtext NOT NULL,
`phrasegroup_cprank` mediumtext NOT NULL,
`phrasegroup_cpusergroup` mediumtext NOT NULL,
`phrasegroup_holiday` mediumtext NOT NULL,
`phrasegroup_posting` mediumtext NOT NULL,
`phrasegroup_poll` mediumtext NOT NULL,
`phrasegroup_fronthelp` mediumtext NOT NULL,
`phrasegroup_register` mediumtext NOT NULL,
`phrasegroup_search` mediumtext NOT NULL,
`phrasegroup_showthread` mediumtext NOT NULL,
`phrasegroup_postbit` mediumtext NOT NULL,
`phrasegroup_forumdisplay` mediumtext NOT NULL,
`phrasegroup_messaging` mediumtext NOT NULL,
PRIMARY KEY (`languageid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
#
# Dumping data for table `language`
#

That's what I'm showing in my lang table right now. And I'm getting the sessions error still.

[GeoffE]

Is there any more after the 'Dumping data' section? If not, looks like the same thing I had .. the table structure is there but there's no data in it.

[Wayne Luke]

When looking at the database in phpMyAdmin how many rows does it have for the phrase table? There should be at least 6,422 rows in that table.

The problem is that sessions.php expects to find phrases and it isn't finding them which means either the phrase table is incomplete or empty.

[DanGarion]

I'm not sure I'm dumping my MYsql back in from 2.3.4 and was going to try an rc2 copy I had.

So how can I get all the stuff I'm missing? I will be around again later. Thank you all for the help so far we are getting some progress.