I'm getting the following mysql error
DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8 SQL=SELECT idarchives FROM dp_jv_archives WHERE idsite = 1 AND date1 = '2008-04-08' AND date2 = '2008-04-08' AND period = 3 AND done <> 3 AND user_type =DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND server_date IN ('2008-04-08')' at line 5 SQL=SELECT count(distinct idcookie) as nb_uniq_vis, max(total_pages) as nb_max_pag FROM dp_jv_visit WHERE idsite = 1 AND user_type = AND server_date IN ('2008-04-08')DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND server_date IN ('2008-04-08') AND returning = 1 GRO' at line 5 SQL=SELECT count(distinct idcookie) as nb_uniq_vis_returning FROM dp_jv_visit WHERE idsite = 1 AND user_type = AND server_date IN ('2008-04-08') AND returning = 1 GROUP BY returningDB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND server_date IN ('2008-04-08') AND returning = 1 GROUP BY pseud' at line 6 SQL=SELECT count(*) as s, server_date as pseudodate, sum(total_pages) as sp FROM dp_jv_visit WHERE idsite = 1 AND user_type = AND server_date IN ('2008-04-08') AND returning = 1 GROUP BY pseudodateDB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND server_date IN ('2008-04-08') GROUP BY idcookie' at line 5 SQL=SELECT count(*) as s FROM dp_jv_visit WHERE idsite = 1 AND user_type = AND server_date IN ('2008-04-08') GROUP BY idcookie
If anyone knows the solution, please let me know. Installed yesterday and love this. Never got JoomlaStats to work but this does! (apart from above problem when looking at a yearly view)