markswall
02-26-2007, 07:19 AM
Hello, I've installed the tables correctly with no problems into my MySQL Db, I also have some actions being updated into tmp/activity.php
I have paypal IPN set to [url] /paypal/index.php
But
I have no record of the transaction in the MySQL db
I have no records when I search for ALL or any transactions
I've read elsewhere from 2006 posts that the PHP paypal assistant is quite buggy with problems for POST functionality. I am planning to use this so do you suggest buying/using the cgi version instead?
I am prepared to do what it takes to get this working
There are no real bugs that should affect your installation.
First, when you say there is data in the activity file, what does this data in general show (without posting any email addresses)?
markswall
02-27-2007, 03:52 AM
Please find the contents attached in the .txt file. The final transaction is the only real i.e. non test transaction.
markswall
02-27-2007, 05:29 AM
Interestingly, I created a wildcard search and this IS in the database.
however there is NO ipn history in the database nor available for viewing through the web browser.
Any suggestions ?
Could you answer my previous question please?
markswall
02-27-2007, 12:31 PM
Could you answer my previous question please?
Hello, thanks for the reply - I did in the post above my last one. Sorry for the confusion.
Today 07:52 AM
markswall Please find the contents attached in the .txt file. The final transaction is the only real i.e. non test transaction.
cmd=_notify-validate&mc_gross=0.01&address_status=unconfirmed&payer_id=QGVDAFGZ9XHLJ&tax=0.00&payment_date=20%3A50%3A26+May+20%2C+2004+PST&address_street=12340+main+st&payment_status=Pending&address_zip=94303&first_name=firstname&address_name=address_name¬ify_version=1.6&custom=custom&payer_status=unverified&business=you%40email.com&address_country=United+States&address_city=Los+Angeles&quantity=1&verify_sign=AkU-lzGsIkV0gazwa9nDVpmsx9X0AMF3KqbmhBuM8UTVNO5CFNAptk +78&payer_email=buyer%40email.com&txn_id=4MX09190KB7728256&payment_type=instant&last_name=last_name&address_state=CA&receiver_email=test%40test.com&receiver_id=WAT63H8628SRN&pending_reason=verify&txn_type=web_accept&item_name=Test&mc_currency=GBP&item_number=&payment_gross=0.01 cmd=_notify-validate&mc_gross=0.01&address_status=unconfirmed&payer_id=QGVDAFGZ9XHLJ&tax=0.00&payment_date=20%3A50%3A26+May+20%2C+2004+PST&address_street=12340+main+st&payment_status=Pending&address_zip=94303&first_name=firstname&address_name=address_name¬ify_version=1.6&custom=custom&payer_status=unverified&business=you%40email.com&address_country=United+States&address_city=Los+Angeles&quantity=1&verify_sign=AkU-lzGsIkV0gazwa9nDVpmsx9X0AMF3KqbmhBuM8UTVNO5CFNAptk +78&payer_email=buyer%40email.com&txn_id=4MX09190KB7728256&payment_type=instant&last_name=last_name&address_state=CA&receiver_email=test%40test.com&receiver_id=WAT63H8628SRN&pending_reason=verify&txn_type=web_accept&item_name=Test&mc_currency=GBP&item_number=&payment_gross=0.01 cmd=_notify-validate&mc_gross=0.01&address_status=unconfirmed&payer_id=QGVDAFGZ9XHLJ&tax=0.00&payment_date=20%3A50%3A26+May+20%2C+2004+PST&address_street=12340+main+st&payment_status=Pending&address_zip=94303&first_name=firstname&address_name=address_name¬ify_version=1.6&custom=custom&payer_status=unverified&business=you%40email.com&address_country=United+States&address_city=Los+Angeles&quantity=1&verify_sign=AkU-lzGsIkV0gazwa9nDVpmsx9X0AMF3KqbmhBuM8UTVNO5CFNAptk +78&payer_email=buyer%40email.com&txn_id=4MX09190KB7728256&payment_type=instant&last_name=last_name&address_state=CA&receiver_email=mark.s.wall%40gmail.com&receiver_id=WAT63H8628SRN&pending_reason=verify&txn_type=web_accept&item_name=Test&mc_currency=GBP&item_number=&payment_gross=0.01 cmd=_notify-validate&mc_gross=0.01&address_status=unconfirmed&payer_id=QGVDAFGZ9XHLJ&tax=0.00&payment_date=20%3A50%3A26+May+20%2C+2004+PST&address_street=12340+main+st&payment_status=Pending&address_zip=94303&first_name=firstname&address_name=address_name¬ify_version=1.6&custom=custom&payer_status=unverified&business=you%40email.com&address_country=United+States&address_city=Los+Angeles&quantity=1&verify_sign=AkU-lzGsIkV0gazwa9nDVpmsx9X0AMF3KqbmhBuM8UTVNO5CFNAptk +78&payer_email=buyer%40email.com&txn_id=4MX09190KB7728256&payment_type=instant&last_name=last_name&address_state=CA&receiver_email=mark.s.wall%40gmail.com&receiver_id=WAT63H8628SRN&pending_reason=verify&txn_type=web_accept&item_name=Test&mc_currency=GBP&item_number=&payment_gross=0.01 cmd=_notify-validate&mc_gross=0.01&address_status=unconfirmed&payer_id=QGVDAFGZ9XHLJ&tax=0.00&payment_date=20%3A50%3A26+May+20%2C+2004+PST&address_street=12340+main+st&payment_status=Pending&address_zip=94303&first_name=firstname&address_name=address_name¬ify_version=1.6&custom=custom&payer_status=unverified&business=you%40email.com&address_country=United+States&address_city=Los+Angeles&quantity=1&verify_sign=AkU-lzGsIkV0gazwa9nDVpmsx9X0AMF3KqbmhBuM8UTVNO5CFNAptk +78&payer_email=buyer%40email.com&txn_id=4MX09190KB7728256&payment_type=instant&last_name=last_name&address_state=CA&receiver_email=40gmail.com&receiver_id=WAT63H8628SRN&pending_reason=verify&txn_type=web_accept&item_name=Test&mc_currency=GBP&item_number=&payment_gross=0.01 cmd=_notify-validate&mc_gross=18.99&for_auction=true&address_status=confirmed&item_number1=280084075099&payer_id=8E8W3GCE96XNU&tax=0.00&address_street=16%0D%0ALl&payment_date=08%3A48%3A27+Feb+26%2C+2007+PST&payment_status=Completed&charset=windows-1252&auction_closing_date=11%3A10%3A51+Feb+24%2C+2007+P ST&address_zip=cf23+6uw&first_name=Malcolm&auction_buyer_id=mal&mc_fee=0.85&address_country_code=GB&address_name=Malcolm¬ify_version=2.1&custom=&payer_status=verified&business=u&num_cart_items=1&address_country=United+Kingdom&address_city=Card&quantity=1&verify_sign=AFcWxV21C7fd0v3iaPJ7tPrF7lsen1VkQ&payer_email=redf&txn_id=6JV638856U6921928&payment_type=instant&last_name=Haney&item_name1=gate&address_state=Cardiff&receiver_email=ukgmail.com&payment_fee=&quantity1=1&receiver_id=MXGG9FLVG2&txn_type=web_accept&item_name=AM&mc_currency=GBP&item_number=28008099&residence_country=GB&payment_gross=&shipping=5.99
So you see these in the wildcard history but no other history? It sounds like you did not create a proper item to handle said sales. Are you sure you created proper IPN actions for these items?
markswall
02-28-2007, 03:12 PM
Database is now being updated. CLosing off this ticket and raising another one about email triggers.