blingyourself Posted June 1, 2008 Share Posted June 1, 2008 Hi, we used supertracker and it worked like a dream. However, yesterday we moved to a more powerful server. Now our supertracker reports only deliver blank results (I checked the database and supertracker is still collecting information, but it is not displayed anymore if I e.g. select last 10 visitors). I thought it was a problem with permissions and set pretty much all supertracker files to full access. Do you have any suggestions? Thank you, Carsten Please let me know if you have any idea why supertracker would not work (reports don't produce any results) anymore after move to another server, Thank you, Carsten Quote Link to comment Share on other sites More sharing options...
Guest Posted June 2, 2008 Share Posted June 2, 2008 Hi Thanks for the great contribution. I seem to be having trouble using the search strings to filter the referers. I am trying to filter all the search engine bots and crawlers. I have tried typing in googlebot and "googlebot" and (googlebot) it just makes everything disappear from the last 10 customers page I just want to get rid of the search engines so that I can see what is being looked at clearly. Any help would be appreciated. Thanks Karl I am also facing the problem of bots taking up db space. Has anyone figured out how to filter them out of the results? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 6, 2008 Share Posted June 6, 2008 I've installed this contribution with no problem - it's a fantastic resource. My one issue is I cannot figure out how to add an Agent - I've read the Agent guide and tried using the myshop.com\?rep=xx landing page and even done a demo purchase but I still have no Agent - can anyone tell me how to get an agent. Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 8, 2008 Share Posted June 8, 2008 I've installed this contribution with no problem - it's a fantastic resource. My one issue is I cannot figure out how to add an Agent - I've read the Agent guide and tried using the myshop.com\?rep=xx landing page and even done a demo purchase but I still have no Agent - can anyone tell me how to get an agent. Anyone? Quote Link to comment Share on other sites More sharing options...
Guest Posted June 9, 2008 Share Posted June 9, 2008 I've installed this contribution with no problem - it's a fantastic resource. My one issue is I cannot figure out how to add an Agent - I've read the Agent guide and tried using the myshop.com\?rep=xx landing page and even done a demo purchase but I still have no Agent - can anyone tell me how to get an agent. How did you conduct the test? Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 9, 2008 Share Posted June 9, 2008 How did you conduct the test? I followed the instructions in the agent readme - but possibly I have misunderstood. I arrived at my site at the URL: www.mydomain.co.uk/catalog/rep?=Fred I thought this would add Fred to the database in the new agent field - perhaps I am not doing the test right - I just have agent number 1. Thanks Lotti Quote Link to comment Share on other sites More sharing options...
Guest Posted June 9, 2008 Share Posted June 9, 2008 I followed the instructions in the agent readme - but possibly I have misunderstood. I arrived at my site at the URL: www.mydomain.co.uk/catalog/rep?=Fred I thought this would add Fred to the database in the new agent field - perhaps I am not doing the test right - I just have agent number 1. Thanks Lotti Did you do the agent_update.rtf changes? Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 9, 2008 Share Posted June 9, 2008 Did you do the agent_update.rtf changes? Sorry a true case of a blond moment - did upload the changed files - now working fantastically - thanks for bearing with me. Fantastic contribution! Quote Link to comment Share on other sites More sharing options...
Guest Posted June 10, 2008 Share Posted June 10, 2008 Sorry a true case of a blond moment - did upload the changed files - now working fantastically - thanks for bearing with me. Fantastic contribution! Easy to miss things, but I agree, it is a great contribution. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 10, 2008 Share Posted June 10, 2008 Yup it's not looking for /includes/geoip.inc It's looking for includes/GeoIP.dat I'm getting the same error. Where do I change the code so it's looking for the right file? Quote Link to comment Share on other sites More sharing options...
pair Posted June 22, 2008 Share Posted June 22, 2008 Hopfully someone can help me with this problem. I just installed Supertracker v3.2b It looks like it will work, If I go to the admin area, I can see on the reports section the supertracker and the types of report I can run, however on my site once when I type my index URL I just get a blank page?? I noticed that if I remove the following code: //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); from /catalog/includes/application_top.php then my site works again? Any idea why this may be happening? Any advice is greatly appreciated. Pair. Quote Link to comment Share on other sites More sharing options...
Steen Smidt Posted June 25, 2008 Share Posted June 25, 2008 Hi Thank for kode but i have a problem > enter my www then i get This 1054 - Unknown column 'agent' in 'field list' INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('80.62.177.189','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; InfoPath.1)','dk', 'Denmark', '', '','/','/index.php','2008-06-25 23:26:30','2008-06-25 23:26:30','') [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Steen Smidt Posted June 27, 2008 Share Posted June 27, 2008 (edited) Hello You just missing this agent in You sql - put it in via. phpmysql and then it works :-) ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL; It works for me Edited June 27, 2008 by Steen Smidt Quote Link to comment Share on other sites More sharing options...
vfx2k4 Posted June 27, 2008 Share Posted June 27, 2008 I think I botched the install. Looks all ok but I get zero reports on supertracker.php. The only part of the install I don't quite understand is this: "You will also need to add this new box in Administrator -> File Access from the admin menu." Where is this? Quote Link to comment Share on other sites More sharing options...
pair Posted July 15, 2008 Share Posted July 15, 2008 Hello everyone, <_< This is my second post about my problem, hopefully someone can help me this time as I have a live site and I really need the stats of where my customers are coming from? Your answer I'm sure will help not only me but others as well. Here is my problem. If I add the following code to my catalog/includes/application_top.php //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); When I type on a browser my website URL I get a blank page, if I remove the code I can see my website again. Please helpppppppppppp. Quote Link to comment Share on other sites More sharing options...
dmayo2 Posted July 19, 2008 Share Posted July 19, 2008 DELETE from supertracker ORDER by tracking_id ASC LIMIT Seems as if this issue hasn't been solved yet. I too am experiencing this issue, and as indicated it has to do with the version of mysql that is being used. From the mysql documentation: ORDER BY can be used with DELETE beginning with MySQL 4.0.0. I'm using mysql ver 3.23.x so the delete code in Supertracker: DELETE from supertracker ORDER by tracking_id ASC LIMIT " . $rows_to_delete; won't work. SOLUTION: We could figure out what the lowest tracker_id numbers are and start to delete based on those. However, if you use this code instead: DELETE from supertracker limit ".$rows_to_delete; This works for me, as it did delete the lowest numbered row (when I had $rows_to_delete = 1). QUESTION: Since tracker_id is the primary key in the table, if you don't give the query an ORDER BY, won't it default to ordering by the primary key in the ASC order? If this is true, then the above suggested code should work just fine. Question remains... will the table ever be ordered by some other column? Quote Link to comment Share on other sites More sharing options...
stephano6 Posted July 21, 2008 Share Posted July 21, 2008 (edited) @Cool >> Did you paste: //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); just before the last ?> in application_top.php ? Edited July 21, 2008 by stephano6 Quote Link to comment Share on other sites More sharing options...
stephano6 Posted July 21, 2008 Share Posted July 21, 2008 hello in admin/supertracker.php for Last ten Visitors, to: Customers Cart : (value=6.00) : QUESTION: the price is wrong because it is home to 6.30, even if I change to 6.10 / 6.50 / 6.90 / it remains to 6.00 (prices in euro) how to debug? Thank you Greetings Quote Link to comment Share on other sites More sharing options...
pair Posted July 23, 2008 Share Posted July 23, 2008 @Cool >> Did you paste: //Do the superstats business require(DIR_WS_CLASSES . 'supertracker.php'); $tracker = new supertracker; $tracker->update(); just before the last ?> in application_top.php ? Hi Williams, Thanks for replying. My problem is that if I add the code you mentioned above, when I type my URL, the index page shows blank. When I remove the code I can see my site as normal? On the admin side it appears like everything will function properly once this puzzle gets solve as I can’t see any errors, at least for now. It shows the following but I’m assuming is because is not tracking anything yet. Database Info: the Supertracker database currently holds 0 rows (oldest record : ) Do you have any idea what other file may be causing the problem that once I add the code on catalog/application_top.php the index page display blank? Any advice from you or anyone will be greatly appreciated. Cool :huh: Quote Link to comment Share on other sites More sharing options...
dmayo2 Posted July 23, 2008 Share Posted July 23, 2008 Cool. Try to narrow it down. In application_top.php just add the first line require(DIR_WS_CLASSES . 'supertracker.php'); then save the file and see if you are having the same problem with a blank index page (if the index page is blank, what about an interior page like /contact_us.php ???). Quote Link to comment Share on other sites More sharing options...
Brownangel Posted August 7, 2008 Share Posted August 7, 2008 Was anyone able to figure out why the catalog is blank when you install supertracker. I'm having the same problem and can't figure it out. Seems like when I take the code from application top everything looks fine. Quote Link to comment Share on other sites More sharing options...
mr_absinthe Posted September 13, 2008 Share Posted September 13, 2008 (edited) Hi, I wonder if anybody experienced this or similar scenario: Our site is unavailable completely, when I try to see any page, I'm receiving SQL error: 145 - Table './mysite04/supertracker' is marked as crashed and should be repaired when I view the database structure in phpMyAdmin, I see that the table supertracker table is "in use". I am however unable to browse it: Error SQL query: Edit SHOW INDEX FROM `supertracker` ; MySQL said: Documentation #145 - Table './mysite04/supertracker' is marked as crashed and should be repaired When I try to repair the table, I receive this message: mysite04.supertracker repair Error Table './mysite04/supertracker' is marked as cra...mysite04.supertracker repair Error Table 'supertracker' is marked as crashed and shou... mysite04.supertracker repair status Table is already up to date Does anybody know: a/how to repair/fix the table as I'm unable to fix it via phpMyAdmin b/ how to avoid this from happening in the future? Edited September 13, 2008 by mr_absinthe Quote Absinthe Original Liquor Store Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 14, 2008 Share Posted September 14, 2008 It's not uncommon for heavily accessed tables to become corrupted. It happens fairly often to the sessions table. If you can't repair it using phpmyadmin, then it would have to be replaced. There may be tools on the web to fix such a table but the cost and time needed for that wouldn't be worth it in my opinion since you are losing important data by replacing it. If you are concerned about losing that though, you can see if your host has a backup, or maybe you have one, that you can copy that table from. Then you wouldn't lose all of it. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
mr_absinthe Posted September 14, 2008 Share Posted September 14, 2008 Thank you Jack, it is exactly what I did in the end - I spoke to support and we decided to replace the table from backup - so if anybody will have similar problem, this might be a solution for you. Quote Absinthe Original Liquor Store Link to comment Share on other sites More sharing options...
xlameee Posted October 8, 2008 Share Posted October 8, 2008 Hey there, I've got a problem when install this contr. 1054 - Unknown column 'agent' in 'field list' INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`, `agent`) VALUES ('75.206.139.134','Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3','us', 'United States', 'http://brand-n- style.com/admin/supertracker.php', 'report=success_refer','/','/index.php','2008-10-07 20:09:09','2008-10-07 20:09:09','') [TEP STOP] anyone can help me pls. I've been looking for kind of this tracking system long time Thanks in advance Niki Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.