Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 4 Years, 9 Months, 1 Week ago MyBB has experienced an internal SQL error and cannot continue. SQL Error: 1130
#1
Solved: 4 Years, 9 Months, 1 Week ago
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.
Reply
#2
Solved: 4 Years, 9 Months, 1 Week ago
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';
Reply
#3
Solved: 4 Years, 9 Months, 1 Week ago
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
Reply
#4
Solved: 4 Years, 9 Months, 1 Week ago
^ oh! change mysqli to mysql for $config['database']['type'] in the config.php file
Reply
#5
Solved: 4 Years, 9 Months, 1 Week ago
It is already mysql
Reply
#6
Solved: 4 Years, 9 Months, 1 Week ago
^ 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.
Reply
#7
Solved: 4 Years, 9 Months, 1 Week ago
mysqli did not work eaither and I have filled out the correct things for ./inc/config.php
Reply
#8
Solved: 4 Years, 9 Months, 1 Week ago
^ 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)
Reply
#9
Solved: 4 Years, 9 Months, 1 Week ago
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?
Reply
#10
Solved: 4 Years, 9 Months, 1 Week ago
It is?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)