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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

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

Started by redbjork, February 28, 2007, 08:39:20 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

redbjork

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.

Nibbler

Click on the SQL tab and enter

REPAIR TABLE cpg149_sessions

redbjork

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