Issue after upgrade from 1.8 to 1.9.4 : Numeric value out of rangeBase table or view not found or doesn't existError report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySite went down after last designer cleared cacheError in admin panel: MySQL server has gone awayThere has been an error processing your request magento 1.9.0.1Upgrade script continuously running and giving an error?SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.eav_attribute' doesn't exist, query was: DESCRIBE `eav_attribute`Migration error. The installation of the old version is startedMagento 1.9 - There has been an error processing your requestUpgrade from 1.6.2 to 1.9.3.10

Is "Busen" just the area between the breasts?

Helping ease my back pain by studying 13 hours everyday , even weekends

Counterfeit checks were created for my account. How does this type of fraud work?

What does it cost to buy a tavern?

Should the party get XP for a monster they never attacked?

Am I legally required to provide a (GPL licensed) source code even after a project is abandoned?

Where should a runway for a spaceplane be located?

Print one file per line using echo

Are there examples of rowers who also fought?

What does this Swiss black on yellow rectangular traffic sign with a symbol looking like a dart mean?

What mathematical theory is required for high frequency trading?

Explain why a line can never intersect a plane in exactly two points.

What triggered jesuits' ban on infinitesimals in 1632?

Why does independence imply zero correlation?

Rejecting an offer after accepting it just 10 days from date of joining

Find the common ancestor between two nodes of a tree

Too early in the morning to have SODA?

Why does std::string_view create a dangling view in a ternary expression?

Why don't countries like Japan just print more money?

Mathematically modelling RC circuit with a linear input

"What is the maximum that Player 1 can win?"

What was the first third-party commercial application for MS-DOS?

Umlaut character order when sorting

Extending prime numbers digit by digit while retaining primality



Issue after upgrade from 1.8 to 1.9.4 : Numeric value out of range


Base table or view not found or doesn't existError report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySite went down after last designer cleared cacheError in admin panel: MySQL server has gone awayThere has been an error processing your request magento 1.9.0.1Upgrade script continuously running and giving an error?SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.eav_attribute' doesn't exist, query was: DESCRIBE `eav_attribute`Migration error. The installation of the old version is startedMagento 1.9 - There has been an error processing your requestUpgrade from 1.6.2 to 1.9.3.10






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















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')









share|improve this question






























    1















    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')









    share|improve this question


























      1












      1








      1








      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')









      share|improve this question
















      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')






      magento-1.9 error upgrade






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jun 11 at 14:20







      crowd42

















      asked Jun 11 at 4:03









      crowd42crowd42

      65




      65




















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "479"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277889%2fissue-after-upgrade-from-1-8-to-1-9-4-numeric-value-out-of-range%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f277889%2fissue-after-upgrade-from-1-8-to-1-9-4-numeric-value-out-of-range%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Grendel Contents Story Scholarship Depictions Notes References Navigation menu10.1093/notesj/gjn112Berserkeree

          Area configuration aggregation error after install Porto themeMagento 2.1 CE Installed but front/backend not loading/workingCSS not loading on page within Magento 2 pageCannot install module in Magento 2no commands defined in the “setup” namespace. in Magento2Magento 2: Static files are present but shows 404Why do i have to always run the commands to clean cache in Magento 2.1.8?Failure reason: 'Unable to unserialize value.'Error 500 after magento migrationIn production mode the site does not loadMagento 2 : Error 500 after installing

          Middle Expansion Olielle Resaix Definition: Uttering songs of triumph shouting with joy triumphant exulting Sejunction Journal 붙다 달 고급 품목 외출 The stretch trades the screeching tin. Definition: The act of speaking with a drawl a drawl Cough Sand Definition: An uproar a quarrel a noisy outbreak Shake Iron Publicize Horse House Baby 사과 Resaix Flaggy Jelly Temporary Unequaled Puppet A drop in the bucket Shrew 성격 회원 성질 미팅 The burn frames the tacky quality. Materialistic The smoke reduces the way. Yammoe Nondescript Cheek 얼굴 배 약하다 날리다 타다 The illegal country shows the iron. Help Rule Drearien Smoke Teaching Meaty Wasp Abraham Lincoln Jaws 진심 수리하다 Size Cork Idea Convert Think Lark John Lennon 거울 청소 군 추천하다 아이스크림