Magento Forum

   
db upgrade issue
 
kaalh
Jr. Member
 
Total Posts:  2
Joined:  2008-11-13
 

when upgrading from 1.18 svn to 1.2 svn (rev 31140) :

Error in file: “/boutique120/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-0.9.28-0.9.29.php” - SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ‘’
Trace:
#0 /boutique120/app/code/core/Mage/Core/Model/Resource/Setup.php(287): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /boutique120/app/code/core/Mage/Core/Model/Resource/Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.9.28’, ‘0.9.29’)
#2 /boutique120/app/code/core/Mage/Core/Model/Resource/Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.9.28’, ‘0.9.29’)
#3 /boutique120/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /boutique120/app/code/core/Mage/Core/Model/Config.php(215): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /boutique120/app/code/core/Mage/Core/Model/App.php(241): Mage_Core_Model_Config->init(Array)
#6 /boutique120/app/Mage.php(427): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 /boutique120/app/Mage.php(446): Mage::app(’’, ‘store’, Array)
#8 /boutique120/index.php(52): Mage::run()
#9 {main}

the sql query :

SELECT `e_int`.`value` AS `order_id`,
SUM(e_decimal.value) AS `order_discount`,
SUM(e_decimal_base.value) AS `order_base_discount`
FROM `` AS `e_int`
INNER JOIN `` AS `e_decimal`
ON e_int.entity_id=e_decimal.entity_id AND e_decimal.attribute_id=’398’
INNER JOIN `` AS `e_decimal_base`
ON e_int.entity_id=e_decimal_base.entity_id AND e_decimal_base.attribute_id=’406’
WHERE e_int.entity_type_id=’23’ AND e_int.attribute_id=’388’
GROUP BY `e_int`.`value`

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