here is the story...
my website was working fine a few weeks ago. a couple days ago, i tried accessing it and all i got was a blank, white page. after reading through the forums, i saw that i had to upgrade. i copied all files and directories except for albums, anycontent.php, and include/config.inc.php as instructed.
http://www.mydomain.com/mycopperminefolder/update.php and got a message similar to the one below (i didn't copy it when i first saw it but did notice someone had posted something similar):
Could not create a mySQL connection, please check the SQL values in include/config.inc.php
MySQL error was : Access denied for user: 'username@host###.xxx.xxx.secureserver.net' (Using password: YES)
on the page with
http://www.mydomain.com/mycopperminefolder, i got the following:
Coppermine critical error:
Unable to connect to database !
MySQL said: Access denied for user 'xuser'@'xx.xx.xxx.128' (using password: YES)
i went into mysql and entered 1 under debug. no improvement. i checked include/config.inc.php and saw that my password was not exactly as it should be. i tried to edit it (to be honest, i wasn't sure how, so i just copied the same thing into word and then later changed the file to a php). i also removed the config.inc.phpSAMPLE file (wasn't sure if it belonged there). tried to run the update again and got 1/2 a page full of symbols such as *&$^*&^(*&^&*^*. i put the unedited config.inc.php and config.inc.phpSAMPLE files back. on the update page, i got the same message as the first one posted above. on the
www.mydomain/mycopperminefolder page, i now get the following:
Coppermine critical error:
Unable to connect to database !
MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
i also checked the connection string posted on my host's page. it states this:
This example describes using PHP to connect to a MySQL Database on a Linux hosting account.
<?php
//Connect To Database
$hostname="mysql##.secureserver.net";
$username="myusername";
$password="your_password";
$dbname="mydbname";
$usertable="your_tablename";
$yourfield = "your_field";
mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname);
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$name = $row["$yourfield"];
echo "Name: ".$name;
}
}
?>
any suggestions on how to fix?
sorry for the long post, but i figure i should indicate the steps i've taken. on a side note - i am not that familiar with php or mysql, but am usually pretty good at figuring things out if i research (ie read the forums) or rtfm (which i did). unfortunately, neither helped. i saw others who had similar issues but it seemed they were at least able to get into/see their pages. i can't access mine at all.