User tracking mod

Hi all,

I had some trouble with the mod, re-installed it and everything seemed to work fine...UNTIL...I entered my site and put a product in the shopping cart, then entered amin user tracker and it shows this product in User Shopping Cart, but in another Session ID from another IP, btw I blocked my IP.

What happened? Any idea?

Thanks a lot.

Regards,
kruna

i am often seeing lines like this in the user tracking module:

00:03:13: Page Not Found /includes/templates/sophybluegr/images/b
ox002.gif
I see this when i view a session, the file is one of the templates' images, the one which makes up the sidebox background. The funny thing is that the image is not clickable, and there is no way they could have gotten to click on a link to that image. This often occurs when they are viewing any page especially the download free mp3 page.

another strange one is:

04:22:52: Page Not Found /favicon.ico

Why is user tracking frequently reporting this stuff?

I really like this user tracking mod. I recently had an idea but am not code savvy enough to implement it. I was curious if there is any way (or even an interest from anyone besides myself) to add a notification feature to this mod.

I will explain,

I have some ip's that visit my site I like to keep close eye's on (such as competitor websites) I was curious how difficult it would be to add on a notification feature to this mod that notifies me by email, sms, or both when one of these ip's visit my site. I know this is a stretch. My business takes me on the go a lot so I am not always able to sit down and browse the tracking log to see what they are up to. I just simply need to know when they visit and who so I know where to look when I return to my office.

If somthing like this already exists, I would be greatful for any insight you can provide,

Steve
cjcrafts.com

Hi All,
Just tried installing this contrib and ran into an SQL error. I followed the install instruction and tried to apply the patch through phpmyadmin. It seems that the patch won't apply this way if you are using a prefix for tables in your database.

However the problems was easily fixed by applying the patch through admin > Tools > Install Sql Patches. This seems to append the table prefix to the sql query.

just though you might want to know.

All the best,

N

keyword: DELETE FROM configuration WHERE configuration_group_id = '999';

Hi again,
I love the contrib. Great work.

I am interested in filtering / excluding results based on my HOST not IP (as I have a dynamic IP that seems to change very regularly).

Has anyone had success with this? I think it would be a great feature.

Or alternativly, has anyone worked out a neat way to analyze the information? Perhaps find out some stats, turn the data into reports. etc.

Cheers,

Nathan

When I try to install the sql patch, I get the following error:

Error

SQL query:

DELETE FROM ol_configuration WHERE ol_configuration_group_id = '999';

MySQL said: Documentation
#1054 - Unknown column 'ol_configuration_group_id' in 'where clause'

Any ideas?

madteckhead:

Hi All,
Just tried installing this contrib and ran into an SQL error. I followed the install instruction and tried to apply the patch through phpmyadmin. It seems that the patch won't apply this way if you are using a prefix for tables in your database.

However the problems was easily fixed by applying the patch through admin > Tools > Install Sql Patches. This seems to append the table prefix to the sql query.

just though you might want to know.

All the best,

N

keyword: DELETE FROM configuration WHERE configuration_group_id = '999';

This method fixed my problem. It's misleading b/c the readme says to use phpMyAdmin

Is anyone else getting this with the user tracking. When you are just browsing through the categories, each page is recorded in the user tracking as page not found. If you click on an item it will record the item. But everything in between comes up page not found.

22:42:57: Page Not Found /index.php?main_page=page_not_found

22:42:56: Contact Us /index.php?main_page=contact_us

22:41:38: Page Not Found /index.php?main_page=page_not_found

22:41:37: Page Not Found /index.php?main_page=page_not_found

22:40:05: Page Not Found /index.php?main_page=page_not_found

22:40:04: Page Not Found /index.php?main_page=page_not_found

22:40:03: Page Not Found /index.php?main_page=page_not_found

22:40:02: Page Not Found /index.php?main_page=page_not_found

22:40:01: Page Not Found /index.php?main_page=page_not_found

22:40:00: Page Not Found /index.php?main_page=page_not_found

22:38:32: Page Not Found /index.php?main_page=page_not_found

22:37:51: Page Not Found /index.php?main_page=page_not_found

22:37:48: Page Not Found /index.php?main_page=page_not_found

Anyone else have this? Or anyone have any idea what, if anything, is wrong?

Thanks in advance,

Kelly

nice mod...lots of chatter...I do have an issue though....

I blocked my IP but it didnt block it. I ask it to purge all records for this IP and it doesnt....is there another setting or something that would enable the IP functions?

Thanks

heres from my report page

 
Click Count:1Start Time:22:06:04Idle Time:03:00:03End Time:22:06:04Total Time:03:00:00
Country:[IMG]https://www.theribbondiva.com/Amag531Jw/images/flags/us.gif[/IMG] United States
IP Address:
Host:

you can see (although the layout didnt copy well) that there is no IP listed....my glitch or yours?

anyone supporting this mod anymore? Maybe this should be dropped until its working correctly. Nice try though.

studeo:

anyone supporting this mod anymore? Maybe this should be dropped until its working correctly. Nice try though.

This mod has gone through a number of permutations (from Petter and JeffD) but it works for me on Zen Cart 1.37. I have a few minor issues, and others have reported design issues with the mod, but overall it is a tool that I would not want to be without.

I have not observed your error and have never observed previous similar report in this thread.

My first recommend is to uninstall and then reinstall the mod. And then see if the IP is getting written to the user_tracking table in the ZC database.

Are you certain you added the proper entry to the common footer template to record full tracking info to the database?

Several months ago Andrew stated he would merge the best of Super Tracker utility, the User Tracking mod, and some other mods together, to develop a full featured tracking mod for Zen Cart but it appears Andrew has dropped out of the Zen Cart community completely this time.

To obtain a more complete picture, besides reading this entire thread, you may want to also read the archived thread.

Good luck.

Woody

Does anyone have an sql patch to remove all of the entries into the db so I can do a clean uninstall?

I dont want to fiddle with something I dont know.

Thanks

Just out of curiousity, when the googlebot is crawling, its landing on 'page 2' over and over. What page would be returning a path of page 2?

Thanks

studeo:

Just out of curiousity, when the googlebot is crawling, its landing on 'page 2' over and over. What page would be returning a path of page 2?

Thanks

Default pages (pg 2-4) in Information sidebox. Look in your Zen Cart sitemap and you will see links. You will have to disable. Off topic for this thread. Search Zen Cart support forum for posts how to disable. I think how to is also listed in the FAQ.

Hello,

I just installed the User Tracking module (User Tracking v.1.3.6.2 for ZEN1.3.7),
pm my zencart 1.36 and the loading of the site seems slower. Has anyone noticed this behavior?

Does UT slow down the site and if so, is there any optimization possiblity, vis-a-vis the DB?

What is the procedure to cleanly de-install (besides deleting the relevant files and the tracker line from the tpl-footer) ? Is there an SQL uninstall script?

Thanks for the help,

HD

Just posting this in case it comes up for someone else. We recently had our mySQL grind to just about a halt for a day while I tore my hair out trying to figure out why. Once or twice in the past we've had yahoo bots go bezerk and spider too vigorously, but that wasn't it this time. Once we had a bot continuously add things to it's cart somehow... but that wasn't it this time...

FINALLY we found it was an old installation of user tracking mod. (I emphasize old in case this issue has been solved). A bot was crawling through the database listings for that mod, which had gotten 1 GB large. The constant queries killed us.

I just removed the mod and the table from mySQL since we hadn't been using it really anymore anyway.

But for the record, if you have this mod installed and you grind to a halt one day, this might be worth checking into!

A

avansant:

Just posting this in case it comes up for someone else. We recently had our mySQL grind to just about a halt for a day while I tore my hair out trying to figure out why. Once or twice in the past we've had yahoo bots go bezerk and spider too vigorously, but that wasn't it this time. Once we had a bot continuously add things to it's cart somehow... but that wasn't it this time...

FINALLY we found it was an old installation of user tracking mod. (I emphasize old in case this issue has been solved). A bot was crawling through the database listings for that mod, which had gotten 1 GB large. The constant queries killed us.

I just removed the mod and the table from mySQL since we hadn't been using it really anymore anyway.

But for the record, if you have this mod installed and you grind to a halt one day, this might be worth checking into!

A

I didn't think that bots were supposed to be able to access the admin side
maybe you should rename the admin for security.

1gig does sound a little large you should empty it out a bit before it gets that big.

I find when using this mod I need to turn the "host lookup" off as this slooows the mod down a lot.

ngamma:

Hello,

I just installed the User Tracking module (User Tracking v.1.3.6.2 for ZEN1.3.7),
pm my zencart 1.36 and the loading of the site seems slower. Has anyone noticed this behavior?

Does UT slow down the site and if so, is there any optimization possiblity, vis-a-vis the DB?

What is the procedure to cleanly de-install (besides deleting the relevant files and the tracker line from the tpl-footer) ? Is there an SQL uninstall script?
In the latest UT release based on JeffD's version no key indexes were applied to the UT db table.

Recommend applying to table "user_tracking" :

KEY session_id (session_id),
KEY time_entry (time_entry)

Can do this easily via phpmyadmin.

Yes UT slows down the site a bit but seems insignificant to me.

Search beck to one of my posts in this thread this last spring. Shows how to disable tracking bots and also visits from your IP address.

As gilby reported clean out your UT log often (once a week is what I do).

No uninstaller. Best to look at the sql used to install your SPECIFIC mod version and work from that. All UT mod versions I'm aware of created table "user_tracking" and added entries to ZC Admin > Config and > Tools menus. Can remove all that via phppmyadmin. And then remove files installed by mod version. Of course back up first if something goes wrong.

Woody

avansant:

We recently had our mySQL grind to just about a halt ... we've had yahoo bots go bezerk and spider too vigorously, but that wasn't it this time. Once we had a bot continuously add things to it's cart somehow... but that wasn't it this time...

FINALLY we found it was an old installation of user tracking mod. (I emphasize old in case this issue has been solved). A bot was crawling through the database listings for that mod, which had gotten 1 GB large. The constant queries killed us.

I just removed the mod and the table from mySQL since we hadn't been using it really anymore anyway.

Appreciate the alert. And glad you have your issue resolved.

But I am curious how the mod was determined be related to your issue. All the tracking logging done by the mod is written to a database table. How can the database be spidered?

It is possible your shop URL containing a zenid was published somewhere on the web, contributed to the issue.

That can cause sessions to be hijacked.

Not that it would be related but are you writing your sql_cache to a file or the database?

You might want to search the forum on "db_cache". There was a related bug fix patch posted in July.

And note spider logging can be disabled in User Tracking (this is highly recommended).

There are flaws in latest versions of User Tracking, but as far as I understand nothing which would have contributed to your scenario. To be sure I'm no expert on these matters and just interested in how it was deduced that User Tracking was the culprit (besides just removing the mod and then all was better)?

Woody