General Error on Chatting Time

[AnAccount]

Hey, I keep getting a general error message when I post on Chatting Time. If we're simply adding mods then this is acceptable but other than that it is really driving me crazy. This is the error I'm getting:

SQL ERROR [ mysqli ]

Duplicate entry '2777' for key 'PRIMARY' [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 (39, 2, 0, '97.114.160.173', 1289360315, 1, 1, 1, 1, 1, '', 'Re: What song are you listening to?', 'Does Your Mother Know from the Mamma Mia Soundtrack', '6047b0af7263d9fca8bca6020726e355', 0, '', '1etngvnz', 1, 0, 14)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 2135
CALL: dbal_mysqli->sql_query()

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

This seems to be an easy fix, as it looks like to do with the posting.php deal, but I want to check with you guys on what should be done before I try anything. Here's the link if you need it: http://www.chattingtime.com

 

[Kashike]

Do you have phpMyAdmin access?

 

[AnAccount]

I don't have access to Cpanel. My tech administrator does. But I did get an email saying that PHPBB has successfully been installed, so I'm assuming he messed up when installing some mods or something. I'm wondering if I should turn the board offline for a while to avoid any future mishaps?

 

[Kashike]

Here's what I have to say (Could be the problem, might not be.):
The issue is that the phpbb_posts table in your database had been stripped of the 'auto-increment' extra instruction in the Primary Key (Post ID) so that the board is trying to reset all post ID's to 1, thus causing the error.

 

[SpacewardAsh]

Hey Theta, I checked the table and it was all fine, but when I ran a check on the tables, phpMyAdmin reported some issues, so I ran a repair & optimize on them and it looks like the error is now fixed 😎

 

[AnAccount]

Yes, everything is resolved and everyone should be able to post like normal. I sincerly apologize for all of this and hopefuly everything works well on your guys' end as well.