Loading...
 
Skip to main content

Features / Usability


MySQL Error 145

Hello,

Have been using Tiki 1.94 for quite a while and have never had any problems (I'm going to upgrade soon), but this morning I visited my wiki site at www.ajdrake.com/wikiQuestion and got the following error message:

Warning: mysql error: Can't open file: 'tiki_sessions.MYI'. (errno: 145) in query:

insert into `tiki_sessions`(`sessionId`,`timestamp`,`user`,`tikihost`) values(?,?,?,?)

in /home/ajdrake/public_html/wiki/lib/tikidblib.php on line 134

Would surely appreciate any insight forum members can offer on how to deal with this problem!

Thanks. Al

> Hello,
>
> Have been using Tiki 1.94 for quite a while and have never had any problems (I'm going to upgrade soon), but this morning I visited my wiki site at www.ajdrake.com/wikiQuestion and got the following error message:
>
> Warning: mysql error: Can't open file: 'tiki_sessions.MYI'. (errno: 145) in query:
>
> insert into `tiki_sessions`(`sessionId`,`timestamp`,`user`,`tikihost`) values(?,?,?,?)
>
> in /home/ajdrake/public_html/wiki/lib/tikidblib.php on line 134
>
> Would surely appreciate any insight forum members can offer on how to deal with this problem!
>
> Thanks. Al
>

Hi,

This is a mysql problem, specifically the table causing problems has been slightly damaged.

Don't worry though, in my experience this error is completely fixable with no data loss.

It can be fixed via the mysql command line, or if you use a gui such as SQLyog, there are options for repairing tables (point to the table in the tree, then click Tools->Table Diagnosics then click on the repair option - you may have to check one or more of the boxes, depending on how stubborn the problem is). Other gui's will have similar tools too.

Hth

al123

> Hi,
>
> This is a mysql problem, specifically the table causing problems has been slightly damaged.
>
> Don't worry though, in my experience this error is completely fixable with no data loss.
>
> It can be fixed via the mysql command line, or if you use a gui such as SQLyog, there are options for repairing tables (point to the table in the tree, then click Tools->Table Diagnosics then click on the repair option - you may have to check one or more of the boxes, depending on how stubborn the problem is). Other gui's will have similar tools too.
>
> Hth
>
> al123

Okay, thanks — yes, I thought it was fixable enough. This time, my server company tech people ran a script that fixed it. Next time I'll see if I can fix it myself. Much appreciated. Al