Codex tools: Log in
The following are some of the common errors occasionally found when installing or modifying WordPress. Familiarity with phpMyAdmin, MySQL, and PHP maybe required to resolve some of these errors. For more help on resolving errors, see the resource list below.
The following errors are most commonly found in relationship to changes within the database during an installation or with the addition of a new or updated plugin. When possible, track backwards from what you have done to fix the error. If it is a plugin, delete the plugin from the server and see if this fixes the problem.
This is a result of a missing database or an attempt to connect to a database that does not exist. You can modify the database you are attempting to connect to through the wp-config.php file. Add a user prefix to the database if you are having difficulties.
There are numerous reasons that may prevent you from connecting to your database.
Check that there is no whitespace at the bottom of your wp-config.php file.
Also, check your Wordpress configuration values have been set correctly. When the username or password assigned to the WordPress Database contains non alpha-numeric characters, the code may become corrupted. To prevent this problem make the following changes to your wp-config.php file:
// ** MySQL settings ** // define('DB_NAME', 'user_wp'); // The name of the database define('DB_USER', 'user'); // Your MySQL username define('DB_PASSWORD', 'password'); // ...and password define('DB_HOST', 'localhost');
// ** MySQL settings ** // define("DB_NAME", "user_wp"); // The name of the database define("DB_USER", "user"); // Your MySQL username define("DB_PASSWORD", "password"); // ...and password define("DB_HOST", "localhost");
Notice the modified version has replaced all single quotes with double quotes. This allows for non alpha-numeric characters to be used without creating a connection error.
Plugin errors can come from many sources. Sometimes from a problem within the plugin itself or from a conflict with other plugins. Some plugins are compatible with only certain versions of WordPress. Most plugin errors are resolved by removing or disabling the plugin.
This problem is most often encountered with "latest comment" plugins and some archive plugins. The best solution is to remove or deactivate the plugin and contact the plugin author for an update.
There are a few specific errors that occur in relationship with the WordPress database.
This may be a sign of several problems, usually related to access to the files on your server, file permissions, or corrupted files. Begin by checking to see if the file is still viable and replace it with the original or updated version. Then see Changing File Permissions on how to change the permissions on files to make them writable or changeable. If these fail, contact your web host in order to resolve this issue.
This error result when the user assigned to this database does not having sufficient permissions to perform actions to create columns or tables in the database. If you have access to phpMyAdmin, set the permissions to allow creation of columns or tables. If you do not or this doesn't work, contact your web host to adjust the setting.
It may be necessary to create a new user with overall permission to resolve the issue. If you do so, modify your wp-config.php file with the new username and password, if necessary.
This error may occur when the cache on your server is full. Your web host needs to be contatcted immediately to empty the cache.
When switching servers, this error may also occur. This error has been known to self-resolve. For more information, see Error 28 For More Information. FIND THIS
If a table in your database is damagned, you will need to access phpMyAdmin and run a CHECK and REPAIR on the tables/database in which the errors are found.
The error is a result of ____________ and is usually not not associated with your database. For more information on these errors, see................
An Unknown Column error is the result of a missing column in the database. The data is prevented from being retrieved or stored in this column. If you have recently upgraded WordPress, then try running wp-admin/upgrade.php again to create the missing column.
Additional problems may occur, if this is the case, then reinsert a fresh copy of the database structure via phpMyAdmin. WHAT??? And HOW???? - Does this happen more with installs or generally? If installs, move it there.
The following may help you resolve these and other errors you may encounter.