1054 - Unknown column 'agent' in 'field list'

[gkrehbiel]

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

[gkrehbiel]

I manually added "agent" to the table and that fixed it.

[♥geoffreywalton]

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.

[gkrehbiel]

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.

[jampott]

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!)

[akact]

You need to update Supertracker table:

 

ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL;

This resolved the issue for me.

[audioshop55]

thank you very much!

 

your topic my helped resolve my problem thank you very much!

 

oscommerce for life :lol: