Page 2 of 2

Re: Debug error on posting

Posted: Sun Oct 26, 2008 6:10 pm
by wittykitty
CREATE TABLE `black_posts` (
`post_id` mediumint(8) unsigned NOT NULL auto_increment,
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`poster_id` mediumint(8) NOT NULL default '0',
`post_time` int(11) NOT NULL default '0',
`poster_ip` char(8) NOT NULL,
`post_username` varchar(25) default NULL,
`enable_bbcode` tinyint(1) NOT NULL default '1',
`enable_html` tinyint(1) NOT NULL default '0',
`enable_smilies` tinyint(1) NOT NULL default '1',
`enable_sig` tinyint(1) NOT NULL default '1',
`post_edit_time` int(11) default NULL,
`post_edit_count` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster_id`),
KEY `post_time` (`post_time`)
) ENGINE=MyISAM AUTO_INCREMENT=2047 DEFAULT CHARSET=latin1;

My highest post count in the black_posts table is 2046, it's set as that already. Please tell me you have another idea!!

Re: Debug error on posting

Posted: Wed Oct 29, 2008 7:52 pm
by wittykitty
Please tell me someone has an idea of how I can fix this problem?

Re: Debug error on posting

Posted: Fri Oct 31, 2008 4:55 am
by espicom
No time right now, but...

Your original error message said that 2017 was a duplicate number in the posts_text table, which does not use an auto_increment column - phpBB uses the value found in the posts table. But, your last message said the auto_inc number was 2046, not 2017... Do you have the SAME number of records in posts as posts_text, and matching numbers throughout?

Re: Debug error on posting

Posted: Fri Oct 31, 2008 8:41 pm
by wittykitty
Let me have a look, it might not as I copied across the data from another database. Let me re-copy the data as of now and try the increment thing again.

Okay, I have recopied all the data and I have 2150 in the post_id.

Just tested it AND IT WORKS!! I can post woohoo!! No idea what happened, maybe it';s because I didn't copy them both over at the same time.

I love all you people who helped, I feel WONDERFUL!!!