User tracking mod

[Arties]

I have this mod working but I have noticed that when someone adds items to their shopping cart it doesn't show in the user shopping cart column on the user tracking mod. Is this something that is not supported in v1.5.0 because it worked on previous versions?

I have the same "problem". Previously all session was stored as plain text in the session table, but with Suhosin (my guess), all sessions values are now encrypted - thus making it unreadable in user tracking.

I also hope for a fix for this, as it does work in the "who's online" tool in ZenCart.

[knuckle-101]

I have this mod working but I have noticed that when someone adds items to their shopping cart it doesn't show in the user shopping cart column on the user tracking mod. Is this something that is not supported in v1.5.0 because it worked on previous versions?

If you click the "View Sessions" link in red the details of the cart are in the left column of the data graph table. See attached screenshot highlighted in yellow, beside it will be the link to that product. Or should..

Attachment 11394

sjbglx


Hello everyone, I have the exactly the same problem. Fresh installation of Zen_cart 1.5.0, and user tracking mod 1.4.0. Just can not execute the SQL patch, every time it returns the same error message. Due to the fact that I have 3 different company's server space, so tested on other server and I don't have any problem on other server. Is this problem related to server? Can anybody help??

According to your quoted error from a previous poster "#1062 - Duplicate entry 'UserTracking' for key 'page_key'". this is telling you that you have the tables already installed into your database.

[sjbglx]

Hello everyone I think I got the problem fixed.
Firstly I checked the MYSQL version on my hosting server and that is 5.5.27-cll. looks like newer than all versions I tested before.
Please NOTE: The given SQL patch can work free of probelms in all of those old MYSQL version so I make one change to the SQL patch.
I located the "TYPE=MyISAM"
and switch it to "ENGINE=MyISAM"
Then the SQL patch can run without problem!

[Brent]

....J
- added forum-suggested index keys to UT table definition for new installs and upgrades


Still compatible with v1.3.x and v1.2.x

DrByte,

sql_update_to_20060805.sql creates duplicate index keys for time_entry.

Brent

PS. I should have added the index keys months ago as they have made a fantastic difference. Thanks for the update.

[DrByte]

sql_update_to_20060805.sql creates duplicate index keys for time_entry.

Oops ... thanks for the update. The zip is fixed for the sake of future downloads.

[inksale]

Installed on 1.3.0.2 and it works well.
I do have one little "QuerK".
I choose user tracking from the tools and can view the users however, when I click on View session I and brought to the admin login screen and need to log in again. Once I have logged in for the 2nd time I can navigate the sessions just fine.

Any idea what is causing this?
Its happening on 3 different computers 2 PCs in different locations IE and FF as well as on my Mac.

[heavenlynights]

I do have one little "QuerK".
I choose user tracking from the tools and can view the users however, when I click on View session I and brought to the admin login screen and need to log in again. Once I have logged in for the 2nd time I can navigate the sessions just fine.

Any idea what is causing this?
Its happening on 3 different computers 2 PCs in different locations IE and FF as well as on my Mac.

I have had this same problem right from the start except that for some reason it does not do this on my laptop and I am not sure as to why. I have had this issue for a long time, but didn't worry too much about it. I decided to post to let users know that this issue isn't isolated to a single person!!

[PeterBKK]

I got something strange today.. And i have NOT done anything with the DB last 24 hour. No updates, have not even looked at it.... The user tracking have worked perfect all the time untill 00:00 last night.... I still can see all tracking till 00:00 last night but only an error for to day.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '915fde48348c08a5e3d9ed11a4100' order by time_last_click desc' at line 1
in:
[SELECT customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, session_id, referer_url FROM zen_user_tracking WHERE session_id = '00d"'915fde48348c08a5e3d9ed11a4100' 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.

[PeterBKK]

Installed on 1.3.0.2 and it works well.
I do have one little "QuerK".
I choose user tracking from the tools and can view the users however, when I click on View session I and brought to the admin login screen and need to log in again. Once I have logged in for the 2nd time I can navigate the sessions just fine.

Any idea what is causing this?
Its happening on 3 different computers 2 PCs in different locations IE and FF as well as on my Mac.

I did never had this problem

[Pinghead]

To all the users of the usertracking mod!

I'm in the process of upgrading to 1.3.0.1 from 1.2.6, and translating the english files to swedish (8815 lines of code...) and fixing the other mods I've installed.

Please bear with me, this will take a while.

In the meantime, post problems and solutions to the usertracking mod in this thread.

Well, as I'm not going to have time to continue my work on/at my webshop I just came here to say goodbye (so you don't think I've gone M.I.A) and wish you all good luck with your continuing use of Zen-Cart (which I think is an awesome tool) and the tracking mod.

Best regards
Petter