PayPal IPN Broke with 1054 Unknown column

[[email protected]]

Hi Forum, anyone able to shed any light on where this error has come from?

 

1054 - Unknown column 'products_stock_attributes' in 'field list'

 

insert into orders_products (orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity, products_stock_attributes) values ('20', '47', '123456', 'Virtualware', '0.0000', '0', '0', '2', '')

 

[TEP STOP]

 

I have just installed the PayPal IPN Payment Modue v2.1 plus the Paypal IPN v2.2 with QTPro-PROPER, having followed the destructions, I received this error on the payment confirmation page?

 

The steps I followed were:

 

1. Created PayPal Sandbox account

2. Downloaded contributions from forum

3. Copied following files v2.1

root/httpdocs/shop/ext/modules/payment/paypal_ipn/ipn.php

root/httpdocs/shop/includes/languages/english/modules/payment/paypal_ipn.php

root/httpdocs/shop/includes/modules/payment/paypal_ipn.php

4. copied following files from v2.2

root/httpdocs/shop/ext/modules/payment/paypal/paypal_ipn.php

root/httpdocs/shop/includes/classes/order.php

root/httpdocs/shop/includes/modules/payment/paypal_ipn.php

5. Than repeated steps 3 & 4 to httpsdocs folder

6. Went to admin module and installed PayPal_IPN module

7. Configured using default values except for email address

8. Tested and received above error and spent the next few hours going mad????

 

I haven't changed any code in any of the copied files, please can someone tell what I have missed?

 

Thanks

[[email protected]]

Hi Forum, anyone able to shed any light on where this error has come from?

 

1054 - Unknown column 'products_stock_attributes' in 'field list'

 

insert into orders_products (orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity, products_stock_attributes) values ('20', '47', '123456', 'Virtualware', '0.0000', '0', '0', '2', '')

 

[TEP STOP]

 

I have just installed the PayPal IPN Payment Modue v2.1 plus the Paypal IPN v2.2 with QTPro-PROPER, having followed the destructions, I received this error on the payment confirmation page?

 

The steps I followed were:

 

1. Created PayPal Sandbox account

2. Downloaded contributions from forum

3. Copied following files v2.1

root/httpdocs/shop/ext/modules/payment/paypal_ipn/ipn.php

root/httpdocs/shop/includes/languages/english/modules/payment/paypal_ipn.php

root/httpdocs/shop/includes/modules/payment/paypal_ipn.php

4. copied following files from v2.2

root/httpdocs/shop/ext/modules/payment/paypal/paypal_ipn.php

root/httpdocs/shop/includes/classes/order.php

root/httpdocs/shop/includes/modules/payment/paypal_ipn.php

5. Than repeated steps 3 & 4 to httpsdocs folder

6. Went to admin module and installed PayPal_IPN module

7. Configured using default values except for email address

8. Tested and received above error and spent the next few hours going mad????

 

I haven't changed any code in any of the copied files, please can someone tell what I have missed?

 

Thanks

 

Sorted this problem by reversing out the changes and only applying the PayPal IPN Payment Modue v2.2, above I repoted 2.1 when it should have been 2.2 (my error) and then not loading the QTPro-PROPER contribution and all now works. What a difference a nights sleep makes??

 

Brian.