forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: redbjork on February 28, 2007, 08:39:20 pm

Title: Can't open file: 'cpg149_sessions.MYI' (errno: 145)
Post by: redbjork on February 28, 2007, 08:39:20 pm

Hi super exelent coppermine support  ;D
First of let me get this of my chest, yes im a noob, so don´t hate me.

Well on to the problem.
My Coppermine version: 1.4.9 has worked fine for some months now.
But when I now open the page I recive the following error message.

Error message:
While executing query "delete from `joomla`.cpg149_sessions where time<1172687269 and remember=0;" on Resource id #6

mySQL error: Can't open file: 'cpg149_sessions.MYI' (errno: 145)

So my past experience told me to do a repear on cpg149_sessions
So I go in to PHPmyAdmin, but there i recive this error message.

Error
SQL query:

SHOW COLUMNS FROM `cpg149_sessions` FROM `joomla`
MySQL said: 

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

so now I don´t know what to do.

Can you please help me?

Regards
Daniel
Sweden.

Title: Re: Can't open file: 'cpg149_sessions.MYI' (errno: 145)
Post by: Nibbler on February 28, 2007, 08:59:32 pm

Click on the SQL tab and enter

Code: [Select]

REPAIR TABLE cpg149_sessions

Title: Re: Can't open file: 'cpg149_sessions.MYI' (errno: 145)
Post by: redbjork on February 28, 2007, 10:07:07 pm

You guys are the best, it worked!  ;D

And thank you for writing the syntax. I did not see it first, so I was poking around in the help file. The example syntax was realy confusing ???.
But when I saw your code it all made sence.

Thank you again, if you ever come to Stockholm Sweden i have to buy you a beer.  :D