last_payment_time is not recorded for a DB
Posted: December 22nd, 2011, 1:23 am
I built the site of the newsletter using PayPal and MailChimp.
After a user completed payment of PayPal, Paid Subscr. ID is registered correctly, but wp_s2member_last_payment_time is not registered with a database.
Therefore, EOT is not calculated correctly when a user cancels subscription and EOT expires immediately.
Processing of subscr_payment is not found in paypal-ipn.log.
I think that this problem occurs because subscr_payment is not handled for some reasons.
how can I resolve this?
Thanks in advance.
paypal-ipn.log
paypal-rtn.log
After a user completed payment of PayPal, Paid Subscr. ID is registered correctly, but wp_s2member_last_payment_time is not registered with a database.
Therefore, EOT is not calculated correctly when a user cancels subscription and EOT expires immediately.
Processing of subscr_payment is not found in paypal-ipn.log.
I think that this problem occurs because subscr_payment is not handled for some reasons.
how can I resolve this?
Thanks in advance.
paypal-ipn.log
- Code: Select all
PHP v5.2.12 :: WordPress® v3.2.1 :: s2Member® v111206
Memory 21.27 MB :: Real Memory 21.75 MB :: Peak Memory 21.42 MB :: Real Peak Memory 21.75 MB
ssmm.jp/wordpress/?s2member_paypal_notify=1
User-Agent:
array (
'txn_type' => 'subscr_signup',
'subscr_id' => 'I-P6TMHFWGLW5H',
'last_name' => 'Sugimori',
'option_selection1' => 'ssmm.jp',
'option_selection2' => 'XXX.XXX.XXX.XXX',
'residence_country' => 'JP',
'mc_currency' => 'JPY',
'item_name' => '"Title In Japanese"',
'business' => 'example@gmail.com',
'recurring' => '600',
'verify_sign' => 'AmvOfkKUjfQ3VwIOqGAwnwv7My.KAgFmtZfePjK9.zK7jjOJSwsS9Ffm',
'payer_status' => 'unverified',
'payer_email' => 'example@birnimal.net',
'first_name' => 'Mitsuhiro',
'receiver_email' => 'example@gmail.com',
'payer_id' => '36ZEBTDTU6Y8A',
'option_name1' => 'Originating Domain',
'invoice' => '4ef075f3910a9~XXX.XXX.XXX.XXX',
'option_name2' => 'Customer IP Address',
'reattempt' => '1',
'item_number' => '1',
'subscr_date' => '03:51:24 Dec 20, 2011 PST',
'custom' => 'ssmm.jp',
'charset' => 'Shift_JIS',
'notify_version' => '3.4',
'period3' => '1 M',
'mc_amount3' => '600',
'ipn_track_id' => 'MjD5qU1.-aiIGSB0NEwRcw',
's2member_log' =>
array (
0 => 'IPN received on: Tue Dec 20, 2011 11:51:36 am UTC',
1 => 's2Member POST vars verified through a POST back to PayPal®.',
2 => 's2Member originating domain ( `$_SERVER["HTTP_HOST"]` ) validated.',
3 => 's2Member `txn_type` identified as ( `web_accept|subscr_signup` ).',
4 => 's2Member `txn_type` identified as ( `web_accept|subscr_signup` ) w/o update vars.',
5 => 'Signup Confirmation Email sent to: example@birnimal.net.',
6 => 'Storing IPN signup vars into a Transient Queue. These will be processed on registration.',
),
'subscr_gateway' => 'paypal',
'eotper' => NULL,
'ccaps' => NULL,
'level' => '1',
'ip' => 'XXX.XXX.XXX.XXX',
'period1' => '0 D',
'mc_amount1' => '0.00',
'initial_term' => '0 D',
'initial' => '600',
'regular' => '600',
'regular_term' => '1 M',
)
PHP v5.2.12 :: WordPress® v3.2.1 :: s2Member® v111206
Memory 20.84 MB :: Real Memory 21.75 MB :: Peak Memory 21.42 MB :: Real Peak Memory 21.75 MB
ssmm.jp/wordpress/?s2member_paypal_notify=1
User-Agent:
array (
'mc_gross' => '600',
'invoice' => '4ef075f3910a9~XXX.XXX.XXX.XXX',
'protection_eligibility' => 'Ineligible',
'payer_id' => '36ZEBTDTU6Y8A',
'payment_date' => '03:51:28 Dec 20, 2011 PST',
'payment_status' => 'Completed',
'charset' => 'Shift_JIS',
'first_name' => 'Mitsuhiro',
'option_selection1' => 'ssmm.jp',
'option_selection2' => 'XXX.XXX.XXX.XXX',
'mc_fee' => '62',
'notify_version' => '3.4',
'subscr_id' => 'I-P6TMHFWGLW5H',
'custom' => 'ssmm.jp',
'payer_status' => 'unverified',
'business' => 'example@gmail.com',
'verify_sign' => 'ADRyWYQnaasOEIbvCahG8s5HzWVZAQAnVcTA47MSCP1Zvj9lsNCRchrN',
'payer_email' => 'example@birnimal.net',
'option_name1' => 'Originating Domain',
'option_name2' => 'Customer IP Address',
'txn_id' => '59328830JF303300J',
'payment_type' => 'instant',
'last_name' => 'Sugimori',
'receiver_email' => 'example@gmail.com',
'payment_fee' => '',
'receiver_id' => '282WTKVUHY4MG',
'txn_type' => 'subscr_payment',
'item_name' => '"Title In Japanese"',
'mc_currency' => 'JPY',
'item_number' => '1',
'residence_country' => 'JP',
'transaction_subject' => '"Title In Japanese"',
'payment_gross' => '',
'ipn_track_id' => '3IcQCZgyun8xLJPWhBMmBw',
's2member_log' =>
array (
0 => 'IPN received on: Tue Dec 20, 2011 11:51:45 am UTC',
1 => 's2Member POST vars verified through a POST back to PayPal®.',
2 => 's2Member originating domain ( `$_SERVER["HTTP_HOST"]` ) validated.',
3 => 's2Member `txn_type` identified as ( `subscr_payment|recurring_payment` ).',
4 => 'Sleeping for 5 seconds. Waiting for a possible ( `subscr_signup|subscr_modify|recurring_payment_profile_created` ).',
5 => 'Awake. It\'s Tue Dec 20, 2011 11:51:51 am UTC. s2Member `txn_type` identified as ( `subscr_payment|recurring_payment` ).',
6 => 'Skipping this IPN response, for now. The Subscr. ID is not associated with a registered Member.',
7 => 'Re-generating. This IPN will go into a Transient Queue; and be re-processed during registration.',
),
'subscr_gateway' => 'paypal',
'ccaps' => NULL,
'level' => '1',
'ip' => 'XXX.XXX.XXX.XXX',
)
paypal-rtn.log
- Code: Select all
PHP v5.2.12 :: WordPress® v3.2.1 :: s2Member® v111206
Memory 18.02 MB :: Real Memory 18.50 MB :: Peak Memory 18.20 MB :: Real Peak Memory 18.50 MB
ssmm.jp/wordpress/?s2member_paypal_return=1&s2member_paypal_return_tra=fnhlOmZmMWUzMjkzY2VkZWI3YmFjMzYwNmQ4YmI0NWQ1MWVifNTk2J3WeG9nh7rol3J2g8PYQ5SYq4KidVx2baR9aLOd2MdHiNqLlGd4fp5otHVyp0O9so-K3INgg5S4hbHKspFzfbaUXX3YrKBaVWqJl4SKpYVeY4a5p1dspLNcgn91UGfYoJKZhLW6f5LMuKB4U6d3dvCppKd6luxMotGDmqFfh46ulK9xeFi_sel_e6-bf7FDe2Dki5uNTsakkmVx7LWVkUd-iYzWZ42Inpavsa_WhK5gqMKje2WDlKjI3IevlJ-OfWRro57woVlhZYyckIRleV1fhoKqb2lrm46wwqeZn9rTgprVfXmPkXvg0XRokouhsqHY0L5drFzNlK_MyHKKoqVTrnOfaX9zqX97uQ&tx=59328830JF303300J&st=Completed&amt=600&cc=JPY&cm=ssmm%2ejp&item_number=&sig=AnlDK2pM53JKmAe5s8WbO3Ncemsm2RaXxuCxOUMLW4ijRc2u6QRCp7wOYAXccaZc9MzbEeBnUWhQMCDp7oriM%2fZYyK8s8L28TJhdXpRDa3XQaae5ZG7fHOwv%2f%2fkdhGMktd%2bRNZexQKwEChbBCdRj6lRvXvM3q12Y%2fr%2fktLsOSiQ%3d
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:8.0.1) Gecko/20100101 Firefox/8.0.1
array (
'transaction_subject' => '"Title In Japanese"',
'payment_date' => '03:51:28 Dec 20, 2011 PST',
'txn_type' => 'subscr_payment',
'subscr_id' => 'I-P6TMHFWGLW5H',
'last_name' => 'Sugimori',
'option_selection1' => 'ssmm.jp',
'option_selection2' => 'XXX.XXX.XXX.XXX',
'residence_country' => 'JP',
'item_name' => '"Title In Japanese"',
'mc_currency' => 'JPY',
'business' => 'example@gmail.com',
'payment_type' => 'instant',
'protection_eligibility' => 'Ineligible',
'payer_status' => 'unverified',
'payer_email' => 'example@birnimal.net',
'txn_id' => '59328830JF303300J',
'receiver_email' => 'example@gmail.com',
'first_name' => 'Mitsuhiro',
'option_name1' => 'Originating Domain',
'invoice' => '4ef075f3910a9~XXX.XXX.XXX.XXX',
'payer_id' => '36ZEBTDTU6Y8A',
'option_name2' => 'Customer IP Address',
'receiver_id' => '282WTKVUHY4MG',
'item_number' => '1',
'payment_status' => 'Completed',
'mc_fee' => '62',
'mc_gross' => '600',
'custom' => 'ssmm.jp',
'charset' => 'Shift_JIS',
's2member_log' =>
array (
0 => 'Return-Data received on: Tue Dec 20, 2011 11:51:38 am UTC',
1 => 's2Member POST vars verified through a POST back to PayPal®.',
2 => 's2Member originating domain ( `$_SERVER["HTTP_HOST"]` ) validated.',
3 => 's2Member `txn_type` identified as ( `web_accept|subscr_signup|subscr_payment` ).',
4 => 's2Member `txn_type` identified as ( `web_accept|subscr_signup|subscr_payment` ) w/o update vars.',
5 => 'Registration Cookies set on ( `web_accept|subscr_signup|subscr_payment` ) w/o update vars.',
6 => 'Transient Tracking Cookie set on ( `web_accept|subscr_signup|subscr_payment` ) w/o update vars.',
7 => 'Redirecting Customer to Registration Page. They need to Register now.',
),
'subscr_gateway' => 'paypal',
'eotper' => NULL,
'ccaps' => NULL,
'level' => '1',
'ip' => 'XXX.XXX.XXX.XXX',
'period1' => '0 D',
'mc_amount1' => '0.00',
'period3' => '1 M',
'mc_amount3' => '600',
'recurring' => '600',
'initial_term' => '0 D',
'initial' => '600',
'regular' => '600',
'regular_term' => '1 M',
's2member_paypal_return_tra' => 'fnhlOmZmMWUzMjkzY2VkZWI3YmFjMzYwNmQ4YmI0NWQ1MWVifNTk2J3WeG9nh7rol3J2g8PYQ5SYq4KidVx2baR9aLOd2MdHiNqLlGd4fp5otHVyp0O9so-K3INgg5S4hbHKspFzfbaUXX3YrKBaVWqJl4SKpYVeY4a5p1dspLNcgn91UGfYoJKZhLW6f5LMuKB4U6d3dvCppKd6luxMotGDmqFfh46ulK9xeFi_sel_e6-bf7FDe2Dki5uNTsakkmVx7LWVkUd-iYzWZ42Inpavsa_WhK5gqMKje2WDlKjI3IevlJ-OfWRro57woVlhZYyckIRleV1fhoKqb2lrm46wwqeZn9rTgprVfXmPkXvg0XRokouhsqHY0L5drFzNlK_MyHKKoqVTrnOfaX9zqX97uQ',
)