xoops forums

davecramer74

Just popping in
Posted on: 2005/6/3 2:24
davecramer74
davecramer74 (Show more)
Just popping in
Posts: 4
Since: 2005/4/7 1
#1

Mysql error (cannot post to forum) HELP!!

Im running MySQL 4.1.9. XOOPS 2 and phpbb 2.x

Im getting error msg, "could not insert forum post".

I ran debug, and i get the following:

INSERT INTO xoops_bb_posts ( post_id, pid, topic_id, forum_id, post_time, uid, poster_ip, poster_name, subject, dohtml, dosmiley, doxcode, doimage, dobr, icon, attachsig, attachment, approved, post_karma, require_reply) VALUES (0, 0, 274, 1, 1117762977, 1, 402946799, '', 'test', 0, 1, 1, 1, 1, '', 0, '', 1, 0, 0)
Error number: 1062
Error message: Duplicate entry '1368' for key 1

I dont know jack about mysql. Any clue how to fix it? Or where to look to fix it?

Chris03

Quite a regular
Posted on: 2005/6/3 2:34
Chris03
Chris03 (Show more)
Quite a regular
Posts: 372
Since: 2004/2/22
#2

Re: Mysql error (cannot post to forum) HELP!!

this is odd as the table should auto increment so that you dont get IDs clashing.... is this a new forum? if so i would truncate the xoops_bb_posts table from PHPmyadmin and try again or remove PHPbb and reinstall it to make sure no tables are corrupt.

davecramer74

Just popping in
Posted on: 2005/6/3 2:38
davecramer74
davecramer74 (Show more)
Just popping in
Posts: 4
Since: 2005/4/7 1
#3

Re: Mysql error (cannot post to forum) HELP!!

forums been up for awhile. I did have a power outage today. Think something may have got corrupted?

Chris03

Quite a regular
Posted on: 2005/6/3 2:43
Chris03
Chris03 (Show more)
Quite a regular
Posts: 372
Since: 2004/2/22
#4

Re: Mysql error (cannot post to forum) HELP!!

i would go into phpmyadmin and run a CHECK or REPAIR on them see what phpmyadmin says...