Attempt to Upgrade to 3.8.2
 

Well I am new to this I have asked several questions and Brian has been amazingly quick to respond. Basically, I attempted to upgrade to 3.8.2 and just kinda browsed the instructions. Bad idea, I overwrote the config.php with config.php.new before changing any settings. Now on step 2/13 of the upgrade I get this.

I have gone into my server and found MySQL settings. I have the username and password, yet im not sure what else to plug in, as its still giving me the same error.

A section of my config reads as follows.

Any input is greatly appreciated!

Ok, now it depends on which host you use too fyi.

I was using Siteground (avoid IMO, strictly IMO) and had

$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 1022;

However I have always used port 3306 w/o any problems.

Additionally w/ SG I used:

NOW, note the prefix is there so unless you need the value remove the DB prefix you have i.e.

Which is wrong regardless due to this:
So they should kinda match i.e. $config['Database']['dbname'] = 'mx6_forum'; AS mx6 is the DB's prefix not the tables SO I say remove the value!

Now currently I have switched over to Godaddy and that requires this:
See if that helps you figure it out! Also close your browser COMPLETELY before attempting again or it can cause issues or repeat the same error messages when it is in fact ready to roll :D

AND now is the time to make a backup of your config file :D

Are you sure your database login name and password are correct? This is usually different than your server login information.

config.php doesn't usually have to be overwritten at all. There are times when it changes, but those are usually only major releases (ie: vb3, vb4, etc).

If you're using cpanel (many are), you can assign another username and password to the database inside the control panel itself, this may help relieve the situation

It is different then my server login information.

I tried what "TheLastSuperman" said still same error, I also closed all windows after editing.
Any other ideas

--------------- Added [DATE]1242094014[/DATE] at [TIME]1242094014[/TIME] ---------------

I can't get into the cpanel at all, I get the Database Error page

--------------- Added [DATE]1242094081[/DATE] at [TIME]1242094081[/TIME] ---------------

Oh, and my host is www.Servage.net

I can add MySQL databases inside there myself as well.

--------------- Added [DATE]1242094747[/DATE] at [TIME]1242094747[/TIME] ---------------

I'll add this as well, line 311 of the class_core.php file is as follows

What is the database error you get? You'll need to view the page source to get it.

OH WOW
I fixed it, but now. my entire forums are gone. Everything.

--------------- Added [DATE]1242095745[/DATE] at [TIME]1242095745[/TIME] ---------------

I made a new MySQL database, is that where all the information for my forums are? that would make sense as the new one worked without a problem, but wiped my forums clean. Now im trying with the previous database I had. Im still getting an error but this time its.

You said you only skimmed the directions.... you didn't Install the forums (install.php), did you? You did an Upgrade (upgrade.php), right?

Nope I just realized that. Im so effed.

The site has only been open for a little over 2 months but still.

Do you have a backup?

(One of the instructions in doing an upgrade is to make a backup. :) )

I did back it up last week, now Im just trying to find where the default saving location is. Any suggestions on that one lol.

By the way, your help is much appreciated

default saving location for what?

The vbulletin.sql, but I have found it. Now im struggling with restoring the database. I have uploaded my .sql file via FTP onto my server, cant figure out how to import it from there, as well I have tried copy paste, then also "Exqcute SQL Quesry" in the admincp. It took awhile then brought me to a blank page in the admincp,

Im so confused!

Can you get into cPanel? There is an option to restore a backed up DB within the MySQL options.

Here is the run down of what I have done tonight, still unsucessful

Imported database via ftp and apparently (so my server tells me) sucessfully imported into both databases I have. I had one called mx6_forum (dont remember creating that one) and when all this happened I created a new one, called mx6. but now I don't know what to do. My forums are still as if new.

What now?

Change your config.php file to reflect the new db. :)

I have lol. Honestly I am out of ideas and have been searching and searching the net for litterally like 10 hours.

If you go in via cPanel and look at the data within the tables in the DB, does it look like there's info in there, or does it look like a virgin DB?

OH MAN! that just made me realize what it was by looking at the tabls

in the config.php file I didn't have a prefix on there for my tables

Forums are fix, for anyone looking at this in the future make sure your prefix is there, and correct.