Jump to content
Sign in to follow this  

Error during test

Recommended Posts

I get the following error when testing the paypal shopping cart ipn:


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


select products_options_id, products_options, products_options_values_id, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '2147483647' and orders_products_id = '3'


I have intslalled the the ips several times to no avail. I have triple checked the install instructions, looked on the borad but find no answer.


I also get the following error from the "orders" in admin:


1054 - Unknown column 'o.paypal_ipn_id' in 'on clause'


select p.payment_status from paypal p left join orders o on p.paypal_ipn_id = o.paypal_ipn_id where o.orders_id ='2147483647'


ANy ides?




Share this post

Link to post
Share on other sites

Yup, post this in the paypal ipn support thread.


Sounds like you didn't run the sql query, but either way, this is the wrong place to post.

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)


Replace that and you're fine...

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this