Live Free Radio Keep Living Free

Table './livefree_129009blog/evo_hitlog' is marked as crashed and should be repaired(Errno=145)

Your query: Record the hit

INSERT INTO evo_hitlog ( hit_datetime, hit_uri, hit_disp, hit_ctrl, hit_action, hit_type, hit_referer_type, hit_referer, hit_referer_dom_ID, hit_keyphrase_keyp_ID, hit_keyphrase, hit_serprank, hit_coll_ID, hit_remote_addr, hit_agent_type, hit_agent_ID, hit_response_code, hit_method, hit_sess_ID )

VALUES ( FROM_UNIXTIME( 1571121199 ), '/?disp=arcdir', 'arcdir', '', '', 'standard', 'direct', '', NULL, NULL, '', NULL, '1', '18.208.159.25', 'unknown', NULL, '200', 'GET', '4282257' )

Table './livefree_129009blog/evo_hitlog' is marked as crashed and should be repaired(Errno=145)

Your query: Aggregate hits log

REPLACE INTO evo_hits__aggregate ( hagg_date, hagg_coll_ID, hagg_type, hagg_referer_type, hagg_agent_type, hagg_count )

SELECT DATE( hit_datetime ) AS hit_date, IFNULL( hit_coll_ID, 0 ), hit_type, hit_referer_type, hit_agent_type, COUNT( hit_ID )

  FROM evo_hitlog

 WHERE hit_datetime < '2019-10-15 00:00:00'

 GROUP BY hit_date, hit_coll_ID, hit_type, hit_referer_type, hit_agent_type