SQL Error : 1016 Can't open file: 'phpbb_***.MYI'.

[dorin]

Nu exista o cauza datorata cuiva, se intampla, de aceea periodic ar trebui sa optimizezi tabelele.

[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]

[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.

[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 .

[bogdan]

ruleaza comanda:

Cod: Selectaţi tot

REPAIR TABLE phpbb_search_wordmatch;

in phpMyAdmin sau alt tool de mySQL.

[ave25ro]

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!

[flowers]

Ruleaza in phpMyAdmin:

Cod: Selectaţi tot

REPAIR TABLE forum_sessions;

[ave25ro]

Ruleaza in phpMyAdmin:

Cod: Selectaţi tot

REPAIR TABLE forum_sessions;

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!

[flowers]

Unde e hostat forumul tau? Majoritatea serverelor cu plata sau gratuite ofera facilitatea asta.

[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