haiyan Posted February 24, 2003 Share Posted February 24, 2003 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. Quote Link to comment Share on other sites More sharing options...
haiyan Posted February 24, 2003 Author Share Posted February 24, 2003 Just figure it out! It turn out that the purchaseorder module does not work with osc2.2 ms1. Thanks for attention! :D Quote Link to comment Share on other sites More sharing options...
elari Posted February 24, 2003 Share Posted February 24, 2003 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 Quote Link to comment Share on other sites More sharing options...
haiyan Posted February 24, 2003 Author Share Posted February 24, 2003 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. Quote Link to comment Share on other sites More sharing options...
Snowman671 Posted March 19, 2003 Share Posted March 19, 2003 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.? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.