Upgrading a slight breeze until last step.

[MarkJW]

Okay, so I'm upgrading from a 3.5.2 to 3.6.3. My 3.5.2 install had some plugins installed, such as vBAdvanced, vBPlaza/ibProArcade/v3Arcade, AJAX Shoutbox, a toplist mod, and a downloads mod. I also run off of a slightly modified eXtremepixels skin (Air & Air X).

When upgrading, I get a few errors. The first few are easy to fix. The very first is a MySQL error saying that in the upgradelog there's already an entry from 3.5.something(should be 2) to 3.5.something(I think it says 4, but should say 3, right?). I fix that by just running an SQL query to delete and rebuilt the upgradelog table.

Same thing with cron, moderators, and adminhelp. I have to delete and rebuild their tables. I use these SQL querys, from the last backup I made:


DROP TABLE IF EXISTS upgradelog;
CREATE TABLE `upgradelog` (
`upgradelogid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`steptitle` varchar(250) NOT NULL default '',
`step` smallint(5) unsigned NOT NULL default '0',
`startat` int(10) unsigned NOT NULL default '0',
`perpage` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS cron;
CREATE TABLE `cron` (
`cronid` int(10) unsigned NOT NULL auto_increment,
`nextrun` int(10) unsigned NOT NULL default '0',
`weekday` smallint(6) NOT NULL default '0',
`day` smallint(6) NOT NULL default '0',
`hour` smallint(6) NOT NULL default '0',
`minute` varchar(100) NOT NULL default '',
`filename` char(50) NOT NULL default '',
`loglevel` smallint(6) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`cronid`),
KEY `nextrun` (`nextrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS moderator;
CREATE TABLE `moderator` (
`moderatorid` smallint(5) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(6) NOT NULL default '0',
`permissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`moderatorid`),
KEY `userid` (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS adminhelp;
CREATE TABLE `adminhelp` (
`adminhelpid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`action` varchar(25) NOT NULL default '',
`optionname` varchar(25) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '1',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`adminhelpid`),
UNIQUE KEY `phraseunique` (`script`,`action`,`optionname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;Anyhow, I get through the rest of the steps unscathed until the update of the skins. The error I get is the first attached picture.

When I click the "Next Step" button again, I get the second picture's error message.

So, anybody got any suggestions?

EDIT: I guess my biggest problem is the "foreach()" error. Anybody know what I have to do to correct this?

[Steve Machol]

I suspect that your install/*.xml files were not uploaded correctly. Please reupload these files in ASCII format and make sure you overwrite the ones on the server.

[MarkJW]

Thanks for the tip, but it didn't work. I think it might have to do with the skins. Other than clearing the styles table in my MySQL database, is there any other way to turn off some skins?

Could it be that adminfunctions_template.php is messed up? Errors on lines 740 and 796.

Line 740:


foreach($template_cache['css'] AS $template)
Line 796:


foreach ($template_cache['template'] AS $template)

[Steve Machol]

You can try reuploading the original files. It wouldn't hurt.

[MarkJW]

Already did.

Hell, I think I've done everything now. In fact, I've used so many cheap little workarounds that now there are absolutely no "phrases" in my install. My entire admin panel is full of "could not find phrase" errors. It would be quite funny, if I wasn't so pissed off. I wanted to get vB up and running within a few hours, not two days. This is ridiculous...

If anyone out there can successfully upgrade my 3.5.2 MySQL dump to 3.6.3, I'll be eternally grateful. Heck, just get my users and posts out of a 3.5.2 MySQL dump and I'll worship you. I know starting over from scratch would fix it all, but I don't really have that luxury.

EDIT: Freakin custom skins and the stupid mods the plugins made to them. I swear, I'm never touching another mod again, and I'm not touching templates any more either. I'll let other people do that...