i need help resolving some error related to paypal returning a confirmation of sales back to the website. when it gets executed, there is an error, we dont get the confirmation and paypal tried again later on, resending the same confirmation.
here is the error log:
Type php
Date Thursday, 2 July 2009 - 11:55am
User Anonymous
Location http://xxxxxxx.net/lm_paypal/ipn
Referrer
Message Unknown column 'confirmed' in 'field list' query: INSERT INTO lm_paypal_ipns (timestamp, mc_gross, address_status, payer_id, tax, address_street, payment_date, payment_status, address_zip, first_name, mc_fee, address_country_code, address_name, custom, payer_status, business, address_country, address_city, quantity, verify_sign, payer_email, txn_id, payment_type, last_name, address_state, receiver_email, payment_fee, receiver_id, txn_type, item_name, mc_currency, residence_country, payment_gross, shipping) VALUES (1246557318, 30.00, confirmed, ............) in /home/xxxxxx/public_html/modules/lm_paypal/lm_paypal.module on line 588.
Severity error
Hostname **.**.**.**
Operations
-------------------------------------------------------
Type LM_PayPal
Date Thursday, 2 July 2009 - 11:55am
User Anonymous
Location http://xxxx.net/lm_paypal/ipn
Referrer
Message IPN in failed to run sql: INSERT INTO {lm_paypal_ipns} (timestamp, mc_gross, address_status, payer_id, tax, address_street, payment_date, payment_status, address_zip, first_name, mc_fee, address_country_code, address_name, custom, payer_status, business, address_country, address_city, quantity, verify_sign, payer_email, txn_id, payment_type, last_name, address_state, receiver_email, payment_fee, receiver_id, txn_type, item_name, mc_currency, residence_country, payment_gross, shipping) VALUES (1246557318, 30.00, confirmed, .........................)
Severity error
Hostname **.**.**.**
Operations
Comments
any one have any ideas at
any one have any ideas at all?
I am still unable to figure
I am still unable to figure out what I need to do, in order to resolve the errors above. Can any one please help me?
User?
I dont know this module at all, but one thing that strikes me is that the error message is about the anonymous user.
I don't think an anonymus user should be able to use paypal on your site.
Maybe anonymous users have permsiion to use the module and should not?
This is a shot in the dark but maybe it will help.
afaik that is part of how
afaik that is part of how paypal sends the information back to the site. it was working fine, but now its not.
WHUT
Hey did you ever find help for this problem... because I think I ran into it today. Does no one else use this feature?
The following fix worked for me: http://drupal.org/node/356435
I don't think it's been backported to the "production version".
Steve Ramos
www.zapcrunch.com