Category Directory

An unexpected error has occurred!

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

Go back to home page

Additional information about this error:

MySQL error!

Table 'evo_hitlog' is marked as crashed and should be repaired(Errno=1194)

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-09-21 00:00:00'

 GROUP BY hit_date, hit_coll_ID, hit_type, hit_referer_type, hit_agent_type