Supertracker

I am running ZC 1.3.8. I installed supertracker and it worked great. However, a couple weeks ago I updated my site to have a 404 error page instead of just going to the front page. Since then, I commonly see Supertracker report people enter or leave my site on "Page Not Found."

The thing is, I know this isn't true, because I can go to the main index page in my browser, then open up supertracker and see that it thinks I am on "Page Not Found." Clearly it's a mistake. Is anyone else running into this, and do you know how to fix it?

Thanks,
TJ

sdsprings:

Hey anyone have luck with this mod recently. I'm not sure if it is my configuration that is effecting the functionality, but none of my pages inside the cart seem to load when this mod is installed. Just blank white pages that continue to try and load, only part that loads is the title. Any ideas? TYI
Login with symbols and forms that the customer puts symbols into will crash it.
:(

Same thing happened to my zencart 1.3.7, after successful installation of the mod my zen site just displayed blank white pages including the index page...
uninstalled the Supertracker using the packaged sql uninstall, but still no avail, any help? ideas?

Hi.
1267 Illegal mix of collations (latin2_czech_cs,IMPLICIT) and (cp1250_czech_cs,IMPLICIT) for operation '='
in:
[SELECT s.*, c.countries_name, s.country_code FROM supertracker s LEFT JOIN countries c ON (c.countries_iso_code_2 = s.country_code) ORDER BY last_click DESC LIMIT 0, 10]
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.

What I did wrong?:(

Thanks in advance.

This is one amazing mod!! Thank you!!

I have a question for you. It appears that if a customer makes a few orders in a row, only the first one gets recorded. Is there a way to fix this so we see all orders the customer made on the supertracker table?

Hi! This is a great mod and up till now I have had no problems with it, however a customer emailed me today saying she got this error when trying to login to her account:

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 've ordered two this time, but it's enough that you send med one with files from ' at line 1
in:

[UPDATE supertracker SET last_click = NOW(), exit_page='/store/', exit_page_name='Store Home', num_clicks=num_clicks+1, added_cart='true', categories_viewed='b:0;', products_viewed='', customer_id='155', completed_purchase='false', cart_contents='a:3:{s:36:"261:0bc6a1a6704712f9030bea5259c6c1ac";a:3:{s:3:"qty";s:1:"2";s:10:"attributes";a:2:{i:33;s:2:"71";i:34;s:1:"0";}s:17:"attributes_values";a:1:{i:34;s:219:"Could you please put files from my order 03/04/2009 # 629 on the CD too? Since I owe you for a previous CD I've ordered two this time, but it's enough that you send med one with files from order 629. Hugs from Lizzie";}}s:36:"536:b23c9e0b8df647a149c40fa24d4bb1d5";a:2:{s:3:"qty";s:1:"1";s:10:"attributes";a:5:{s:8:"18_chk26";s:2:"26";s:8:"19_chk29";s:2:"29";s:8:"20_chk32";s:2:"32";s:8:"25_chk35";s:2:"35";s:8:"26_chk37";s:2:"37";}}s:36:"261:1609c6acabb1b4d95936bbd9e6310955";a:2:{s:3:"qty";s:1:"1";s:10:"attributes";a:1:{i:33;s:2:"71";}}}', cart_total = '45', order_id = '0' WHERE tracking_id='10130']
```I retrieved the code and saw it for myself using the master password mod to login to her account, and I have fixed the error by deleting that line from the supertracker table in the database using the tracking id *but* I would like to prevent it happening again....seems the supertracker also recorded customer comments but didn't escape the ' and I don't know enough to either have it not record the customer comments along with the cart or escape any apostrophes lol

Any ideas?

Sorry I have to add onto this, missed the edit time LOL I don't think it was the customer comment section, what the customer was trying to order has a text field as an attribute for information, here:

http://www.havendesignz.com/store/custom-services/cd-dvd-shipping-service

So lol not sure what the fix would be to stop it erroring like this again :)

I have a little more information on this....my customer had added the cd service to her cart with this text in the text attribute box:

Could you please put files from my order 03/04/2009 # 629 on the CD too? Since I owe you for a previous CD I've ordered two this time, but it's enough that you send med one with files from order 629. Hugs from Lizzie

Every time she or I tried to login to her account it added a new line to the supertracker mod bringing up the syntax error every time because that item was still in her cart, so I had to uninstall the supertracker mod, login to her account and delete the item from her cart, and then reinstall the supertracker mod to get rid of the error entirely.

Since this is the only error that arose from the text entry I can only assume that the supertracker mod is not escaping apostrophes in text attributes but I have no idea on what or where to edit the mod files to fix that and would much appreciate some help so this doesn't happen again LOL

Hey christon26, there was a note about this near post 74 of this same thread...

here is the post that the mod writer posted to change...

http://www.zen-cart.com/forum/showpost.php?p=479202&postcount=74

hope that helps :)

christon26:

I have a little more information on this....my customer had added the cd service to her cart with this text in the text attribute box:

Could you please put files from my order 03/04/2009 # 629 on the CD too? Since I owe you for a previous CD I've ordered two this time, but it's enough that you send med one with files from order 629. Hugs from Lizzie

Every time she or I tried to login to her account it added a new line to the supertracker mod bringing up the syntax error every time because that item was still in her cart, so I had to uninstall the supertracker mod, login to her account and delete the item from her cart, and then reinstall the supertracker mod to get rid of the error entirely.

Since this is the only error that arose from the text entry I can only assume that the supertracker mod is not escaping apostrophes in text attributes but I have no idea on what or where to edit the mod files to fix that and would much appreciate some help so this doesn't happen again LOL

Thanx! I did search the thread but musta used the wrong search terms LOL :)

i Love this mod i have been using it for a while now. but for some reason it has now started to show 6 entry's for each visit to my site. Each entry is showing a different Country name for the UK e.g. one will show United Kingdom next will show Northern Ireland the next Scotland and so on.

I'm guessing it is being caused by the new Big Royal mail mod zones that I installed the other day but i cant finger out where it is picking them up from as I have removed some zones but it is still doing it? :frusty:

I am having the same issue, duplicate entries of the same cart. StarBuck & PatF have you got several countries under the same ISO ref.

I have as with StarBuck the Big Royal mail mod installed and to get Jersey/Guernsey the same postal prices I have used the ISO code GBR/GB which gets around this issue, but for this mod it causes dupilcated results, as I see it it is part of the code that calls the list using the iso code so I will have three copies of the same cart becuse I have three entries of GBR/GB in countries.

$lt_query = "SELECT s.*, c.countries_name, s.country_code
									 FROM " . TABLE_SUPERTRACKER . " s
										 LEFT JOIN " . TABLE_COUNTRIES . " c ON (c.countries_iso_code_2 = s.country_code)" .
									 $where . "
									 ORDER BY last_click DESC
									 LIMIT " . $offset . ", 10";

Any ideas on how we can get around this ?

I am getting the same problem with duplicate entries, I have also noticed that even if I have logged in it shows me as guest instead of the username as the same mod did for OSC.

Actually I want to make sure I Am clear, I am not getting duplicate entries, I am getting a new entry for each page that I vist. In other words, if I click on 15 different products than I get 15 entries in the database and NONE of them are showing as coming from a registered user when that person has logged in.

could this be due to sessions?

Any ideas?

Running 1.3.8 with zj_black template
It puts the site down, only background remains,
seems like an javascript problem when removing the jscript_supertracker file, it works again. pls respond somebody.

Hi, I am having an issue using apostrophes in my text boxes.

Here's the thread.

DrByte thinks it might be a Supertracker bug. Does anyone know of an easy way to disable Supertracker so I can see if it is the culprit?

I really like Supertracker. If there is a problem with it, hopefully the bug can be fixed - I'd like to keep it running.

Thanks!

cowgirlmodel:

Hi, I am having an issue using apostrophes in my text boxes.

Here's the thread.

DrByte thinks it might be a Supertracker bug. Does anyone know of an easy way to disable Supertracker so I can see if it is the culprit?

I really like Supertracker. If there is a problem with it, hopefully the bug can be fixed - I'd like to keep it running.

Thanks!

I had the same problem a page back lol http://www.zen-cart.com/forum/showthread.php?p=695274#post695274

The solution was posted here: http://www.zen-cart.com/forum/showpost.php?p=479202&postcount=74

Hope that helps you too :D

Just to add in, I had to empty out the customer's cart before the error would go away completely

christon26:

I had the same problem a page back lol http://www.zen-cart.com/forum/showthread.php?p=695274#post695274

The solution was posted here: http://www.zen-cart.com/forum/showpost.php?p=479202&postcount=74

Hope that helps you too :D

Just to add in, I had to empty out the customer's cart before the error would go away completely

Thanks Christon - you are a HERO! It worked! :clap:
You have a really nice store, too; I bookmarked it.

For future reference for others with this apostrophe problem - this file that needs to be changed is /includes/classes/supertracker.php

LOL you're welcome....the hero though is not me, I didn't write the mod nor the fix :blush:

And thanx about my store...I have worked long and hard on it....and still always finding new things to add or change LOL :wink:

I really appreciate that you answered my ?? so quickly; so yes, for me you are the hero.

ZenCart is a great program, but definitely not for the faint of heart or those who can't put in the time to work on it. I'm amazed by how much work so many people in the forum have put into their stores; and it's such a steep learning curve for many of us. This forum community is by far one of the best - so many people helping each other. And a lot of it is just plain trial & error solutions shared for no reason except to make it easier on the next person.

I have read around for few weeks and found some posts with the same problem I am having but not a solution. I am using Zen Cart version 138a with 2 mods installed. User tracking and image handler 2.
The admin interface for supertracker appears to be fuctioning but I get no information. It always has the following line.
database currently holds 0 rows (oldest record : )
And its the same line for everything in the dropdown menu. Anyone have an idea?