Duplicate entry '22769-9' for key 2

Started by dwoolcott, June 26, 2007, 01:25:59 AM

Previous topic - Next topic

dwoolcott

I imported a database for our new host for a site running SMF. 

Tryign to run maintance on the forums after improting yields the following:

Duplicate entry '22769-9' for key 2
File: /home/woalair/public_html/Sources/RepairBoards.php
Line: 190

Any suggestions?

The original errors it finds are:

The following errors are fouling up your forum:
Message #22766 is in non-existent topic #3290.
Message #22767 is in non-existent topic #3290.
Message #22768 is in non-existent topic #3290.
Message #22769 is in non-existent topic #3290.
Message #22766 is in non-existent topic #3290.
Message #22767 is in non-existent topic #3290.
Message #22768 is in non-existent topic #3290.
Message #22769 is in non-existent topic #3290.
Topic #3337 has the first message ID 0, which is incorrect.
Topic #3337 has the last message ID 0, which is incorrect.
Topic #3338 has the first message ID 0, which is incorrect.
Topic #3338 has the last message ID 0, which is incorrect.
Topic #3339 has the first message ID 22766, which is incorrect.
Topic #3339 has the last message ID 22769, which is incorrect.
Topic #3340 has the first message ID 23008, which is incorrect.
....

Thanks

SMF 1.1.2

Sarge

First, get a database backup. Then try repairing database tables from phpMyAdmin:
http://www.simplemachines.org/community/index.php?topic=176088.msg1129597#msg1129597

Note: Database backup can also be performed from cPanel or phpMyAdmin or even the create_backup script attached to this post:
http://www.simplemachines.org/community/index.php?topic=18350.msg168327#msg168327

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Advertisement: