pmsmiers
-
Posts
24 -
Joined
-
Last visited
Posts posted by pmsmiers
-
-
I've just installed http://addons.oscommerce.com/info/8307/v,23
I was hoping this would solve my problems with this add on (empty csv files) but this version also just gives me an empty csv files (no errors) any idea's ?
-
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
-
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] -
Yes, callback URL is filled in correctly
-
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
-
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
-
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 ?
-
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
-
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
-
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
-
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
-
Did you try my suggestion in post #5?
Look in your ./admin/includes/functions/database.php for mysqli_prepared_query and tep_db_fetch_all functions. If you can find them, try with commenting them out or removing them to see if it solves your problem.
Yes, I only have mysqli_prepared_query and I tried commenting it out but then my whole admin panel is gone
-
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 :
- setlocale(LC_ALL, array('en_US.UTF-8', 'en_US.UTF8', 'enu_usa'));
- 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()
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 ?
-
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'); -
Good morning,
I have a problem with this add-on, it only shows 1970
Peter
-
I use the Advanced Cache Control Tool and it works great but I use a superfish menu so in my work directory I have files like : categories_superfish_box-dutch.cache
instead of categories_box_dutch.cache or something like that.
How can I change Advanced Cache Control Tool so it sees the superfish version ? -
I get this 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 '-t' at line 1
SHOW TABLE STATUS FROM db.........
[TEP STOP]
-
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
-
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
-
I'm getting a blank order_handler.php, I'm using PHP 5.3.3-7 and osCommerce 2.3.3.4
Header Tags SEO
in General Add-Ons Support
Posted
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 ?