MyBB Community Forums

Full Version: MyBB SQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello everyone,

I purchased a site a little while ago and recently moved it to my own server, everything went well except the MyBB forum transfer, I have uploaded and edited details but now get this error on my site:

Quote:MyBB has experienced an internal SQL error and cannot continue.

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

What can I do to fix this?

Thanks
Make sure the table exists.

What happens if you change in inc/config.php

$config['cache_store'] = 'db';

into

$config['cache_store'] = 'files';

(2010-10-31, 03:25 AM)Disturbed Wrote: [ -> ]Make sure the table exists.

What happens if you change in inc/config.php

$config['cache_store'] = 'db';

into

$config['cache_store'] = 'files';
After doing that, I get:
Quote:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1045 - Access denied for user 'h3odst_g3bbuse'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server

And sorry, but how do I check if the table exists?
In phpmyadmin you can check if the table exists.

I think your database settings in inc/config.php are incorrect.

I think I know what the problem is, if so I'm an idiot! Big Grin
(2010-10-31, 03:50 AM)danielgb123 Wrote: [ -> ]I think I know what the problem is, if so I'm an idiot! Big Grin

I hope you are an idiot lol... at least it's fixed then..





haha, I'm a nut Toungue