Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

tgely

Team
  • Posts

    2,159
  • Joined

  • Last visited

  • Days Won

    51

Posts posted by tgely

  1. 3. Finally I have issue with special caracter like "à, ô, ï" (etc.)  when I use the search button, no product found each time.

    I have checked the sentence in content_searches.php but it look like your fix :

    urlencode(str_replace(' ', ' ', $query))
    

    An idea of the fix to apply for french language process?

     

     

    Thank you very much for this amazing contribution.  :thumbsup:

     

    http://www.oscommerce.com/forums/topic/407969-store-search-bar-bs/page-2#entry1743820

  2. @@astecme Why dont you use IPN? IPN ensure to close of payments.


     

     

    Notes Order Processing

    When the customer goes through the checkout procedure and lands on the checkout confirmation page, their order is saved in the database with a private order status (by default, Preparing [PayPal Standard]). The order status is updated to an acknowledged order status (by default, the default order status level) when the customer returns back to the store from PayPal after payment has been made, or when the IPN notification is received if the customer didn't return back to the store.

    If the customer did not finalize the payment at PayPal and does not return back to the store, the order remains in the database with the Preparing [PayPal Standard] order status and can be safely deleted after a period of time.

     

    Website preferences
    Bring customers back to my website after they pay with PayPal.

    If you dont set IPN than the checkout wont be closed in all case.

    Look at this between IPN codes:
            tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'");
            tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "'");
    

    You hang up the standard process if you dont use IPN by the way.


    Never be facts that customer come back after payments so you have to run IPN to close the process.

    IPN should be on. Set it in Website Payment Preferences Paypal account page.

    IPN and standard return order could be change somethimes IPN is the first callback somethimes the standard return but bot of them need in Paypal Standard.
  3. Your _notify_sync is very solid with params i have at least give back 50 parameters in my log. Have you deleted some params?

    Paypal account could be wrong so I wouldnt be surprised if it is happened.

    From this log we could see that Paypal doesnt do return.


    My Exatct questions:

    1. What is your Paypal Preparing Order Status?

    2. How long is your PDT Identity Token?

     

    3. What is your Return URL set in your Paypal account?

     

     

  4. You should set UTF8 between paypal buttons in your paypal account.

    You should get PDT token from paypal account and save into oscommerce Paypal App paypal standard configuration page and finaly between general setting you should set Transactions Order Status to the default: Paypal [Transactions]
     


    You have only success payment if the paypal log in oscommerce Paypal App will show the green PS buttons with _notify_sync and _notify-validate [iPN] between actions.


    In order between status informations you should see at least 3 status report.
     
     
    05/24/2016 20:32:33   PayPal [Transactions]
    Transaction ID: ****************************
    Payer Status: verified
    Address Status: unconfirmed
    Payment Status: Completed
    Payment Type: instant
    Pending Reason:
    Source: IPN



    05/24/2016 20:32:29  PayPal [Transactions]
    Transaction ID: ******************************
    Payer Status: verified
    Address Status: unconfirmed
    Payment Status: Completed
    Payment Type: instant
    Pending Reason:
     
     
    05/24/2016 20:32:29  Payment confirmed



    What is your log results in [your doamin]/[your admin]/paypal.php?action=log when payment is fail and what is your status reports?

     

  5. Yes its could be UTF8, PDT or inconsistent paypal payment order status error. All of them cause that customer shopping cart is not cleared after the payment and the return is broken.
    Paypal logs inform you about the problem.
     

  6. @@azpro

    I have extended to multi language in execute function:

            ob_start();
            include('ext/bootstrap-plugins/typeahead/bootstrap3-typeahead.min.js');
            echo "\n";
            include('ext/modules/content/header/store_search/content_searches.js');
            $script = ob_get_clean();
    
            $oscTemplate->addBlock('<script>' . $script . '</script>' . "\n", 'footer_scripts');
    

    non-minified script:

    $(function(){
        $("#quick_search").typeahead({
        items : 15,
        source: function (query, process) {
    
          $.ajax({
            url: 'ext/modules/content/header/store_search/content_searches.php?language=<?php echo $language_code; ?>',
            type: 'POST',
            data: 'query=' + query,
            dataType: 'JSON',
            async: true,
            success: function(data){
                       var resultList = data.map(function (item) {
                       var link = { icon: item.icon, href: item.href, name: item.title, price: item.price};
                       return JSON.stringify(link);
                     });
                return process(resultList);
            }
          })
        },
    
        matcher: function (obj) {
          return true;
        },
    
        sorter: function (items) {          
          var beginswith = [], caseSensitive = [], caseInsensitive = [], item;
          while (link = items.shift()) {
              var item = JSON.parse(link);
              if (!item.name.toLowerCase().indexOf(this.query.toLowerCase())) beginswith.push(JSON.stringify(item));
              else if (~item.name.indexOf(this.query)) caseSensitive.push(JSON.stringify(item));
              else caseInsensitive.push(JSON.stringify(item));
          }
    
          return beginswith.concat(caseSensitive, caseInsensitive)
    
        },
    
        highlighter: function (link) {
          var item = JSON.parse(link);
          return '<i class="fa fa-' + item.icon + '"></i> ' + item.name + ((item.price) ? ' (' + item.price + ')' : '') + '';
        },
    
        updater: function (link) {
          var item = JSON.parse(link);
          window.location.href = item.href;
        }
      });
    });
    

    dont forget to add $lng into globals in execute function.

     

        function execute() {
          global $lng;
    
          // languages
          if (!isset($lng) || (isset($lng) && !is_object($lng))) {
           include(DIR_WS_CLASSES . 'language.php');
            $lng = new language;
          }
    
          foreach ($lng->catalog_languages as $lkey => $lvalue) {
            if ($lvalue['id'] == $languages_id) {
              $language_code = $lkey;
              break;
            }
          }
    
  7. pls do complete debug with Sandbox. You can create one sandbox buyer and one sandbox seller to find the real problem without money costs. set up in credentials and add sandbox PDT to paypal standard config.
    You will see the logs, emails and actions.

  8. Hi all,

     

    @@Zoltan problems could be query collation problem where the query request contains non-coherens characters so the upgrade possible wont be help.

     

    Sometimes the unix enviroment or localisation sets could be less than we need. Knock out the query to see the real query string or save it a separated log file. Use oscommerce admin for prepaire the query log system.

    osCommerce installation manual contains direct instructions about the debugs. (see into older v2.2 pdf helps.  admin->configuration->logging->Store Database Queries e.t.c)

     

     

    Later if the problem will be localized you could use collation commands in the query string for example something like this:

    $where_str .= "(lower(pd.products_name) like '%" . tep_db_input($keyword) . "%' COLLATE utf8_bin or p.products_model like '%" . tep_db_input($keyword) . "%' or lower(m.manufacturers_name) like '%" . tep_db_input($keyword) . "%' COLLATE utf8_bin";
    

    One another possible issue if @@Zoltan has missing conversion from latin_swedish_ci collated database tables to native utf8 characters.

  9. @@Gergely

     

    Hello, what I want is to disable the 401, 403 and 404 codes from showing up in the recorder.  I have setting as False but these codes still appear.  Should

     

    Enable Dirname Record? False

     

    disable those in recorder?

     

    Thanks

     

    add the following code into .htaccess

    # If you are getting errors you may need to comment this out like ..
    # Options +FollowSymLinks
    Options +SymLinksIfOwnerMatch
    
×
×
  • Create New...