Pagina 5 din 6
Scris: 17-Noi-2005, 18:45:40
de dorin
Nu exista o cauza datorata cuiva, se intampla, de aceea periodic ar trebui sa optimizezi tabelele.
Nu se deschide Forumul
Scris: 20-Noi-2005, 17:56:53
de zamolxe
De cca .30 zile , cand incerc sa deschid Forumul , apare anuntul :
Could not query forum moderator information
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_user_group.MYD'. (errno: 145)
SELECT aa.forum_id, u.user_id, u.username FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_groups g, phpbb_users u WHERE aa.auth_mod = 1 AND g.group_single_user = 1 AND ug.group_id = aa.group_id AND g.group_id = aa.group_id AND u.user_id = ug.user_id GROUP BY u.user_id, u.username, aa.forum_id ORDER BY aa.forum_id, u.user_id
Line : 221
File : index.php
Ce se poate face pentru remedierea acestei erori ?
[edit="flowers"]Subiect unit cu altul care dezbate aceeaşi problemă.[/edit]
Scris: 20-Noi-2005, 21:07:41
de dorin
Si abia acum ne spui
Copiaza codul de mai jos intr-un fisier fixtables.php, pune-l pe server in directorul root al forumului si executa-l (in browser il accesezi adresa_url_domeniu/directorul_forum/fixtables.php) :
Cod: Selectaţi tot
<?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";
}
?>
Dupa executie, poti sa-l stergi sau sa-l pui intr-o zona protejata a site-ului pentru o executie viitoare.
Poti sa descaci acest fisier in format .txt de
AICI si sa-l salvezi in format .php.
Scris: 10-Ian-2006, 20:22:02
de globalisation
azi ...cand am vrut sa postez ceva pe forum a inceput sa imi dea o eroare de genul :
Could not insert new word matches
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 8085, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('revenge') <----- [aici imi apar cuvintele care le scriu in anunt]
Line : 251
File : functions_search.php
imi da eroarea ...si totusi anuntul meu se posteaza ..si nu imi apare cine a postat ultima data .
Scris: 14-Ian-2006, 02:31:17
de bogdan
ruleaza comanda:
in phpMyAdmin sau alt tool de mySQL.
Re: Nu se deschide Forumul
Scris: 12-Iul-2006, 16:29:42
de ave25ro
zamolxe scrie:De cca .30 zile , cand incerc sa deschid Forumul , apare anuntul :
Could not query forum moderator information
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_user_group.MYD'. (errno: 145)
SELECT aa.forum_id, u.user_id, u.username FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_groups g, phpbb_users u WHERE aa.auth_mod = 1 AND g.group_single_user = 1 AND ug.group_id = aa.group_id AND g.group_id = aa.group_id AND u.user_id = ug.user_id GROUP BY u.user_id, u.username, aa.forum_id ORDER BY aa.forum_id, u.user_id
Line : 221
File : index.php
Ce se poate face pentru remedierea acestei erori ?
salutare,
patesc si eu de astazi ceva asemanator pe forum.airguns.ro :
Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1016 Can't open file: 'forum_sessions.MYD'. (errno: 145)
INSERT INTO forum_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('f1902c85ddf8278f0b02072216fe6c3a', 285, 1152710115, 1152710115, 'c30705bf', 0, 1)
Line : 152
File : /softure/forum/airguns/includes/sessions.php
ceva s-a intamplat, dar nu stiu ce, poate ma puteti voi ajuta
merci!
Scris: 12-Iul-2006, 21:10:10
de flowers
Scris: 12-Iul-2006, 21:19:08
de ave25ro
flowers scrie:Ruleaza in phpMyAdmin:
suna simplu, dar eu am preluat administrarea forumului din zbor, sper sa nu moara de ras tot forumul phpbb, dar cum ajung in phpMyAdmin?
multumesc!
Scris: 12-Iul-2006, 21:30:19
de flowers
Unde e hostat forumul tau? Majoritatea serverelor cu plata sau gratuite ofera facilitatea asta.
Scris: 12-Iul-2006, 22:04:29
de ave25ro
este la vodafone, preluat de pe myx.
am intrat in meniul de administrare dar nu prea reusesc sa gasesc nici o unealta pt. administrarea serverului sql