MyBB Community Forums

SQL Error:
1062 - Duplicate entry '0' for key 1
Query:
INSERT INTO mybb_forums (name,description,linkto,type,pid,parentlist,disporder,active,open,allowhtml,allowmycode,allowsmilies,allowimgcode,allowpicons,allowtratings,usepostcounts,password,showinjump,modposts,modthreads,mod_edit_posts,modattachments,style,overridestyle,rulestype,rulestitle,rules,defaultdatecut,defaultsortby,defaultsortorder) VALUES ('Did you hear... ?','Talk about anything.\r\n\r\njust keep it clean sort of.','','f','1','','4','1','1','0','1','1','1','1','1','1','','1','0','0','0','0','0','0','0','','','0','','')

i got this error when i tried to add theme xml's, create a forum

p.s. I have not checked out creating users, ive been focused on the forums for someone whos had this problem but after finding none im posting this desperate plea for help.

try repairing your tables in phpmyadmin or repair your databse

that was my first instinct but theres no error in the database.

---

any other suggestions?

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1062 - Duplicate entry '0' for key 1
Query:
INSERT INTO mybb_awaitingactivation (uid,dateline,code,type) VALUES ('0','1231298045','5lgzQ2fW','p')


this is the error when i try to activate a test account.

the second last string is the activation code.

well, did you install any plugins?