MyBB Community Forums

Fatal error: [SQL] [1050] Table 'phoenixsupras_mybb_upgrade_data' already exists
CREATE TABLE eastbank_forum.phoenixsupras_mybb_upgrade_data ( title varchar(30) NOT NULL, contents text NOT NULL, UNIQUE (title) ); in /home/eastbank/public_html/inc/db_mysqli.php on line 557

Uploaded the changed files only.

Went to run the script but came up with the error above.


What may have caused this is...

I had a database at a free forum host. Purchased it so I could have more control and put it on to a paid host.

I had paid hosting with a domain name phoenixsupras.net so phoenixsupras_ was the table name previously.

I downloaded the database and uploaded onto free hosting with the subdomain eastbank

The database is now eastbank_forum .

The Version check says I am running 1.6.5 but the upgrade script failed so I'm at a bit of a loss as to what's next.

Not sure how this happened as it checks if the table exists first and deletes it if it does, run this query in phpMyAdmin:

DROP TABLE `phoenixsupras_mybb_upgrade_data`;

Then run the upgrade script again.

Thanks.

That's fixed it..