Magento Forum

   
Numeric product attributes not saving
 
limesystems
Jr. Member
 
Total Posts:  6
Joined:  2008-08-12
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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
limesystems
Jr. Member
 
Total Posts:  6
Joined:  2008-08-12
Plymouth Meeting, PA
 

Just to update incase someone goes looking.

The problem was an incomplete upgrade from PHP 5.2.0 to 5.2.4.  Core PHP was 5.2.0 but the mysql libraries where 5.2.4, once all libraries where downgraded back to 5.2.0, the SQL was correct.  Everything was fine down to the library call, but for what ever reason, when the parameters were bond to the SQL query the output was incorrect.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top