PayPal IPN [TEP STOP]

[baesic2]

This is the complete error message i get when looking at account

 

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

 

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

 

[TEP STOP]

[baesic2]

When making a purchase through the check out process seems to wotk flawlessly however when trying to retrieve information on orders whether in admin or customer account area and attempt to look at

 

"customer Acount"previous order information or ivoice thriough admin I get the following errors

 

can anyone assist me in making the corrections to my palpal IPN

 

Here is the error code

 

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

 

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

 

[TEP STOP]

[MarcoZorro]

The cause of this is one of your changes has added the field products_options_id into the query to select the data but this field does not exist in the database.

 

You need to either edit the query or add the field to the database.

 

I take it you didnt add the official IPN module?

 

http://www.oscommerce.com/community/contributions,2679

 

If not I would consider using the above as its as easy to install as uploading 2 files. The file from 10 Feb 2005 seems to be ok. The last update was made by some fool and doesnt work and isnt even paypal related.

[baesic2]

The cause of this is one of your changes has added the field products_options_id into the query to select the data but this field does not exist in the database.

 

You need to either edit the query or add the field to the database.

 

I take it you didnt add the official IPN module?

 

http://www.oscommerce.com/community/contributions,2679

 

If not I would consider using the above as its as easy to install as uploading 2 files. The file from 10 Feb 2005 seems to be ok. The last update was made by some fool and doesnt work and isnt even paypal related.

<{POST_SNAPBACK}>

 

That copy doesn't seem to work when downloading it from the contribution page from that and I download 10 Feb 2005 I get a txt file Preloader text file. I do not think that is what I am looking for either. Thank you for your assistance. If you have any other suggestions please feel free to assist me.

[MarcoZorro]

That copy doesn't seem to work when downloading it from the contribution page from that and I download 10 Feb 2005 I get a txt file Preloader text file. I do not think that is what I am looking for either. Thank you for your assistance. If you have any other suggestions please feel free to assist me.

<{POST_SNAPBACK}>

 

You need to install the full contrribution not just the update, in any case just add the field to the database and the error will do away.

[Guest]

You have modified files - there is an error in your queries, since the table 'orders_products_attributes' does not have a column named 'products_options_id' :blink:

 

Correct the database queries :D

 

Perhaps you should use the official IPN module which doesn't require you to alter files :thumbsup:

 

Matti

[MarcoZorro]

You have modified files - there is an error in your queries, since the table 'orders_products_attributes' does not have a column named 'products_options_id'    :blink:

 

Correct the database queries  :D

 

Perhaps you should use the official IPN module which doesn't require you to alter files  :thumbsup:

 

Matti

<{POST_SNAPBACK}>

 

Exactly what I said in baesic2's other post that he seemed to want to ignore :)

[baesic2]

This is the complete error message i get when looking at account

 

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

 

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

 

[TEP STOP]

<{POST_SNAPBACK}>

 

thank you for your assistance I did a complete drop all table and a complete re-install and put the oscommerce_paypal_ipn contribution in with 2 files and for noe in sandbox mode it's working fine now just to fine tune and get the invoice information to pass through to paypal, any ideas?

 

Thank you I aooreciate you taking the time and pointing me in the right direction.

[baesic2]

The cause of this is one of your changes has added the field products_options_id into the query to select the data but this field does not exist in the database.

 

You need to either edit the query or add the field to the database.

 

I take it you didnt add the official IPN module?

 

http://www.oscommerce.com/community/contributions,2679

 

If not I would consider using the above as its as easy to install as uploading 2 files. The file from 10 Feb 2005 seems to be ok. The last update was made by some fool and doesnt work and isnt even paypal related.

<{POST_SNAPBACK}>

 

Thanks so much I finally got it running without problems. All assistance and any cross posting was an error on my part thinking they were of the same nature of topic.