Harald Ponce de Leon

Member Since 31 Aug 2002
Online Last Active Today, 18:56

Find content

About Me

Manager at osCommerce. Specialize in ecommerce web development. Love to cook and bake. Getting into photography. Located in Solingen, Germany, Rock City No. 1.

Personal Blog: Shiny Red Apples

Profiles: Google+, Twitter, GitHub

Community Stats

Group Manager
Active Posts 3,038 (0.88 per day)
Most Active In General Support (509 posts)
Profile Views 93,648
Age 32 years old
Birthday September 3, 1979
Real Name
Harald Ponce de Leon
Gender
Male
Location
Solingen, Germany
Interests
Entertaining dwarf-hamsters.

Contact Information

Website URL http://www.oscommerce.com

46 Excellent

Friends

Latest Visitors

Pronux
Today, 16:32
orchidist
Today, 07:21
dcaballero
Yesterday, 14:11
maximus01
08 Feb 2012, 15:40
thanhluan12a14
08 Feb 2012, 12:12

Issues I've Posted

XAMPP 1.7.3

Posted 11 Aug 2011

The following is reported in the ErrorLog for some SQL queries:

"Cannot execute queries while other unbuffered queries are active."

Some unknown factor is causing this in XAMPP 1.7.3 (PHP 5.3.1 / MySQL 5.1.41) with the php_pdo_mysql_libmysql.dll extension. The solution is to use the php_pdo_mysql_mysqlnd.dll extension instead. In C:\xampp\php\php.ini, change:

;extension=php_pdo_mysql_mysqlnd.dll
extension=php_pdo_mysql_libmysql.dll

to:

extension=php_pdo_mysql_mysqlnd.dll
;extension=php_pdo_mysql_libmysql.dll

and restart Apache in the XAMPP Control Panel.

This will cause another issue of some SQL queries being logged in ErrorLog even though no actual error occurred. This is due to PDOStatement::execute() sometimes returning false when executing queries even though an error code of 00000 is returned (which is a successful code number).

XAMPP 1.7.4 does not experience these issues.

Reference topic:

http://forums.oscommerce.com/topic/378382-osc302-first-trial-some-issues/

Categories Not Sortable In IE8

Posted 8 Aug 2011

The Categories are not sortable in IE8.

Special Characters Not Escaped During Setup

Posted 15 Apr 2011

Special characters are not escaped during installation and configuration.

This has been fixed with:

https://github.com/osCommerce/oscommerce/commit/557563e3620386ce52cfee7b6a38a01c985c12e5

Reference topic:

http://forums.oscommerce.com/topic/374000-v301-admin-logon-error/

Undefined Constant MYSQL_ATTR_INIT_COMMAND

Posted 15 Apr 2011

Quote

PHP Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in C:\wamp\www\osCommerce3\osCommerce\OM\Core\PDO\MySQL\Standard.php on line 33

This is due to a PHP 5.3.0 bug on Windows where MYSQL_ATTR_INIT_COMMAND is not available. The PHP bug report is:

http://bugs.php.net/bug.php?id=47224

If you are experiencing this, please update your WAMP product to a version that uses PHP 5.3.1 or later version.

Reference topic:

http://forums.oscommerce.com/topic/373374-watching-the-testing-database-windows-now-for-an-hour/

Can't Login to the Add-Ons Site With My Twitter Associated Community Profile

Posted 14 Apr 2011

Accounts that were created through a Twitter login are not able to log into the Add-Ons or Live Shops sites due to this feature not being supported by our Single-Sign-On service. A community profile needs to be created on the forum to be able to log into the Add-Ons and Live Shops sites.

Please note that you can associate your community profile with your Twitter account after the community profile has been created, to log into the forum with your Twitter account and to log into the Add-Ons and Live Shops sites with your community profile.

Related bug report:

http://community.invisionpower.com/tracker/issue-27564-twitterfacebook-registration-not-recorded-in-converge/