MyBB Community Forums

Full Version: MyBB has experienced an internal SQL error and cannot continue.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have an error when I try to go on my website.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'darkphaze1.mybb_datacache' doesn't exist
Query:
SELECT title,cache FROM mybb_datacache

Database name and username: 
darkphaze1
Password:
<hidden> Reset
MySQL version:
5.0 (Direct access not allowed)
Hostname:
darkphaze1.db.11146581.hostedresource.com

I resently changed my sql but I chnaged it in my config.php
Here is a bit of the config.php

<?php
/**
 * Database configuration
 *
 * Please see the MyBB Docs for advanced
 * database configuration for larger installations
 * http://docs.mybb.com/
 */

$config['database']['type'] = 'mysql';
$config['database']['database'] = 'darkphaze1';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] =  'darkphaze1.db.11146581.hostedresource.com';
$config['database']['username'] = 'darkphaze1';
$config['database']['password'] = '***';

/**
 * Admin CP directory
 *  For security reasons, it is recommended you
 *  rename your Admin CP directory. You then need
 *  to adjust the value below to point to the
 *  new directory.
 */

$config['admin_dir'] = 'admin';

/**
 * Hide all Admin CP links
 *  If you wish to hide all Admin CP links
 *  on the front end of the board after
 *  renaming your Admin CP directory, set this
 *  to 1.
 */

$config['hide_admin_links'] = 0;

/**
 * Data-cache configuration
 *  The data cache is a temporary cache
 *  of the most commonly accessed data in MyBB.
 *  By default, the database is used to store this data.
 *
 *  If you wish to use the file system (cache/ directory), MemCache, xcache, or eAccelerator
 *  you can change the value below to 'files', 'memcache', 'xcache' or 'eaccelerator' from 'db'.
 */

$config['cache_store'] = 'db';
Quote: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.

Common MyBB Errors: http://docs.mybb.com/Help-Common_Error_Messages.html