MyBB Community Forums

SQL query:

-- MyBB Database Backup
-- Generated: 15th September 2011 at 09:28
-- -------------------------------------
CREATE TABLE mybb_adminlog (
uid int( 10 ) unsigned NOT NULL DEFAULT '0',
ipaddress varchar( 50 ) NOT NULL DEFAULT '',
dateline bigint( 30 ) NOT NULL DEFAULT '0',
module varchar( 50 ) NOT NULL DEFAULT '',
action varchar( 50 ) NOT NULL DEFAULT '',
data text NOT NULL ,
KEY module ( module , action )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;



MySQL said:
#1050 - Table 'mybb_adminlog' already exists

Could someone help me with this error. Thank you in advance.

Go into phpmyadmin and drop all the tables in the database.

I did import my back up db to my phpmyadmin and got those errors.

(2011-09-16, 03:23 AM)Malcolm. Wrote: [ -> ]Go into phpmyadmin and drop all the tables in the database.

Sir i really have no idea about that, could you please help me? Thanks

---

Got it..hehehehe, thanks sir

---

now i have this error:
MyBB has experienced an internal error and cannot continue.
Error Type:
MyBB Error (42)
Error Message:
Your board has not yet been upgraded. Please do so before attempting to browse it.

im using mybb 1.6 latest version, i did not upgrade mybb i just import my db.

(2011-09-16, 03:39 AM)wickedrig Wrote: [ -> ]Sir i really have no idea about that, could you please help me? Thanks

---

Got it..hehehehe, thanks sir

---

now i have this error:
MyBB has experienced an internal error and cannot continue.
Error Type:
MyBB Error (42)
Error Message:
Your board has not yet been upgraded. Please do so before attempting to browse it.

im using mybb 1.6 latest version, i did not upgrade mybb i just import my db.

Was the backup of the database from an older/different version of MyBB?

yes sir from 1.4

The database schema has changed significantly between MyBB 1.4 and 1.6. I think the only way to fix this is to install MyBB 1.4, import your database, then upgrade to 1.6.

thank you