Help:Common Error Messages
Contents |
[edit] Introduction
When using MyBB, you may encounter an Internal MyBB Error, an SQL error, or see a permissions error of some sort. These can limit what you can do with your forum, or may stop you using it altogether. This page will show you some of the common errors people encounter, along with how to fix the problem.
[edit] Internal MyBB Errors
Error Type: MyBB Error (40)
Error Message: Your board has not yet been installed and configured. Please do so before attempting to browse it.
Information: This occurs when the file ./inc/config.php is incorrectly configured. If you have not already installed your forum, you need to go to ./install/index.php and run through the installation process, including entering your database details. If you have already installed your forum, and you have data in your database, then you will need to open ./inc/config.php, use this sample Inc/config.php text, and edit in your database information.
Error Type: MyBB Error (40)
Error Message: The install directory (install/) still exists on your server and is not locked. To access MyBB please either remove this directory or create an empty file in it called 'lock'.
Information: This occurs when, as the error says your 'install' folder is still present, or has not been locked. To solve this error, either completely delete the ./install/ folder, or create an empty file in it called 'lock'. MyBB requires you to remove or lock this folder, so nobody can run the installation or upgrade script, and corrupt or erase your database with it.
Error Type: MyBB Error (40)
Error Message: Your board has not yet been upgraded. Please do so before attempting to browse it.
Information: This occurs when you are attempting to do a major upgrade, for example 1.2.x to 1.4.x, and after upload the new files, you do not run the upgrade script. To fix this, go to ./install/upgrade.php and choose your old version from the list.
Error Type: MyBB Error (40)
Error Message: MyBB was unable to load the SQL extension. Please contact the MyBB Group for support. MyBB Website
Information: This occurs when the database type is incorrect in ./inc/config.php. To fix this, open ./inc/config.php and check the entry for $config['database']['type']. A common issue is having 'mysql' instead of 'mysqli', or having 'mysqli' instead of 'mysql'. If you do not know what needs to be here, contact your host provider.
[edit] SQL Errors
Database: MySQL
SQL Error: 0 -
Query: [READ] Unable to select database
Information: This occurs when you are using MySQL and the database name or database username is incorrect in ./inc/config.php. To fix this, open ./inc/config.php and check the entries for $config['database']['database'] and $config['database']['username']. If you do not know what needs to be here, contact your host provider.
Database: MySQL
SQL Error: 2005 - Unknown MySQL server host 'HOSTNAME' (11004)
Query: [READ] Unable to connect to MySQL server
Information: This occurs when you are using MySQL and the database host name is incorrect in ./inc/config.php. To fix this, open ./inc/config.php and check the entry for $config['database']['hostname']. If you do not know what needs to be here, contact your host provider.
Database: MySQL
SQL Error: 1045 - Access denied for user 'USERNAME'@'HOSTNAME' (using password: YES)
Query: [READ] Unable to connect to MySQL server
Information: This occurs when you are using MySQL and the database password is incorrect in ./inc/config.php. To fix this, open ./inc/config.php and check the entry for $config['database']['password']. If you do not know what needs to be here, contact your host provider.
Database: MySQL
SQL Error: 1146 - Table 'forum_mybb14x.test_datacache' doesn't exist
Query: SELECT title,cache FROM test_datacache
Information: This occurs when you are using MySQL and the database table prefix is incorrect in ./inc/config.php. To fix this, open ./inc/config.php and check the entry for $config['database']['table_prefix']. If you do not know what needs to be here, contact your host provider.
Database: MySQL
SQL Error: 2013 - Lost connection to MySQL server during query
Query: SELECT title,cache FROM mybb_datacache
Information: To solve this, using PHPMyAdmin, or some other database manager that you have access to, you must repair the table mentioned in the error, in this case, mybb_datacache. If this continues to happen, you should contact your host provider with the error.
Database: SQLite
SQL Error: 1 - no such table: test_datacache
Query: SELECT title,cache FROM test_datacache
Information: This occurs when you are using SQLite and the database table prefix is incorrect in ./inc/config.php. To fix this, open ./inc/config.php and check the entry for $config['database']['table_prefix']. If you do not know what needs to be here, contact your host provider. This error also shows when the database path is incorrect in $config['database']['database']. To fix this, make sure the path points to where your database is stored.
Database: MySQL
SQL Error: 2013 - Lost connection to MySQL server during query
Query: [READ] Unable to connect to MySQL server
Information: This occurs when your MySQL server is down or experiencing an issue and MyBB cannot connect to it. You will have to contact your host with this error message.
Database: MySQL
SQL Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
Query: [READ] Unable to connect to MySQL server
Information: This occurs when your MySQL server is down or experiencing an issue and MyBB cannot connect to it. You will have to contact your host with this error message.
Database: MySQL
SQL Error: 1054 - Unknown column 'loginattempts' in 'field list'
Query: SELECT loginattempts FROM mybb_users WHERE LOWER(username)='username' LIMIT 1
Information: This occurs when you are using MySQL and you attempt to upgrade from 1.4.3 to 1.4.4, after you upload all the new files, but do not run the upgrade script. In 1.4.4, a new column, 'loginattempts', was added to the users table for a new security feature. The error shows as the 1.4.4 member.php file is trying to find the 'loginattempts' column in a 1.4.3 database, where it doesn't exist. To fix this issue, go to ./install/upgrade.php and choose 1.4.2/1.4.3 from the list.
[edit] Other Error Messages
Error Message: Error
The installer is currently locked, please remove 'lock' from the install directory to continue
Information: This happens when you try to run the installation or upgrade script, but your ./install/ folder is locked. Simply remove the 'lock' file from the ./install/ folder to continue.
Error Message: Forbidden
You don't have permission to access /admin/index.php on this server.
Information: This is nearly always a problem with mod_security. mod_security is an extension to Apache that is used for security. In MyBB 1.4, mod_security treats the way the URLs are set out in the ACP as a security threat, so it will deny you access. For information on how to prevent this, see the Wiki page for mod_security. If nothing here works, contact your host provider and ask them to whitelist your domain or hosting account against mod_security - basically so that it doesn't affect you anymore.