phpBB Sverige

Kod: Markera allt

phpBB : Critical Error 

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('03122917033ddac4c28e33c36fd00de1', -1, 1114117303, 1114117303, '53e38685', -1, 0)

Line : 170
File : sessions.php 

Kod: Markera allt

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Värd: mydb2.surf-town.net
-- Skapad: 22 april 2005 kl 22:35
-- Serverversion: 4.0.24
-- PHP-version: 4.3.6


<!-- PMA-SQL-ERROR -->
    <table border="0" cellpadding="2" cellspacing="1">        <tr>
            <th class="tblHeadError"><div class="errorhead">Fel</div></th>
        </tr>
        <tr>
            <td><div class="tblWarn"><p>
    <b>SQL-fråga:</b>
<a href="tbl_properties.php?lang=sv-iso-8859-1&server=2&db=forum&table=phpbb_sessions&sql_query=SHOW+CREATE+TABLE+%60forum%60.%60phpbb_sessions%60&show_query=1"><img src=" ./themes/original/img/b_edit.png" width="16" height="16" border="0" hspace="2" align="middle" alt="Ändra" /></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">`forum`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`phpbb_sessions`</span> </span>
</p></div>
<div class="tblWarn"><p>
    <b>MySQL sa: </b><a href="http://www.mysql.com/doc/E/r/Error-returns.html" target="mysql_doc"><img src="./themes/original/img/b_help.png" width="11" height="11" border="0" alt="Dokumentation" title="Dokumentation" hspace="2" align="middle" /></a>
</p>
<code>
#1016 - Can't open file: 'phpbb_sessions.MYI'. (errno: 145)
</code><br /><br />
</div>            </td>
        </tr>
    </table>


<script type="text/javascript">
<!--

    function reload_querywindow () {
        if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
                        // no submit, query was invalid
                    }
    }

    function focus_querywindow(sql_query) {
        if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
            if (parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab != 'sql') {
                parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab.value = "sql";
                parent.frames.queryframe.querywindow.document.querywindow.query_history_latest.value = sql_query;
                parent.frames.queryframe.querywindow.document.querywindow.submit();
                parent.frames.queryframe.querywindow.focus();
            } else {
                parent.frames.queryframe.querywindow.focus();
            }

            return false;
        } else if (parent.frames.queryframe) {
            new_win_url = 'querywindow.php?sql_query=' + sql_query + '&lang=sv-iso-8859-1&server=2&db=heathen_forum&table=phpbb_sessions';
            parent.frames.queryframe.querywindow=window.open(new_win_url, '','toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=yes,resizable=yes,width=550,height=310');

            if (!parent.frames.queryframe.querywindow.opener) {
               parent.frames.queryframe.querywindow.opener = parent.frames.queryframe;
            }

            // reload_querywindow();
            return false;
        }
    }

    reload_querywindow();

//-->
</script>


</body>

</html>

Kod: Markera allt

SQL-fråga: 

SHOW CREATE TABLE `forum`.`phpbb_sessions` 
MySQL sa:  

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

Kod: Markera allt

SQL-fråga: 

CREATE TABLE `forum`.`phpbb_sessions` 
MySQL sa:  

#1113 - A table must have at least 1 column 

Kod: Markera allt

CREATE TABLE phpbb_sessions (
   session_id char(32) DEFAULT '' NOT NULL,
   session_user_id mediumint(8) DEFAULT '0' NOT NULL,
   session_start int(11) DEFAULT '0' NOT NULL,
   session_time int(11) DEFAULT '0' NOT NULL,
   session_ip char(8) DEFAULT '0' NOT NULL,
   session_page int(11) DEFAULT '0' NOT NULL,
   session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (session_id),
   KEY session_user_id (session_user_id),
   KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
);