MyBB Community Forums

Hi, i recently had a crash in the database. And now i have re-installed the MyBB 1.2 (updated before crash) but when i ran the www.xx.com/install.php it created the new entries in the database, but i want to import the users and all the settings from a backup eg. forum.sql

But then i get this messege: "#1136 - Column count doesn't match value count at row 1." The file is attached.

Any ideas? Because it seems that there is some diffrenses between the versions?

Thanx in advance!

Thats only the users table.

Besides, is it possible that you are using a 1.1 database on a 1.2 forum?

Yes it is a 1.18 database. But i still want all the settings from that DB to the new one.

Then you will need to install 1.1.8 again first (Download here: http://community.mybboard.net/showthread.php?tid=12276)

Import your old data (clear the content of the existing tables first)

Then you need to run the 1.2 upgrade procedure.

But now i get:

INSERT INTO mybb_attachtypes
VALUES ( 1, 'Zip File', 'application/zip', 'zip', 1024, 'images/attachtypes/zip.gif' )

#1062 - Duplicate entry '1' for key 1