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

Installed on the 26th at around 8pm (GMT +7), on the 27th I could see some stats for the 26th. On the 28th, I could see some stats for the 27th (which seemed very low). Today (29th) there is no data for 28th.

My forum is also set to GMT +7.

Any idea?

Being handled @ our site :)


Fillip

Hi I am trying to install it in my vBulletin forum occultforums.net
My vBulletin version No is 4.2.3. I am getting the following error while installing it:

Database error in vBulletin 4.2.3:

Invalid SQL:

ALTER TABLE dbtech_vbanalytics_tracking
DROP column logid,
ADD PRIMARY KEY ( `dateline` );

MySQL Error : Can't DROP 'logid'; check that column/key exists
Error Number : 1091
Request Date : Wednesday, December 28th 2016 @ 11:00:10 AM
Error Date : Wednesday, December 28th 2016 @ 11:00:17 AM
Script : http://www.occultforums.net/admincp/...=productimport
Referrer : http://www.occultforums.net/admincp/...?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Please help me..