phpbb error

[kostoff]

Какво ли означава това:

Error in posting



DEBUG MODE



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



INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES (864, 27, 38, '', 1116155651, 'd4cd9d46', 1, 1, 1, 0)



Line : 271

File : functions_post.php





Когато се опитвам да отговоря на една тема в един друг форум?

[kostoff]

Никой не ми отговори

Аз намерих решението с това:

<blockquote id="quote"><font size="1" id="quote"><b id="quote">quote:</b id="quote"></font id="quote"><table border="0" id="quote"><tr id="quote"><td class="quote" id="quote"><font size="1" id="quote"><?php

// Check and repair all tables in a PHPBB structure



// verify that we're supposed to run

// change 'PX42m3' to something unique for your site, so it will only

// execute if you call it as 'http://mysite.com/fixtables.php?PX42m3=1'

if (!isset($_GET['PX42m3']))

{

header("Location: http://127.0.0.1/");

die();

}



define('IN_PHPBB', true);

$phpbb_root_path = './';

include($phpbb_root_path . 'config.php');



// connect to the database server

$db = mysql_connect($dbhost,$dbuser,$dbpasswd);

if (!$db) die("Unable to connect to database!\n");



// select the PHPBB database

mysql_select_db($dbname,$db);



// get a list of tables for this PHPBB

$tablequery = "show tables like '".$table_prefix."%'";

$tablelist = mysql_query($tablequery,$db);





// cycle through them for repair

while ($tar = mysql_fetch_array($tablelist))

{

$tablename = $tar[0];

// output some verbosity for comfort

echo "Now checking and repairing table $tablename ... ";

$repres = mysql_query("repair table $tablename");

$result = mysql_fetch_array($repres);

echo $result['Msg_text'] . "<br>\n";

}



?>

</td id="quote"></tr id="quote"></table id="quote"></blockquote id="quote"><font size="2" id="quote"></font id="quote">

Ако някой има проблем с БД на phpbb,нека го запази като "fixtables.php" в главната дир на форума и после да отвори това:

"http://името на сайта/phpbb/fixtables.php?PX42m3=1".

Това "fixtables.php" поправя и други грешки в таблиците!

Благодаря!