[resolved] Cant post anymore!?!?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
kenno
Registered User
Posts: 81
Joined: Sun Apr 09, 2006 10:54 am
Location: Estonia
Contact:

[resolved] Cant post anymore!?!?

Post by kenno »

I have a problem with my forum, i cant post because post_id just raised to 16777215. I got this error:

Code: Select all

Error in posting

DEBUG MODE

SQL Error : 1062 Duplicate entry '16777215' for key 1

INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES (8891313, 2, 607, '', 1165679892, '58c4193d', 1, 0, 1, 0)

Line : 273
File : functions_post.php
And there is the question..How can post_id just jump so high? All the previous post_id were low.
Where does forum takes that id?
User avatar
kenno
Registered User
Posts: 81
Joined: Sun Apr 09, 2006 10:54 am
Location: Estonia
Contact:

Post by kenno »

okay, here is the answer:

Code: Select all

alter table phpbb_posts auto_increment=1;
write this to mysql and its done! :)
User avatar
lost
Registered User
Posts: 242
Joined: Fri Jan 24, 2003 3:28 am

Re: [resolved] Cant post anymore!?!?

Post by lost »

Thank you very much! This worked perfectly!
Locked

Return to “2.0.x Support Forum”