I'm trying out the paid adverts feature with the Paypal sandbox. The money transfer works just fine, but the IPN never makes the nodes public. I always get the following error message when the IPN comes back:

Type LM_PayPal
Date Sunday, March 18, 2007 - 4:09pm
User Anonymous
Location http://devel.chippewaguide.com/lm_paypal/ipn
Referrer
Message IPN incoming subscr_signup
Severity notice
Hostname 66.135.197.164

Type LM_PayPal
Date Sunday, March 18, 2007 - 4:09pm
User Anonymous
Location http://devel.chippewaguide.com/lm_paypal/ipn
Referrer
Message process_in cannot find ipn: 0
Severity error
Hostname 66.135.197.164

What I don't understand is why it always tries to find ipn 0 ---

I get these IPN transactions --

8 03/18/2007 - 4:09pm subscr_signup 2 (335)

id 8
timestamp Sun, 03/18/2007 - 4:09pm
processed 0
test_ipn 1
verify_sign ApTxMN2QqSjXs2vccpnf
payer_email freddy@cruiskeen.com
first_name Freddy
last_name Farkle
payer_id 6AFZ92D8SQKZL
payer_status 0
residence_country US
item_name One Year Extended Listing
quantity 0
item_number 4
receiver_email mrtestguy@chippewaguide.com
custom 21954562
mc_currency USD
txn_type subscr_signup
subscr_date 15:09:05 Mar 18, 2007 PDT
period3 1 Y
amount3 50.00
mc_amount3 50.00
recurring 0
reattempt 1
subscr_id S-9X138641AM009742E

7 03/18/2007 - 4:09pm subscr_payment 2 (335)

id 7
timestamp Sun, 03/18/2007 - 4:09pm
txn_id 6ER912017U956243M
processed 0
test_ipn 1
verify_sign A8VEUSxpa9y3gWECbIyN
payment_date 15:09:05 Mar 18, 2007 PDT
payment_status Completed
payment_type instant
payer_email freddy@cruiskeen.com
first_name Freddy
last_name Farkle
payer_id 6AFZ92D8SQKZL
payer_status 0
residence_country US
business mrtestguy@chippewaguide.com
item_name One Year Extended Listing
quantity 0
item_number 4
receiver_email mrtestguy@chippewaguide.com
receiver_id LPTTHMCL9X9GN
custom 21954562
mc_currency USD
payment_fee 1.75
payment_gross 50.00
mc_fee 1.75
mc_gross 50.00
txn_type subscr_payment
subscr_id S-9X138641AM009742E

I'm bewildered - this almost works right, but I just can't get the ads to go public.

Comments

steve hanson’s picture

steve hanson commented

Oh - by the way - this is drupal 4.7

LeeMcL’s picture

LeeMcL commented
Assigned: Unassigned » LeeMcL

Thanks for the detailed error report it really helps track things down.

It looks like the call to mysql_insert_id(); in lm_paypal.module is returning zero. Can you check which kind of database interface you are using for your site. Currently lm_paypal only works with MySQL databases using the mysql interface. So in your settings file you should have a $db_url like:

mysql://user:pass@localhost/db

Can you confirm that you are using mysql:// please?

Lee

steve hanson’s picture

steve hanson commented

Yup - mysql
$db_url = 'mysql://chippewaguide.com:password@localhost/devel_chippewaguide_com';
$db_prefix = '';

mysql 4.1.28
php 4.3.9

steve hanson’s picture

steve hanson commented

Update --
A little further investigation shows that it's the CiviCRM module. If I disable CiviCRM, then the LM_Paypal module works. So it has something or another to do with having CiviCRM enabled.

I was really hoping to be able to use CiviCRM with this project :-(.

steve hanson’s picture

steve hanson commented

Another point - Applying the patch for mysqli (http://drupal.org/node/91124) which uses drupal-style locking for the table seems to also fix the interaction with civicspace.

john franklin’s picture

john franklin commented
Status: Active » Closed (fixed)

Closing all 5.x and earlier issues. If this is still an issue, please reopen and update with 6.x or 7.x details.