Duplicate entry '155450' for key 1 [1062]

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
carlosburgossanz
Registered User
Posts: 48
Joined: Thu Dec 25, 2008 11:05 am

Duplicate entry '155450' for key 1 [1062]

Post by carlosburgossanz »

Hi,

I recently had a problem with my server: disk filled. After eliminating excess space, the forum gives this error when I try to upload a post:

Code: Select all

SQL ERROR [ mysql4 ]

Duplicate entry '155450' 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 (8, 155, 0, '217.126.131.236', 1239111532, 1, 1, 1, 1, 1, '', 'Re: ddd', 'otra prueba', 'f429853206c2021ed37d71de16ed27c8', 0, '', '8gdz4cm6', 1, 0, 11215)

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: 1008
CALL: submit_post()
What can I do?

Regards

User avatar
COD3M4ST3R-X
Registered User
Posts: 2269
Joined: Sat Aug 02, 2008 5:47 am
Location: Lahore,Pakistan

Re: Duplicate entry '155450' for key 1 [1062]

Post by COD3M4ST3R-X »

Please provide us more information Support Request Template :)
“Need and struggle are what excite and inspire us.”

narqelion
I've Been Banned!
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm
Contact:

Re: Duplicate entry '155450' for key 1 [1062]

Post by narqelion »

carlosburgossanz wrote:What can I do?
Do a complete backup of you database, then run a repair on that table in phpmyadmin if you haven't already.

carlosburgossanz
Registered User
Posts: 48
Joined: Thu Dec 25, 2008 11:05 am

Re: Duplicate entry '155450' for key 1 [1062]

Post by carlosburgossanz »

Ok, in backup process...

What table must i to repair? phpbb_posts?

narqelion
I've Been Banned!
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm
Contact:

Re: Duplicate entry '155450' for key 1 [1062]

Post by narqelion »

carlosburgossanz wrote:What table must i to repair? phpbb_posts?
Yes.

carlosburgossanz
Registered User
Posts: 48
Joined: Thu Dec 25, 2008 11:05 am

Re: Duplicate entry '155450' for key 1 [1062]

Post by carlosburgossanz »

Thanks narqelion!!!

It works!

I will try to post and send private messages and other tasks... but I think all is in order.

Thank you ver much for your support,

Greetings.

narqelion
I've Been Banned!
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm
Contact:

Re: Duplicate entry '155450' for key 1 [1062]

Post by narqelion »

Good. Depending on the damage to your database when you ran out of disk space, you may have other tables that were affected and just don't know it yet. If you get that error message for other tables, just do the same thing. The repair rebuilds the table index which is what the problem was with. :)

Locked

Return to “[3.0.x] Support Forum”