vb.org Archive - Statistics Modifications - [DBTech] vBAnalytics v1 (vB4)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Statistics Modifications - [DBTech] vBAnalytics v1 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=280052)

Quote:

Originally Posted by Mariner1 (Post 2309744)

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....07&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

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

Quote:

Originally Posted by Mariner1 (Post 2309749)

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

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

Quote:

Originally Posted by Mariner1 (Post 2309757)

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

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?

Quote:

Originally Posted by bposner (Post 2309765)

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

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:

PHP Code:


		
			
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

Quote:

Originally Posted by pete_brady (Post 2309800)

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:

PHP Code:


		
			
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

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.php

If 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

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02154 seconds Memory Usage 1,775KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: