sql error need help "Duplicate entry '23273' for

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

sql error need help "Duplicate entry '23273' for

Author

Topic

Breez
Starting Member

1 Post

Posted - 2009-01-11 : 05:30:48

Hey guys I have a small problem every time I try to make thread on my site it spits out this error

SQL ERROR [ mysql4 ]

Duplicate entry '23273' for key 1 [1062]

SQL

INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES (30, 2, 0, '86.155.131.181', 1231640088, 1, 1, 1, 1, 1, '', 'jhskjhd', 'sadasdasbkjdaskjdbj lksahdjklashd', '99d7823afca60945a1f04be4baefac73', 0, '', 'ianxkgay', 1, 0, 21707)

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1871
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 1001
CALL: submit_post()

ANy help please?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-11 : 06:18:46

No. This is a MICROSOFT SQL Server forum.
Please redirect your question to www.dbforums.com, or similiar forum.

E 12°55'05.63"
N 56°04'39.26"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-11 : 06:19:49

Also, this is NOT a corruption issue.
The error message simply states you are trying to INSERT a record that duplicates an existing record over the primary/unique key.

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources