gkrehbiel Posted February 10, 2008 Share Posted February 10, 2008 The complete error message follows. 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 ('71.191.73.43','Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12','us', 'United States', 'http://crowhill.net/osCommerce/catalog/admin/stats_products_purchased.php', 'selected_box=reports&osCAdminID=59a9aa3e4ebaec60d45a3746822fac59','/osCommerce/catalog/','/osCommerce/catalog/index.php','2008-02-10 12:36:23','2008-02-10 12:36:23','') [TEP STOP] How do I fix this? Thanks, Greg Quote Link to comment Share on other sites More sharing options...
gkrehbiel Posted February 10, 2008 Author Share Posted February 10, 2008 I manually added "agent" to the table and that fixed it. Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted February 11, 2008 Share Posted February 11, 2008 The real question is what step in the installation of a contribution was missed out. I would guess the sql to update the db was not run. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
gkrehbiel Posted February 11, 2008 Author Share Posted February 11, 2008 I would guess the sql to update the db was not run. No, I ran it. If I hadn't, it wouldn't be a matter of one field missing. There wouldn't have been a table at all. The file supertracker_setup_db.php doesn't have a line to add the field "agent" into the supertracker table. I should note that I also installed salestracker, so it's possible the problem is the interaction between those two add-ons. Quote Link to comment Share on other sites More sharing options...
jampott Posted March 7, 2008 Share Posted March 7, 2008 No, I ran it. If I hadn't, it wouldn't be a matter of one field missing. There wouldn't have been a table at all. The file supertracker_setup_db.php doesn't have a line to add the field "agent" into the supertracker table. I should note that I also installed salestracker, so it's possible the problem is the interaction between those two add-ons. Can you tell a newbie exactly what you added? Ta :) (oh, and how!) Quote Link to comment Share on other sites More sharing options...
akact Posted May 10, 2008 Share Posted May 10, 2008 You need to update Supertracker table: ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL; This resolved the issue for me. Quote Link to comment Share on other sites More sharing options...
audioshop55 Posted August 26, 2008 Share Posted August 26, 2008 thank you very much! your topic my helped resolve my problem thank you very much! oscommerce for life :lol: 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.