MyBB Community Forums

Full Version: MySQL failure?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, I was trying to set up my forum and it worked. Made a nice theme for it, and installed some plugins.

But then I suddenly get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mybb._datacache' doesn't exist
Query:
SELECT title,cache FROM datacache


Even though that . doesn't even suppose to be there.. My config even says:

$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'mybb';
$config['database']['table_prefix'] = '_';

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'root';
$config['database']['password'] = '';


Help would be appreciated!
Like you see, my prefix is fine.. And I don't use .'s in my $config. So I still don't know what the problem is..

In my database, it's also displayed as mybb_datacache
edited !

Quote:1146 - Table 'mybb._datacache' doesn't exist
expected database prefix is mybb._ (there is a dot at the middle)
can you physically check what is the prefix used for the forum database ..

Quote:$config['database']['table_prefix'] = '_';
it means that datacache table should be shown as _datacache (underscore followed by datacache)