User tracking mod

[DrByte]

Just a quick note to announce that I've uploaded the User Tracking mod to the downloads area for easy access.

http://www.zen-cart.com/index.php?ma...roducts_id=261

I also updated it to new edition: 20060805.

- added new switch in UT-Config to allow disabling of the gethostbyname lookup, thus allowing faster display without showing host domain names of IP addresses
- Note: installation instructions updated to add a check for whether the zen_update_user_tracking() function exists. If it doesn't exist, no error will display. Thus if mod isn't installed then no errors on screen.
- Added a note that the Admin Profiles mod has been adapted to properly handle permissions for User Tracking. Use it instead of Admin Levels mod if you are having problems.
- added forum-suggested index keys to UT table definition for new installs and upgrades


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

[PeterBKK]

I upgraded to the user_tracking_20060805 today and now it seems that the user tracker is missing to record som visitors

I hade a customer who posted in our guestbook today 14:49 and there are no records of that in the user tracker.. Normaly i do see if someone visit and post in our guestbook. The guestbook: http://siamonnet.se/babystore/index....page=guestbook

[PeterBKK]

Sorry it was recorded but as the person had been active for 5 hours, i missed it as the record was out of page.....

[DrByte]

There were no code changes related to "who" gets tracked.

[bettysue]

One of the sites I have the v1.27d compatible version in is suddenly after working without error since installation is getting this error message:

1016 Can't open file: 'user_tracking.MYI' (errno: 145)

I can't find such a file.

Any ideas as to how to fix this?

thank You,

betty

[DrByte]

1016 Can't open file: 'user_tracking.MYI' (errno: 145)

This is database-corruption.
Run a database-repair either on that table or the entire database using your cPanel or phpMyAdmin.

[Phil020782]

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?

[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!