Recent Topics

1 Mar 05, 2006 08:11    

Hey, i'm using a cvs build of 1.7 from last month (feb) and today i started getting this error on the stats summary page for 2/5 of my blogs...

MySQL error!

Got error 127 from table handler(Errno=1030)

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
WHERE hit_blog_ID = 2
GROUP BY year, month, day, referer_type

ORDER BY year DESC, month DESC, day DESC, referer_type

Backtrace:

1. db->print_error( "", "Get hit summary" )
File: /home/balupton/public_html/blogs/evocore/_db.class.php:557
2. db->query( "SELECT COUNT(*) AS hits, CONCAT(hit_referer_type) AS referer_typ...", "Get hit summary" )
File: /home/balupton/public_html/blogs/evocore/_db.class.php:799
3. db->get_results( "SELECT COUNT(*) AS hits, CONCAT(hit_referer_type) AS referer_typ...", "ARRAY_A", "Get hit summary" )
File: /home/balupton/public_html/blogs/admin/stats.php:165

Ignored last: 1

Can anyone help me out.

2 Mar 05, 2006 08:20

error 127 means a table is corrupted.

3 Mar 05, 2006 08:29

Alrite any idea how to fix this?
I would really like to keep my stats....

4 Mar 06, 2006 05:36

In phpmyadmin check the corrupted tables (check all your tables if you don't know) and choose "repair" in the list of actions at the bottom

5 Mar 06, 2006 16:57

Thanks madz i owe you one.


Form is loading...