Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Beezer2005

Recommended Posts

HI..I've just installed the PayPal_IPN version 3.1.5 and everything works great until paypal returns me to checkout_success.php and then I receive the following error:

 

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

 

select payment_id from orders where orders_id = 6

 

I have no idea how to fix this and have read so much in the forums that I'm totally confused. Our store is Live and We only use Paypal so if someone could please tell Us what to do in laymans terms ASAP, We will be forever grateful!!!

 

Thanks In Advance

Bill & Tashia

 

:(

Link to comment
Share on other sites

HI..I've just installed the PayPal_IPN version 3.1.5 and everything works great until paypal returns me to checkout_success.php and then I receive the following error:

 

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

 

select payment_id from orders where orders_id = 6

 

I have no idea how to fix this and have read so much in the forums that I'm totally confused. Our store is Live and We only use Paypal so if someone could please tell Us what to do in laymans terms ASAP, We will be forever grateful!!!

 

Thanks In Advance

Bill & Tashia

 

:(

 

 

I also have an error in admin/orders.php it's as follows

 

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

 

select p.payment_status from paypal p left join orders o on p.paypal_id = o.payment_id where o.orders_id ='6'

 

PLEASE HELP!!!

 

Bill & Tash

Link to comment
Share on other sites

Looks like you did not run an sql file, or add information to your database that you need for this to run. It should have come with the contribution.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

Looks like you did not run an sql file, or add information to your database that you need for this to run. It should have come with the contribution.

 

 

I know that's what it seems like but I did run the paypal sql file included and commented out the 3 lines the install said to do.

:blink:

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.

Guest
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...