Upgrade Help

[BlessedBe]

I have helped a friend upgrade their forum and I am positive that all files have been uploaded from the file I down loaded.

When I try and upgrade php I get this.


Warning: mysql_connect(): Access denied for user 'sweepsta_smf1'@'localhost' (using password: YES) in /home/sweepsta/public_html/upgrade.php on line 59

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/sweepsta/public_html/upgrade.php on line 59

This is the link I use for the upgrade

http://sweepstakescanada.net/upgrade.php

Can someone help please.

Thank's in advance.

[JayBachatero]

Make sure that the information in Settings.php is correct.

[BlessedBe]

Make sure that the information in Settings.php is correct.

ok this is what she has in settings.php

########## Maintenance ##########
# Note: If $maintenance is set to 2, the forum will be unusable!  Change it to 0 to fix it.
$maintenance = 0;      # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
$mtitle = 'Maintenance Mode';      # Title for the Maintenance Mode message.
$mmessage = 'Ok faithful users...we\'re attempting to restore an older backup of the database...news will be posted once we\'re back!';      # Description of why the forum is in maintenance mode.

########## Forum Info ##########
$mbname = 'Sweepstakes Canada';      # The name of your forum.
$language = 'english';      # The default language file set for the forum.
$boardurl = 'http://sweepstakescanada.net';      # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]';      # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10';      # Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'sweepsta_smf1';
$db_user = 'sweepsta_smf1';
$db_passwd = 'pass removed';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/home/sweepsta/public_html';      # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/home/sweepsta/public_html/Sources';      # Path to the Sources directory.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 1146106239;

# Make sure the paths are correct... at least try to fix them.
if (!file_exists($boarddir) && file_exists(dirname(__FILE__) . '/agreement.txt'))
$boarddir = dirname(__FILE__);
if (!file_exists($sourcedir) && file_exists($boarddir . '/Sources'))
$sourcedir = $boarddir . '/Sources';

?>

EDIT:  I removed the password for database.

[JayBachatero]

Make sure that that user has enough priviledges.  Go to your control panel and check.  The hosting control panel.

[BlessedBe]

Make sure that that user has enough priviledges.  Go to your control panel and check.  The hosting control panel.

Ok when I go to the hosting control panel how do I know if the user has enough privledges. I know when I upgraded mine it was pretty straight forward. This one for some reason is a bit more confusing. lol

Thank's for all your help.

[JayBachatero]

Are you using cPanel?

[BlessedBe]

Are you using cPanel?

I did all this through ftp. I am in the process of trying to find out if she has cpanel as well.

[JayBachatero]

If she has cPanel you go to the MySQL database page and check the users permission.  Just allow all permissions.

[BlessedBe]

If she has cPanel you go to the MySQL database page and check the users permission.  just allow all permissions.

Thank's Jay. I will let you know if that works. I am just about ready to pull my hair out. haha

[BlessedBe]

Well, I think it's time to give up. This is what her cpanel says

Users in sweepstasmf1
sweepsta_sweepst (Privileges: ALL PRIVILEGES)

So all are checked.

[JayBachatero]

I see the problem.  The database name is sweepstasmf1 not sweepsta_smf1.  Change that in the $db_name.

[BlessedBe]

ack. I am a total noob at this. How do I change that.

I never had this much problems when I did my own forum upgrade.

I really thank you for all your patience with me Jay.

[JayBachatero]

In cPanel where you manage your database you can create users.  After you create the user there is a drop down that says add user to database.  You select the user you created and add it to the smf database.

[BlessedBe]

Well I have officially given up on this. lol look's like she is going to have to start from scratch.

I will never do this again I tell you.

Thank's for all your help Jay. I really appreciate it.

[JayBachatero]

If you want PM me the cPanel information and I will take a look at this for you .