andrew71 1 Posted October 15, 2008 I'm having the same problem as the posters above, where the index page is blank after adding the lines to application_top.php. It would appear that the problem lies with the third line of the code, as I've added them one at a time and it works until the third line is added, as below: $tracker->update(); I'm using STS, and I'm not sure if that could be the cause of the problem. Any help would be appreciated. Share this post Link to post Share on other sites
xlameee 0 Posted October 19, 2008 Do you have a this error 1054 - Unknown column 'agent' in 'group statement' SELECT *, COUNT(*) as total FROM supertracker GROUP BY agent order by total DESC in top agents Let me know and if you not and u know how fix that pls let me know too Thanks in advance Niki I'm having the same problem as the posters above, where the index page is blank after adding the lines to application_top.php. It would appear that the problem lies with the third line of the code, as I've added them one at a time and it works until the third line is added, as below: $tracker->update(); I'm using STS, and I'm not sure if that could be the cause of the problem. Any help would be appreciated. Share this post Link to post Share on other sites
Guest Posted October 19, 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 Did you run the sql in phpmyadmin? Share this post Link to post Share on other sites
bigpanther1 0 Posted October 22, 2008 hi when i added the contribution to my site my store front no longer shows up how do i fix it? thank you in advance for your help Share this post Link to post Share on other sites
Guest Posted October 22, 2008 hi when i added the contribution to my site my store front no longer shows up how do i fix it? thank you in advance for your help Restore your back up files that you made before installing the contribution. Share this post Link to post Share on other sites
WoodsWalker 0 Posted October 27, 2008 (edited) Hi All, Like the many folks who have posted above, when I install SuperTracker, my online catalogue disappears. In place of the index page, I get this message: 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 ('216.211.59.244','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1','ca', 'Canada', 'http://www.mydomain.com/', '','/catalog/','/catalog/index.php','2008-10-26 21:35:45','2008-10-26 21:35:45','') [TEP STOP] In the above quote I have substituted "mydomain" for my own domain name. I did run supertracker_setup_db.php. It was successful. The Admin side seems to be functional, but the tracker is not tracking. The SuperTracker screen in Admin says: Database Info: the Supertracker database currently holds 0 rows (oldest record : ) even though I have had lots of traffic in the last few hours. Anyone know what is wrong? I am really looking forward to using this contribution! Thanks, ~Wendy P.S.: I have restored my storefront by removing the SuperTracker code from application_top.php . Edited October 27, 2008 by WoodsWalker Share this post Link to post Share on other sites
WoodsWalker 0 Posted October 27, 2008 Hi Folks - Me again! Problem solved. I had read backwards in this thread, but not far enough. Finally found the same question at Post #490. It seems the installation into the database leaves out a row called "agent". You have to go into the database and insert that row. Equilla, who maintains this contribution, will probably fix it on the next update. Otherwise, it looks good and I look forward to supertracking. :) ~Wendy Share this post Link to post Share on other sites
bigpanther1 0 Posted October 30, 2008 Restore your back up files that you made before installing the contribution. i did that allready and got the store working again but if i put the code back in then my store stops working what do i need to do to get this contrbution working? thank you Share this post Link to post Share on other sites
Guest Posted October 30, 2008 i did that allready and got the store working again but if i put the code back in then my store stops working what do i need to do to get this contrbution working? thank you If you made no error on the install, it must be imcompatible with your template. Share this post Link to post Share on other sites
ScottShipley 1 Posted November 10, 2008 Hi, I've got a couple of issues with supertracker v3.2b, first is that the keyword reports doesn't seem to work and the 2nd thing is the last 10 visitor report brings up bots, is there a way to get this to show only genuine customers? Thanks Scott Share this post Link to post Share on other sites
WoodsWalker 0 Posted November 29, 2008 (edited) Hello, All, I've been using Supertracker for a month now, and enjoying it. But last night I decided to remove the 7000 oldest rows of data, using the interface that Supertracker provides. The only other thing I did at that time, prior to removing the rows, was to use phpMA to export these rows as a spreadsheet file to my PC. I noticed this morning that Supertracker stopped recording at that point. There have been no new rows of data. Normally I would have had 100 by now. Folks and bots are visiting the site - I can see them in Who's Online. Any ideas? :unsure: Thanks, ~Wendy Edited November 29, 2008 by WoodsWalker Share this post Link to post Share on other sites
WoodsWalker 0 Posted November 29, 2008 Sorry, hold the phone, I was being a moron. :blush: I got worried when I looked in phpMA this morning and thought there were no new entries, but I must have twiddled something in there, as the newest rows are now appearing at the top instead of the bottom (which I like better, actually). Naturally, this morning I looked at the bottom of the table, which contained entries from last night around the time I dumped the data. All is well. Share this post Link to post Share on other sites
NewBudda 0 Posted November 29, 2008 Hi all, I just installed Supertracker but got the following error message after i called up the index.html: 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 ('84.59.99.240','Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3','de', 'Germany', '', '','/shop/','/shop/index.php','2008-11-29 23:26:36','2008-11-29 23:26:36','') [TEP STOP] Not sure what any of this means, but I would really appreciate some pointers! Open Source Newsletter: PhPList Open Source Questionnaire: Lime Survey Share this post Link to post Share on other sites
Guest Posted November 29, 2008 Hi all,I just installed Supertracker but got the following error message after i called up the index.html: Not sure what any of this means, but I would really appreciate some pointers! did you run the sql file in phpmyadmin? Share this post Link to post Share on other sites
NewBudda 0 Posted November 30, 2008 (edited) No, I used the provided supertracker_setup_db.php, which resulted in the message that all was inserted correctly. Edited November 30, 2008 by NewBudda Open Source Newsletter: PhPList Open Source Questionnaire: Lime Survey Share this post Link to post Share on other sites
NewBudda 0 Posted December 12, 2008 I still have not gotten it to work. Any ideas? Open Source Newsletter: PhPList Open Source Questionnaire: Lime Survey Share this post Link to post Share on other sites
Guest Posted December 13, 2008 I still have not gotten it to work. Any ideas? Try post 557 in this forum. Share this post Link to post Share on other sites
spunkypup 0 Posted December 13, 2008 Hey guys Would love to use this addon but i'm confused........ Which one do I need to add and install?????????? Share this post Link to post Share on other sites
Guest Posted December 13, 2008 Hey guys Would love to use this addon but i'm confused........ Which one do I need to add and install?????????? http://addons.oscommerce.com/info/3924 Share this post Link to post Share on other sites
Guest Posted December 22, 2008 (edited) Hello all, I havent installed the last contribution (20 dec) but i have the older one. I got these errors: Supertracker Database Info: the Supertracker database currently holds 0 rows (oldest record : ) To delete oldest data, enter the number of rows to remove: Please select a report to view: And when I click Erase, it gives following error: 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 '' at line 1 DELETE from supertracker ORDER by tracking_id ASC LIMIT [TEP STOP] Any help ? <_< Edited December 22, 2008 by supplementler Share this post Link to post Share on other sites
random183 0 Posted December 24, 2008 Hi, Great contribution, I can see this being very useful as the data builds up! One minor issue though, on the report "Last 10 Site visitors" the button "Next Ten Results" at the bottom does'nt work! No errors or anything, just does'nt do anything! I've had a good look through the firum, but can't find anything, and seing as it's on a new page I doubt it's anything to do with my install... (Though happy to be proved wrong!) Any ideas? Cheers Mat Share this post Link to post Share on other sites
acidrush 0 Posted January 6, 2009 Hi, Great contribution, I can see this being very useful as the data builds up! One minor issue though, on the report "Last 10 Site visitors" the button "Next Ten Results" at the bottom does'nt work! No errors or anything, just does'nt do anything! I've had a good look through the firum, but can't find anything, and seing as it's on a new page I doubt it's anything to do with my install... (Though happy to be proved wrong!) Any ideas? Cheers Mat I have a same problem. Can anyone help? Thx Share this post Link to post Share on other sites
fbrace 0 Posted January 14, 2009 This gives some great information, but is it not a pain to have to login on the admin side everytime that a query is run????? Frederick C Brace,III PA-C www.21st-tees.com (osc) www.tanda-designs.com (osc) Share this post Link to post Share on other sites
gbolt 0 Posted January 21, 2009 Did I do something wrong, or does the next 10 visitor button not work yet? Everything else seems to work great, so I am not sure what to do. GB Share this post Link to post Share on other sites
Guest Posted January 25, 2009 I just tried the newer versions and the next ten button does not work as reported. I reverted back to the Supertracker v3.2b-agent version which did work and continues to work. Share this post Link to post Share on other sites