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.
Make sure that the information in Settings.php is correct.
Lainaus käyttäjältä: JayBachatero - huhtikuu 28, 2006, 05:49:30 IP
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.
Make sure that that user has enough priviledges. Go to your control panel and check. The hosting control panel.
Lainaus käyttäjältä: JayBachatero - huhtikuu 28, 2006, 07:37:44 IP
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.
Are you using cPanel?
Lainaus käyttäjältä: JayBachatero - huhtikuu 28, 2006, 07:43:41 IP
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.
If she has cPanel you go to the MySQL database page and check the users permission. Just allow all permissions.
Lainaus käyttäjältä: JayBachatero - huhtikuu 28, 2006, 07:49:59 IP
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
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.
:'(
I see the problem. The database name is sweepstasmf1 not sweepsta_smf1. Change that in the $db_name.
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.
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.
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. :-*
If you want PM me the cPanel information and I will take a look at this for you :).