Hi,
As the title says, Ive moved my forum but upon adding the database again I seem to have done something wrong and i think i have duplicate entries now.
When trying to make a post I get the following error:
Script: /var/www/website.co.uk/forum/addpost.php
Line#: 873
SQL Error: Duplicate entry '0' for key 1
SQL Error #: 1062
Query: INSERT INTO w3t_Posts (B_Board,B_Parent,B_Main,B_Posted,B_Last_Post,B_IP,B_Subject,B_Body,B_Kept,B_Status,B_Approved,B_Icon,B_Reged,B_Poll,B_Replies,B_Topic,B_Convert,B_PosterId,B_AnonName,B_Sticky,B_ParentUser,B_CalDay,B_CalMonth,B_CalYear,B_AddSig) VALUES ('2','0','0','1145769428','1145769428','192.168.0.6','test','testing',' ','O','yes','book.gif','y','','0',1,'markup','2','','0','','','','','1')
Also when trying to send a PM, I get this error message:
Script: /var/www/website.co.uk/forum/sendmessage.php
Line#: 224
SQL Error: Duplicate entry '0' for key 1
SQL Error #: 1062
Query: INSERT INTO w3t_Messages (M_Uid,M_Status,M_Subject,M_Sender,M_Message,M_Sent) VALUES ('10062', 'N', 'test', '2', 'testing', 1145769821)
Any guru's out there know whats wrong or how I can fix this please?