Someone please help! installed paypalipn v097 now this!

[Guest]

Read most of the threads regarding error below.

Did not understand, or get close to a answer.

=================

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

 

select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '145'

 

[TEP STOP]

 

==========================

That shows when customer views history.

Also when I switch on paypalipn and go to checkout the paypalipn

option has this:

Paypal Ipn

Array

What could the array fault be?

I'm using Nov 2.2 snap.

========================

Please reply using PLAIN ENGLISH please!

I'm still learning!

Jeff.

[Guest]

ok, If you receive this error when viewing customer history after installing paypal ipn v097 on a Nov 2.2 snapshot. It means your database is missing the below:

 

ALTER TABLE `orders` ADD customers_company varchar(32) AFTER `customers_name`, ADD delivery_company varchar(32) AFTER `delivery_name`, ADD `billing_name` varchar(64) NOT NULL AFTER `delivery_address_format_id`, ADD `billing_company` varchar(32) AFTER `billing_name`, ADD `billing_street_address` varchar(64) NOT NULL AFTER `billing_company`, ADD `billing_suburb` varchar(32) AFTER `billing_street_address`, ADD `billing_city` varchar(32) NOT NULL AFTER `billing_suburb`, ADD `billing_postcode` varchar(10) NOT NULL AFTER `billing_city`, ADD `billing_state` varchar(32) AFTER `billing_postcode`, ADD `billing_country` varchar(32) NOT NULL AFTER `billing_state`, ADD `billing_address_format_id` int(5) NOT NULL AFTER `billing_country`;

 

Add these into your database and all shood work ok.