Supertracker

[Woodymon]

Does the release of SuperTracker in the downloads area include all the fixes discussed in this thread? Including the sql patch from Andrew on the first page of this thread?

As far as I can see no code fixes were discussed or posted to this thread. Only sql patch by Andrew in post #3.

Regarding the questin on if the updated sql patch is in the available download version of Supertracker mod, it is easy enough for you to check. Just download and compare!

At bottom of the announce post:

v.1.0.0 05.09.07 a_berezin
(Initial ZC version - based on ported v.3.20b - 01.11.05)

Since the release date of the mod, as listed above, is AFTER Andrew's sql fix posting, it could be presumed the updated sql patch would be in version in the ZC downloads area. But if you do not like to assume things then as stated it would easy enough for you to compare with the sql posted on the forum and rectify.

At any rate Andrew would not have updated the mod version number just because of a slightly altered sql patch.

But for you I just checked and the version in the downloads area indeed contains the updated sql patch. So please proceed.

Woody

[StoryBook]

Thanks Woody!

Got it installed and it works flawlessly, as far as I can tell right now. Just as soon as I've collected enough data, I'll look over the wealth of information.

I do appreciate the help.

I think it's important to remember, that even though a lot of Zen Cart store owners are ahead of the curve, and have a good working knowledge of coding (or at least as far as ZenCart goes), our primary vocation is in what we sell, not how we sell it.

I am, after all, a potter. I make cookie jars.

The Zen Cart community is great, and I hope some day I'll be able to give back some of the help I've received thus far.

Thanks again!
StoryBook

[Woodymon]

I think it's important to remember, that even though a lot of Zen Cart store owners are ahead of the curve, and have a good working knowledge of coding (or at least as far as ZenCart goes), our primary vocation is in what we sell, not how we sell it. I am, after all, a potter. I make cookie jars.

I recommended comparing files as it appeared that you did not know you could do that for sql files (otherwise you probably would have done that and not posted your question). sql patch files are just text files. Obtain a good compare tool and learn the basics in using it. If running Windows try WinMerge or Beyond & Compare. Just some hints to help you become a little more self-sufficient in Zen Cart shopowner basics.

I need to visit my potters support website and ask them why my cookie jar broke when I dropped it and how to glue it back together it. Hope they understand my primary vocation is eating cookies, not fixing cookie jars.

Woody

[StoryBook]

I recommended comparing files as it appeared that you did not know you could do that for sql files (otherwise you probably would have done that and not posted your question). sql patch files are just text files. Obtain a good compare tool and learn the basics in using it. If running Windows try WinMerge or Beyond & Compare. Just some hints to help you become a little more self-sufficient in Zen Cart shopowner basics.

Thanks! I got WinMerge. Neat program, thanks for recommending it. I did as you suggested (now after the fact) so that I can become familiar with the technique. I feel like I just made a major leap forward!

I need to visit my potters support website and ask them why my cookie jar broke when I dropped it and how to glue it back together it. Hope they understand my primary vocation is eating cookies, not fixing cookie jars.

I can help you with that!! First, let me ask you if your jar is vitreous Porcelain, Stoneware, or low-fire ceramic? What cone was the clay body fired at? How long did it soak?

Ha!!

Thanks again. Really!!

Kevin

[StoryBook]

So I have SuperTracker installed, and every report works just fine, EXCEPT for the last ten visitors report.

For some reason I can't seem to fathom, it is taking up to 45 seconds for the last ten visitors to load. Everything other report works just fine, and I've having no other issues with anything else on the site.

Any ideas?

Kevin

[Woodymon]

So I have SuperTracker installed, and every report works just fine, EXCEPT for the last ten visitors report.

For some reason I can't seem to fathom, it is taking up to 45 seconds for the last ten visitors to load. Everything other report works just fine, and I've having no other issues with anything else on the site.

Possibly resolving each customers IP to a host name is contributing to your delay. The resolution occurs at time the report is rendered (such info is not saved to the database)

To test if this may be contributing to your delay comment out the Supertracker code which resolves the IP (to disable the lookup function).

I don't observe this delay on the shops where I have installed Supertracker.

For the wishlist: Add additional switches to Supertracker admin UI config to enable/disable Supertracker features (eg disable host lookup).

Woody

[StoryBook]

I chased this thing around for two days. Checked every log, looked at everything I had changed or added, ran tests against showmyip, optimized the database, but nothing indicated any problem.

We run SuperTracker on our OSC site, and it works just fine, even during the period that the ZenCart version was having problems.

But this morning, the issue cleared up on it's own. I didn't do anything else that might have fixed it, other than getting a good night's sleep. I have to assume that the issue was on my host's end? Except that my data is stored at the same place as our OSC store.

I dunno...but all's fine now.

Thanks Woody, for responding, and I agree with the "wishlist". It could help problem solving to be able to easily isolate external requests.

Thanks again,
SB