Greetings,
I just shifted my Forum,
The GTA Zone from a free host
IcyBoards.com to my own Host.
I installed MyBB 1.6.8 at my forum
http://thegtazone.net/forums/
Then I opened phpMyAdmin and selected the tables and dropped them.
Then I imported my database.
It's after then I tried opening the Forums to find error message showing 1146, missing datacache table.
I have done database imports before. But this never seem to have happened.
I check inc/config.php. It seems ok to me.
Any help would be appreciated.
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.
http://docs.mybb.com/Help-Common_Error_Messages.html
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'u508559025_mybb';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = 'mysql.0hosting.org';
$config['database']['username'] = 'u508559025_mybb';
$config['database']['password'] = '<snip>';
The table Prefix is mybb_ like my config.php. Is there any other file where I have to change it?
What about the rest of the db info are they correct. It looks like you did not update the db info with those of your new host at the config.php file.
(2012-11-24, 02:42 PM)borbole Wrote: [ -> ]What about the rest of the db info are they correct. It looks like you did not update the db info with those of your new host at the config.php file.
I Did update. The info. They are correct.
(2012-11-24, 06:35 PM)Jimmy. Wrote: [ -> ] (2012-11-24, 02:42 PM)borbole Wrote: [ -> ]What about the rest of the db info are they correct. It looks like you did not update the db info with those of your new host at the config.php file.
I Did update. The info. They are correct.
Are you sure? The db error says:
1146 - Table 'u508559025_ryRyH.mybb_datacache' doesn't exist
Whereas above you have listed the name of the db at your config.php file as: u508559025_mybb
You see the difference?
(2012-11-24, 07:37 AM)Jimmy. Wrote: [ -> ]$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'u508559025_mybb';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = 'mysql.0hosting.org';
$config['database']['username'] = 'u508559025_mybb';
$config['database']['password'] = '<snip>';
The table Prefix is mybb_ like my config.php. Is there any other file where I have to change it?
Jimmy change the 'mysqli' to 'mysql' it will work then
I see. I'm gonna try the above.
Sorry Mr. Tech. That doesn't work.
Good catch Mr. Tech. I missed that.