Can't open file ...

[rodman]

Hello All,

My site went down last night .... so this morning I went to repair my tables .... and I noticed it timed out.  Then I rebooted my "node" and went to myPhPAdmin and when I brought up the smf database I get the following:

#1016 - Can't open file: 'smf_log_errors.MYI' (errno: 144)

I tried the following on the SQL part of PhpMyAdmin:
REPAIR TABLE smf_log_errors;

I also noticed a few weeks back that my smf_lof_errors.MYI was HUGE!!!!

Any help is greatly appreciated!

[Jump1979man]

I would suggest to drop the table.....then create a new one.

[rodman]

I'm not to familiar with how to do that? 

What command is used to drop and then create that table?

Thanks =)
Rod

[Jump1979man]

its very easy in phpmyadmin....

find the table....check it....go to the bottom and select to drop selected table.

Then go to the bottom of the tables list and enter the same exact name of that table....BE EXACT!!!.....then click add table. 

Not sure if it will help you but it wont hurt to try.

btw, by dropping the table you will lose any info stored in it.  Just so you know.

[rodman]

What is in this table?  Are they just error logs?

[redone]

Try the following:

Forum Maintenance>Find and repair any errors

[rodman]

Also ... I can't get to the point where I "check box" that table.  It doesn't even get that far ... it stops at the table before that one:

[rodman]

Try the following:

Forum Maintenance>Find and repair any errors

Can't even get into the forum .... I get this when I go to the forum:

Code Select Expand

Database Error: Can't open file: 'smf_messages.MYI' (errno: 145)
File: /var/www/html/forum/Sources/TPortal.php
Line: 682

Usually when I get this I repair my tables .... but now it seems like my smf_log_errors is keeping me from doing so =(

Thanks for the help guys!  I've got a whole bunch of angry fisherman blowing up my cell phone! hahaha!

[redone]

We are not talking about the same thing. I am talking about from within your SMF admin panel and not phpmyadmin.

[rodman]

We are not talking about the same thing. I am talking about from within your SMF admin panel and not phpmyadmin.

Redone .... I know what you're talking about heheh ... =)
I can't even get into my Forum .... SMF admin panel ... or anything. =(

I get that error message I code'd above. 

http://www.freespool.net/forum/status.php

http://www.freespool.net/forum

Thanks for your help! Greatly appreciated! =)

[rodman]

If I drop this particular table? What data am I going to lose?  Will I lose anything REALLY important?

[Jump1979man]

You will lose the logged info that is stored in there.....it is just error logged messages.  If you are not a programmer then they will really be meaningless to you for anything other than some helpful insight as to what errors people browsing your site are getting.

I wouldnt worry about it.  You can do the same thing through the admin panel when you delete them. 

[rodman]

Sounds good ....

So since I can't drop the table by:

find the table....check it....go to the bottom and select to drop selected table.

Then go to the bottom of the tables list and enter the same exact name of that table....BE EXACT!!!.....then click add table. 

Is there another way of doing so:

Thanks

[H]

I fail to see why you need to drop the table.

Just clear the errors using remove all from error log in the admin area

[Jump1979man]

You can call your host and sometimes they will help you out and do it....or you need root access.

[Jump1979man]

I fail to see why you need to drop the table.

Just clear the errors using remove all from error log in the admin area

he cannot log in to get to that area....and he says it is due to this table of logs.

[H]

You can call your host and sometimes they will help you out and do it....or you need root access.

I would do this for free if rodman wants to PM me an SMF admin user and phpmyadmin access

[rodman]

I fail to see why you need to drop the table.

Just clear the errors using remove all from error log in the admin area

I am unable to get into my forum at all .... here's a link to my forum.

http://www.freespool.net/forum

Heres a link to my status.php

http://www.freespool.net/forum/status.php

The reason why I think I need to drop this table is because of the error message which I have attached in a post above =)

[rodman]

You can call your host and sometimes they will help you out and do it....or you need root access.

I've got root access and shell access ... but no clue what commands to run .... =(

[Jump1979man]

google....

http://www.1keydata.com/sql/sqldrop.html

You can call your host and sometimes they will help you out and do it....or you need root access.

I've got root access and shell access ... but no clue what commands to run .... =(

[rodman]

K ... that sounds simple enough ... but recreating it sounds like a pain! 

[rodman]

Okkkkayyy ... so please I hope this works ... but I wanted to run it by you guys ...

I'll drop the table .... since the create table commands confuse me ....

Can I import just the smf_log_errors from a backup?!?! Will that work?

[Thantos]

from phpMyAdmin run the following query:

Code Select Expand

REPAIR TABLE smf_log_errors

That particular error has been discussed quite a bit here.  Its due to a corruption of the file that contains the data for that table.

[carlatf]

Hi,
Sorry for bringing back this old topic.
I receive the exact same error "Can't open file: 'smf_messages.MYI' (errno: 145)"

But my table is fine, I repaired just in case. But it doesn't work.
I don't see any other msg in the error file.

Best,
Carla

[currysgirl]

Does anyone have the query text available to create the new smf_error_log table?   

[H]

Code Select Expand


CREATE TABLE {$db_prefix}log_errors
( ID_ERROR mediumint(8) unsigned NOT NULL auto_increment, logTime int(10) unsigned NOT NULL default '0', ID_MEMBER mediumint(8) unsigned NOT NULL default '0', ip char(16) NOT NULL default ' ', url text NOT NULL, message text NOT NULL, session char(32) NOT NULL default ' ', PRIMARY KEY (ID_ERROR), KEY logTime (logTime), KEY ID_MEMBER (ID_MEMBER), KEY ip (ip(16)) ) TYPE=MyISAM;

[loki66]

The code is wrong :

Database Error: Can't open file: 'smf106_log_errors.MYI' (errno: 145)
File: /home/monstr/public_html/forum/Sources/ManageBans.php
Line: 809

[青山 素子]

How is the code wrong? That message means MySQL is having an error trying to open the table it has been asked to.