Hi, when i try to acces to forum stats from admin panel i see this error:
Database error: Invalid SQL: INSERT into forum_dailyforumstats (year_stat,month_stat,day_stat,forum,total_insert, total_login,total_view,total_subscribe,total_register) SELECT YEAR(datestamp), MONTH(datestamp), LEFT(datestamp,8), forum, SUM(action='insert'), SUM(action='login'), SUM(action='view'), SUM(action='subscribe'), SUM(action='register') FROM forum_log_t2 WHERE datestamp >= '0000-00-00 00:00:00' GROUP BY YEAR(datestamp), MONTH(datestamp), LEFT(datestamp,8), forum
[1062] Duplicate entry '0000-00-00 00:00:00-' for key 2
What is the problem? thanks a lot, agora it's great!
Greetings
|
Problem with forum stats!
