PDA

View Full Version : Help with Purchase Order add



Anonymous
11-30-2002, 01:18 PM
Hello,

I have tried to install the Purchase Order contribution add-on which would be a great thing.

The complete payment system works fine if I do not have the Purchase Order checked to use in 'admin', but as soon as I check to use it, this is my problem.

BTW I have oscom snapshot November 22nd.

I have double checked everything I have done to add this module however when a customer gets to the payment page they get this... (from /checkout_shipping.php


Payment Method
1054 - Unknown column 'account_name' in 'field list'

SELECT account_name, account_number FROM orders WHERE customers_id='4' ORDER BY date_purchased DESC LIMIT 1

[TEP STOP]

I also evidently need to add these files to the dbase. How do I do that?

account_name varchar(64) default NULL,
account_number varchar(25) default NULL,
po_number varchar(13) default NULL,

I guess I best first ask, does this work with that snaphot!!

Thanks

modom
12-01-2002, 09:15 AM
Hi,

You can add those files in phpMyAdmin. Find the location where they go and use the other listings as examples.