User tracking mod

[cefyn]

I've just installed the updated version of this,no problems.But the previous version had a feature that let you clear the cache past the last 72 hrs of data. Any way I could put that back in ? The user tracking database table grows alarmingly fast. Talking of which,and this might be the wrong place to post this question ,so please point me to the right thread if you don't want to discuss this here - as I write I can see in my user tracking, about 800 single hits in the last hour from various i.p.'s ,all with the same originating url - a site which is outside my site and nothing to do with my site and has no legitimate link to my site.Whats going on with that kind of thing ?

[mc12345678]

I've just installed the updated version of this,no problems.But the previous version had a feature that let you clear the cache past the last 72 hrs of data. Any way I could put that back in ? The user tracking database table grows alarmingly fast. Talking of which,and this might be the wrong place to post this question ,so please point me to the right thread if you don't want to discuss this here - as I write I can see in my user tracking, about 800 single hits in the last hour from various i.p.'s ,all with the same originating url - a site which is outside my site and nothing to do with my site and has no legitimate link to my site.Whats going on with that kind of thing ?

Don't know from what version you upgraded, but the delete option is still present, check the configuration panel for User Tracking, the delete option probably has beeen set to default off. If the configuration window is not present then there is a patch above to make it reappear and under the configuration menu option.

As for the various hits, welcome to the new version of User Tracking that prevents the potential abuse by making the SQL queries of incoming data safer. Basically, that has probably been happening (check your server logs) for a while now, and it is only because of the rewrite that you are now observing the action.

It was discovered by those that had newly installed an older version of User Tracking that there would often or occassionally be an error generated by an outside visitor with information logged. Review of the logged information showed that the SQL query/page to visit had incorrect information/was formatted with a purpose. The web address being visited often had a single quote ' in it. When was the last time you went to a webpage that had a single quote in it's title? Anyways, that single quote caused some issues. As a result the method of capturing outside data was revised. Also, to support the growth of other users being given access to the site, an option was added in to allow/disallow various actions through the configuration menu.

[cefyn]

Thanks,thats what it was.And thanks for the explanation.

[mc12345678]

Thanks,thats what it was.And thanks for the explanation.

Welcome, and with that said, if your host is now using PHP 5.4, you more than likely will need to run a patch that is a page or two back to default to using the ZC installed configuration file instead of the originally provided User Tracking admin configuration file. The older version uses code that is no longer supported by PHP 5.4 and the additional config file has become obsolete/unnecessary for newer versions of ZC.

[MyCoolHats]

Hello, I am having two problems with this new install. I am currently using ZenCart v1.5.1 and using User Tracking Version 1.4.4. I have the menu working great under "User Tracking Config", but I am not getting any tracking results. I have verified the lines

#1. Under my "User Tracking" Screen I get this (it would appear that I a missing a language file, but I gone through each file and uploaded all one by one to make sure they were in the appropriate folders).

User Tracking Start: * Hide SpidersShow Spiders Update Report
This tool allows for you to see the click patterns of the users through your site, organized by sessions. This data can be very valuable to those looking for how to improve your site by watching how customers actually use it. You can surf back and forth through the days by using the link below.
Idle time is calculated from the current date/time and is based off of the last action taken during the session.
SELECT VIEW: Back to Jun 16, 2014

Now displaying the latest CONFIG_USER_TRACKING_SESSION_LIMIT sessions of this 24 hour period. You can also purge all records past the last 7 day(s) of data.

Delete all info from IP-Address CONFIG_USER_TRACKING_EXCLUDED purge all records

There have been 0 page views in this 24 hour period. Total number of users: 0. Total number of spiders: 0.
There have been 0 page views in this 24 hour period. Total number of users: 0. Total number of spiders: 0.

#2. The second issue I am having is an error in my logs:

[17-Jun-2014 13:09:11] PHP Fatal error:  1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (0, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', @UserTrackgID, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120 

I have tried to go this forum thread and to be honest I am confused by all the changes and different sql patches. I apologize if I am referring to an issue you have already cleared up. Any help would be greatly appreciated. Obviously I have done something wrong. Thank you!

[mc12345678]

Hello, I am having two problems with this new install. I am currently using ZenCart v1.5.1 and using User Tracking Version 1.4.4. I have the menu working great under "User Tracking Config", but I am not getting any tracking results. I have verified the lines

#1. Under my "User Tracking" Screen I get this (it would appear that I a missing a language file, but I gone through each file and uploaded all one by one to make sure they were in the appropriate folders).

User Tracking Start: * Hide SpidersShow Spiders Update Report
This tool allows for you to see the click patterns of the users through your site, organized by sessions. This data can be very valuable to those looking for how to improve your site by watching how customers actually use it. You can surf back and forth through the days by using the link below.
Idle time is calculated from the current date/time and is based off of the last action taken during the session.
SELECT VIEW: Back to Jun 16, 2014

Now displaying the latest CONFIG_USER_TRACKING_SESSION_LIMIT sessions of this 24 hour period. You can also purge all records past the last 7 day(s) of data.

Delete all info from IP-Address CONFIG_USER_TRACKING_EXCLUDED purge all records

There have been 0 page views in this 24 hour period. Total number of users: 0. Total number of spiders: 0.
There have been 0 page views in this 24 hour period. Total number of users: 0. Total number of spiders: 0.

#2. The second issue I am having is an error in my logs:

[17-Jun-2014 13:09:11] PHP Fatal error:  1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (0, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', @UserTrackgID, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),'); in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120 

I have tried to go this forum thread and to be honest I am confused by all the changes and different sql patches. I apologize if I am referring to an issue you have already cleared up. Any help would be greatly appreciated. Obviously I have done something wrong. Thank you!

The first issue (what looks like a missing definition) is actually a missing database install (SQL). That is/would be included in one of the unfortunately not well put together sets of files. Or so it would seem to me as the one that. Packaged it and somehow lead you down this path.

The second item, I am not sure why there is something different about that statement compared to what is in your database, but it appears that the number of columns between the two do not match. Version of ZC?

I have been working on packaging this better, but have gotten distracted with other things. May need to finish it off in the short term. Had a few other minor improvements as well. Was making progress on incorporating the ip blocker developed by lat9 until it got fundamentally changed. :)

[MyCoolHats]

The first issue (what looks like a missing definition) is actually a missing database install (SQL). That is/would be included in one of the unfortunately not well put together sets of files. Or so it would seem to me as the one that. Packaged it and somehow lead you down this path.

The second item, I am not sure why there is something different about that statement compared to what is in your database, but it appears that the number of columns between the two do not match. Version of ZC?

I have been working on packaging this better, but have gotten distracted with other things. May need to finish it off in the short term. Had a few other minor improvements as well. Was making progress on incorporating the ip blocker developed by lat9 until it got fundamentally changed. :)

The version of zencart 1.5.1 and I understand you are busy. Just let me know when you have a package put together and I will try again. Until then any suggestions are welcome. I don't which SQL to use that came in the download. I have tried them all and uninstalled sql - every option I can think off. I usually get a duplicate error or the column count doesn't match. I think it may be due to me using 1.5.1???

[mc12345678]

The version of zencart 1.5.1 and I understand you are busy. Just let me know when you have a package put together and I will try again. Until then any suggestions are welcome. I don't which SQL to use that came in the download. I have tried them all and uninstalled sql - every option I can think off. I usually get a duplicate error or the column count doesn't match. I think it may be due to me using 1.5.1???

I can say this, no it's not because of using zC 1.5.1.

Placing the entire code of the new install sql into the instaall sql patches window of the admin should install all of the sql at once. It will not work if put in one line at a time.

[mc12345678]

Also just looked, the most recent version is 1.5.

[mc12345678]

There is a difference in the formatting of the new user and update sql statements regarding how the calls are made to the sql database. The new install sends on as if the number of columns in the sql statement is exactly correct. Have you added any plugins to your cart, and if so which?

I know one of the things to modify in the new user sql is to instead just insert into the table, inform the database what the following assignments relate to.

Take a look at the update_user_tracking.sql. The first insert statement inserts into the configuration table and has a parenthetical list of fields. If you copy that parenthetical list and paste it between configuration and VALUES in the new_install_user_tracking.sql file (where it is not currently), that should resolve the issues found at the first insert to the configuration table.

Then I think now that I look at the new_install and update sqls, that the update sql is to be run after the new_install.

Sorry, it appears that the full new install sql didn't get the new features added to it. :/ thank you for identifying this. All the more reason to put together the installer I was working on so that the instructions will be very easy. :) it is easier to do than to document. :) I will do better though.