Total Posts: 6
Plymouth Meeting, PA
I have a development environment running on Windows (PHP 5.2.6 and mySQL 5.0.67) and a test environment running on Linux (SUSE 10.1, PHP 5.2.0 and mySQL 5.0.45), I did some configuration on the Dev box, backed up and restored to the test database, everything appeared to be ok. Can create new products and attributes, problem is any numeric attribute will not update on the test environment, updating any numeric attribute results in the value of 0. Turned on Magento logging, but don’t see any errors.
Turned on SQL logging on both systems.
Updating the product weight on a product, SQLs are below
Windows - UPDATE `catalog_product_entity_decimal` SET `value` = ‘123.210000’ WHERE (value_id=29)
Linux - UPDATE `catalog_product_entity_decimal` SET `value` = ‘%F’ WHERE (value_id=57)
All updates to catalog_product_entity_decimal result in value = ‘%F’, thought it was a parameterized SQL statement but can’t find anything to support this.
Does anyone know what is causing the %F in the update statements on the Linux box. Any help would be greatly appreciated.