Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pmsmiers

Pioneers
  • Posts

    24
  • Joined

  • Last visited

Posts posted by pmsmiers

  1. I'm using Header Tag SEO for years and it works great but I'm having problems adding a social bookmark icon.

     

    Adding the icons is working fine and the icon is showing in header_tags_seo_social.php, an extra field is showing up fine but when I enter an URL in this field and save it and go back to the header_tags_seo_social.php page the icon is again deselected and the field is empty. I want to make an icon for Trustpilot so when a customer presses the bookmark they get the evaluate page for my website.

    So no URL and TITLE are needed, just a link (maybe opening in a frame if possible).

     

    Can someone give me some help ? 

  2. I have only one problem with this add on,

     

    in page control when I select index.php I can't seem to get the keywords to show when I select : view results

    It just shows a red box 

    I have three languages and this only happens in the dutch language (german and  english work fine)

     

    Off course I entered the keywords

     

    Please help me solve this strange problem

  3. Everything looks like it's working except for the restore function. When I select the file which I would like to restore and press restore I get the following error :

     

    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

    );

    [TEP STOP]

  4.  

    Guys, I did it!! Facebook social login finally working  :thumbsup:

     

    Edit login_with_facebook.php and replace the "GET array" line under 'https://graph.facebook.com/me' with the following

                                            'GET', array(
                                                    'fields'=>'first_name,last_name,gender,email'
                                            ), array('FailOnAccessError'=>true), $user);
    
    

    It still doesn't work, I get following message when I click on Refresh User Acces Token:

    in dutch:

    De opgegeven URL wordt niet toegestaan door de configuratie van de applicatie.: Een of meer van de opgegeven URL's zijn niet toegestaan door de instellingen van de app. De URL moet overeenkomen met de website- of canvas-URL, of het domein moet een subdomein zijn van een van de domeinen van de app.

    in english:

    the given URL is not permitted for configureation of the application: one or more of the given URL's are not permitted. The URL most be the same as the website of canvas URL' , or the domain must be a sub domain of the domains of the App

    I did fill in the website url in the setting menu (add platform)

     

    What can it be ?

     

    With kind regards,

    Peter

  5. Hello @@pmsmiers,

     

    It seems you have a header tag module which uses the "display_price" function on the product_info page. You should localize the header tag module by switching off step by step the header tag modules and then once you know which one, search in it for the "display_price" function. Apply then the modification like explained at the end of the installation instructions under "Optional": Add "false" as the sixth parameter of the "display_price" function.

     

    Regards

    Rainer

    Yes, found it in : header_tags_opengraph.php and works great.

    Thanks man for this fast reaction.

     

    Regards,

    Peter

  6. Dear Rainer ,

     

    First I like to say, installing was a breeze easy and this add-on works and looks great.

     

    I have one problem when I enable this add on for the : product_info.php page, I get the following at the top left side of this page :

     

    Incl. 21% BTW">
    Incl. 21% BTW" />

     

    (I'm dutch)

     

    When I check the element inspector (Goofle Chrome) the first line is inserted just before the first meta tags and the second one somewhere between the las meta tags.

     

    Can you help ?

  7. Good day, 

     

    I want to use this Add on with OSCommerce 2.3.4 but I can't get it to work. I got the buttons working but when I click them to start : label_pdf.php?oID=231 the screen is empty.

    Most likely the label_pdf.php needs to be adapted to 2.3.4, can someone have a look and post a new 2.3 (or 2.3.4) version ?

    I really like the idea to be able to print a label.

     

    With regards,

    Peter

  8. I'm using version GoogleBase 3.4 and it's almost perfect.

     

    The only problem is I have to manually change the , to %2C in the image URL

    How can I change Googlefeeder to automate this ?

     

    With regards,

    Peter

    I've solved this problem by changing all the image names (remove the , )

     

     

    Other problem : 

    How can I use two different TAX rates ?

    Some products use 21 percent TAX and some only 6 percent

  9.  

    Did you get a fatal error in your PHP log when this happened? You probably just forgot to comment a bracket, }, or something.

     

    But perhaps it's simpler to just replace the mysqli_prepared_query function in database.php. Replace it with the code below

        function mysqli_prepared_query( $sql, $typeDef = FALSE, $params = FALSE, $link = "db_link" ) {
          global $$link;
    
          if ( false === $typeDef || empty( $typeDef ) ) {
            return tep_db_fetch_all( $sql );
          }
    
          # Kiss Error Debugger
          $start_time = microtime( true );
    
          if ( $stmt = mysqli_prepare( $$link, $sql ) ) {
            if ( count( $params ) == count( $params, 1 ) ) {
              $params = array( $params );
              $multiQuery = FALSE;
            } else {
              $multiQuery = TRUE;
            }
    
            if ( $typeDef ) {
              $bindParams = array();
              $bindParamsReferences = array();
              $bindParams = array_pad( $bindParams, ( count( $params, 1 )-count( $params ) )/count( $params ), "" );
              foreach ( $bindParams as $key => $value ) {
                $bindParamsReferences[ $key ] = &$bindParams[ $key ];
              }
              array_unshift( $bindParamsReferences, $typeDef );
              $bindParamsMethod = new ReflectionMethod( 'mysqli_stmt', 'bind_param' );
              $bindParamsMethod->invokeArgs( $stmt, $bindParamsReferences );
            }
    
            $result = array();
            foreach ( $params as $queryKey => $query ) {
              foreach ( $bindParams as $paramKey => $value ) {
                $bindParams[ $paramKey ] = $query[ $paramKey ];
              }
              $queryResult = array();
              if ( mysqli_stmt_execute( $stmt ) ) {
                $resultMetaData = mysqli_stmt_result_metadata( $stmt );
                if ( $resultMetaData ) {
                  $stmtRow = array();
                  $rowReferences = array();
                  while ( $field = mysqli_fetch_field( $resultMetaData ) ) {
                    $rowReferences[] = &$stmtRow[ $field->name ];
                  }
                  mysqli_free_result( $resultMetaData );
                  $bindResultMethod = new ReflectionMethod( 'mysqli_stmt', 'bind_result' );
                  $bindResultMethod->invokeArgs( $stmt, $rowReferences );
                  while ( mysqli_stmt_fetch( $stmt ) ) {
                    $row = array();
                    foreach ( $stmtRow as $key => $value ) {
                      $row[$key] = $value;
                    }
                    $queryResult[] = $row;
                  }
                  mysqli_stmt_free_result( $stmt );
                } else {
                  $queryResult[] = mysqli_stmt_affected_rows( $stmt );
                }
              } else {
                $queryResult[] = FALSE;
              }
              $result[ $queryKey ] = $queryResult;
            }
            mysqli_stmt_close( $stmt );
          } else {
            $result = FALSE;
          }
    
          # Kiss Error Debugger
          if ( class_exists( 'KissER' ) ) {
            $sql = interpolateQuery( $sql, $params[0] );
            KissER::q( round( ( microtime( true ) - $start_time ), 4 ), $sql );
          }
    
          if ( $multiQuery ) {
            return $result;
          } else {
            return $result[0];
          }
        }
    

    Tried it, the admin dashboard keeps working now but when I select : advanced_statistics the screen is blank now

     

    Error.log :

    PHP Fatal error: Call to a member function query() on a non-object in /admin/advanced_statistics/general_functions.php on line 47

    PHP Warning: file(includes/languages/dutch/modules/boxes/bm_categories2.php): failed to open stream: No such file or directory in /dynamic-sitemap.php on line 117

    PHP Warning: file(includes/languages/dutch/modules/boxes/bm_partners.php): failed to open stream: No such file or directory in /dynamic-sitemap.php on line 117

    PHP Fatal error: Call to a member function query() on a non-object in /admin/advanced_statistics/general_functions.php on line 47

    ******************************************************************

    I've solved it !! I've replaced database.php with the original 2.3.3 version (I use OsCommerce 2.3.4)

     

    Thanks for you help

  10.  

    My Locale settings :

     

    setlocale(LC_TIME, 'en_US.ISO_8859-1');
    define('DATE_FORMAT_SHORT', '%m/%d/%Y');  // this is used for strftime()
    define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()
    define('DATE_FORMAT', 'm/d/Y'); // this is used for date()
    define('PHP_DATE_TIME_FORMAT', 'm/d/Y H:i:s'); // this is used for date()
    define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

     

    I've tried :

    1. setlocale(LC_ALL, array('en_US.UTF-8', 'en_US.UTF8', 'enu_usa'));
    2. define('DATE_FORMAT_SHORT', '%m/%d/%Y'); // this is used for strftime()
    3. define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()
    4. define('DATE_FORMAT', 'm/d/Y'); // this is used for date()
    5. define('PHP_DATE_TIME_FORMAT', 'm/d/Y H:i:s'); // this is used for date()

     

    No solution

     

    Error log :

    PHP Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in /admin/includes/functions/database.php on line 174

    PHP Warning: Invalid argument supplied for foreach() in /var/www/vhosts/19/176347/admin/advanced_statistics.php on line 38

    PHP Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in /admin/includes/functions/database.php on line 174

    PHP Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in //admin/includes/functions/database.php on line 174

    PHP Warning: Invalid argument supplied for foreach() in /var/www/vhosts/19/176347/admin/advanced_statistics.php on line 38

    PHP Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in /admin/includes/functions/database.php on line 174

    PHP Warning: mysqli_prepare() expects parameter 1 to be mysqli, resource given in /admin/includes/functions/database.php on line 174

    PHP Warning: end() expects parameter 1 to be array, null given in /admin/advanced_statistics.php on line 185

    File does not exist: /admin/ext/tiny_mce/plugins/imagemanager, referer: http://www.espresso-t.nl/admin73pm/advanced_statistics.php

    File does not exist: admin/ext/tiny_mce/plugins/filemanager, referer: http://www.espresso-t.nl/admin73pm/advanced_statistics.php

     

    Any idea's ?

  11. My Locale settings :

     

    setlocale(LC_TIME, 'en_US.ISO_8859-1');
    define('DATE_FORMAT_SHORT', '%m/%d/%Y');  // this is used for strftime()
    define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()
    define('DATE_FORMAT', 'm/d/Y'); // this is used for date()
    define('PHP_DATE_TIME_FORMAT', 'm/d/Y H:i:s'); // this is used for date()
    define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');
  12. Ok, in ./admin/order_handler.php around line 576, replace this code:

    if (isset($orders_rows_raw))
     $orders_query_total = (int)tep_db_fetch_array(tep_db_query($orders_rows_raw))['total'];
    else
     $orders_query_total = tep_db_num_rows(tep_db_query($orders_query_raw));
    

    To This:

    if (isset($orders_rows_raw)) {
     $orders_query_total = (int)tep_db_fetch_array(tep_db_query($orders_rows_raw));
     $orders_query_total = $orders_query_total['total'];
    } else {
     $orders_query_total = tep_db_num_rows(tep_db_query($orders_query_raw));
    }
    

     

    That did the trick :) you're the best

  13. Hello pmsmiers,

     

    Can you check what information the PHP Error Log has?

     

    If you can't access the error log then find this line in ./admin/includes/application_top.php

    error_reporting(E_ALL & ~E_NOTICE);
    

    And change it, temporarily, to:

    error_reporting(E_ALL);
    ini_set('display_errors', '1');
    

     

    Then go to order_handler.php page again and reply with the error messages that you get.

     

    Thanks for your help, I get the following error :

    PHP Parse error: syntax error, unexpected '[' in /storage/web/public/sites/www.espresso-t.nl/admin/order_handler.php on line 577, referer: http://www.espresso-t.nl/admin/orders.php?page=1&oID=42&action=edit

     

    Peter

×
×
  • Create New...