Recent Topics

1 Feb 08, 2007 19:55    

My b2evolution Version: 1.8.x

Hello,

just got this error:

MySQL error!

Duplicate entry '485922' for key 1(Errno=1062)

Your query: Record the hit

INSERT INTO evo_hitlog(
hit_sess_ID, hit_datetime, hit_uri, hit_referer_type,
hit_referer, hit_referer_dom_ID, hit_blog_ID, hit_remote_addr, hit_agnt_ID )
VALUES( "400593", FROM_UNIXTIME(1170960828), "/", "blacklist", "http://www.snigles.de/admin.php?ctrl=antispam&action=poll", "1", '1', "217.233.188.238", 141
)

Link to the error at the buttom of the page http://www.snigles.de
What went wrong?

regards
Joe

2 Feb 09, 2007 05:50

This ist the error from mysql:

MySQL error!

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

Your query: Get hit summary

SELECT COUNT(*) AS hits, CONCAT(hit_referer_type) AS referer_type, YEAR(hit_datetime) AS year,
MONTH(hit_datetime) AS month, DAYOFMONTH(hit_datetime) AS day
FROM evo_hitlog INNER JOIN evo_useragents ON hit_agnt_ID = agnt_ID
WHERE agnt_type = "browser" AND hit_blog_ID = 1 GROUP BY year, month, day, referer_type
ORDER BY year DESC, month DESC, day DESC, referer_type

Please help me :'(

3 Apr 15, 2007 07:25

Since 1.8.x to 1.9.x I believe there is a known problem with how it handles the evo_stats tables. If you do a search there are a lot of people with different MYSQL errors in various evo_stats tables. The current advice, not a solution is to CONSTANTLY repair the tables when these often errors appear. I myself have posted about this problem prior but no fixes appear or suggestions to fix.

If you are using Cpanel, the temp fix is to click on CHECK the SQL file that b2 is using, then REPAIR.

I keep doing this, even emptying the affected table to have the problem re-appear every 3 days. No solution yet has been suggested, unfortunately.

I just had the MYSQL evo_stats bug appear yet again after my last repair a few days ago. My best guess with no help so far is that the way b2 writes the data to evo_stats it's putting writing incorrectly, which will just keep happening when whatever is causing it repeats itself on your blog.

My latest one was:

Additional information about this error:

MySQL error!

Got error 127 from storage engine(Errno=1030)

Your query: Get hit summary

SELECT COUNT(*) AS hits, agnt_type, YEAR(hit_datetime) AS year,
MONTH(hit_datetime) AS month, DAYOFMONTH(hit_datetime) AS day

FROM evo_hitlog INNER JOIN evo_useragents ON hit_agnt_ID = agnt_ID
WHERE hit_blog_ID = 5
GROUP BY year, month, day, agnt_type

ORDER BY year DESC, month DESC, day DESC, agnt_type


Form is loading...