Shipping Status v. 1.0 for 2.2ms2 ???

[Guest]

I just added Shipping Status v. 1.0 for 2.2ms2

 

If i try to edit, invoice etc i get this error

 

 

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

 

select 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, currency, currency_value, date_purchased, orders_status, last_modified, tracking_no, ship_date, delivery_date from orders where orders_id = '10'

 

[TEP STOP]

 

I've rechecked all the modifications and it appears i did it correct.

 

Any ideas?

[Guest]

OK the file shippingstatus.sql

 

had this

 

ALTER TABLE `orders` ADD `confirmation_no` TEXT;

 

changed to

 

ALTER TABLE `orders` ADD `tracking_no` TEXT;

 

problem solved!

[tammy507]

I just added this GREAT contribution!! Works perfect, except when a customer pays using paypal??? I know absolutely nothing about PHP, however I can follow directions and am willing to try if someone knows what to put where to get it to work with paypal customers.

 

Thanks in advance for any help

Tammy