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

[stefan_p]

I have this communicate when I enter shipping address options:

 

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

 

select '' as firstname,'' as company, efc.value as firstname, entry_nip as nip, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from address_book left join customers_to_extra_fields efc on efc.customers_id = address_book.customers_id where address_book.customers_id = '2' and efc.fields_id = 1 and address_book_id = '2'

 

[TEP STOP]

 

http://sklep.taski.pl/screen.jpg - check the screen

 

When I try to enter checkout_shipping.php I get this error:

 

1054 - Unknown column 'ab.entry_nip' in 'field list'

 

select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_nip, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) where c.customers_id = '2' and ab.customers_id = '2' and c.customers_default_address_id = ab.address_book_id

 

[TEP STOP]

 

 

Can anybody help mi with these problems??

 

Thanks

[Jack_mcs]

The 'ab.entry_nip' is not a standard oscommerce field. You will need to check the contribution that made that change. It probably required a database upload that wasn't done.

 

Jack