User tracking mod

mc12345678:

Will be issuing version 1.5.8 to ZC in the next couple of days, at least. This version can be found on github at the version 1.5.8 branch:

This modification nearly updates/modifies all files while removing some of them as well.

Fantastic!

I updated to v1.5.8 and can confirm I no longer receive any debug errors anywhere. I clicked all around show/hide and did thorough other testing and it works 100% flawless.
Thanks again!

Nitroedge:

Fantastic!

I updated to v1.5.8 and can confirm I no longer receive any debug errors anywhere. I clicked all around show/hide and did thorough other testing and it works 100% flawless.
Thanks again!

Thanks for that feedback. Makes it more compelling to go ahead and submit for review and publishing. As a side note, because you have installed the version 1.5.8 published to github, that you will not receive notification from within your ZC admin of when 1.5.8 has been published to ZC. You can "follow" action on github to get notification of changes that occur there, but I don't expect to do anything more with 1.5.8 between now and publishing to ZC. You will/should get notification of updates that are published to ZC beyond that version based on the version checking settings...

Hi,

I've been using UT since ZC v1.3x without any issues. Last month I installed it on same server for a customer that didn't have it previously and I didn't have issues (it was a ZC upgrade from 1.5.4 to 1.5.5). Now I'm installing it on an upgrade but UT was existant on previous ZC. The issue I'm having is that everything installs fine but the "User Tracking Config" stays on the "Tools" menu and it's going to a 404 page. When I insert the correct link on browser to go to the correct config page I get an incomplete module configuration (see image).

I have uninstalled the db (following your troubleshooting on readme) but doesn't fix the issue.

Your troubleshooting "7.4" mentions an alternative installation by patch but I don't see any sql file on the file set. Would you please help me?

ideasgirl:

Hi,

I've been using UT since ZC v1.3x without any issues. Last month I installed it on same server for a customer that didn't have it previously and I didn't have issues (it was a ZC upgrade from 1.5.4 to 1.5.5). Now I'm installing it on an upgrade but UT was existant on previous ZC. The issue I'm having is that everything installs fine but the "User Tracking Config" stays on the "Tools" menu and it's going to a 404 page. When I insert the correct link on browser to go to the correct config page I get an incomplete module configuration (see image).

I have uninstalled the db (following your troubleshooting on readme) but doesn't fix the issue.

Your troubleshooting "7.4" mentions an alternative installation by patch but I don't see any sql file on the file set. Would you please help me?

Sorry that there remain upgrade issues with the installer. Part of its design was consideration that the software had been updated previously at least up to when I had originally stepped in and had modified the use of the configuration on the tools menu portion. I see now that definitely can not make that assumption.

Further I didn't catch removal/modification of step 7.4.

I have recently also been shown a similar setup result via PM.

My recommended solution was to use the admin/includes/installers/user_tracking/uninstall.sql file omitting the first "line" associated with drop table if exists... and perform that query as many times as necessary in a row: recommend running at least 2 times back-to-back, until the configuration menu appears in the configuration dropdown.

In working with the site, were you able to identify what version was previously installed? This would help to revise the first of the upgrade scripts to prevent reoccurrence of this issue.

For those wondering why the move of the configuration settings away from the tools menu, even though it was previously explained in this forum, basically the old script that handled the UT configuration was nearly identical to the script needed/used for the options in the configuration menu. So much so that as ZC progressed and improved on that script, similar changes were/would be necessary to the script in UT. Forgive me, but that seems like unnecessary additional work and as was discovered with the original script, lead to a potential security issue that would otherwise be corrected by the security conscience developers of ZC. Again, why reinvent the wheel and not just use what already works?

My recommended solution was to use the admin/includes/installers/user_tracking/uninstall.sql file omitting the first "line" associated with drop table if exists... and perform that query as many times as necessary in a row: recommend running at least 2 times back-to-back, until the configuration menu appears in the configuration dropdown.
That made the trick! :clap: AWESOME!

In working with the site, were you able to identify what version was previously installed? This would help to revise the first of the upgrade scripts to prevent reoccurrence of this issue.
Here's the info:

Last Modified: 05/27/2015
Should be: User Tracking  -  Version: 1.5.2

For those wondering why the move of the configuration settings away from the tools menu, even though it was previously explained in this forum, basically the old script that handled the UT configuration was nearly identical to the script needed/used for the options in the configuration menu. So much so that as ZC progressed and improved on that script, similar changes were/would be necessary to the script in UT. Forgive me, but that seems like unnecessary additional work and as was discovered with the original script, lead to a potential security issue that would otherwise be corrected by the security conscience developers of ZC. Again, why reinvent the wheel and not just use what already works?
Yes, I saw that post before when installing last month on that customer's store. It actually makes more sense to have it on the Config menu.

Thanks for the help. :bow:

ideasgirl:

That made the trick! :clap: AWESOME!

No, but I can get that info for you because is the one I have on the current site.

Yes, I saw that post before when installing last month on that customer's store. It actually makes more sense to have it on the Config menu.

Thanks for the help. :bow:

Thank you for the report back. Look forward to finding out the existing/previously existing version so that 1) can update the troubleshooting instructions and 2) update the upgrade script to better handle the issues of previous installs. Ultimately that was the thing I was trying to address through use of an "automated" script because there were always so many things that could go wrong and cause install/upgrade issues, but it was always because of some "simple" things.

The uninstall script used to work better also because it would remove all instances, but in review of that script it also had the potential of affecting older systems that had data stored in the configuration group of 0 (ZC used to have three such configuration options and then there was also at least one popular plugin that did as well). Anyways, thank you again for posting both the issue (basically how to reproduce it) and that the proposed solution worked. :)

It's always a pleasure to help back!

So you know... I posted the version info (in case you missed it).

Hi, I have problem with sitemap xml and this plugin, some conflict or other...
I did fresh install zc 1.5.5e then sitemap (it was ok), then this plugin and sitemap xml became bad.

I would try to uninstall this plugin, how can I do? Is there a uninstall sql? In files I didn't find it.
Thank you

giuly:

Hi, I have problem with sitemap xml and this plugin, some conflict or other...
I did fresh install zc 1.5.5e then sitemap (it was ok), then this plugin and sitemap xml became bad.

I would try to uninstall this plugin, how can I do? Is there a uninstall sql? In files I didn't find it.
Thank you
This plugin should have zero interface with Sitemap XML. In fact, with the way ZC 1.5.5 is designed, the only file that needs modification to work with this plugin using its full capacity is the admin's footer page. Otherwise no files are modified in the store.

As to an uninstall sql, the uninstall would be located in: YOUR_SECRET_ADMIN/includes/installers/user_tracking. Removal of related files should be performed prior to executing the uninstall script otherwise it will be again installed on the next admin area navigation.

thanks, I uninstalled plugin, I didn't see that was in that directory.
Can I ask a thing please? But the directory youradmin>installer>user tracking and all the files has to be uploaded or not?
Because I uploaded it

giuly:

thanks, I uninstalled plugin, I didn't see that was in that directory.
Can I ask a thing please? But the directory youradmin>installer>user tracking and all the files has to be uploaded or not?
Because I uploaded it

Of course need to upload it

The package is designed to provide installation "through the ages" and at various version conditions.

Meaning, as the instructions state, to upload all of the files. The files are arranged in a structure to support uploading for example all of the files that are in the YOUR_ADMIN directory into the folder that represents your_admin. Therefore, as part of the installation operation, every file that is version based within the admin/includes/installers/user_tracking directory will be executed in order. Each file contains either code to be executed or a description of what was changed for that version. Each file serves at least one function: to identify the version of the plugin. Omission of a file could prevent modifications to the system needed to operate the plugin.

The one exception is the uninstall.sql. This is placed and recommended to be present to support some future uninstall that may be desired rather than trying to locate the file in some future point.

thanks for your patience, I tried to install again, but same issue, and I installed other plugins without problems.
At this time I think it is a hosting problem in some way, because on another site both plugins work.

Thank again

giuly:

thanks for your patience, I tried to install again, but same issue, and I installed other plugins without problems.
At this time I think it is a hosting problem in some way, because on another site both plugins work.

Thank again
Perhaps with more detail beyond "doesn't work" the reason for the issue could be identified and if in fact there is something with UT it could be corrected/adjusted for others as well as that site.

Everything is working great on my end, I do every now and then get this error showing up in my Debug log:

[30-Nov-2017 14:15:36 America/Detroit] PHP Notice: CURL error checking plugin versions: 7:Failed to connect to plugins.zen-cart.com port 443: Connection refused

Trying file_get_contents() instead. in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 136
[30-Nov-2017 14:15:36 America/Detroit] PHP Warning: file_get_contents(https://plugins.zen-cart.com/versioncheck/159%29: failed to open stream: Connection refused in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 138
[30-Nov-2017 14:15:36 America/Detroit] PHP Notice: file_get_contents() error checking plugin versions.
Trying http instead. in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 140
[30-Nov-2017 14:15:36 America/Detroit] PHP Warning: file_get_contents(http://plugins.zen-cart.com/versioncheck/159%29: failed to open stream: Connection refused in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 141
[30-Nov-2017 14:15:36 America/Detroit] PHP Notice: file_get_contents() error checking plugin versions.
Aborting. in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 144

Just wanted to let you know and I'm running v1.5.8.

Thanks!

Brandon

Nitroedge:

Everything is working great on my end, I do every now and then get this error showing up in my Debug log:

[30-Nov-2017 14:15:36 America/Detroit] PHP Notice: CURL error checking plugin versions: 7:Failed to connect to plugins.zen-cart.com port 443: Connection refused

Trying file_get_contents() instead. in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 136
[30-Nov-2017 14:15:36 America/Detroit] PHP Warning: file_get_contents([url]https://plugins.zen-cart.com/versioncheck/159):[/url] failed to open stream: Connection refused in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 138
[30-Nov-2017 14:15:36 America/Detroit] PHP Notice: file_get_contents() error checking plugin versions.
Trying http instead. in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 140
[30-Nov-2017 14:15:36 America/Detroit] PHP Warning: file_get_contents([url]http://plugins.zen-cart.com/versioncheck/159):[/url] failed to open stream: Connection refused in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 141
[30-Nov-2017 14:15:36 America/Detroit] PHP Notice: file_get_contents() error checking plugin versions.
Aborting. in /home/webserver/public_html/myadmin/includes/init_includes/init_user_tracking.php on line 144

> 
> Just wanted to let you know and I'm running v1.5.8.
> 
> Thanks!
> 
> Brandon
This is a result of the version of version checking that was applied at the time of issue, permissions/setup of the server, and whatever else may have prevented the applicable operation(s). This has been a relatively known issue for some. Newer versions of the version checking (independent of the plugin and incorporated into ZC) use some various methods to perform the check(s). It is possible to pull in the newer version(s) to older ZC installs and therefore bypass the check software currently included. I'd have to look around a little bit to find the file(s) that should be incorporated, but it can also be disabled by changing information in the top of that file. There are some instructions included. What it means is that no notification will be made in using the program of a newer version. But there should be a notification from here about it...

Lastly, thank you for identifying the issue. :)

I've just installed 1.5.8 ( upgarded from 1.4.1 ) and it seems working.

The problem is log directory where I can see many errors as:

error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed,[errno] => 60))
#1 trigger_error(CURL error checking plugin versions: 60:SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed

Do you know what problem is ?

PS. I don't use SSL , my ZC version is 1.5.5

[04-Feb-2018 21:40:40] Request URI: /myshop/mydmin/user_tracking.php?gID=1018, IP address:xxxxxxx
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
Trying file_get_contents() instead., /myshop path//includes/functions/plugin_support.php, 68, Array ([plugin_file_id] => 159,[version_string_to_compare] => 1.5.8,[new_version_available] => ,[lookup_index] => 0,[url1] => https://plugins.zen-cart.com/versioncheck/159,[url2] => https://www.zen-cart.com/versioncheck/159,[ch] => Resource id #175,[response] => ,[error] => SSL certificate problem, verify that the CA cert is OK. Details:

I have disabled ( update check ) for from User Tracking Config , but still have the errors on log directory.

I believe the errors are reported only when I navigate in Admin pages.

Looks like the certificate associated with your server to be able to communicate with other servers has a problem. (this is different than the SSL certificate one would get to allow customers to connect via https:) yes it will be related to admin navigation as the version check software tends to only be built into admin related operations.

You could try to remove the admin/includes/auto_loaders/config.user_tracking_install.php file. This will prevent user tracking from checking for updates.

Thank you but I only have this file: config.user_tracking.php

deleting I have the same errors.

Trying http instead., /var/www/html/mywebsite/includes/functions/plugin_support.php, 72, Array ([plugin_file_id] => 159,[version_string_to_compare] => 1.5.8,[new_version_available] => ,[lookup_index] => 0,[url1] => https://plugins.zen-cart.com/versioncheck/159,[url2] => https://www.zen-cart.com/versioncheck/159,[ch] => Resource id #175,[response] => ,[error] => SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed,[errno] => 60,[ctx] => Resource id #176,[http_response_header] => Array ([0] => HTTP/1.0 400 Bad Request,[1] => Date: Wed, 07 Feb 2018 10:35:24 GMT,[2] => Server: Apache/2.4.18 (Ubuntu),[3] => Cache-Control: private, must-revalidate,[4] => pragma: no-cache,[5] => expires: -1,[6] => X-RateLimit-Limit: 60,[7] => X-RateLimit-Remaining: 57,[8] => Content-Length: 60,[9] => Connection: close,[10] => Content-Type: application/json)))
#1 trigger_error(file_get_contents() error checking plugin versions.
Trying http instead.) called at [/var/www/html/mywebsite/includes/functions/plugin_support.php:72]
#2 plugin_version_check_for_updates(159, 1.5.8) called at [/var/www/html/mywebsite/myadmin/includes/init_includes/init_user_tracking.php:164]
#3 require(/var/www/html/mywebsite/myadmin/includes/init_includes/init_user_tracking.php) called at [/var/www/html/mywebsite/includes/autoload_func.php:48]
#4 require(/var/www/html/mywebsite/includes/autoload_func.php) called at [/var/www/html/mywebsite/myadmin/includes/application_top.php:171]
#5 require(/var/www/html/mywebsite/myadmin/includes/application_top.php) called at [/var/www/html/mywebsite/myadmin/index.php:10]

[07-Feb-2018 12:35:25] PHP Notice: file_get_contents() error checking plugin versions.
Trying http instead. in /var/www/html/mywebsite/includes/functions/plugin_support.php on line 72
[07-Feb-2018 12:35:25] Request URI: /mywebsite/myadmin/index.php, IP address: xxx.xxx.xxx.xxx
, /var/www/html/mywebsite/includes/functions/plugin_support.php, 73, Array ([plugin_file_id] => 159,[version_string_to_compare] => 1.5.8,[new_version_available] => ,[lookup_index] => 0,[url1] => https://plugins.zen-cart.com/versioncheck/159,[url2] => https://www.zen-cart.com/versioncheck/159,[ch] => Resource id #175,[response] => ,[error] => SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed,[errno] => 60,[ctx] => Resource id #176,[http_response_header] => Array ([0] => HTTP/1.0 404 Not Found,[1] => Date: Wed, 07 Feb 2018 10:35:25 GMT,[2] => Server: Apache/2.4.18 (Ubuntu),[3] => Cache-Control: no-cache, private,[4] => Connection: close,[5] => Content-Type: text/html; charset=UTF-8)))
#1 file_get_contents(http://plugins.zen-cart.com/versioncheck/159, , Resource id #176) called at [/var/www/html/mywebsite/includes/functions/plugin_support.php:73]
#2 plugin_version_check_for_updates(159, 1.5.8) called at [/var/www/html/mywebsite/myadmin/includes/init_includes/init_user_tracking.php:164]
#3 require(/var/www/html/mywebsite/myadmin/includes/init_includes/init_user_tracking.php) called at [/var/www/html/mywebsite/includes/autoload_func.php:48]
#4 require(/var/www/html/mywebsite/includes/autoload_func.php) called at [/var/www/html/mywebsite/myadmin/includes/application_top.php:171]
#5 require(/var/www/html/mywebsite/myadmin/includes/application_top.php) called at [/var/www/html/mywebsite/myadmin/index.php:10]

[07-Feb-2018 12:35:25] PHP Warning: file_get_contents(http://plugins.zen-cart.com/versioncheck/159%29: failed to open stream: HTTP request failed! HTTP/1.0 404 Not Found
in /var/www/html/mywebsite/includes/functions/plugin_support.php on line 73
[07-Feb-2018 12:35:25] Request URI: /mywebsite/myadmin/index.php, IP address: xxx.xxx.xxx.xxx
Aborting., /var/www/html/mywebsite/includes/functions/plugin_support.php, 76, Array ([plugin_file_id] => 159,[version_string_to_compare] => 1.5.8,[new_version_available] => ,[lookup_index] => 0,[url1] => https://plugins.zen-cart.com/versioncheck/159,[url2] => https://www.zen-cart.com/versioncheck/159,[ch] => Resource id #175,[response] => ,[error] => SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed,[errno] => 60,[ctx] => Resource id #176,[http_response_header] => Array ([0] => HTTP/1.0 404 Not Found,[1] => Date: Wed, 07 Feb 2018 10:35:25 GMT,[2] => Server: Apache/2.4.18 (Ubuntu),[3] => Cache-Control: no-cache, private,[4] => Connection: close,[5] => Content-Type: text/html; charset=UTF-8)))
#1 trigger_error(file_get_contents() error checking plugin versions.
Aborting.) called at [/var/www/html/mywebsite/includes/functions/plugin_support.php:76]
#2 plugin_version_check_for_updates(159, 1.5.8) called at [/var/www/html/mywebsite/myadmin/includes/init_includes/init_user_tracking.php:164]
#3 require(/var/www/html/mywebsite/myadmin/includes/init_includes/init_user_tracking.php) called at [/var/www/html/mywebsite/includes/autoload_func.php:48]
#4 require(/var/www/html/mywebsite/includes/autoload_func.php) called at [/var/www/html/mywebsite/myadmin/includes/application_top.php:171]
#5 require(/var/www/html/mywebsite/myadmin/includes/application_top.php) called at [/var/www/html/mywebsite/myadmin/index.php:10]

[07-Feb-2018 12:35:25] PHP Notice: file_get_contents() error checking plugin versions.
Aborting. in /var/www/html/mywebsite/includes/functions/plugin_support.php on line 76

3 logfiles ( last one above ) when a get into admin.