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

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

419 nièngy_Soadمي 19bal1.5o_g

Chiĕng-gī: 1 chiĕng-gī Sié-gī: 4 sié-gī | 5 sié-gī | 6 sié-gī Nièng-dâi: 380 nièng-dâi | 390 nièng-dâi | 400 nièng-dâi | 410 nièng-dâi | 420 nièng-dâi | 430 nièng-dâi | 440 nièng-dâi Nièng: 414 nièng | 415 nièng | 416 nièng | 417 nièng | 418 nièng | 419 nièng | 420 nièng | 421 nièng | 422 nièng | 423 nièng | 424 nièng Nùng-lĭk: gī-ê nièng ( iòng nièng ) Nièng-hô̤: 419 nièng sê siŏh ciáh bìng-nièng, tàu nĭk téng bái-nê kăi-sṳ̄. Duâi dâi [ Siŭ-gāi | Gāi nguòng-mā ] Chók-sié [ Siŭ-gāi | Gāi nguòng-mā ] Guó-sié [ Siŭ-gāi | Gāi nguòng-mā ] This page is only for definition, need detailed information please check here
Read more

Queiggey Chernihivv 9NnOo i Zw X QqKk LpB

Image
Queiggey Chernihiv Чернігівська область —   Queiggey   — Brattagh Armys Soiaghey Wheiggey Chernihiv er caslys-çheerey yn Ookraan Co-ordnaidyn: 51°20′N 32°04′E  /  51.333°N 32.067°E  / 51.333; 32.067 Co-ordnaidyn: 51°20′N 32°04′E  /  51.333°N 32.067°E  / 51.333; 32.067 Çheer Yn Ookraan Bunneeaght  - 15 J. Fouyir 1932 Bunnit Preeu-valley Chernihiv Reiltys  - Kiannoort Volodymyr Ivashko  - Caairliagh Nataliya Romanova Eaghtyr  - Yn clane 31,865 km² (12,303.1 mi ker) Earroo yn phobble (2006)  - Yn clane 1,156,609   - Glooaght y phobble 36.3/km² (94/mi ker) Cryss hraa EET (UTC+2)  - Sourey (TTSL) EEST (UTC+3) Coad ISO 3166 UA-74 Recortyssey carbyd CB Ynnyd-eggey www.cg.gov.ua She queiggey 'syn Ookraan hwoaie eh Queiggey Chernihiv (Ookraanish: Чернігівська область Chernihiv’ka oblast’ ) ny Chernihivshchyna (Ookraanish: Чернігівщина ) myr t'eh enmyssit d
Read more