andrew71 Posted October 15, 2008 Share 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. Quote Link to comment Share on other sites More sharing options...
xlameee Posted October 19, 2008 Share 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 19, 2008 Share 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? Quote Link to comment Share on other sites More sharing options...
bigpanther1 Posted October 22, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2008 Share 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. Quote Link to comment Share on other sites More sharing options...
WoodsWalker Posted October 27, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
WoodsWalker Posted October 27, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
bigpanther1 Posted October 30, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 30, 2008 Share 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. Quote Link to comment Share on other sites More sharing options...
ScottShipley Posted November 10, 2008 Share 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 Quote Scott Link to comment Share on other sites More sharing options...
WoodsWalker Posted November 29, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
WoodsWalker Posted November 29, 2008 Share 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. Quote Link to comment Share on other sites More sharing options...
NewBudda Posted November 29, 2008 Share 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! Quote Open Source Newsletter: PhPList Open Source Questionnaire: Lime Survey Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2008 Share 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? Quote Link to comment Share on other sites More sharing options...
NewBudda Posted November 30, 2008 Share 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 Quote Open Source Newsletter: PhPList Open Source Questionnaire: Lime Survey Link to comment Share on other sites More sharing options...
NewBudda Posted December 12, 2008 Share Posted December 12, 2008 I still have not gotten it to work. Any ideas? Quote Open Source Newsletter: PhPList Open Source Questionnaire: Lime Survey Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2008 Share Posted December 13, 2008 I still have not gotten it to work. Any ideas? Try post 557 in this forum. Quote Link to comment Share on other sites More sharing options...
spunkypup Posted December 13, 2008 Share 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?????????? Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
random183 Posted December 24, 2008 Share 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 Quote Link to comment Share on other sites More sharing options...
acidrush Posted January 6, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
fbrace Posted January 14, 2009 Share 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????? Quote Frederick C Brace,III PA-C www.21st-tees.com (osc) www.tanda-designs.com (osc) Link to comment Share on other sites More sharing options...
gbolt Posted January 21, 2009 Share 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2009 Share 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. Quote Link to comment Share on other sites More sharing options...
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.