Guest User

Untitled

a guest
Aug 15th, 2018
270
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.66 KB | None | 0 0
  1. I receive Paypal IPN fine, but my application only record it if it has been done from a paypal account. Caused by UTF-8/ISO-8859-1
  2. Started POST "/notification_paiements?secret=testsecret" for 173.0.82.126 at 2011-11-09 18:25:18 +0100
  3. Processing by NotificationPaiementsController#create as HTML
  4. Parameters: {"mc_gross"=>"287.04", "invoice"=>"36", "protection_eligibility"=>"Ineligible", "address_status"=>"unconfirmed", "item_number1"=>"1", "payer_id"=>"N9JJ8RH7BM8EU", "tax"=>"47.04", "address_street"=>"Av. de la Pelouse, 87648672 Mayet", "payment_date"=>"09:25:14 Nov 09, 2011 PST", "payment_status"=>"Completed", "charset"=>"windows-1252", "address_zip"=>"75002", "mc_shipping"=>"0.00", "mc_handling"=>"0.00", "first_name"=>"Test", "mc_fee"=>"10.01", "address_country_code"=>"FR", "address_name"=>"Test User", "notify_version"=>"3.4", "custom"=>"", "payer_status"=>"verified", "business"=>"syl_1315650606_biz@bellino.fr", "address_country"=>"France", "num_cart_items"=>"1", "mc_handling1"=>"0.00", "address_city"=>"Paris", "verify_sign"=>"AwOJnPNRFHZdnSqc35Btm-KkMwvbA-NWFOONFl0sDe.h8qfGzX3T3iVE", "payer_email"=>"sylvai_1320835836_per@bellino.fr", "mc_shipping1"=>"0.00", "txn_id"=>"67D29474V1031193M", "payment_type"=>"instant", "last_name"=>"User", "address_state"=>"Alsace", "item_name1"=>"Blopsters", "receiver_email"=>"syl_1315650606_biz@bellino.fr", "payment_fee"=>"", "quantity1"=>"2", "receiver_id"=>"VENU3QCG22URG", "txn_type"=>"cart", "mc_gross_1"=>"240.00", "mc_currency"=>"EUR", "residence_country"=>"FR", "test_ipn"=>"1", "transaction_subject"=>"Shopping CartBlopsters", "payment_gross"=>"", "ipn_track_id"=>"1HUPu0oG.fhexChWw61WQA", "secret"=>"testsecret"}
  5. Collection Load (0.6ms) SELECT `collections`.* FROM `collections`
  6. BijouType Load (0.2ms) SELECT `bijou_types`.* FROM `bijou_types`
  7. SQL (0.2ms) BEGIN
  8. AREL (0.6ms) INSERT INTO `carts` (`purchased_at`, `status`, `created_at`, `updated_at`) VALUES (NULL, 'Panier', '2011-11-09 17:25:18', '2011-11-09 17:25:18')
  9. SQL (12.4ms) COMMIT
  10. Before actualize
  11. AREL (13.6ms) UPDATE `carts` SET `updated_at` = '2011-11-09 17:25:18' WHERE (`carts`.`id` = 37)
  12. LineItem Load (0.6ms) SELECT `line_items`.* FROM `line_items` WHERE (`line_items`.cart_id = 37)
  13. After actualize
  14. SQL (0.2ms) BEGIN
  15. SQL (0.7ms) describe `notification_paiements`
  16. AREL (0.4ms) INSERT INTO `notification_paiements` (`params`, `cart_id`, `status`, `transaction_id`, `created_at`, `updated_at`) VALUES ('--- !map:ActiveSupport::HashWithIndifferentAccess nmc_gross: "287.04"ninvoice: "36"nprotection_eligibility: Ineligiblenaddress_status: unconfirmednitem_number1: "1"npayer_id: N9JJ8RH7BM8EUntax: "47.04"naddress_street: Av. de la Pelouse, 87648672 Mayetnpayment_date: 09:25:14 Nov 09, 2011 PSTnpayment_status: Completedncharset: windows-1252naddress_zip: "75002"nmc_shipping: "0.00"nmc_handling: "0.00"nfirst_name: Testnmc_fee: "10.01"naddress_country_code: FRnaddress_name: Test Usernnotify_version: "3.4"ncustom: ""npayer_status: verifiednbusiness: syl_1315650606_biz@bellino.frnaddress_country: Francennum_cart_items: "1"nmc_handling1: "0.00"naddress_city: Parisnverify_sign: AwOJnPNRFHZdnSqc35Btm-KkMwvbA-NWFOONFl0sDe.h8qfGzX3T3iVEnpayer_email: sylvai_1320835836_per@bellino.frnmc_shipping1: "0.00"ntxn_id: 67D29474V1031193Mnpayment_type: instantnlast_name: Usernaddress_state: Alsacenitem_name1: Blopstersnreceiver_email: syl_1315650606_biz@bellino.frnpayment_fee: ""nquantity1: "2"nreceiver_id: VENU3QCG22URGntxn_type: cartnmc_gross_1: "240.00"nmc_currency: EURnresidence_country: FRntest_ipn: "1"ntransaction_subject: Shopping CartBlopstersnpayment_gross: ""nipn_track_id: 1HUPu0oG.fhexChWw61WQAnsecret: testsecretnaction: createncontroller: notification_paiementsn', 36, 'Completed', '67D29474V1031193M', '2011-11-09 17:25:18', '2011-11-09 17:25:18')
  17. SQL (3.3ms) COMMIT
  18. Rendered text template (0.0ms)
  19. Completed 200 OK in 96ms (Views: 20.4ms | ActiveRecord: 32.7ms)
  20.  
  21. Started POST "/notification_paiements?secret=testsecret" for 173.0.82.126 at 2011-11-09 18:39:01 +0100
  22. Processing by NotificationPaiementsController#create as HTML
  23. Parameters: {"mc_gross"=>"143.52", "invoice"=>"38", "protection_eligibility"=>"Ineligible", "address_status"=>"unconfirmed", "item_number1"=>"1", "payer_id"=>"TVV27PV4CE9WN", "tax"=>"23.52", "address_street"=>"1 Rue molixE8re", "payment_date"=>"09:28:02 Nov 09, 2011 PST", "payment_status"=>"Completed", "charset"=>"windows-1252", "address_zip"=>"06000", "mc_shipping"=>"0.00", "mc_handling"=>"0.00", "first_name"=>"Sylvain", "mc_fee"=>"5.13", "address_country_code"=>"FR", "address_name"=>"Sylvain Bellino", "notify_version"=>"3.4", "custom"=>"", "payer_status"=>"unverified", "business"=>"syl_1315650606_biz@bellino.fr", "address_country"=>"France", "num_cart_items"=>"1", "mc_handling1"=>"0.00", "address_city"=>"Quinper", "verify_sign"=>"AqbqXETD.PxAAbSmxayIN78tg6E5A8bGf00DQNeRfx1TbcIGu8oSrIKM", "payer_email"=>"test@test.com", "mc_shipping1"=>"0.00", "txn_id"=>"7L144405TP446563S", "payment_type"=>"instant", "last_name"=>"Bellino", "address_state"=>"", "item_name1"=>"Blopsters", "receiver_email"=>"syl_1315650606_biz@bellino.fr", "payment_fee"=>"", "quantity1"=>"1", "receiver_id"=>"VENU3QCG22URG", "txn_type"=>"cart", "mc_gross_1"=>"120.00", "mc_currency"=>"EUR", "residence_country"=>"FR", "test_ipn"=>"1", "receipt_id"=>"4652-2775-4616-8599", "transaction_subject"=>"Shopping CartBlopsters", "payment_gross"=>"", "ipn_track_id"=>"gfqdiv.LSFZQPO3RomLrBw", "secret"=>"testsecret"}
  24. Collection Load (0.4ms) SELECT `collections`.* FROM `collections`
  25. BijouType Load (0.1ms) SELECT `bijou_types`.* FROM `bijou_types`
  26. SQL (0.1ms) BEGIN
  27. SQL (0.7ms) SHOW TABLES
  28. SQL (0.6ms) describe `carts`
  29. AREL (0.6ms) INSERT INTO `carts` (`purchased_at`, `status`, `created_at`, `updated_at`) VALUES (NULL, 'Panier', '2011-11-09 17:39:01', '2011-11-09 17:39:01')
  30. SQL (7.0ms) COMMIT
  31. Before actualize
  32. AREL (10.1ms) UPDATE `carts` SET `updated_at` = '2011-11-09 17:39:01' WHERE (`carts`.`id` = 45)
  33. LineItem Load (0.7ms) SELECT `line_items`.* FROM `line_items` WHERE (`line_items`.cart_id = 45)
  34. After actualize
  35. SQL (0.2ms) BEGIN
  36. SQL (0.1ms) ROLLBACK
  37. Completed in 134ms
  38.  
  39. class NotificationPaiementsController < ApplicationController
  40. protect_from_forgery :except =>[:create]
  41. skip_before_filter :authorize, :only => [:create]
  42.  
  43. def create
  44. @notification_paiement = NotificationPaiement.create!(:params => params,
  45. :cart_id => params[:invoice],
  46. :status=> params[:payment_status], :transaction_id => params[:txn_id])
  47. render :nothing=>true
  48. end
  49. end
  50.  
  51. ic = Iconv.new('UTF-8//IGNORE', 'UTF-8')
  52. vparams = {}
  53. params.each do |k,v|
  54. vparams[k]=v.force_encoding('ISO-8859-1').encode!('UTF-8')
  55. end
Add Comment
Please, Sign In to add comment