Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. Corrupt hit log table

Corrupt hit log table

1 Mar 12, 2006 08:48    

Version: 0.9.1 "Dawn"
The error..

MySQL error!

Can't open file: 'evo_hitlog.MYD'. (errno: 144)(Errno=1016)

How do I best approach this problem.
The web hosting techs have tried to fix it but errors still occur
The table does not even show in PHPMYSQLAdmin so that I can run a repair.

I do have a .txt backup of the MYSQL for the site, though its about a month older than the current posts

-- 
-- Table structure for table `evo_hitlog`
-- 

CREATE TABLE `evo_hitlog` (
  `visitID` bigint(11) NOT NULL auto_increment,
  `visitTime` timestamp(14) NOT NULL,
  `visitURL` varchar(250) default NULL,
  `hit_ignore` enum('no','invalid','badchar','blacklist','rss','robot','search') NOT NULL default 'no',
  `referingURL` varchar(250) default NULL,
  `baseDomain` varchar(250) default NULL,
  `hit_blog_ID` int(11) NOT NULL default '0',
  `hit_remote_addr` varchar(40) default NULL,
  `hit_user_agent` varchar(250) default NULL,
  PRIMARY KEY  (`visitID`),
  KEY `hit_ignore` (`hit_ignore`),
  KEY `baseDomain` (`baseDomain`),
  KEY `hit_blog_ID` (`hit_blog_ID`),
  KEY `hit_user_agent` (`hit_user_agent`),
  KEY `visitTime` (`visitTime`)
) TYPE=MyISAM AUTO_INCREMENT=866689 ;

followed by the huge related data dump.

I am unable to "Import" this due, I guess, to it's size.

Any tips appreciated or angles I should be putting the tech support team at my Hosting outfit

Back to top

2 Mar 13, 2006 01:36

I think this may be a widespread problem.
Today my forum AND my blogs developed errors similiar to yours.

My linkblog section on my blog says:


Linkblog

MySQL error!

Can't create/write to file '/tmp/#sql_ee7_0.MYI' (Errcode: 13)(Errno=1)

Your query: Get ID list for Item List (Main|Lastpostdate) Query

SELECT DISTINCT post_ID
                      

FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
                          INNER JOIN evo_categories ON postcat_cat_ID = cat_ID 

WHERE (cat_blog_ID = 4) 

  AND ( (  ( post_status = "private" 

  AND post_creator_user_ID = 1 )  

  OR post_status IN ('published','protected') ) ) 

  AND (post_datestart <= '2006-03-12 19:34:49') 

ORDER BY post_main_cat_ID ASC, post_title ASC 

LIMIT 99
Backtrace:
db->print_error()
File: /home/purpleme/public_html/allthingscrabby/evocore/_db.class.php:557
db->query()
File: /home/purpleme/public_html/allthingscrabby/evocore/_db.class.php:759
db->get_col()
File: /home/purpleme/public_html/allthingscrabby/evocore/_db.class.php:782
db->get_list()
File: /home/purpleme/public_html/allthingscrabby/evocore/_itemlist.class.php:403
itemlist->itemlist()
File: /home/purpleme/public_html/allthingscrabby/skins/_linkblog.php:48
require( "/home/purpleme/public_html/allthingscrabby/skins/_linkblog.php" )
File: /home/purpleme/public_html/allthingscrabby/skins/Clean/_linkblog.php:35
require( "/home/purpleme/public_html/allthingscrabby/skins/Clean/_linkblog..." )
File: /home/purpleme/public_html/allthingscrabby/skins/Clean/_main.php:253
require( "/home/purpleme/public_html/allthingscrabby/skins/Clean/_main.php" )
File: /home/purpleme/public_html/allthingscrabby/evocore/_blog_main.inc.php:403
require( "/home/purpleme/public_html/allthingscrabby/evocore/_blog_main.in..." )
File: /home/purpleme/public_html/allthingscrabby/index.php:108

My forum has 


MySQL error!

Can't create/write to file '/tmp/#sql_ee7_0.MYI' (Errcode: 13)(Errno=1)

I'm no tech whiz my any means but this is different software and different people now with the same errors so it has to by MySQL right?

Back to top

3 Mar 13, 2006 02:22

@Daethian2

I think this may be a widespread problem.

I'm not sure about this, it may indicate something that is less than robust however this whole problem ( for me ) was the result of a site on the server running a rogue script. They were able to fix most of the issues but in the whole process evo_hitlog somehow got corrupted.

One thing I do know is that if your going to have server related problems, don't have them on a weekend :)

They are going to try another repair when their MYSQL guru comes on tomorrow.

I have to say that I have had no B2Evo MYSQL issues for years that couldn't be fixed by running "repair tables" and this one was a real surprise.

I will attempt to get a full explanation when ( if) it gets resolved :)

Back to top

4 Mar 13, 2006 21:05

Mine seems to have fixed itself while I was sleeping. Now explain that! LOL weird

Back to top

5 Mar 13, 2006 23:44

Well, my host worked on the corrupted hitlog table last night and fixed it without losing any data.

Thank goodness for a host that cares !!

Man that evo_hitlog table is big !!!

Back to top


Form is loading...