Upgrade to 3.8.6 went bad...

[PhillyTom]

I'm upgrading to 3.8.6 in preparation for upgrading to version 4.

I get this error in the admin panel:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054

I think that I misfollowed the instructions and I ended up with two forum folder on the server. The old one is called "forum" and the new one is called "forums". Oh dear.

[Homeworld'sa]

eh? There isn't a 3.8.6

[PhillyTom]

Sorry, I meant 3.8.5.

[PhillyTom]

OK, the forum's working but all of the avatars are not showing. How can I get vbull to find the avatars again?

[Zachery]

What did you upgrade from?

[PhillyTom]

3.6.8

[Zachery]

did you revert any of the templates that required it? There was at least 1 change to the postbit from 3.6.8 on the way the avatar is called.

[PhillyTom]

I'm sorry, Zak. I don't know what reverting the templates means, so I guess I didn't do it.

[Zachery]

In every new version of vBulletin sometimes templates get changed, you upgraded two point releases and a handful of minor versions (Major.Point.Minor 3.6.8 to 3.8.5). Some of your templates are going to be out of date and either require a revert, or an update. Try adding a new style: AdminCP > Styles & Templates > Style Manager > Add New Style > Make sure it has no parrent and hit save. Now switch to using this style, does the same issue occur with your avatars?

[PhillyTom]

You want me to simply create a new style name? How do I "switch to using that style"?

[PhillyTom]

I think my problems are a bit deeper...

I have all of the avatars and icons in a separate subdirectory where the "old" forum is. I don't know how to get those things over to the new, active forum.

[Trevor Hannant]

If you've upgraded your site on the same domain and same server as it was before, the files are still there. When you login to AdminCP, do you get a notice about out of date templates? If so, you need to click on that link and then choose the 'Revert' option on each one or create a new style.

Once you've created the new style, you can force it to become the default style for all users in AdminCP > vBulletin Options > Style & Language Settings

[PhillyTom]

If you've upgraded your site on the same domain and same server as it was before, the files are still there. When you login to AdminCP, do you get a notice about out of date templates? If so, you need to click on that link and then choose the 'Revert' option on each one or create a new style.

Once you've created the new style, you can force it to become the default style for all users in AdminCP > vBulletin Options > Style & Language Settings

Thanks, Trevor. I do in fact get a notice about out of date templates. But there's also the SQL error and the two forum folders problem. This problem has gone to support ticket and I wonder if I should just wait to hear back from whoever's working on the ticket. But thanks again.

[PhillyTom]

OK, problems resolved through the ticket system and all seems well. Thank you staff!