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

Quote:

---

Originally Posted by 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:

Code:

---

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/cu...ipping-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/showpo...2&postcount=74

hope that helps :)

Quote:

---

Originally Posted by 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 :)