[Forum] Database error when updating Navigation manager

[Mr Jolly]

I've recently updated to vB 4.2 and members can no longer mark forums read, they get an error message saying the security token was invalid.

After a bit of research it looks like it's because the mark forums read link in the navigation manager is incorrect, but when I try to edit it I get this database error message:

Invalid SQL:

UPDATE navigation
SET state = 19,
displayorder = 90,
productid = 'vbulletin',
scripts = '',
showperm = 'canviewforums',
url = 'forumdisplay.php?{session.sessionurl}do=markread&markreadhash={bbuserinfo.securitytok en}',
menuid = ''

WHERE navid = 76;

MySQL Error : Unknown column 'menuid' in 'field list'
Error Number : 1054

Can anyone figure out how to solve this?

[Mark.B]

Does this happen if you disable vBSEO?

[Mr Jolly]

Yeah, it does. I disabled all plug ins and used the default style and it still occurs.

[Mark.B]

Add the following lines to your config.php under the <?php line:

define('SKIP_ALL_ERRORS', true);
define('DISABLE_HOOKS', true); 

Also, what versions of php and MySQL are you running?

[Mr Jolly]

OK, I've done that.

I'm running version 5.3.27 PHP and 5.0.95 - community MySQL.

[Mark.B]

Did the upgrade script complete fully, right the way to the "Upgrade Complete" message?

[Mr Jolly]

No, I had trouble with the upgrade so I don't think it did upgrade properly. I've not been able to run the upgrade script though. Even if I upload all the files I get an error message saying the page is missing.

The upgrade went badly and I asked my hosts to restore from a back up. I wasn't expecting it to be upgraded at all. Will I have to do the install again from the start?

[Mark.B]

If you're using 4.2.2 files but the database is an earlier version then that will explain the error.

The upgrade script needs to be run in order for a site to be upgraded.

Close the site, Upload a fresh copy of the 4.2.2 files, then run /install/upgrade.php.
Once it's complete, reopen the site and remove the /install folder.

As with all upgrades, backup the database first.

[Mr Jolly]

Even though I've uploaded everything when I go to mydomain/forum/install/upgrade.php I get a page not found message.

[Mr Jolly]

It was the chuffin' vBSEO, even though it was all switched off. I have disabled the rewrites in the .htaccess file and I think I can now do the upgrade. Fingers crossed.

[Mr Jolly]

OK, everything seems to be working fine now, thanks for your assistance Mark.

[Mark.B]

You're welcome. Glad you got it sorted.