User tracking mod

[studeo]

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

[Woodymon]

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

[studeo]

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

[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

[Woodymon]

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.

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

Thanks for the help,

HD

[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

[gilby]

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.

[Woodymon]

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

[Woodymon]

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