ortho Posted June 21, 2005 Share Posted June 21, 2005 Just installed IPN vs 1.2. Created a sandbox account and when trying it out get the following error on the oders conformation page. Nothing else happens 1054 - Unknown column 'billing_piva' in 'field list' insert into orders (customers_id, 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, billing_piva, billing_cf, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_nam..... [TEP STOP] Any help with fixing this would be greatly appreciated. Thanks. Quote Link to comment Share on other sites More sharing options...
brainbabe Posted June 30, 2005 Share Posted June 30, 2005 Hi, any luck getting the billing_piva issue fixed? I am in the same boat, can't seem to find anything about it here directly except for your post. Can you read italian? Doing a google search for the error line turns up what looks like good info regarding this problem... Please provide solution if you have one! Quote Link to comment Share on other sites More sharing options...
judebert Posted August 4, 2005 Share Posted August 4, 2005 Just comment it out of your paypal_ipn.php module. Hi, any luck getting the billing_piva issue fixed? I am in the same boat, can't seem to find anything about it here directly except for your post. Can you read italian? Doing a google search for the error line turns up what looks like good info regarding this problem... Please provide solution if you have one! <{POST_SNAPBACK}> Anyway, I did a Google search on "billing_piva" and came up with an Italian Forum where they claim the field is from the "P.IVA" contribution. Later there's talk about IVA as a tax number. More Googling indicates that Italian web stores must include an invoice number, apparently called an "IVA", in every invoice. Frankly, I'm thinking it's like an American tax number: something that indicates you don't have to pay taxes, because you'll collect them when you resell. If you're not running an Italian store, or selling to Italian resellers, I assume it's safe to eliminate the billing_piva field. Quote If this were easy, everybody would do it. 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.