criscc
Hi! Yesteday I installed Google Analytics Plugin. It seems not working at the evening, but tonight something happened and now it works. Google Analytics offers me statistics but... Wiki doesn't work fine!
When I logged in this morning, two messages appears:
DB Error: could not set UTF-8 (Access denied for user ''@'localhost' to database 'stats')
DB Error: INSERT DELAYED INTO stats_logins SET dt = NOW()
Yesterday it didn't appear! Not even when I put the scripts into the Wiki code, in main.php y mediamanager.php.
I've deleted the scripts in both php but the messages still being there...
Someone knows what I have to do? I need Google Analytics but I have to delete the messages.
Thank you!
lupo49
The messages could appear from a statistcis plugin? Did you install it?
criscc
Yes, I installed Statistics and Analytics plugins, but I think the error is with Analytics and Java Script. Now when I try to put a media link in a page, the emergent window doesn't show the directory, it opens the window but just appear blank.
criscc
Ok, now I see that the error could be Statistics plugin. In 'access and usage statistics' there is some many error messages:
DB Error: could not set UTF-8 (Access denied for user ''@'localhost' to database 'stats')
DB Error: SELECT ref_type, COUNT(*) as cnt FROM stats_access as A WHERE A.dt >= '2013-04-12 00:00:00' AND A.dt <= '2013-04-12 23:59:59' AND ua_type = 'browser' GROUP BY ref_type
DB Error: Access denied for user ''@'localhost' to database 'stats' SELECT COUNT(DISTINCT session) as sessions, COUNT(session) as views, COUNT(DISTINCT user) as users, COUNT(DISTINCT uid) as visitors FROM stats_access as A WHERE A.dt >= '2013-04-12 00:00:00' AND A.dt <= '2013-04-12 23:59:59' AND ua_type = 'browser'
DB Error: Access denied for user ''@'localhost' to database 'stats' SELECT AVG(views) as cnt FROM stats_session as A WHERE A.dt >= '2013-04-12 00:00:00' AND A.dt <= '2013-04-12 23:59:59'
DB Error: Access denied for user ''@'localhost' to database 'stats' SELECT AVG(end - dt)/60 as time FROM stats_session as A WHERE A.dt >= '2013-04-12 00:00:00' AND A.dt <= '2013-04-12 23:59:59' AND dt != end
DB Error: Access denied for user ''@'localhost' to database 'stats' SELECT COUNT(*) as logins FROM stats_logins as A WHERE A.dt >= '2013-04-12 00:00:00' AND A.dt <= '2013-04-12 23:59:59' AND (type = 'l' OR type = 'p')
DB Error: Access denied for user ''@'localhost' to database 'stats' SELECT COUNT(*) as registrations FROM stats_logins as A WHERE A.dt >= '2013-04-12 00:00:00' AND A.dt <= '2013-04-12 23:59:59' AND type = 'C'
criscc
I've deleted Statistics plugin and the message error has disappeared :-)