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.

Internal MyBB Errors

MyBB Error (41)

Error Type: MyBB Error (41)

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.

MyBB Error (43)

Error Type: MyBB Error (43)

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.

MyBB Error (42)

Error Type: MyBB Error (42)

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.

MyBB Error (44)

Error Type: MyBB Error (44)

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.

SQL Errors

MySQL Error 0 -

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.

MySQL Error 2005

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.

MySQL Error 1045

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.

MySQL Error 1146

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.

MySQL Error 2013

Database: MySQL

SQL Error: 2013 - Lost connection to MySQL server during query

Query: SELECT title,cache FROM mybb_datacache

Information: *This is an issue with the connection to your database, your host will have to solve this issue for you.

SQLite Error 1

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.

MySQL Error 2002

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.

MySQL Error 1054

Database: MySQL

SQL Error: 1054 - Unknown column 'loginattempts' in 'field list'

Query: SELECT loginattempts FROM mybb_users WHERE LOWER(username)='username' LIMIT 1

Information: Note: this fix does not apply to all unknown column errors, it is specifically for the query in the image (with a different username/table prefix etc of course). Please do not suggest this fix when someone has any other unknown column error.

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.

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 Apache extension 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.

You should 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.

Catchable Fatal Error (4096)

This error occurs when you upgrade your forum from MyBB 1.6.4 or older to MyBB 1.6.5 or newer. The member_register template has to be updated.

1. Go to Admin CP > Templates > Your Theme's Template Set > Member Templates > member_register.

2. Find:

   {$captcha}
   

3. Replace it with:

   {$hiddencaptcha}
   

ویرایش در گیت‌هاب