Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. [1.9.x] Can't open file: 'evo_hitlog.MYI' [resolved]

[1.9.x] Can't open file: 'evo_hitlog.MYI' [resolved]

1 Oct 19, 2008 08:13    

My b2evolution Version: 1.9.x

Hi.

I have recently being seeing the following error at the bottom of my blog.
Everything else seems to work fine.

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Can't open file: 'evo_hitlog.MYI' (errno: 145)(Errno=1016)

Your query: Autopruning hit log
      DELETE 
FROM evo_hitlog
      
WHERE hit_datetime < "2008-10-04"

Here is the website: www.sigweb.co.za (B2 version 1.9.3).

Any ideas?

Back to top

2 Oct 20, 2008 23:28

You have a problem with the evohitlog database. Talk to your host provider.

Back to top

3 Oct 21, 2008 06:12

It's safe to empty that table.

Back to top

4 Nov 02, 2008 06:05

Walter wrote:

You have a problem with the evohitlog table. Talk to your host provider.

Thanks.
If I try to browse or edit the table "evo_hitlog" using phpMyAdmin i also get the error:

Error
SQL query:  
SHOW INDEX FROM `evo_hitlog` ;

MySQL said:  
#1016 - Can't open file: 'evo_hitlog.MYI' (errno: 145)

Is it not possible that the table has been corrupted and needs to be replaced/repaired?

Back to top

5 Nov 02, 2008 06:08

Empty the evo_hitlog table and/or repair your database

Back to top

6 Nov 02, 2008 06:16

sam2kb wrote:

Empty the evo_hitlog table and/or repair your database

I can't empty it.

If I use phpMyAdmin and click on the table "evo_hitlog" on the left, I then get the error mentioned above. The Empty and Browse hyperlink buttons don't work, and when I click Structure or Insert buttons I get the same error.

Back to top

7 Nov 02, 2008 06:20

Try this

Click on database name, you'll see a list of all tables
Check evo_hitlog, scroll down and select EMPTY from dropdown menu

You can also select all tables and do RECOVER from the same menu

Back to top

8 Nov 02, 2008 06:31

sam2kb wrote:

Try this

Click on database name, you'll see a list of all tables
Check evo_hitlog, scroll down and select EMPTY from dropdown menu

You can also select all tables and do RECOVER from the same menu

Thanks.
I will try this a bit later.
I have first emailed my host for some help as for some reason I can no longer export the whole database and I would like to make a backup before going any further.

Back to top

9 Nov 04, 2008 16:45

Just an update.
I contacted my hosting company and they repaired the database, so all is working again. :D

Back to top


Form is loading...