Jump to content

nixo

Members
  • Content count

    8
  • Joined

  • Last visited

Profile Information

  • Real Name
    Nicolas
  1. nixo

    Official PayPal IPN Support Thread

    Well I am using version 2.3.4.5 with no problem now :o) I think you need to use the same charset that is used to save datas in your database Nicolas
  2. nixo

    Official PayPal IPN Support Thread

    Hi Jayman11 First, you should tell us which version of paypal_ipn you are using, it might help. If you are using a version <2.3.3 , update it, so you will have this line where you can setup the right charset you use Around line 500 /******************************************************************************** ************* * Currently these are the supported charsets: * * big5, euc-jp, euc-kr, euc-tw, gb2312, hz-gb-2312, ibm-862, iso-2022-cn, iso-2022-jp, * * iso-2022-kr, iso-8859-1, iso-8859-2, iso-8859-3, iso-8859-4, iso-8859-5, iso-8859-6, * * iso-8859-7, iso-8859-8, iso-8859-9, iso-8859-13, iso-8859-15, ko18-r, shift_jis, * * utf-7, utf-8, utf-16, utf-16be, utf-16le, utf-16_platformendian, utf-16_oppositeendian, * * utf-32, utf-32be, utf-32le, utf-32_platformendian, utf-32_oppositeendian, usa-ascii, * * windows-1250, windows-1251, windows-1252, windows-1253, windows-1254, windows-1255, * * windows-1256, windows-1257, windows-1258, windows-874, windows-949, x-mac-greek, * * x-mac-turkish, x-mac-centraleurroman, x-mac-cyrillic, ebcdic-cp-us, ibm-1047 * *************************************************************************** *******************/ $parameters['charset'] = "iso-8859-2"; // Modify this line if you have problems with the character set. // EOF parameters fix by AlexStudio Hope this will help Nicolas
  3. nixo

    Official PayPal IPN Support Thread

    Hi ski2bbad, All that I have done is modifying the tep_db_insert_id() function in both the admin and catalog side ( ie: in catalog/includes/function/database.php and in admin/includes/function/database.php) Replace : function tep_db_insert_id() { return mysql_insert_id(); } by function tep_db_insert_id($link = 'db_link') { global $$link; return mysql_insert_id( $$link ); } That's it Nicolas
  4. nixo

    Official PayPal IPN Support Thread

    Ok I finally found with the help of Shoprun on the french osc forum :o) I just have to modify the tep_db_insert_id() function in /includes/function/database.php and as well in the admin side function tep_db_insert_id($link = 'db_link') { global $$link; return mysql_insert_id( $$link ); } Thanks Nicolas
  5. nixo

    Official PayPal IPN Support Thread

    Hi again, after many hours reading the ENTIRE thread, many hours doing some testing, I am now pretty sure that my problem of orders_id ( see my two posts before) come from this part of paypal_ipn.php around line 200: it is in the confirmation() function tep_db_perform(TABLE_ORDERS, $sql_data_array); $insert_id = tep_db_insert_id(); It seems that tep_db_insert_id() doesn't return any value (so $insert_id = 0) For memory I am using PHP 5.2.4 with MySQL 4.1.22 and curl enabled (libcurl/7.15.5 OpenSSL/0.9.8c zlib/1.2.3 libidn/0.6.5 ) on an up-to-date MS2.2 I use the last paypal_ipn.php posted by AlexStudio. Ok, I have an issue with curl but I don't think it matters as proved in my debug ipn.php log in previous post When using another payment module, the same part of code in checkout process give me the good orders_id and everything is going well. I am sure of that fact because I used some error_log debugging to verify it. Help, please :blink: Thanks Nicolas
  6. nixo

    Official PayPal IPN Support Thread

    Hi platte, Try the above code, it should work. $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_CUSTOMER_ID . ' ' . (int)$_POST['custom'] . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $_POST['invoice'] . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $_POST['invoice'], 'SSL', false) . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n" . EMAIL_SEPARATOR . "\n" . EMAIL_PAYPAL_PENDING_NOTICE . "\n\n";
  7. nixo

    Official PayPal IPN Support Thread

    Hi again, I failed to edit my previous post so I made a new one. There are more infos on my configuration I am using : paypal_ipn 2.3.4.5 with MySQL - 4.1.22 - Oscommerce MS2 updated Paypal_ipn module configuration : aggregate - move tax... : true Reading the 170 first pages of this thread (for now) and the 2.3.3 installation guide) I have done some fixes : 1. Fix for the empty state field in paypal_ipn.php if (empty($state_abbr)) $state_abbr = 'none'; 2 . the fix for the MS2 bug in both the admin and catalog compatibilty files As mentionned in my previous post (and proved by the debug log), the ipn.php part seems OK The only problem is that the orders_id does not exists ( in fact it is equal to 0 in my orders_total, orders_products and orders_status_history tables but set to the right orders_id in my orders table) So I think that maybe my problem comes from the paypal_ipn.php part (because others payment module works great) Thanks again :rolleyes:
  8. nixo

    Official PayPal IPN Support Thread

    Hi, thanks for the great job and sorry for my english. I am having a strange issue with a paypal_ipn_2.4.5 version Everything is going well in the customer side, but it doesn't receive the confirmation mail from the store I don't receive the confirmation mail from the store on the admin side but I receive the payment confirmation from Paypal There is the debug (v 2.3.3) PP TEST start PP TEST PayPal is accessing the ipn file PP TEST we have successfuly loaded application top and language file PP TEST PayPal IPN module successfully loaded PP TEST we are assembling the reply: cmd=_notify-validate&mc_gross=3.90&protection_eligibility=None&address_status=unconfirmed&payer_id=SK3VUDC48VJNE&tax=0.00&address_street=there_was_the_address&payment_date=14%3A08%3A32+Sep+22%2C+2008+PDT&payment_status=Completed&charset=windows-1252&address_zip=zip_code&first_name=Nicolas&mc_fee=0.38&address_country_code=FR&address_name=Nicolas+RIAS&notify_version=2.5&custom=740&payer_status=verified&business=mail_address&address_country=France&address_city=Anglet&quantity=1&verify_sign=A4nS7c8NGYVTCR33hXFRNJaV.m3UAknJMpwQMHCT2SbPkhfPj0RESP8j&payer_email=customer_email&txn_id=3G979696EK087712G&payment_type=instant&last_name=RIAS&address_state=&receiver_email=mail_address&payment_fee=&receiver_id=LJJ9J3T2FLXW8&txn_type=web_accept&item_name=store_name&mc_currency=EUR&item_number=&residence_country=FR&payment_gross=&shipping=0.00 PP TEST PayPal server is www.paypal.com PP TEST option1 - fsocket is true, port 443 PP TEST option1+3 we start to send string PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 we're receiving PayPal reply PP TEST option1+3 REPLY: VERIFIED PP TEST result is VERIFIED PP TEST order id is: PP TEST order id problem - cannot verify order id PP TEST end Obviously the orders_id is missing As today I was just updating the database manually, adding the right orders_id where it was needed but it's getting harder now. So if someone has just a little idea it will be great Thanks a lot :blush: Cheers Nicolas MySQL - 4.1.22 if needed I can give the entire files (checkout_process.php, ipn.php and paypal_ipn.php)
×