SQL Error : 1034 Incorrect key file for table: 'phpbb_users'

[IS 18 BOG]

Cod: Selectaţi tot

phpBB : Critical Error 

Error updating last visit time

DEBUG MODE

SQL Error : 1034 Incorrect key file for table: 'phpbb_users'. Try to repair it

UPDATE phpbb_users SET user_session_time = 1113993386, user_session_page = 0, user_lastvisit = 1113975002 WHERE user_id = 4

Line : 171
File : sessions.php

_________________
ce vrea sa insemne treaba asta ???
nici bine nu am instalat versiunea 2.0.13 si iata ca problemele au aparut .....

[BuGsY]

Repară tabelul phpbb_users, rulând următoarea linie în phpMyAdmin:

Cod: Selectaţi tot

REPAIR TABLE `phpbb_users`

Nu mai trimite mesaje consecutive, ai opţiunea de a edita mesajul precedent.

[IS 18 BOG]

Cod: Selectaţi tot

#1016 - Can't open file: 'phpbb_search_results.MYI'. (errno: 145)

cu treaba asta ce fac ??

Cod: Selectaţi tot

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_results.MYI'. (errno: 145)

DELETE FROM phpbb_search_results WHERE session_id NOT IN ('123226ff401ba9136762d083429fe3af', '16b1583a3edc6f0303f87a3d93f4daa3', '274033fc31c314bb9641085b0d8b8727', '364d0cc331453397390630fc883f070c', '573de1179e0289100ac283075211e0cf', '59c0eb56863edab98b0c2204db9fc0c6', '66ea0745c16373fa7403dff039c3e71a', '73a1cf9f3aac32fea6e1e90e2571755e', '783956f3698923567f621d5d33839f5b', '81392b7b0fd2fe984fe7c09b8cf58e5a', '83fc25e9cb0a18d64a16a482fe066b42', '89e357c553c83ec245bc91bb03382752', 'a00caf3bf68a32bd21af18bbcee49e2b', 'a47dcfb0f201429079798be40de74d04', 'b99de64c4bca426a116a7aa1a578355c', 'be3d642d289a4d007ea69df2ee032710', 'd416919c5cc0fbe2b5ba7a14c5155000', 'd5d301ce19e75d58a8ca6892a6c4d264', 'e29184ea0b23a4a8e98ebe36bfb622ff', 'eeabe90c4e6d986871f462b66038df04', 'fd057bda987e37b7561a60d7ffc67337')

Line : 633
File : search.php

am incercat sa zic ce spune acolo ... dar ma intreaba daca sunt sigur ... deci ???

[flowers]

Cod: Selectaţi tot

REPAIR TABLE phpbb_search_results;

[RapidFans]

Error
SQL query:

SHOW INDEX FROM `phpbb_sessions_keys` ;



MySQL said:

#1016 - Can't open file: 'phpbb_sessions_keys.MYI' (errno: 145)

am dat repair si nimik

Table Op Msg_type Msg_text
phpbb_search_results repair status OK

Cod: Selectaţi tot

-- phpMyAdmin SQL Dump
-- version 2.8.0.4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 01, 2006 at 11:49 AM
-- Server version: 4.1.14
-- PHP Version: 5.1.2
-- 
-- Database: `rapidfans_04`
-- 

<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
    <p><strong>SQL query:</strong>
<a href="tbl_properties.php?db=rapidfans_04&table=phpbb_sessions_keys&sql_query=SHOW+CREATE+TABLE+%60rapidfans_04%60.%60phpbb_sessions_keys%60&show_query=1"><img class="icon" src=" ./themes/original/img/b_edit.png" width="16" height="16" alt="Edit" /></a>    </p>
    <p>
        <span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span>  <span class="syntax_alpha syntax_alpha_reservedWord">CREATE</span>  <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span>  <span class="syntax_quote syntax_quote_backtick">`rapidfans_04`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`phpbb_sessions_keys`</span> </span>
    </p>
<p>
    <strong>MySQL said: </strong><a href="http://dev.mysql.com/doc/mysql/en/error-returns.html" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p>
<code>
#1016 - Can't open file: 'phpbb_sessions_keys.MYI' (errno: 145)
</code><br />
</div><fieldset class="tblFooters">    </fieldset>

<script type="text/javascript" language="javascript">
//<![CDATA[
// updates current settings
window.parent.setAll('en-utf-8', 'utf8_romanian_ci', '1', 'rapidfans_04', 'phpbb_sessions_keys');


// set current db, table and sql query in the querywindow
window.parent.reload_querywindow(
    "rapidfans_04",
    "phpbb_sessions_keys",
    "");


// reset content frame name, as querywindow needs to set a unique name
// before submitting form data, and navigation frame needs the original name
window.parent.frames[1].name = 'frame_content';
//]]>
</script>
</body>
</html>

[flowers]

In cazul tau:

Cod: Selectaţi tot

REPAIR TABLE phpbb_sessions_keys;

[RapidFans]

am incercat si nu a mers ... pana la urma s`a rezolvat ... cred ca era de la ei

mersi de raspuns