purchaseorder installation probelm

[haiyan]

Hi there,

I installed olby's module purchaseorder and tested in osc admin/customers/orders. I selected one order and tried to edit it, and crashed. This is the message:

 

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

1054 - Unknown column 'comments' 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, comments, currency, currency_value, account_name, account_number, po_number, date_purchased, orders_status, last_modified from orders where orders_id = '5'

 

[TEP STOP]

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

 

Seems that a field 'comments' is missing from table orders. but I did not see there is such a field from osc's installl.sql!

 

If I added this field manually, then there will be other probelm like can not find field 'new_value' ...

 

here is some configs i am using

Linx RH 7.3/php4.2.?/apache1.3.?/osCommerce2.2 ms1

module purchaseorder ver 1.2 (by olby)

 

Am i doing something wrong??? please advise.

 

Thanks in advance.

[haiyan]

Just figure it out!

It turn out that the purchaseorder module does not work with osc2.2 ms1.

 

Thanks for attention! :D

[elari]

these are field used by osc before end jan02.

 

to make purchase order working you need to readd old field

~comment

~newvalue

~oldvalue

in orders_history

[haiyan]

Thanks elari.

You are right. Acturaly i made a mistake when reading the read.doc. Instead 'alter'ing my code, i just did a forced copy (in linux) and all related codes got overwritten by the module's. And unfortunately they are not compatible.

I should check version compatibility first. It is a great module though. Thanks to olby also.

[Snowman671]

I actually have it working but it does not retun the PO numbe ron the invoice or the e-mail so retiving the PO is a pain anyone do any work on this.?