1045 Unknown colum

[jibo97]

Greetings,

 

I need some assistance in resolving the following error mesage that i get when i try to add a new field (customer input in checkout_shipping). I'm new at OsCommerce and I am basically lost.

 

 

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

 

select orders_status_id, date_added, customer_notified, comments, associd from orders_status_history where orders_id = '21' order by date_added

 

[TEP STOP]

 

I'm trying to include a field so my customers can add a sales associate number. Any help will be greatly appreciated.

 

Thanks

Tom

[♥yesudo]

you need to add the field - associd - to the relevant table in the database.

[jibo97]

hello again and thanks for your input.

 

Do you know where this table reside within the database?

As I said I'm new to OsCommerce and don't know my way around. I basically copied the "comments" field to get where I am now. I did change checkout_shipping.php in both language and catalog dir and order in admin. Does this table is within these files or stored somewhere else?

 

Thanks again,

Tom