Issue with missing table after upgrading Mega Menu extension
Hi,
I am using Floristry theme from VES Themes, aka Land of Coder. I like the theme, but literally 2 months after buying it they stated they wouldn’t support Magento 2.3x, but I also could refund it. Ugh. That said, their “support” stated to fix the issue I’m having (menu block not showing), to upgrade their Mega Menu module to newest 2.3.x version. I did that, and it had issue, but thanks for
The issue is the backend is failing b/c it can’t find table vulcansr_dev.ves_all_licence and I confirmed this table doesn’t exist. My questions:
1. Any ideas on how to fix the table issue? I’ve got a ticket in with support at
2. Do you think it would be smart to uninstall their Mega Menu and use a different Mega Menu module out there if I can’t get a solution from them?
Thanks in advance I’m at the end of this site so I’m really hoping for a simple solution as to not scrap the theme, b/c I really like it visually.
Please see error below from when I try to end backend admin area.
Thanks!
Kory
2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vulcansr_dev.ves_all_license' doesn't exist, query was: SELECT `ves_all_license`.* FROM `ves_all_license` WHERE (`ves_all_license`.`extension_code`='ves-megamneu')
Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vulcansr_dev.ves_all_license' doesn't exist
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vulcansr_dev.ves_all_license' doesn't exist, query was: SELECT `ves_all_license`.* FROM `ves_all_license` WHERE (`ves_all_license`.`extension_code`='ves-megamneu')
<pre>#1 MagentoFrameworkDBStatementPdoMysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546]
#5 MagentoFrameworkDBAdapterPdoMysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]
#6 MagentoFrameworkDBAdapterPdoMysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:756]
#7 Zend_Db_Adapter_Abstract->fetchRow() called at [vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php:354]
#8 MagentoFrameworkModelResourceModelDbAbstractDb->load() called at [app/code/Ves/All/Model/ResourceModel/License.php:50]
#9 VesAllModelResourceModelLicense->load() called at [vendor/magento/framework/Model/AbstractModel.php:540]
#10 MagentoFrameworkModelAbstractModel->load() called at [app/code/Ves/All/Helper/Data.php:138]
#11 VesAllHelperData->getLicense() called at [app/code/Ves/All/Observer/CheckLicense.php:77]
#12 VesAllObserverCheckLicense->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#13 MagentoFrameworkEventInvokerInvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#14 MagentoFrameworkEventInvokerInvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66]
#15 MagentoFrameworkEventManager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95]
#16 MagentoFrameworkEventManagerProxy->dispatch() called at [app/code/Ves/All/Block/Adminhtml/License.php:30]
#17 VesAllBlockAdminhtmlLicense->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1099]
#18 MagentoFrameworkViewElementAbstractBlock->MagentoFrameworkViewElement{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1103]
#19 MagentoFrameworkViewElementAbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:673]
#20 MagentoFrameworkViewElementAbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:564]
#21 MagentoFrameworkViewLayout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:540]
#22 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#23 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#24 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#25 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#26 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#27 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#28 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#29 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#30 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#31 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#32 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#33 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#34 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#35 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#36 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#37 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#38 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#39 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#40 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#41 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#42 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#43 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#44 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#45 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:961]
#46 MagentoFrameworkViewLayout->getOutput() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:492]
#47 MagentoFrameworkViewLayoutInterceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258]
#48 MagentoFrameworkViewResultPage->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#49 MagentoFrameworkViewResultLayout->renderResult() called at [generated/code/Magento/Backend/Model/View/Result/Page/Interceptor.php:37]
#50 MagentoBackendModelViewResultPageInterceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120]
#51 MagentoFrameworkAppHttp->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#52 MagentoFrameworkAppBootstrap->run() called at [index.php:39]
</pre>
Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vulcansr_dev.ves_all_license' doesn't exist
<pre>#1 MagentoFrameworkDBStatementPdoMysql->MagentoFrameworkDBStatementPdo{closure}() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:107]
#2 MagentoFrameworkDBStatementPdoMysql->tryExecute() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:92]
#3 MagentoFrameworkDBStatementPdoMysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#4 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#5 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#6 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546]
#7 MagentoFrameworkDBAdapterPdoMysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]
#8 MagentoFrameworkDBAdapterPdoMysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:756]
#9 Zend_Db_Adapter_Abstract->fetchRow() called at [vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php:354]
#10 MagentoFrameworkModelResourceModelDbAbstractDb->load() called at [app/code/Ves/All/Model/ResourceModel/License.php:50]
#11 VesAllModelResourceModelLicense->load() called at [vendor/magento/framework/Model/AbstractModel.php:540]
#12 MagentoFrameworkModelAbstractModel->load() called at [app/code/Ves/All/Helper/Data.php:138]
#13 VesAllHelperData->getLicense() called at [app/code/Ves/All/Observer/CheckLicense.php:77]
#14 VesAllObserverCheckLicense->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#15 MagentoFrameworkEventInvokerInvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#16 MagentoFrameworkEventInvokerInvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66]
#17 MagentoFrameworkEventManager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95]
#18 MagentoFrameworkEventManagerProxy->dispatch() called at [app/code/Ves/All/Block/Adminhtml/License.php:30]
#19 VesAllBlockAdminhtmlLicense->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1099]
#20 MagentoFrameworkViewElementAbstractBlock->MagentoFrameworkViewElement{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1103]
#21 MagentoFrameworkViewElementAbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:673]
#22 MagentoFrameworkViewElementAbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:564]
#23 MagentoFrameworkViewLayout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:540]
#24 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#25 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#26 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#27 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#28 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#29 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#30 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#31 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#32 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#33 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#34 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#35 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#36 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#37 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#38 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#39 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#40 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#41 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#42 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#43 MagentoFrameworkViewLayout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#44 MagentoFrameworkViewLayout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#45 MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#46 MagentoFrameworkViewLayout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#47 MagentoFrameworkViewLayoutInterceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:961]
#48 MagentoFrameworkViewLayout->getOutput() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:492]
#49 MagentoFrameworkViewLayoutInterceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258]
#50 MagentoFrameworkViewResultPage->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#51 MagentoFrameworkViewResultLayout->renderResult() called at [generated/code/Magento/Backend/Model/View/Result/Page/Interceptor.php:37]
#52 MagentoBackendModelViewResultPageInterceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120]
#53 MagentoFrameworkAppHttp->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#54 MagentoFrameworkAppBootstrap->run() called at [index.php:39]
</pre>