Geert-K Posted September 11, 2005 Share Posted September 11, 2005 I haven't had this problem before... This is in the admin area, when I click on invoice or packing slip I get this message: 1054 - Unknown column 'purchase_order_number' 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, purchase_order_number, date_purchased, orders_status, last_modified from orders where orders_id = '2' If someone can help me with this i would be very thankfull. Link to comment Share on other sites More sharing options...
♥yesudo Posted September 11, 2005 Share Posted September 11, 2005 Looks like an additional field to the basic db - have you added a contribution recently - as check for the sql that came with it. Your online success is Paramount. Link to comment Share on other sites More sharing options...
Geert-K Posted September 11, 2005 Author Share Posted September 11, 2005 I added INVOICE 1.3 As far as I know it didn't come with any sql..but I have another check..for insurance Link to comment Share on other sites More sharing options...
Geert-K Posted September 11, 2005 Author Share Posted September 11, 2005 There is nothing I had to be adding to the DB after installing Invoice 1.30... The contribution Invoice 1.30 works flawless tho..the rest of the site also..except for this little thing.. Link to comment Share on other sites More sharing options...
nana Posted September 12, 2005 Share Posted September 12, 2005 purchase_order_number is what is missing just add a column to your orders table you can use phpmyadmin in your cpanel or whatever mysql program that is available to you. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.