-
phpbb error
Какво ли означава това:
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
Когато се опитвам да отговоря на една тема в един друг форум?
-
phpbb error
Никой не ми отговори:(
Аз намерих решението с това:
<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" поправя и други грешки в таблиците!
Благодаря!