Articles Block
Most database errors are caused by simply missing a step in the creation of the database and user/pass.
Could not connect to MySQL
This error message usually starts with "Warning: mysql_connect() [function.mysql-connect]: Access denied for user..." and ends with "Could not connect to MySQL". The reason for this is that the script looked in the system/config.inc.php and/or admin/system/config.inc.php for the database connection information, and it either wasn't there, or the information was wrong. To review the database creation requirements, please see Creating the database page, and then where to enter the database info right here.
First Things First
The first thing to check is if your database creation was done correctly. Did you create a database? Did you create a user/pass? Did you associate the correct database user with the database you created for the Article Friendly database? If you've checked all these things and sure they are correct, lets move on to the connection info.
Connection Info
1. Make sure you've pasted the correct database connection info in between the quotes of the correct field. For example, if you put the database connection info for your database
name into the "db username" field, you will get an error message.
2. Make sure there are isn't any whitespace (blank areas) before or after the database connection information you pasted in. For example, this would cause an error: " database name"
3. Check that you've copied your database connection information in both the "system/config.inc.php" and the "admin/system/config.inc.php" files.
Again....
The biggest reason for a database error is the database user was not associated to the correct database, or not associated at all. Check this first.
Other Errors
If you, or your site users get a mysql database error such as "Insert Operation Failed", "Query went bad" or "Something wrong in the query", it usually is a problem that can be fixed by clicking on the "repair database" link in your admin nav section, then the "CleanUp Database" link.