Will this 3.8/4.0 swap work? How should I?

[JohnnieOO]

I've been putting off upgrading from 3.8.7 to 4+, well, today I'm unexplainably getting SQL errors on the website (but none found on the backend) and I have been unable to diagnose. So, I guess I'll go ahead and jump to 4. Originally, my 3.8 VB is in website.com/forum with vbadvanced CMPS in the home directory. Due to the errors I'm having, I cannot get to the existing VB/AdminCP to execute any diagnostics.

Is there a simple method to swap 3.8 to 4.0? Do I need to reinstall 3.8 and upgrade? Can I just delete 3.8 and install the 4.0 files in the "forum" directory (and keep the config settings)? If I delete the "forum" directory and install a clean 3.8 in a new "forum" directory, will the mods come with the unaltered database? I am not experienced enough to KNOW what to do here. I seem to understand that the mods are in the database, right?

Long story short, I want to keep all of my posts, users, threads, etc...but I want to avoid the errors I am experiencing.

Thanks,
Johnnie

[kNeo]

Just a note here -- but you should figure out what's wrong first, because "SQL errors" could mean the database is broken, in which case upgrading will accomplish nothing.

You should also be aware that EVERY mod will break/be unusable when you upgrade, this includes vbacmps (though they do have a 4.x version). Additionally 4.x also requires you to re-customize the style/design (look of your forums) -- you can't bring over your 3.x design (if you've customized it). It took me a good month and a half to finish my vB4.x style, though my forum was heavily customized as far as styles go.

You can do some simple troubleshooting such as disabling all addons/plugins/etc... and going through 1 by 1 to see if any are causing issues.

You can edit the config file, I think this is the code:
define('DISABLE_HOOKS', true);

add that at the top of the config php file, just below <?php

This should disable all plugins that might be causing trouble; if the forums work after you do this that means a plugin/addon or something is causing the trouble. If not it could be indicative of a more serious issue.

Also contact your host, ask them if they've upgraded your php, vB is currently not fully compatible with php 5.4, for vB4 it's easy to work around, but I think it's worse for vB3s.

I am not at all that good with vB3, the last time I touched one was 6~ years ago, so you might be better luck on the vB3 section and/or contacting vB support (if you have an active license) to see if they can figure out what's up with your board.

EDIT: For the record if your database is fine, you can certainly upgrade to vB4, you will keep all users, content, etc... you will just lose mods and the style (the look) of your site.