User tracking mod

Yeah that sorted it, thanks

Does anyone know if theres a way to get this mod to let you see what items have been added to a customers cart?

"Install sql patch file, preferably by phpMyAdmin then add sql patch of zen (as recommended in the forum"

Hi, what forum post is this referring to exactly?

To install the user_tracking.sql what exactly is the command line that I need to type.

Thank you.

Hi, i am using 1.39h, with User Traking off course :clap:

When i open User Tracking, by default it opens me the first user that whas recorded without a session_id.
In my case web crawlers as google, yahoo....
This may be only particular to me as i have in config-> Sessions :
Prevent Spider Sessions
Prevent known spiders from starting a session = True
And they have a lot off hits in one day > 5000
it is a headake to scroll to the real users sessions throh so many hits

the solution is that in admin/user_tracking.php around the end there is the line that shows the clicks off a certain user, for me this line returns true by default in the case off spiders as they dont have session IDs.
line 363 in my file

if ($_GET['viewsession'] == $ut['value']['session_id']){
  while (($pu = each($ut['value']['last_page_url']))&&($du = each($ut['value']['page_desc'])))
  {

and replaced it with (adedd code in red and bold)

if ($_GET['viewsession'] == $ut['value']['session_id'] [B] && $ut['value']['session_id'] != ''[/B]){
  while (($pu = each($ut['value']['last_page_url']))&&($du = each($ut['value']['page_desc'])))
  {

in this way even if the is a record without session_id, it does not open by default, only when you click on [view session]

Best regards Zoli.

Thanks for that tip because it was starting to drive me crazy.

Gary

Has anyone got this running CORRECTLY on a 1.3.9h site or is this one that needs to be re-worked and updated for newer versions of PHP and SQL?

Thanks,

Rod

rod44:

Has anyone got this running CORRECTLY on a 1.3.9h site or is this one that needs to be re-worked and updated for newer versions of PHP and SQL?

Thanks,

Rod

Hi Rod,

I just installed the mod and it worked fine without a problem. I'm just bit concerned about some people saying that it will also track the search engine activities. I am trying to find an answer to that matter.

Josh
@Jostar

Hi

Just started getting this error message:

144 Table './DIRECTORY NAME NOT SHOWN/user_tracking' is marked as crashed and last (automatic?) repair failed
in:
[select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, session_id, referer_url, customers_host_address from user_tracking where time_entry > 1301727600 and time_entry < 1301814000 order by time_last_click desc]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thanks
John

I just installed and I'm not getting everything under the admin (configuration) user tracking config. Pictures to show what I have. Also, I had an error message when I installed the sql pictures as well. Any help will be kindly appreciated. thanks in advance!

This is the error message when installing the sql 1062 Duplicate entry '999' for key 'PRIMARY'
in:
[INSERT INTO znc_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

2nd. The only fields showing on the admin are: Title/Value &Action. I thought it would be more (perhaps I'm wrong)

We're running ZC 1.3.9H with user tracking with no problems. Cart contents don't show but am working on that. will post back if and when I have an answer.

Some of these issues you guys are having sound like there is likely a conflict with one or more mods you have installed.

You should carefully read through each mods readme to see which core files may need to be merged with other core files you may have overridden previously.

deathman2006:

Does anyone know if theres a way to get this mod to let you see what items have been added to a customers cart?

Recover Cart Sales will handle this for you available here http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=100 confirmed working in 1.3.9h

Does the latest updated version in the downloads section (1.4.0) work with 1.3.9x carts or only with 1.5.0?

Boggled:

Does the latest updated version in the downloads section (1.4.0) work with 1.3.9x carts or only with 1.5.0?

It is designed for V1.5.0 only.. For V1.3.9xx you will need to use the older version

Well ain't that DANY!
Just installed it only to come here to find an aswere as to why the SQL failed on: table admin_pages does not exist LOL

Has this done any damage to my site??

Rizla:

Well ain't that DANY!
Just installed it only to come here to find an aswere as to why the SQL failed on: table admin_pages does not exist LOL

Has this done any damage to my site??

No if you have not added the admin tables inside your SQL simply download the version for your ZenCart version upload and overwrite the files.

Think I boobed even more than that Knuckle.... Sure I used the update SQL file first (early morning) Then attempted the main SQL file to be told Error.. Table exists on 999 or something (NOt at the PC with it on)

I have a DB backup from Wednesday so will only loose a couple of customer details or can I delete the tables manually?

I knew I should have waited till the weekend :((

Also.. where is the version I need?

Thanks

Rizla:

Think I boobed even more than that Knuckle.... Sure I used the update SQL file first (early morning) Then attempted the main SQL file to be told Error.. Table exists on 999 or something (NOt at the PC with it on)

I have a DB backup from Wednesday so will only loose a couple of customer details or can I delete the tables manually?

I knew I should have waited till the weekend :((

Also.. where is the version I need?

Thanks

You do not have to run a full backup to remove the tables you inserted simply run the SQL Query below from the store admin located under the "Install SQL Patches" under tools menu

Or

You could execute it directly from your MySQL management phpMyAdmin or whatever your hosts allows you to use for MySQL management

Execute

DELETE FROM admin_pages WHERE  language_key = 'BOX_TOOLS_USER_TRACKING';
DELETE FROM admin_pages WHERE  language_key = 'BOX_TOOLS_USER_TRACKING_CONFIG';
```To get the older version you have to use the Version for 1.3.7 which is located under the 1.5.0 version here <http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=261>

The older version does not use or overwrite core files and no vulnerabilities are found you should be able use this safely (Still Use At Own Risk)

Download the files and simply overwrite the 1.5.0 files, make your file changes as it states in the readme and you will be good to go.

Hi Knuckle
Thanks for the reply... but it doesn't like "admin_pages"

Tried changing to "my_admin_name" but that fails too:

1146 Table 'metalpix_db1.admin_pages' doesn't exist

Rizla:

Hi Knuckle
Thanks for the reply... but it doesn't like "admin_pages"

Tried changing to "my_admin_name" but that fails too:

1146 Table 'metalpix_db1.admin_pages' doesn't exist

Can you give some more specifics how you run the command inside the admin "Install SQL Patches" or the host panel? Have you looked at the tables inside your database and see if admin_pages exist?

What version of Zencart are you using?

Just out of curiosity which SQL file did you use when you installed the mod?

new_install_user_tracking.sql or UPDATE_user_tracking.sql. After looking at a test store using 1.3.xxx and the install schema file there is no admin_pages table in the database in these versions so it seems you may have not installed the admin_pages alteration into the database at all, which in your error it says the tables does not exists.. Which would be what you want since your not using V1.5.0 which is only beta and not recommended for use anyway on a live site.

Either/Or the New Install and The Update SQL sheet inside Module folder for version 1.5.0 does not create admin_pages table for you (Only Updates) so I would be 99.8% certain the table does not exists hence there is nothing to worry about as far as the admin_pages insertion goes.