[DBTech] vBAnalytics v1 (vB4)

[DragonByte Tech]

vBAnalytics: What is it?
vBAnalytics provides detailed and customized analytics from traffic including bounce rates, landings, pageviews, visits and many more customized just for vBulletin! Think Google Analytics but made for vBulletin!

Uses
If you ever wanted Google Analytics to provide more attention to your forum specific aspects than this is a must have for you. It provides statistics specifically requested from experienced board owners and displays them in an friendly and knowledgeable manner. Allowing even the most novice of board owners to know exactly what his users like and dislike in his community.

Use vBAnalytics to see how your individual forums are doing overtime, great to see if recent changes to boost activity there actually worked. You could do the same thing to individual pages in your forum, to see if recent changes to boost activity on those pages actually worked. With the pro version you can monitor search trends, to see what your users are searching on your forum and what links they click from the search allowing you to tailor to the needs of your community.

The benefits of this mod can raise your traffic and your overall member experience by showing exactly what the most and least popular aspects of your forum is. Tracking landings, bounces, visits and pageviews is a quintessential part of finding out where work needs to be done in order to improve your forum's activity and success.

-------------------------------------------------------------------------------------------

If you like this mod please hit the https://vborg.vbsupport.ru/external/2015/08/1.png button to the right ---->

Please remember to click the, https://vborg.vbsupport.ru/external/2015/08/2.png button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com (http://www.dragonbyte-tech.com/)

-------------------------------------------------------------------------------------------

Translations available @ our forum (http://www.dragonbyte-tech.com/forums/91-Translations)
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------
Major Features
Automatically Track Analytics: Automatically track forum analytics. Daily or hourly scheduled tasks ensure data integrity and consistency without any involvement from you.

Flexible & Comprehensive: From forums, threads, members, registrations, searches and overall analytics tracking, vBAnalytics is the most comprehensive analytics add-on for vBulletin. Allowing you to specify what exactly you want to track and how the tracked data displays to you.

Comparing Data: Allows you to compare different data from different time periods to easily compare via graph and aggregated results.

Real-time Stats: You can see the exact analytics of your forum in real-time without having to wait like you would in other Analytics systems.

Conversions: Monitor new registrations to see how your site appeals to new users. Track register bounce rates, pageviews & time before and after members register to your site!
Daily analytics tracking for:
Entire forum
Visits
Bounces
Pageviews
Pages/Visit
Total Time on Site
Average Time on Site
Referrals
Forums
Replies
Threads
Visits
Bounces
Landings
Pageviews
Pages/Visit
Referrals
Pages (this_script)
Visits
Bounces
Landings
Pageviews
Pages/Visit
Referrals
Registrations
Registrations
Activated Accounts
Bounces
Pageviews before and after registering
Posts
Time on site before and in the process of registering
Average time on site before and in the process of registering
Admin Defined Threads
Visits
Bounces
Landings
Pageviews
Pages/Visit
Referrals
Posts
Posts/Day
Admin Defined Members
Visits and the areas they were made in.
Bounces and the areas they were made in.
Pageviews and the areas they were made in.
Posts and the forums they were made in.
Threads and the forums they were made in.
Pages/Visit
Total Time on site.
Average Time on site.
Analytics for Searches
Amount of Searches
Detailed graph shows timeline of analytics.
Choose the metric you wish to compare in the timeline.
Shows aggregated results of all metrics below graph.
Compare two different time periods and/or page/forum/search/thread.
Ajax-enabled browsers can compare and view analytics without page refresh.
Google Analytics-esque page design to improve user expierence.
Analytics Administration
Statistics Page shows analytic stats of today in real-time
Most Active Pages/Forums/Threads
Least Active Pages/Forums/Threads
Maintenance page to update the date of the first post in each forum and the total thread views for each forum.
Analytics Searching shows analytics stats of today in real-time for:
Forums
Threads
Pages
Searches
Sessions
Settings
Enable Modification
Enable Navbar Tab
Forum Integration
Default Overview - Number of days in the past to show for default in the analytics viewer.
Google Analytics template integration.
Enable hourly tracking instead of daily tracking. (Pro)
Threads to Track Over Time
Users to Track Over Time
Update Forum Total Views
Option to prune sessions older than x days.
Per Usergroup
Can view vBAnalytics Pro-only Features:
Front-end
In-depth Conversions (New Registrations) tracking.
Average Time on Site.
Analytics for Searches.
Analytics Administration
Option for hourly tracking.
Scripts to Exclude
Forums to Exclude

-------------------------------------------------------------------------------------------

This mod displays a copyright notification in the footer of pages generated by this mod which includes:
Link to DragonByte Technologies homepage
Link to Product Description page of this modification


-------------------------------------------------------------------------------------------

Notes:

Do not run any of the scheduled tasks manually. They are set up to run at the allotted times for a reason. If you run a scheduled task manually your analytics data will be extremely inaccurate.

[thecore762]

First!
Looking forward to test drive this new addon!

[MagicPID]

Just installed it, hoping it works out good :)

[M.Iftikhar]

please give screen shot.............thanks

[DragonByte Tech]

please give screen shot.............thanks
Knew I was missing something somewhere. :)

Uploaded some screenshots for you!

- Jon

[Sforums]

Receiving all sorst of errors on vb 4.1.0. pl2. Forum home page littered and defaced with error messages.

Database error in vBulletin 4.1.0:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_session_visits
(sessionhash, data)
VALUES
('', 'a:1:{s:7:\"scripts\";a:1:{i:0;s:4:\"misc\";}}')
ON DUPLICATE KEY UPDATE
sessionhash = 'abb08b6df58588db9985bfda74a77408',
data = 'a:1:{s:7:\"scripts\";a:1:{i:0;s:4:\"misc\";}}';

MySQL Error : Duplicate entry 'abb08b6df58588db9985bfda74a77408' for key 'PRIMARY'
Error Number : 1062

[Pandemikk]

Receiving all sorst of errors on vb 4.1.0. pl2. Forum home page littered and defaced with error messages.

Database error in vBulletin 4.1.0:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_session_visits
(sessionhash, data)
VALUES
('', 'a:1:{s:7:\"scripts\";a:1:{i:0;s:4:\"misc\";}}')
ON DUPLICATE KEY UPDATE
sessionhash = 'abb08b6df58588db9985bfda74a77408',
data = 'a:1:{s:7:\"scripts\";a:1:{i:0;s:4:\"misc\";}}';

MySQL Error : Duplicate entry 'abb08b6df58588db9985bfda74a77408' for key 'PRIMARY'
Error Number : 1062

Hmm. That's weird. For some reason there's no sessionhash. This may be an issue with that vB version. If you could forward me some FTP and Admin login I will be able to really get to the bottom of this.

For now disable the modification and I will look into vB 4.1.0 and see if there's any reason it's not working for that version.


p.s I am the developer of this modification- just using my personal account.

EDIT:

I am unable to reproduce this on 4.1.0 patch level 8. Due to how patches work, I can not test patch level 2.

Were you personally the receiver of this error? If so could you tell me what exactly you did to get this error?

[DragonByte Tech]

Hi,

I've uploaded a hotfix that may fix this issue. Even if you are not getting this issue you should apply this update as it will slightly increase the accuracy of the analytics.

Please redownload the package and upload:
dbtech/vbanalytics/hooks/global_complete.php
dbtech/vbanalytics/hooks/global_start.php
dbtech/vbanalytics/cron/sessions.phpNo product re-import will be necessary.

- Jon

[lapiervb]

Could you post a few more screen shots? This doesnt show much.

Maybe a demo on your site, I would like to see more before buying.

[Mariner1]

Get this message,running 4.1.11

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/global_complete.php on line 26

[bposner]

Another fine product, thanks!!

[BrightStar]

Thanks a lot. Great product. Just installed and will see how it works :)

Cheers

[DragonByte Tech]

Could you post a few more screen shots? This doesnt show much.

Maybe a demo on your site, I would like to see more before buying.

Our site does indeed have a demo of the product running :). To see it you need to sign-up to the site; same would have to be done in order to buy it as the version on here is free ;).

Get this message,running 4.1.11

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/global_complete.php on line 26

Odd. Can you tell me where / how you get this error? I've double checked the code and everything looks correct and I am also unable to reproduce this error.

- Jon

[Mariner1]

if i go to read a post it appears at the top of the site above to logo.Its also posted in the top 10 stats

[DragonByte Tech]

if i go to read a post it appears at the top of the site above to logo.Its also posted in the shoutbox

Hi,

Can you clarify what you mean by "read a post"? I've read many posts without seeing the error pop-up. Can you tell me which shoutbox you use (MGC Evo, DBTECH, etc).

To clarify, the error you are getting is nothing bad, but I would like to make sure you don't see it after the next update :).

EDIT:

I see you've clarified to Top 10 Stats. Can you tell me what version of that you're running?

- Jon

[Mariner1]

im using vsa advanced forum stats

If i click on Pics section for example i see Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/forumdisplay_start.php on line 9 above the logo.

If i then click on a thread in that section i see Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/showthread_start.php on line 13 above the logo

[Mariner1]

ok now im getting this on a white page

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/showthread_start.php on line 13

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:5605) in [path]/includes/functions.php on line 4109

[DragonByte Tech]

im using vsa advanced forum stats

If i click on Pics section for example i see Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/forumdisplay_start.php on line 9 above the logo.

If i then click on a thread in that section i see Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/dbtech/vbanalytics/hooks/showthread_start.php on line 13 above the logo

I've gone ahead and uploaded a hotfix for this issue :).

Please redownload the zip and reupload: dbtech/vbanalytics/hooks

And let me know if it fixes your errors. :)

- Jon

[Mariner1]

Database error in vBulletin 4.1.11:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_session_visits
(sessionhash, data)
VALUES
('41344f10909dd3345a6b5a324eb211bc', 'a:3:{s:7:\"scripts\";a:2:{i:0;s:10:\"showthread\";i:1;s:5:\"index\";}s:6:\"foru ms\";a:0:{}s:7:\"threads\";a:1:{i:0;i:23;}}')
ON DUPLICATE KEY UPDATE
sessionhash = '5c70e232c95f57adf266ac4d6b28e647',
data = 'a:3:{s:7:\"scripts\";a:2:{i:0;s:10:\"showthread\";i:1;s:5:\"index\";}s:6:\"foru ms\";a:0:{}s:7:\"threads\";a:1:{i:0;i:23;}}';

MySQL Error : Duplicate entry '5c70e232c95f57adf266ac4
MySQL Error : Duplicate entry '5c70e232c95f57adf266ac4d6b28e647' for key 1
Error Number : 1062
Request Date : Thursday, March 15th 2012 @ 12:37:07 PM
Error Date : Thursday, March 15th 2012 @ 12:37:07 PM

[Mariner1]

Thats the latest errors with the hotfix

[DragonByte Tech]

Thats the latest errors with the hotfix

I'm sorry, but I accidentally overwrote the previous hotfix that addressed this issue.

Please follow: https://vborg.vbsupport.ru/showpost.php?p=2309607&postcount=8

Redownload and reupload those files. That should fix your issue. :)

If you still get that database error let me know and I will try to further troubleshoot this mysterious session conflict.

- Jon

[Mariner1]

Theres nothing there to redownload,i just see this post

Hi,

I've uploaded a hotfix that may fix this issue. Even if you are not getting this issue you should apply this update as it will slightly increase the accuracy of the analytics.

Please redownload the package and upload:

dbtech/vbanalytics/hooks/global_complete.php
dbtech/vbanalytics/hooks/global_start.php
dbtech/vbanalytics/cron/sessions.php

No product re-import will be necessary.

- Jon

[DragonByte Tech]

Theres nothing there to redownload,i just see this post

Hi,

I've uploaded a hotfix that may fix this issue. Even if you are not getting this issue you should apply this update as it will slightly increase the accuracy of the analytics.

Please redownload the package and upload:

dbtech/vbanalytics/hooks/global_complete.php
dbtech/vbanalytics/hooks/global_start.php
dbtech/vbanalytics/cron/sessions.php

No product re-import will be necessary.

- Jon

The zip file of the product is what will be needed to download and upload. I've just gone and double-checked that all the files creating these conflicts have been fixed accordingly. So please redownload the zip file and reupload:

dbtech/vbanalytics/hooks/global_complete.php
dbtech/vbanalytics/hooks/global_start.php- Jon

[Mariner1]

got it,fixed the issue.Thanks for the help,appreciate it

[DragonByte Tech]

got it,fixed the issue.Thanks for the help,appreciate it

No problem :).

Just happy to have the product working on your board. Sorry for the overwriting causing you to have to do another download and upload, that was a mess up on my part :(.

- Jon

[bposner]

I do have one question, I'm not seeing any data. I ran the scheduled task but no data is showing up. I ran the maintenance things too.
I installed this on a brand new site that has no real users other than admin and a test user but both accounts are adding things and visiting pages, but no data shows up.

Thoughts?

[DragonByte Tech]

I do have one question, I'm not seeing any data. I ran the scheduled task but no data is showing up. I ran the maintenance things too.
I installed this on a brand new site that has no real users other than admin and a test user but both accounts are adding things and visiting pages, but no data shows up.

Thoughts?
Hi,

Please do not run the scheduled tasks manually as it will provide inaccurate results. I realized this during the beta stages of the mod development which is why the scheduled task responsible for tracking the data was modified to ensure it would only once per day. Since you have ran it already, further manual running of it will not generate any more entries until the next day.

The task is designed to run the first second of every day so that it collects the data from yesterday and stores it into the database. This explains why you do not see any data- as, I'm assuming, you are updating the form to show today's data which will not be shown until the task runs 12:00 AM tomorrow board time. The data you have gotten from manually running the task will be shown as yesterday (however, depending on timezone settings you may need to actually update the form a day before that to see the data for that day; this will be addressed in v1.1.0)

Since this is a test board, there is no actual harm in running the results manually, but they will be stored as yesterday's date as the task was not designed nor intended to track in increments less than daily. If you want to see real-time stats you may see them in your ACP. These stats are purged when the scheduled task runs successfully (once per day).

As a side but relevant note, the v1.1.0 update will have a pro option allowing for hourly tracking which will mean faster, more accurate across multiple timezones, results. :)

- Jon

[pete_brady]

installed, looked fine, applied hotfix above just in case, checked it a few hours later & got MySQL error on the analytics page. did a full reinstall & then got this error:

Database error in vBulletin 4.1.11:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_session_visits
(sessionhash, data)
VALUES
('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'a:3:{s:7:\"scripts\";a:2:{i:0;s:11:\"vbanalytics\";i:1;s:5:\"index\";}s:6:\"forums\";a:0:{}s:7:\"threads\";a:0:{}}')
ON DUPLICATE KEY UPDATE
sessionhash = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx',
data = 'a:3:{s:7:\"scripts\";a:2:{i:0;s:11:\"vbanalytics\";i:1;s:5:\"index\";}s:6:\"forums\";a:0:{}s:7:\"threads\";a:0:{}}';

MySQL Error : Duplicate entry 'xxxxxxxxxxxxxxxxxxxxxxxxxxx' for key 'PRIMARY'
Error Number : 1062
Request Date : Thursday, March 15th 2012 @ 06:08:34 PM
Error Date : Thursday, March 15th 2012 @ 06:08:35 PM

had to uninstall to fix

[DragonByte Tech]

installed, looked fine, applied hotfix above just in case, checked it a few hours later & got MySQL error on the analytics page. did a full reinstall & then got this error:

Database error in vBulletin 4.1.11:

Invalid SQL:

INSERT INTO dbtech_vbanalytics_session_visits
(sessionhash, data)
VALUES
('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'a:3:{s:7:\"scripts\";a:2:{i:0;s:11:\"vbanalytics\";i:1;s:5:\"index\";}s:6:\"forums\";a:0:{}s:7:\"threads\";a:0:{}}')
ON DUPLICATE KEY UPDATE
sessionhash = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx',
data = 'a:3:{s:7:\"scripts\";a:2:{i:0;s:11:\"vbanalytics\";i:1;s:5:\"index\";}s:6:\"forums\";a:0:{}s:7:\"threads\";a:0:{}}';

MySQL Error : Duplicate entry 'xxxxxxxxxxxxxxxxxxxxxxxxxxx' for key 'PRIMARY'
Error Number : 1062
Request Date : Thursday, March 15th 2012 @ 06:08:34 PM
Error Date : Thursday, March 15th 2012 @ 06:08:35 PMhad to uninstall to fix

This error continues to elude and frustrate me. Are you positive you redownloaded the package and reuploaded it?

It would really help if you could PM me FTP and ACP information so that I can troubleshoot this as I am simply unable to reproduce this error and the installation running on DBTech has never once encountered this error in the entire month+ it's been installed (and that site gets some serious traffic).

EDIT:

I have uploaded one final hotfix that will completely solve this issue. Please redownload and reupload the following files in the package:

dbtech/vbanalytics/hooks/global_complete.php
dbtech/vbanalytics/hooks/global_start.phpIf you still have this error I will need FTP and Admin login credentials as I have exhausted the list of reasons why this may be happening and am still unable to reproduce this either on my localhost or on sites it is installed to that I have access to.


I apologize to the users who have had this annoying error plague them and I thank them for having patience. It is tough to solve a bug you are unable to reproduce but I am confident I have finally fixed the SOB. :)


- Jon

[pete_brady]

i'll install the latest version & see how it goes...

[Sforums]

Hi,

I've uploaded a hotfix that may fix this issue. Even if you are not getting this issue you should apply this update as it will slightly increase the accuracy of the analytics.

Please redownload the package and upload:
dbtech/vbanalytics/hooks/global_complete.php
dbtech/vbanalytics/hooks/global_start.php
dbtech/vbanalytics/cron/sessions.phpNo product re-import will be necessary.

- Jon

Thanks, it works now.

[DragonByte Tech]

Hello,

1.0.4 of vBAnalytics has been released. It includes many of the hotfixes I've provided here since initial release.

vBAnalytics 1.0.4:

Fix: Certain third-party AJAX based add-ons would show a PHP warning.
Fix: Rare database error that would be caused sometimes due to sessionhash conflicts.
Fix: A few template typos in: dbtech_vbanalytics_results
Change: Reworked session tracking into a manner that follows a session even if they log-out then log-in, etc.To apply the update, you'll need to download the zip file, unpackage it then upload and overwrite the files. In addition, you'll need to reimport the product XML files as I've corrected some template typos.

[Qwest]

Does this cover one of the most important metrics? That being registration funnel.

Like, how they arrived, what keyword they used or where they were linked from initially so we know what traffic sources/keywords are sending us users that register?

[CharlieDelta]

Will you be adding the option to remove the "HiVelocity Hosting" from the copyright footer as with all other DBT mods? ;)

[RRCamellini]

someone already installed version 1.0.4 in vb 4.1.11 without errors?

[DragonByte Tech]

Does this cover one of the most important metrics? That being registration funnel.

Like, how they arrived, what keyword they used or where they were linked from initially so we know what traffic sources/keywords are sending us users that register?

Registrations and referrers will be covered in 1.1.0 which will be ready soon. :)

It will show the exact referrer of every user. :)

Will you be adding the option to remove the "HiVelocity Hosting" from the copyright footer as with all other DBT mods? ;)

Wow. Sorry about that :o. We use a shell to quickly create the outlines of new mods and, for some reason, the setting for that wasn't included. I will make sure the shell gets fixed and that the option is added in 1.1.0. In the meantime, if you want to manually remove the copyright we won't hold it against you- or you could forward me your ACP information and I can do it for you if you are unsure how.

someone already installed version 1.0.4 in vb 4.1.11 without errors?

I have received no error reports on here or back at our support forums regarding v1.0.4.

[DragonByte Tech]

Update:

v1.1.0 Beta has been released at our forums. Following a successful beta period a lite version will be released which includes an update to this thread. Full details of what's new in v1.1.0 can be found at our forums and will be posted here following the lite release.

Included in this release are registration and user tracking, Google Analytics template integration, and, as promised, the Hivelocity branding removal option. ;)

- Jon

[Mukashi]

Just had a member of staff on my forums notice that the analytics page remains visible regardless of what the settings are in the admin CP for their usergroup (including for unregistered users). Anyone else having this issue?

[Andyrew]

This has stopped working on my forums, seems to be around the 24th, not sure if that's when I updated vb or not but the graph has just flat lined ever since.

https://vborg.vbsupport.ru/

EDIT: Now I see why it's showing this, because it thinks I had 88811 visits on the 24th. :confused: Actual visits was 4,282

[ptceuro]

thanks so much!!

[Pandemikk]

Just had a member of staff on my forums notice that the analytics page remains visible regardless of what the settings are in the admin CP for their usergroup (including for unregistered users). Anyone else having this issue?
:o

Seems that all the permission does is hide the navbar link it doesn't actually prevent you from seeing the page. I've gone ahead and patched the download link. Just replace vbanalytics.php with this.

This has stopped working on my forums, seems to be around the 24th, not sure if that's when I updated vb or not but the graph has just flat lined ever since.

http://dl.dropbox.com/u/58940544/screen_2012-03-31%2017.10.59.jpg

EDIT: Now I see why it's showing this, because it thinks I had 88811 visits on the 24th. :confused: Actual visits was 4,282

That's very odd. What version are you using?

[DragonByte Tech]

This has stopped working on my forums, seems to be around the 24th, not sure if that's when I updated vb or not but the graph has just flat lined ever since.

[image retracted]

EDIT: Now I see why it's showing this, because it thinks I had 88811 visits on the 24th. :confused: Actual visits was 4,282

Forgive me, it shows me you're using 1.0.4.Could you provide me with FTP access to troubleshoot this issue? This is the very first time I've come across anything like this happening (on any version).

- Jon

[Andyrew]

Forgive me, it shows me you're using 1.0.4.Could you provide me with FTP access to troubleshoot this issue? This is the very first time I've come across anything like this happening (on any version).

- Jon

Hi Jon

I have now installed the pro version since you posted this message. I will let it run a while to gather data and see how things go.

[Pandemikk]

Any updates Andyrew?

[CharlieDelta]

Any updates Andyrew?

Huh?

[troyuncucom]

works 3.8.x?

[Pandemikk]

works 3.8.x?
No. A 3.8.x version may or may not be released shortly. Depends on unknown factors. However, a 3.8 version is planned.

[ckelley]

Installed and working as promised so far. No apparent errors and I like how it puts the analytics right on the forum for aadministrators so we don't have to go into the admincp to see what is going on with the site. Nice Job! thanks!

[Mr_Running]

Much need :) vBAnalytics

[Altari]

Hi,

When i'm on you live demo at : http://www.dragonbyte-tech.com/vbanalytics.php?do=main&action=threads

Page start by 2 errors :
Warning: Invalid argument supplied for foreach() in [path]/dbtech/vbanalytics/includes/class_core.php on line 610

Warning: Invalid argument supplied for foreach() in [path]/dbtech/vbanalytics/includes/class_core.php on line 610

[Pandemikk]

Hi,

When i'm on you live demo at : http://www.dragonbyte-tech.com/vbanalytics.php?do=main&action=threads

Page start by 2 errors :
Warning: Invalid argument supplied for foreach() in [path]/dbtech/vbanalytics/includes/class_core.php on line 610

Warning: Invalid argument supplied for foreach() in [path]/dbtech/vbanalytics/includes/class_core.php on line 610
How embarrassing. :o

We'll be sure to get that fixed before releasing it here.

[DragonByte Tech]

We are proud to announce vBAnalytic 1.1.3 [LITE] has been released! This is the first version of the 1.1.x series to be released for lite!

A full list of features can be found on the product's first page. New major features with this release include:

Conversions (new registrations) tracking! Find out how many new registration take place on your site, as well as in-depth information such as pageviews and time spent before and after registering!
Hourly tracking! Faster results and timezone support!
Metric chooser allows you to choose which metric to compare against over the course of a timeline!
Referrals, find out how many times your site has been referred to (across a timeline of course!) and from where!
Thread and user tracking! Perhaps you want to find out how active your moderators are? No problem! Simply input their userid into the tracking users option and find out for yourself!To download this product, simply unzip the zip file found in the first post and upload the content of the "upload" folder to your forum root directory. Then, import the product found in the "XML" folder into your product manager. If you have a previous version of vBAnalytics installed be sure to check "allow overwrite".

[egyptsons]

Thanks
I will try it
:)

[Dasia]

Hi!

With this new release, when I try to view the members, if the User field is not filled the query to the database fails. How can I prevent the sending of data if this field is empty?
Invalid SQL:

SELECT *
FROM dbtech_vbanalytics_tracking_users
WHERE
(dateline BETWEEN 1334354401 AND 1334440799) AND userid =

ORDER BY dateline ASC;
Thanks! :)


PS: the field "Thread" does the same...

[DragonByte Tech]

Could have sworn I updated the package with the fix for that.

Please redownload and reupload dbtech/vbanalytics/actions/main.php

Please let me know if that fixes it for you. :)

- Jon

[Neal-UK]

Parse error: syntax error, unexpected ';' in /****************/dbtech/vbanalytics/actions/main.php on line 302

[DragonByte Tech]

*kicks self*

Please redownload and reupload dbtech/vbanalytics/actions/main.php

- Jon

[Alan_SP]

Thread and user tracking! Perhaps you want to find out how active your moderators are? No problem! Simply input their userid into the tracking users option and find out for yourself!

This feature is very useful. :up:

Thanks for implementing it.

[Dasia]

Thanks!! It works fine now!

[diyautoftw]

Hey, I installed it and there seems to be a few errors. With the graphs, the lines and points don't display. If I mouse over where the point is it appears but otherwise they are blank graphs.
Also with the user tracking, if I want to track multiple users do I use a comma or semicolon between the userIDs in the adminCP settings? i set it to track myself and someone else a few days ago and it hasn't tracked any visits yet. Thanks.

[DragonByte Tech]

Hey, I installed it and there seems to be a few errors. With the graphs, the lines and points don't display. If I mouse over where the point is it appears but otherwise they are blank graphs.
Also with the user tracking, if I want to track multiple users do I use a comma or semicolon between the userIDs in the adminCP settings? i set it to track myself and someone else a few days ago and it hasn't tracked any visits yet. Thanks.

Use a comma, like the setting says. I've had no other reports about missing date in whole or part.

However, a user using the [LITE] version of this mod reported that the install file did not install a necessary change in this version. This may be what's happening to you. I can either fix this for you or provide you with the query to do so yourself.

- Jon

[autoescala]

I installed on 4.1.10 and works fine, I'm not seeing any data , all values are 00000, what happens ??

[Pandemikk]

I installed on 4.1.10 and works fine, I'm not seeing any data , all values are 00000, what happens ??
Data takes 24 hours to populate. Unfortunately, we can not retroactively fetch data. Please wait 24 hours. If you still do not have results I will need FPT and ACP login because nobody else is reporting this mistake.

Jon

[autoescala]

I upgraded to 4.20 and now I can't locate the menu in the navbar..... any idea ?

[Pandemikk]

I upgraded to 4.20 and now I can't locate the menu in the navbar..... any idea ?
4.2.0 introduced changes to the navbar. As of now, this mod's navbar integration is incompatible with 4.2.0. We are upgrading all our products to be compatible with 4.2.0.

Jon

[logismod]

I have customized navbars, so I don't have a navbar link to vbAnalytics. What url should I use to access the analytics directly? Thanks!

Edit: found it. www.domain.com/forum/vbanalytics.php

[DragonByte Tech]

vBAnalytics v1.1.4
Feature: vBulletin 4.2.0 Navigation Manager compatibility
Fix: Potential XSS vulnerability

Fillip

[DragonByte Tech]

vBAnalytics v1.2.0 Gold
Feature: Added an option to turn off the Google Graph
Feature: The "Threads To Include" setting now supports a blank input to track all threads
Feature: The "Users To Include" setting now supports a blank input to track all users
Feature: The "Auto-Prune" setting has been updated to reflect it also prunes tracking data, to help with long-term performance
Feature: In-Depth Analysis: Forums now displays a list of all data tracked sorted by the chosen metric
Feature: In-Depth Analysis: Pages now displays a list of all data tracked sorted by the chosen metric
Feature: In-Depth Analysis: Searches now displays a list of all data tracked sorted by the chosen metric
Feature: In-Depth Analysis: Threads now displays a list of all data tracked sorted by the chosen metric
Feature: In-Depth Analysis: Members now displays a list of all data tracked sorted by the chosen metric
Feature: Improved logging details for Control Panel actions
Change: Changed the Branding display method to inject itself into the copyright footer (underneath vBulletin copyright) instead of the page footer.
Change: Changed the Branding Free Key to a more secure key.
Change: Greatly improved the performance of the
Change: The "Results Breakdown" block should now be easier to read
Change: Renamed "Referrals" on certain pages to more accurately reflect what this metric represents
Change: The "Results Breakdown" now has number formatting for the values
Change: Updated the available metrics for each type to more accurately reflect available data
Fix: Multiple issues with the "Analytics Tracker" cron job that prevented it from saving statistics have been resolved
Fix: Removed some metrics from some pages that were displayed yet did not have tracking data
Fix: The "Threads" page will now correctly display a "Total" statistic
Fix: In certain scenarios, the "Options" form would not submit via AJAX but instead reload the page
Fix: In certain scenarios, the default values would not be correctly filled out for all metrics
Fix: A fresh install would see invalid displays until the first time the cron job was ran
Fix: Removed the extraneous line break under the left side menu

Fillip

[xziomx]

Database error in vBulletin 4.2.0:

Invalid SQL:

REPLACE INTO dbtech_vbanalytics_session_visits
(sessionhash, data)
VALUES
('3bca012099ea22e52cb869ec0ae2fa36', 'a:3:{s:7:\"scripts\";a:1:{i:0;s:5:\"index\";}s:6:\"forums\";a:0:{}s:7:\"threads \";a:0:{}}');

MySQL Error : Incorrect key file for table './xxxxxxxxxx/dbtech_vbanalytics_session_visits.MYI'; try to repair it
Error Number : 126
Request Date : Monday, May 27th 2013 @ 01:25:04 AM
Error Date : Monday, May 27th 2013 @ 01:25:04 AM

Can any one help?

[DragonByte Tech]

Go into phpMyAdmin and find the table then click Repair, this is a system error on your server.

Fillip

[DragonByte Tech]

Update

Hotfix: PHP 5.4 Compatibility fixes


This does not guarantee the mod is error free on PHP 5.4, but it will take care of the reported errors. Thank you all for your reports :)



Fillip

[karnevil]

Hi, I've done something terribly wrong I think installing this - my forum has gone poof.

www.legalbeagles.info/forums

Help ! please :)


Forum is on VB 4.2

I uploaded all the upload file to the right places on the server, then imported the xml file all looked fine until it completed then just a blank white screen on every page of the site.

[karnevil]

All fixed. My fault, I'd uploaded the files manually and misspelt the hooks folder as hook :( Thank you, all looks to be working okay will test everything and then feedback.

[DragonByte Tech]

No problem, hopefully everything works for you :)


Fillip

[mort2412]

hi Im getting the following errors:

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/users.php on line 48

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/threads.php on line 45

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/forums.php on line 74

And does this mod only calculate registration and other data from the day it was installed to the forum?

[ozzy47]

Did you just change PHP versions, or upgrade to vB4.2.2?

[mort2412]

No change to php, and installed onto vB4.2.2

[ozzy47]

Did you have this installed prior to the upgrade? If so, download the product again, and upload the files to your server, and import the XML.

[mort2412]

No this was a first time install onto 4.2.2, downloaded the mod about an hour ago

[ozzy47]

I would disable it until you hear from the developer then. :(

[mort2412]

Already done thanks for your input ozzy

[ozzy47]

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

[DragonByte Tech]

hi Im getting the following errors:

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/users.php on line 48

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/threads.php on line 45

Warning: Non-static method VBANALYTICS_RESULTS::fetch_vbanalytics_array() should not be called statically in ..../dbtech/vbanalytics/actions/pages/forums.php on line 74

And does this mod only calculate registration and other data from the day it was installed to the forum?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

[spd2612]

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.php?s=&securitytoken=1410376076-13e6d1ba6a9df4b41eb67bf6b537ac48b9a1ba3e&do=main&action=scripts&first%5Bmonth%5D%5B%5D=9&first%5Bday%5D%5B%5D=3&first%5Byear%5D%5B%5D=2014&first%5Bmonth%5D%5B%5D=9&first%5Bday%5D%5B%5D=10&first%5Byear%5D%5B%5D=2014&compared%5Bmonth%5D%5B%5D=9&compared%5Bday%5D%5B%5D=3&compared%5Byear%5D%5B%5D=2014&compared%5Bmonth%5D%5B%5D=9&compared%5Bday%5D%5B%5D=10&compared%5Byear%5D%5B%5D=2014&metric=pages%2Fvisit&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

[spd2612]

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 :

[ForceHSS]

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.php?s=&securitytoken=1410376076-13e6d1ba6a9df4b41eb67bf6b537ac48b9a1ba3e&do=main&action=scripts&first%5Bmonth%5D%5B%5D=9&first%5Bday%5D%5B%5D=3&first%5Byear%5D%5B%5D=2014&first%5Bmonth%5D%5B%5D=9&first%5Bday%5D%5B%5D=10&first%5Byear%5D%5B%5D=2014&compared%5Bmonth%5D%5B%5D=9&compared%5Bday%5D%5B%5D=3&compared%5Byear%5D%5B%5D=2014&compared%5Bmonth%5D%5B%5D=9&compared%5Bday%5D%5B%5D=10&compared%5Byear%5D%5B%5D=2014&metric=pages%2Fvisit&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
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

[DragonByte Tech]

vBAnalytics v1.2.0 Patch Level 1

Bug Fixes:

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



Fillip

[m7sen]

can you support this mod for vb 3.8.8 please

[Pandemikk]

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

[DragonByte Tech]

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

[expatindo]

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?

[DragonByte Tech]

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

[pratul11]

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/plugin.php?do=productimport
Referrer : http://www.occultforums.net/admincp/plugin.php?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Please help me..