Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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?




Link to comment
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...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...