PDA

View Full Version : Posting to New Threads error



redranger
Sat 13th May '00, 2:07pm
Database error in vBulletin: Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,lastposter,dateline,iconid,visible) VALUES (NULL,'Forum Junkie Poster Rankings',NOW(),1,1,0,'redranger','redranger',NOW( ),1,1)
mysql error: Duplicate entry '' for key 2
mysql error number: 1062
Date: Sunday 14th of May 2000 12:02:48 AM
Script: /mb/newthread.php
Referer: http://highervoltage.net/mb/newthread.php?action=newthread&forumid=1


Has anyone experienced this error before? I can post replies to previous threads perfectly, but can't create new threads.

--red

John
Sun 14th May '00, 8:58am
Have you added any of your own indicies to the tables, or are you just running the default installation set of indicies.

If you have added your own, I think that is where the problem lies - you have created a unique index, which you are trying to add non-unique values to.

John