Can't open file ...

[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.