MyBB Community Forums

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1130 - Host '10.1.1.48' is not allowed to connect to this MySQL server
Query:
[READ] Unable to connect to MySQL server
Please contact the MyBB Group for technical support.

Hi this is what I am getting when I am going to my website.
I tried copy and pasting my old server files from my other website to a new one.
Please help me out, as I do not wish to make it again thank you!

Reason I'm switching is because, I wanted to change my domain name, and can not without making a new one.

config.php file in inc folder consists of database details. they need to be edited with the new server details

$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'xxxxxxxx';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'xxxxxxxxx';
$config['database']['username'] = 'xxxxxxxxx';
$config['database']['password'] = 'xxxxxxxxx';

Thanks, but now I am getting this error!

MyBB has experienced an internal SQL error and cannot continue.

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

Pictures: (Cut out password)
http://puu.sh/fghsR/28a79b528c.png
http://puu.sh/fghvb/e8e40df7e0.png

^ oh! change mysqli to mysql for $config['database']['type'] in the config.php file

It is already mysql

^ if so, change it to mysqli

Quote:SQL Error: 1146 - Table 'mybb_datacache' doesn't exist

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.

mysqli did not work eaither and I have filled out the correct things for ./inc/config.php

^ looks like database is corrupt or table prefix is incorrect. please check once again.

if you need direct help then you can PM me temporary access to webhost control panel
(change your credentials later)

What do I put for table prefix I do not have one of those it just says "mybb_"
Do I need to make one? and if so how please?

It is?