IvanChepurnyi/EcomDev_UrlRewrite — Issue #2: Problems with more restricted configurations on MySQL for stored functions
Author: IvanChepurnyi
Created: 2011-10-19 15:37:04+00:00
State: open

From Omar's comment on the blog posting:

I gave this extension a try on 1.4.1.1 and realize it was not supported, moved to test it on 1.6.0.0 I get this error during installation.

Error in file: "/home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/community/EcomDev/UrlRewrite/sql/ecomdev_urlrewrite_setup/mysql4-install-0.2.0.php" - SQLSTATE[HY000]: General error: 1418 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

#0 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.2.0')
#2 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('0.2.0')
#3 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/core/Mage/Core/Model/App.php(408): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/code/core/Mage/Core/Model/App.php(336): Mage_Core_Model_App->_initModules()
#6 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#7 /home/muhsin/public_html/Magento_Projects/magento/1_6_0_0/index.php(80): Mage::run('', 'store')
#8 {main}