MyBB Community Forums

Received a backup from my old mybb forum in August of 2017.
Decided to start my old forum back up since I let the hosting expire.
Purchased GoDaddy hosting and located my old backup file. 


I have 2 files in my backup folder.
One is a  GZ file (538kb) , the other is a PHP file (3kb).

 
I went to phpMyAdmin wizard (in my Cpanel), created a new database. I uploaded the GZ file to the database.

I went to the file manager in Cpanel and went to my Public_html > inc > config.php.  I edited this file to reflect my settings.

I then uploaded the myBB new upload files.

I then go to my website /install/ 

It prompts me to upgrade my existing copy of MyBB.


I click upgrade and receive the following error.

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1146 - Table 'New20180423.mbb_settings' doesn't exist
Query:SELECT value, name FROM mbb_settings ORDER BY title ASC

Do you see the settings table in PHPMyAdmin?

MySQL Error 1146

Information: This occurs when you are using MySQL and the database table prefix is incorrect in inc/config.php. 
Fix: 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.

Also make sure that you have the right info in ~/inc/config.php and ~/inc/settings.php.

See Error Messages for more info about MyBB’s errors.

(2018-04-24, 07:11 PM)Brian. Wrote: [ -> ]Do you see the settings table in PHPMyAdmin?

MySQL Error 1146

Information: This occurs when you are using MySQL and the database table prefix is incorrect in inc/config.php. 
Fix: 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.

Also make sure that you have the right info in ~/inc/config.php and ~/inc/settings.php.

See Error Messages for more info about MyBB’s errors.

Yes I see the settings table in PHPMyAdmin.

The entry in the inc/config.php is correct.

The right info is in ~/inc/config.php,
But when i go to ~/inc/settings.php it is blank.

---

nvm.. I'm probably wrong. Error is still there.

settings.php should populate data while installing MyBB. Even if it is empty it should not bother you if you have settings table in database. It gets updated everytime any setting is being changed from ACP.

The problem is here with your database connection. Are you sure:
1. Your database name is "New20180423" ?
2. Are you sure your table prefix is "mbb"? (note the default one is "mybb" but depends upon what you set during installation. Check your database tables, like it is "mbb_settings" or "mybb_settings". If you are not sure check the value of "$config['database']['table_prefix']" in your config.php. If it is default it should be "mybb_").