How do and ta for even reading this, if you are, if you're not then i take it back. Rights I'm a noob to this so be gentle. i'm getting the error (in full below) when I'm publishing my site to my live server. I'm fairly certain this will turn out to be something simple that i've missed as all the other errors i've had since starting with ss have (various conflicting programs not giving me access tomy localhost myphpadmin being the worst as i had to uninstall everything to reinstall from scratch only to find out i had to disable one). any how that's off topic and one for a blog tutorial.
i published my site from the WebMatrix control panel (ftp) all was going well, did ?flush=1 on the live site and got this. (i've starred out password etc but they have been checked and they are correct) line 57 is highlighted in red
[Warning] mysql_connect() [function.mysql-connect]: Access denied for user '*****'@'localhost' (using password: YES)
GET /testsite/?flush=1
Line 57 in /home/mydomain/public_html/tynesidetshirts/sapphire/core/model/MySQLDatabase.php
Source
48 * Connect to a MySQL database.
49 * @param array $parameters An map of parameters, which should include:
50 * - server: The server, eg, localhost
51 * - username: The username to log on with
52 * - password: The password to log on with
53 * - database: The database to connect to
54 * - timezone: (optional) The timezone offset. For example: +12:00, "Pacific/Auckland", or "SYSTEM"
55 */
56 public function __construct($parameters) {
57 $this->dbConn = mysql_connect($parameters['server'], $parameters['username'], $parameters['password'], true);
58
59 if(self::$connection_charset) {
60 $this->query("SET CHARACTER SET '" . self::$connection_charset . "'");
61 $this->query("SET NAMES '" . self::$connection_charset . "'");
62 }
Trace
* mysql_connect(localhost,*****,********,1)
Line 57 of MySQLDatabase.php
* MySQLDatabase->__construct(Array)
Line 97 of DB.php
* DB::connect(Array)
Line 121 of main.php
any of this make sense to anyone? personally i'm coming from the visual design side of things with a decent html knowledge. the way that silverstripe creates these site is amazing to me and i'm getting there with the understanding but this error (as i said earlier i've had a few and managed to work around) has got me stumped. it's going to be something daft...
i'm running xp, xampp and MySQL client version: 4.1.22(from server control panel)
cheers in advance
jonny