Already done thanks for your input ozzy

I was pretty sure that those errors were sorted, but I guess not.

Can you try re-downloading the Lite version from here: http://www.dragonbyte-tech.com/demo/153-vbanalytics and see if that works for you?


Fillip

Any idea why i would get this error

Invalid SQL:

SELECT dbtech_vbanalytics_tracking_scripts.*, dbtech_vbanalytics_tracking_scripts.this_script
FROM dbtech_vbanalytics_tracking_scripts AS dbtech_vbanalytics_tracking_scripts

WHERE (dbtech_vbanalytics_tracking_scripts.dateline BETWEEN '1409716801' AND '1410407999') AND this_script != ''

ORDER BY dbtech_vbanalytics_tracking_scripts.pages/visit DESC
LIMIT 0, 20;

MySQL Error : Unknown column 'dbtech_vbanalytics_tracking_scripts.pages' in 'order clause'
Error Number : 1054
Request Date : Wednesday, September 10th 2014 @ 03:08:38 PM
Error Date : Wednesday, September 10th 2014 @ 03:08:38 PM
Script : http://tsite.com/forums/vbanalytics....&submit=Submit
Referrer : http://site.com/forums/vbanalytics.php
IP Address : 24.38.44.147
Username : test
Classname : vB_Database_MySQLi
MySQL Version : 5.5.28

And now this error

And now this error

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_tracking_users
(userid, visits, bounces, pageviews, total_time, posts, threads, data, dateline)
SELECT
userid,
dbtech_vbanalytics_visits,
dbtech_vbanalytics_bounces,
dbtech_vbanalytics_pageviews,
dbtech_vbanalytics_total_time,
dbtech_vbanalytics_posts,
dbtech_vbanalytics_threads,
dbtech_vbanalytics_data,
1410321599 AS dateline
FROM user;

MySQL Error : Duplicate entry '1-1410321599' for key 'PRIMARY'
Error Number : 1062
Request Date : Wednesday, September 10th 2014 @ 04:04:22 PM
Error Date : Wednesday, September 10th 2014 @ 04:04:22 PM
Script : http://web.com/forums/cron.php?rand=1410379461
Referrer : http://web.com/forums/member.php?16-ssratracer
IP Address : 24.38.44.147
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Unknown column means you are missing a table you need to reinstall go to their site and download the latest version as it will also fix your other problem

vBAnalytics v1.2.0 Patch Level 1

Bug Fixes:

• Fixed an issue with the cron calculations that could produce a database error

Fillip

can you support this mod for vb 3.8.8 please

There's not enough demand for us to make that possible, sorry :(

Changed Features:

• A fresh copy of the jQuery library is now only downloaded if one has not been downloaded previously. Requires updating of all other affected DBTech mods to take full effect.

Fillip