cancel
Showing results for 
Search instead for 
Did you mean: 

Issue after upgrade from 1.8 to 1.9.4 : Numeric value out

Issue after upgrade from 1.8 to 1.9.4 : Numeric value out

I just upgraded magento from 1.8 to 1.9.4, but I get this error below. I tried to change the type of attribute_id from smallint to bigint but then I get this error "Error on rename of './magento/#sql-65cb_4e6d' to './magento/eav_attribute' (errno: 150)".

Appreciate any help. Thanks.

 

a:5:{i:0;s:567:"Error in file: "/home/xxxx/public_html/app/code/core/Mage/Customer/sql/customer_setup/upgrade-1.6.2.0.5-1.6.2.0.6.php" - SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'attribute_id' at row 1, query was: INSERT INTO `eav_attribute` (`entity_type_id`, `attribute_code`, `backend_model`, `backend_type`, `backend_table`, `frontend_model`, `frontend_input`, `frontend_label`, `frontend_class`, `source_model`, `is_required`, `is_user_defined`, `default_value`, `is_unique`, `note`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";i:1;s:994:"#0 /home/xxxxx/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /home/xxxxx/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.2.0.1', '1.6.2.0.7')
#2 /home/xxxxx/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.2.0.1', '1.6.2.0.7')
#3 /home/xxxxxx/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/xxxxx/public_html/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/xxxxx/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
#6 /home/xxxxxx/public_html/app/Mage.php(687): Mage_Core_Model_App->run(Array)
#7 /home/xxxxx/public_html/index.php(83): Mage::run('', 'store')
3 REPLIES 3

Re: Issue after upgrade from 1.8 to 1.9.4 : Numeric value out

You are using what extension to migrate? The Numeric value out error usually occurs when you migrate to 1.9 by commandline. Please let me know what version of 1.8.x (exactly) you are using, I will help you to fix

If issue solved, Click Kudos & Accept as Solution.
LitExtension - #1 Shopping Cart Migration Expert

Re: Issue after upgrade from 1.8 to 1.9.4 : Numeric value out

Hi,

You were right, I used the command line. The version is 1.8.0.

Thank you

Re: Issue after upgrade from 1.8 to 1.9.4 : Numeric value out

nothing ?