[mythtv-users] Mythweb Sessions problem

[Steve Daniels]

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of Christopher Friend
> Sent: 07 May 2006 16:14
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] Mythweb Sessions problem
> 
> Hey there, I'm having a problems trying to access mythweb - it keeps
> giving
> the following error when I try to access it:
> 
> 
> Fatal Error at /srv/www/htdocs/mythweb/includes/db.php, line 360:
> SQL Error: Can't open file: 'mythweb_sessions.MYI' (errno: 145) [#1016]
> 
> Details:
> 
> errornum:  256
> error type:  User Error
> error string:  SQL Error: Can't open file: 'mythweb_sessions.MYI' (errno:
> 145) [#1016]
> filename:  /srv/www/htdocs/mythweb/includes/db.php
> error line:  360

What you need to do here is actually have a good read of the error it is
giving you.

SQL Error <- This bit means SQL is having a problem with something you told
it to do.

So a quick google of that... SQL Error: Can't open file: .MYI' (errno: 145)
[#1016]

http://www.google.co.uk/search?q=SQL+Error%3A+Can't+open+file%3A+.MYI+(errno
%3A+145)+%5B%231016%5D&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mo
zilla:en-US:official

Note I removed the mythweb_sessions bit because that is application
specific.

Click the first link:

http://www.karakas-online.de/forum/viewtopic.php?t=332

It should tell you how you can fix the corrupted table :-)

> 
> 
> Could be unrelated but I think it happened around the same time I
> acidentally hit the power switch on my pc's plug socket, shutting the
> thing

VERY Related. This is most likely how you fried the database.

> down while I was using mythweb, and with the firefox browser profile being
> on a fat32 partion, well... took a while to get things working again :oP
> 
> Google only has one mention of "mythweb_sessions" with a guy saying he
> deleted all the session info in a table, but not saying which table or how
> to delete stuff.
> 
> So erm.. any help would be good.

<snip />

> Christopher
> 
> =================
> The Crimea / The Crocketts
> http://www.inaudible.co.uk
> =================


Steve Daniels