1
davecramer74
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?

2
Chris03
Re: Mysql error (cannot post to forum) HELP!!
  • 2005/6/3 2:34

  • Chris03

  • Quite a regular

  • Posts: 372

  • Since: 2004/2/22


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.

3
davecramer74
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?

4
Chris03
Re: Mysql error (cannot post to forum) HELP!!
  • 2005/6/3 2:43

  • Chris03

  • Quite a regular

  • Posts: 372

  • Since: 2004/2/22


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

Login

Who's Online

198 user(s) are online (117 user(s) are browsing Support Forums)


Members: 0


Guests: 198


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits