[DragonByte Tech]

Originally Posted by 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:

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