MyBB Community Forums

During the upgrade process the upgrade recommended the RC3 to RC4 upgrade. Which I believe was correct... ^^' Mind like a sponge in the desert...

And when I go to update/change/create themes I get:

mySQL error: 1054
Unknown column 'linkhover' in 'field list'
Query: UPDATE themes SET name='Axiom', templateset='1', bodybgcolor='#e3e3e3', bodybgimage='images/Light/logo_bg.png', bodybgimageattributes='repeat-x', bgcolor='#FFFFFF', text='#000000', link='#000000', linkhover='', imgdir='images', logo='images/logo.gif', maintablewidth='100%', tablewidth='98%', tablespace='4', borderwidth='1', bordercolor='#000000', header='#013c74', headerimg='images/thead_bg.gif', headertext='#FFFFFF', category='#013c74', categoryimg='images/tcat_bg.gif', categorytext='#000000', tabletext='#000000', altbg1='#efefef', altbg2='#f7f7f7', smallfont='', smallfontsize='', normalfont='', normalfontsize='', largefont='', largefontsize='', menubgcolor='', menubgimage='', menucolor='', menuhoverbgcolor='', menuhoverbgimage='', menuhovercolor='', panelbgcolor='', panelbgimage='', outerwidth='0', outercolor='' WHERE tid='2'

I REALLY want to upgrade to RC4, as the new RSS syndication is a tasty addition. ^^

Update - Whoops, more than the themes are funky... I'll try restoring and re-running the upgrade.

I was able to revert to a backup of the forum. Now when running the CORRECT upgrade (RC2 to RC4) I get past the first step (database modifications) and it goes whackadinghoy right after the database modifications. Here is a screenshot:

And it's not a browser issue either. I've tried Mozilla, Opera, and MSIE.

Update:

It would appear that there is a fatal error in the second step of the RC2 -> RC4 upgrade process. However it does not appear to damage the database in any way. AND if you go back to the /install/upgrade.php you can THEN complete the RC3 -> RC4 upgrade process without any loss of data and gets your forum up at least.

You DO LOSE the administration panel settings template. I am unable to change the settings of the board. Every other function of the administration panel seems fine.

Sorry I haven't been around to help with this. I'm currently in the middle of exams and to make things worse i've now became fairly sick with a bad cough, cold, and all I pretty much want to do is sleep.

When you say you lose the Admin CP settings template, and cannot change the settings, what error do you receive?

Chris

No error, just the template doesn't seem to be there. Here is what I mean:

And despite this little problem I love where things are going.

Okay, I think i've worked out whats going on here. Because you ended the RC2 upgrade process early when it spat out all of that garbage, it did not reinsert the settings which were previously deleted.

Here's the recommended procedure for fixing that:

1. Go to /install/upgrade.php?action=1_dbchanges3 it should say it has reinserted the settings (These will be RC3 setting so we have to do it again for RC4).

2. Make a temporary script, call it whatever you like just make sure its a php file. Upload it to your forums directory, making sure it has the following contents:

<?php
require "./global.php";
	$db->query("DROP TABLE ".TABLE_PREFIX."settings;");
	$db->query("CREATE TABLE ".TABLE_PREFIX."settings (
	  sid smallint(6) NOT NULL auto_increment,
	  name varchar(120) NOT NULL default '',
	  title varchar(120) NOT NULL default '',
	  description text NOT NULL,
	  optionscode text NOT NULL,
	  value text NOT NULL,
	  disporder smallint(6) NOT NULL default '0',
	  gid smallint(6) NOT NULL default '0',
	  PRIMARY KEY  (sid)
	);");
die("Done");
?>

Alternatively you can go in to phpMyAdmin or MySQL and run the following two queries:

DROP TABLE settings;
CREATE TABLE settings (
	  sid smallint(6) NOT NULL auto_increment,
	  name varchar(120) NOT NULL default '',
	  title varchar(120) NOT NULL default '',
	  description text NOT NULL,
	  optionscode text NOT NULL,
	  value text NOT NULL,
	  disporder smallint(6) NOT NULL default '0',
	  gid smallint(6) NOT NULL default '0',
	  PRIMARY KEY  (sid)
	);

3. Go to /install/upgrade.php?action=2_dbchanges2.

Follow the upgrade wizard from there, even though you may have already done that - it will rebuild the necessary settings cache's and other things that may not have been updated correctly before.

Hopefully that will work..

Chris

I did exactly that, and the settings still can't be changed.

how many members/post etc have you got?? Maybe you can just start over??