Posting problem

[cooky]

I backed up the database recently and after re-installinig it I got the following message


Error in posting

DEBUG MODE

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

INSERT INTO phpbb_posts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (9010, 'afa', '0e58b275ed', 'frafra')

Line : 282
File : functions_post.php


Any idea what this means

Thanks
Steve

[Marshalrusty]

Repairing the table should reset the auto increment.

1. Create a fix.php file with the following:

   Code: Select all

   <?php
   define('IN_PHPBB', true);
   include('./extension.inc');
   include('./common.'.$phpEx);
   $page_title = 'phpBB Fix';
   
   $sql = "REPAIR TABLE phpbb_posts_text";
   
   message_die(GENERAL_MESSAGE, '<table width="80%" class="forumline"><tr><td><b>Query: </b>' . $sql . '<br /><b>Status: </b><font color="' . ((!($db->sql_query($sql))) ? 'red">Error running query (' . mysql_error() . ')</font><br /><br /><br /><b>Be sure to post this message in your topic on phpBB.com</b><br />' : 'green">Ran successfully</font><br /><br /><br />') . '<b>For security reasons, delete this file when you are finished.</b></td><tr></table>');
   ?>

2. Upload the file to your board's root folder (the one with config.php)
3. Run it by navigating to the file in your browser (ex. http://www.yoursite.com/phpBB2/fix.php)
4. If any errors come up, post the report here.
5. Be sure to delete the file; don't leave it on your server

[cooky]

ran the test and it's still the same


Query: REPAIR TABLE phpbb_posts_text
Status: Ran successfully