Base table or view not found: 1146 Table 'mycompany_live.debit_bankdata' doesn't existProduct Attributes could not be reindexedSQLSTATE[42S02]: Base table or view not found: 1146 Table 'core_store' doesn't existCron jobs not being called, getting email notification errorsShows “SQLSTATE[42S02]: Base table or view not found----” when I try to access the customer details in admin panelMagento 1.9.1.1 : Create Store View : Cardinality violation: 1241 Operand should contain 1 column(s)Error in admin panel: MySQL server has gone awayThere has been an error processing your request magento 1.9.0.1SQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoCan't run CRON PDOException Magento 1.9.3.8Magento 1.9 - There has been an error processing your request

What about the virus in 12 Monkeys?

Is "remove commented out code" correct English?

How can saying a song's name be a copyright violation?

Do scales need to be in alphabetical order?

Which is the best way to check return result?

ssTTsSTtRrriinInnnnNNNIiinngg

How to show a landlord what we have in savings?

Why does this cyclic subgroup have only 4 subgroups?

Extract rows of a table, that include less than x NULLs

Is this a hacking script in function.php?

Should I cover my bicycle overnight while bikepacking?

Why no variance term in Bayesian logistic regression?

How do I gain back my faith in my PhD degree?

One verb to replace 'be a member of' a club

How does a predictive coding aid in lossless compression?

Do UK voters know if their MP will be the Speaker of the House?

GFCI outlets - can they be repaired? Are they really needed at the end of a circuit?

Would Slavery Reparations be considered Bills of Attainder and hence Illegal?

Madden-Julian Oscillation (MJO) - How to interpret the index?

If human space travel is limited by the G force vulnerability, is there a way to counter G forces?

Forgetting the musical notes while performing in concert

Is there an expression that means doing something right before you will need it rather than doing it in case you might need it?

What exploit Are these user agents trying to use?

Unlock My Phone! February 2018



Base table or view not found: 1146 Table 'mycompany_live.debit_bankdata' doesn't exist


Product Attributes could not be reindexedSQLSTATE[42S02]: Base table or view not found: 1146 Table 'core_store' doesn't existCron jobs not being called, getting email notification errorsShows “SQLSTATE[42S02]: Base table or view not found----” when I try to access the customer details in admin panelMagento 1.9.1.1 : Create Store View : Cardinality violation: 1241 Operand should contain 1 column(s)Error in admin panel: MySQL server has gone awayThere has been an error processing your request magento 1.9.0.1SQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoCan't run CRON PDOException Magento 1.9.3.8Magento 1.9 - There has been an error processing your request













1















I am using Magento 1.9.4.0 with Patch SUPEE-11086 and PHP 5.6. I get this error logged into my console after checkout:



a:5:i:0;s:222:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mycompany_live.magedebit_bankdata' doesn't exist, query was: SELECT `magedebit_bankdata`.`bank_name` FROM `magedebit_bankdata` WHERE (swift_code='5498494') LIMIT$
#1 /home/mycompany/live/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/mycompany/live/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `magedeb...', Array)
#4 /home/mycompany/live/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `magedeb...', Array)
#5 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Resource/Bankdata.php(83): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select))
#7 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Bankdata.php(65): Itabs_Debit_Model_Resource_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#8 /home/mycompany/live/app/code/community/Itabs/Debit/Helper/Data.php(81): Itabs_Debit_Model_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#9 /home/mycompany/live/app/code/community/Itabs/Debit/controllers/AjaxController.php(42): Itabs_Debit_Helper_Data->getBankByIdentifier('swift', '5498494')
#10 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Itabs_Debit_AjaxController->checkblzAction()
#11 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('checkblz')
#12 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /home/mycompany/live/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#14 /home/mycompany/live/app/Mage.php(690): Mage_Core_Model_App->run(Array)
#15 /home/mycompany/live/index.php(83): Mage::run('', 'store')
#16 main";s:3:"url";s:21:"/debit/ajax/checkblz/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";


The checkout works and the correct bank data is saved, so why do I get this message?






magento-1.9







share|improve this question






















  • you have third party extension install ?

    – Rakesh Donga
    2 days ago











  • Yes I do have third party extension installed, e.g. Itabs/Debit as you can see in the stack trace

    – Black
    2 days ago















1















I am using Magento 1.9.4.0 with Patch SUPEE-11086 and PHP 5.6. I get this error logged into my console after checkout:



a:5:i:0;s:222:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mycompany_live.magedebit_bankdata' doesn't exist, query was: SELECT `magedebit_bankdata`.`bank_name` FROM `magedebit_bankdata` WHERE (swift_code='5498494') LIMIT$
#1 /home/mycompany/live/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/mycompany/live/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `magedeb...', Array)
#4 /home/mycompany/live/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `magedeb...', Array)
#5 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Resource/Bankdata.php(83): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select))
#7 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Bankdata.php(65): Itabs_Debit_Model_Resource_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#8 /home/mycompany/live/app/code/community/Itabs/Debit/Helper/Data.php(81): Itabs_Debit_Model_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#9 /home/mycompany/live/app/code/community/Itabs/Debit/controllers/AjaxController.php(42): Itabs_Debit_Helper_Data->getBankByIdentifier('swift', '5498494')
#10 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Itabs_Debit_AjaxController->checkblzAction()
#11 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('checkblz')
#12 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /home/mycompany/live/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#14 /home/mycompany/live/app/Mage.php(690): Mage_Core_Model_App->run(Array)
#15 /home/mycompany/live/index.php(83): Mage::run('', 'store')
#16 main";s:3:"url";s:21:"/debit/ajax/checkblz/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";


The checkout works and the correct bank data is saved, so why do I get this message?






magento-1.9







share|improve this question






















  • you have third party extension install ?

    – Rakesh Donga
    2 days ago











  • Yes I do have third party extension installed, e.g. Itabs/Debit as you can see in the stack trace

    – Black
    2 days ago













1












1








1








I am using Magento 1.9.4.0 with Patch SUPEE-11086 and PHP 5.6. I get this error logged into my console after checkout:



a:5:i:0;s:222:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mycompany_live.magedebit_bankdata' doesn't exist, query was: SELECT `magedebit_bankdata`.`bank_name` FROM `magedebit_bankdata` WHERE (swift_code='5498494') LIMIT$
#1 /home/mycompany/live/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/mycompany/live/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `magedeb...', Array)
#4 /home/mycompany/live/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `magedeb...', Array)
#5 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Resource/Bankdata.php(83): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select))
#7 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Bankdata.php(65): Itabs_Debit_Model_Resource_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#8 /home/mycompany/live/app/code/community/Itabs/Debit/Helper/Data.php(81): Itabs_Debit_Model_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#9 /home/mycompany/live/app/code/community/Itabs/Debit/controllers/AjaxController.php(42): Itabs_Debit_Helper_Data->getBankByIdentifier('swift', '5498494')
#10 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Itabs_Debit_AjaxController->checkblzAction()
#11 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('checkblz')
#12 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /home/mycompany/live/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#14 /home/mycompany/live/app/Mage.php(690): Mage_Core_Model_App->run(Array)
#15 /home/mycompany/live/index.php(83): Mage::run('', 'store')
#16 main";s:3:"url";s:21:"/debit/ajax/checkblz/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";


The checkout works and the correct bank data is saved, so why do I get this message?






magento-1.9







share|improve this question














I am using Magento 1.9.4.0 with Patch SUPEE-11086 and PHP 5.6. I get this error logged into my console after checkout:



a:5:i:0;s:222:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mycompany_live.magedebit_bankdata' doesn't exist, query was: SELECT `magedebit_bankdata`.`bank_name` FROM `magedebit_bankdata` WHERE (swift_code='5498494') LIMIT$
#1 /home/mycompany/live/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/mycompany/live/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `magedeb...', Array)
#4 /home/mycompany/live/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `magedeb...', Array)
#5 /home/mycompany/live/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Resource/Bankdata.php(83): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select))
#7 /home/mycompany/live/app/code/community/Itabs/Debit/Model/Bankdata.php(65): Itabs_Debit_Model_Resource_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#8 /home/mycompany/live/app/code/community/Itabs/Debit/Helper/Data.php(81): Itabs_Debit_Model_Bankdata->loadByIdentifier('swift', '5498494', NULL)
#9 /home/mycompany/live/app/code/community/Itabs/Debit/controllers/AjaxController.php(42): Itabs_Debit_Helper_Data->getBankByIdentifier('swift', '5498494')
#10 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Itabs_Debit_AjaxController->checkblzAction()
#11 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('checkblz')
#12 /home/mycompany/live/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#13 /home/mycompany/live/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#14 /home/mycompany/live/app/Mage.php(690): Mage_Core_Model_App->run(Array)
#15 /home/mycompany/live/index.php(83): Mage::run('', 'store')
#16 main";s:3:"url";s:21:"/debit/ajax/checkblz/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";


The checkout works and the correct bank data is saved, so why do I get this message?






magento-1.9




magento-1.9






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 2 days ago









BlackBlack

420320




420320












  • you have third party extension install ?

    – Rakesh Donga
    2 days ago











  • Yes I do have third party extension installed, e.g. Itabs/Debit as you can see in the stack trace

    – Black
    2 days ago

















  • you have third party extension install ?

    – Rakesh Donga
    2 days ago











  • Yes I do have third party extension installed, e.g. Itabs/Debit as you can see in the stack trace

    – Black
    2 days ago
















you have third party extension install ?

– Rakesh Donga
2 days ago





you have third party extension install ?

– Rakesh Donga
2 days ago













Yes I do have third party extension installed, e.g. Itabs/Debit as you can see in the stack trace

– Black
2 days ago





Yes I do have third party extension installed, e.g. Itabs/Debit as you can see in the stack trace

– Black
2 days ago










1 Answer
1






active

oldest

votes


















1














Manually rewind core_resource

Take the following steps to resolve the issue.



  • Open the database table ‘core_resource’

  • Browse the table and find: debit_resource // your extension setup

  • Remove this entry (only one)

  • Refresh the cache

  • The error should be gone!





share|improve this answer























  • The error is gone, thx bro!

    – Black
    2 days ago











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%2f268172%2fbase-table-or-view-not-found-1146-table-mycompany-live-debit-bankdata-doesnt%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









1














Manually rewind core_resource

Take the following steps to resolve the issue.



  • Open the database table ‘core_resource’

  • Browse the table and find: debit_resource // your extension setup

  • Remove this entry (only one)

  • Refresh the cache

  • The error should be gone!





share|improve this answer























  • The error is gone, thx bro!

    – Black
    2 days ago















1














Manually rewind core_resource

Take the following steps to resolve the issue.



  • Open the database table ‘core_resource’

  • Browse the table and find: debit_resource // your extension setup

  • Remove this entry (only one)

  • Refresh the cache

  • The error should be gone!





share|improve this answer























  • The error is gone, thx bro!

    – Black
    2 days ago













1












1








1







Manually rewind core_resource

Take the following steps to resolve the issue.



  • Open the database table ‘core_resource’

  • Browse the table and find: debit_resource // your extension setup

  • Remove this entry (only one)

  • Refresh the cache

  • The error should be gone!





share|improve this answer













Manually rewind core_resource

Take the following steps to resolve the issue.



  • Open the database table ‘core_resource’

  • Browse the table and find: debit_resource // your extension setup

  • Remove this entry (only one)

  • Refresh the cache

  • The error should be gone!






share|improve this answer












share|improve this answer



share|improve this answer










answered 2 days ago









Rakesh DongaRakesh Donga

2,393316




2,393316












  • The error is gone, thx bro!

    – Black
    2 days ago

















  • The error is gone, thx bro!

    – Black
    2 days ago
















The error is gone, thx bro!

– Black
2 days ago





The error is gone, thx bro!

– Black
2 days ago

















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%2f268172%2fbase-table-or-view-not-found-1146-table-mycompany-live-debit-bankdata-doesnt%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

Image
17 \\$\\begingroup\\$ I need an answer because I am a beginner. And I got the players handbook and it does not say a thing about this. pathfinder-1e pathfinder-beginner-box share | improve this question edited 2 days ago V2Blast ♦ 33.8k 5 5 gold badges 123 123 silver badges 212 212 bronze badges asked 2 days ago Brys Brys 89 1 1 silver badge 3 3 bronze badges New contributor ...
Read more

Sum ergo cogito? 1 nng

Image
3 Following Descartes but in the opposite direction: I exist. Something has made the assertion in the previous sentence and must have thought it to do so. Therefore my thoughts exist. Combining with the direction established by Descartes I have cogito ⇔ sum . Since assuming either is equiavlent to assuming the other I conclude that Descartes does not establish existence as following from something more basic or fundamental. Instead he has merely stated a tautology. Am I right or wrong? Or both, or neither? ontology descartes share | improve this question asked yesterday Dzamo Norton...
Read more

三茅街道4182Guuntc Dn precexpngmageondP

Image
三茅街道 概览 国家   中华人民共和国 上级行政区 扬中市 行政区类型 街道办事处 行政区划代码 32 11 82 001 村级区划单位数 30 - 社区数 14 - 行政村数 16 地理、人口、经济 坐标 32°14′25″N 119°49′08″E  /  32.24028°N 119.81884°E  / 32.24028; 119.81884 坐标： 32°14′25″N 119°49′08″E  /  32.24028°N 119.81884°E  / 32.24028; 119.81884 电话区号 +86  时区 UTC+8（北京时间） 三茅街道 是中华人民共和国江苏省镇江市扬中市下辖的一个街道办事处 [1] 。西部毗邻新坝镇，东南方毗邻油坊镇、八桥镇，北隔长江主航道與泰州市高港区相望。 2000年以后，丰裕镇并入，三茅镇面积达到49.45平方千米，人口73284人。2005年，兴隆镇并入，面积133.19平方千米，人口13万，占扬中全市40%。 行政区划 [ 编辑 ] 三茅街道下辖以下村级行政区划单位 [2] ： 文化新村社区、扬子新村社区、江州路社区、英雄社区、广宁社区、中桥社区、建设社区、金星社区、同心社区、丰裕社区、新民社区、港联社区、新胜社区、新扬社区、民主村、中华村、友好村、锦程村、三桥村、大众村、滨江村、企东村、兴华村、指南村、兴阳村、明华村、营房村、永和村、永勤村和普济村。 参考资料 [ 编辑 ] ↑ 2017年统计用区划代码和城乡划分代码：扬中市. 中华人民共和国国家统计局. 2017.   ↑ 2017年统计用区划代码和城乡划分代码：三茅街道. 中华人民共和国国家统计局. 2017.     这是一个关于江苏行政区划的小作品。你可以通过 编辑或修订 扩充其内容。 查 论 编 扬中市行政区划 行政隶属：中华人民共和国江苏省镇江市 街道 三茅街道 兴隆街道 镇 新坝镇 油坊镇 八桥镇 西来桥镇 类似乡级单位 扬中市良种繁育场 扬中市种猪场 扬中市渔业社 雷公岛水产养殖场 扬...
Read more