User tracking mod

[mc12345678]

The keyword there is they should be but I don't see uninstall instruction. Inside the Readme I have HOW_TO_UPDATE-V1.5.0.txt and New_Install_Readme.txt and inside the sql folder I have new_install_user_tracking.sql and UPDATE_user_tracking.sql Now sure if my 1.4.2 package download is missing something but there's no uninstall instruction for the database or page registration stuff. I honestly cannot tell you what exactly is wrong but we have so many customization on our site and this is the only mod that's not playing well with the database (in the sense that it keeps triggering an error related to an insert and line 120 of query factory). Instead of chasing it around, I decided to remove it from our site for now. When there's another release I will try it again but it's not critical enough to our business to be messing with it. Our livehelp mod have a built functionality that collects the same data so I am not missing anything. Thanks!

First, thank you for the detailed feedback, whether it be me or another Zenner, hopefully the trouble data that is causing the error can be evaluated and an appropriate action taken rather than forwarding on the information in it's entirety to force an additional error log.

As for uninstall, I seem to recall that it is addressed in the individual install documents. I also thought there was an uninstall.sql file provided with the package and that the instructions addressed how to apply that file to the cart.

I'll take a look to see if I'm wrong, and if so provide instructions. I was the last to modify the package, but there was not a separate uninstall instruction file when I made the changes I did.

Glad to hear that the problem(s) will still be captured/addressed by something else, allowing them to be resolved. Whatever the solution specifically for this mod, I think that solution should not use up a significant amount of space either on the server or the database to "flag" the issue. Probably will be as simple as adding a flag to a portion of the collected data and stripping out the offending information from the data before sending it down the path for ZC to process.

[BlessIsaacola]

Thank you so much for taking the time to thorough engage with me on this. I really appreciate it! I downloaded the 1.4.2 again and there's no uninstall instruction. This is simply so you know. I can drop the table from the database manually (but others may not be comfortable with that). The page registration stuff is still new to me which is why I went looking for the uninstall instruction. Have a great weekend!

[mc12345678]

Thank you so much for taking the time to thorough engage with me on this. I really appreciate it! I downloaded the 1.4.2 again and there's no uninstall instruction. This is simply so you know. I can drop the table from the database manually (but others may not be comfortable with that). The page registration stuff is still new to me which is why I went looking for the uninstall instruction. Have a great weekend!

I did the same, and from reviewing the install sql (Fresh install) developed the following SQL statements to remove information related to this mod from the mySQL database:

DELETE FROM admin_pages WHERE page_key = 'UserTracking';
DELETE FROM admin_pages WHERE page_key = 'UserTrackingConfig';
DROP TABLE IF EXISTS user_tracking;
DELETE FROM configuration WHERE configuration_group_id = '999';
DELETE FROM configuration_group WHERE `configuration_group_id` = 999 AND `configuration_group_title` = 'User Tracking Config' AND `configuration_group_description` = 'User Tracking' AND `sort_order` = 31 AND `visible` = 1;

I haven't tested the code and am only worried about the 2nd to last line, though it is the same line included in the install package. Concern is if the value 999 is unique enough (ie. not used by other packages) that other information in the configuration table with the configuration_group_id of 999 won't exist to be affected.

But, I think that if you paste the above into your admin panel where you have the ability to perform SQL functions, then it will undo database actions previously performed. It is expected that by running this that you will lose all of the tracked data that might exist. Please report the success and I will incorporate into the my next changes (I have mods on another plugin that I have currently placed priority to implement before returning to this one). But it looks like those will work for an uninstall.

[mc12345678]

I forgot to mention, please backup your database before running that code. (Will not affect the files showing your site, but will affect the data that is shown.) Don't want something else to be affected, and if it is, want to be able to restore it.

[BlessIsaacola]

I forgot to mention, please backup your database before running that code. (Will not affect the files showing your site, but will affect the data that is shown.) Don't want something else to be affected, and if it is, want to be able to restore it.

I already took care of it manually via phpmyadmin. Sorry I wasn't able to test your code for you. Thanks!

[mc12345678]

I already took care of it manually via phpmyadmin. Sorry I wasn't able to test your code for you. Thanks!

You're welcome. Technically you would be in the ideal situation now to test that code, by at least running the Sql to install, and then the above SQL to remove.

That said, a small description of what the above does is this,
The first line removes the admin menu option to see the list of tracked users.
The second line removes the admin menu option to see the admin settings for user tracking.
The third line removes the user tracking table from the database if it is present.
The fourth line removes all occurrences of the configuration_group_id that equal 999 from the configuration table and
the last line removes what is expected to be only the one entry from the configuration_group table that meets all of the criteria that were set in the install.

[corseter]

Hi, I have installed the latest version on 1.3.8 and have everyting installed where it should be but I do not see user tracking under tools in the admin. Can't figure out why? Anybody got any ideas?
Thanks.
A.

[mc12345678]

Hi, I have installed the latest version on 1.3.8 and have everyting installed where it should be but I do not see user tracking under tools in the admin. Can't figure out why? Anybody got any ideas?
Thanks.
A.

Forgive me for going back to the basics, but you also "ran" the install SQL?

[gilby]

Does this version show correctly what is currently in a customers cart if they have a current session?
Sort of like is shown in who's online.

I had used this some years ago,
It seemed there was a bug in earlier versions that would show the same items for multiple current sessions.

[mc12345678]

Does this version show correctly what is currently in a customers cart if they have a current session?
Sort of like is shown in who's online.

I had used this some years ago,
It seemed there was a bug in earlier versions that would show the same items for multiple current sessions.

I think that issue is currently still present. I hadn't yet made any changes to that part, and I think I have seen the effects of what you describe. I plan on making more changes, I'll definitely consider that as one of the factors to try to correct.