PDA

View Full Version : Error message


White_Rabbit
08-17-2004, 11:01 AM
Hi guys, I know nothing at all about MySQL databases so please bear with me. I have a forum on my site and at the weekend we started getting an error message when anyone tries to post a new message or reply to one. The message is as follows

mySQL query error: INSERT INTO ibf_posts (author_id,use_sig,use_emo,ip_address,post_date,icon_id,post,author_name,forum_id,topic_id,queued,attach_id,attach_hits,attach_type,attach_file,new_topic) VALUES ('2','1','1','82.4.157.234','1092769110','0',' test test test ','White_Rabbit','20','138','0','','','','','1')

mySQL error: Duplicate entry '615' for key 1
mySQL error code:
Date: Tuesday 17th of August 2004 02:58:30 PM

It means nothing to me, but if some one has the time to explain what is going and how to fix it. My website address is whiterabbitfilms.**.uk

veedee
08-20-2004, 02:40 AM
Hard to shoot the error without knowing the table description, could you pls send me the table description? It seems that you try to duplicate an unique column.
______________________
free ebook php (http://www.free-itebooks.com) | free php ebook (http://www.free-itebooks.com)

azlatin2000
08-20-2004, 05:35 AM
Hmm, are you sure you didn't accidentally remove a auto_increment from a column? That hapens when a column is set to be unique but you try to insert a second row that has the same value in that column.

Try downloading the latest version of the forums from their website.