cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with missing table after upgrading Mega Menu extension

SOLVED

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 @Nishu Jindal I was able to get the front-end back up as per this topic post here. 

 

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 @Landofcoder but like I said, their support has been lazy at best in their solutions.

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 Magento\Framework\DB\Statement\Pdo\Mysql->_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 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->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 Magento\Framework\Model\ResourceModel\Db\AbstractDb->load() called at [app/code/Ves/All/Model/ResourceModel/License.php:50]
#9 Ves\All\Model\ResourceModel\License->load() called at [vendor/magento/framework/Model/AbstractModel.php:540]
#10 Magento\Framework\Model\AbstractModel->load() called at [app/code/Ves/All/Helper/Data.php:138]
#11 Ves\All\Helper\Data->getLicense() called at [app/code/Ves/All/Observer/CheckLicense.php:77]
#12 Ves\All\Observer\CheckLicense->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#13 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#14 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66]
#15 Magento\Framework\Event\Manager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95]
#16 Magento\Framework\Event\Manager\Proxy->dispatch() called at [app/code/Ves/All/Block/Adminhtml/License.php:30]
#17 Ves\All\Block\Adminhtml\License->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1099]
#18 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1103]
#19 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:673]
#20 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:564]
#21 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:540]
#22 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#23 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#24 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#25 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#26 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#27 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#28 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#29 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#30 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#31 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#32 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#33 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#34 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#35 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#36 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#37 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#38 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#39 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#40 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#41 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#42 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#43 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#44 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#45 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:961]
#46 Magento\Framework\View\Layout->getOutput() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:492]
#47 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258]
#48 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#49 Magento\Framework\View\Result\Layout->renderResult() called at [generated/code/Magento/Backend/Model/View/Result/Page/Interceptor.php:37]
#50 Magento\Backend\Model\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120]
#51 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#52 Magento\Framework\App\Bootstrap->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 Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:107]
#2 Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:92]
#3 Magento\Framework\DB\Statement\Pdo\Mysql->_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 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]
#8 Magento\Framework\DB\Adapter\Pdo\Mysql->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 Magento\Framework\Model\ResourceModel\Db\AbstractDb->load() called at [app/code/Ves/All/Model/ResourceModel/License.php:50]
#11 Ves\All\Model\ResourceModel\License->load() called at [vendor/magento/framework/Model/AbstractModel.php:540]
#12 Magento\Framework\Model\AbstractModel->load() called at [app/code/Ves/All/Helper/Data.php:138]
#13 Ves\All\Helper\Data->getLicense() called at [app/code/Ves/All/Observer/CheckLicense.php:77]
#14 Ves\All\Observer\CheckLicense->execute() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:88]
#15 Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod() called at [vendor/magento/framework/Event/Invoker/InvokerDefault.php:74]
#16 Magento\Framework\Event\Invoker\InvokerDefault->dispatch() called at [vendor/magento/framework/Event/Manager.php:66]
#17 Magento\Framework\Event\Manager->dispatch() called at [generated/code/Magento/Framework/Event/Manager/Proxy.php:95]
#18 Magento\Framework\Event\Manager\Proxy->dispatch() called at [app/code/Ves/All/Block/Adminhtml/License.php:30]
#19 Ves\All\Block\Adminhtml\License->_toHtml() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1099]
#20 Magento\Framework\View\Element\AbstractBlock->Magento\Framework\View\Element\{closure}() called at [vendor/magento/framework/View/Element/AbstractBlock.php:1103]
#21 Magento\Framework\View\Element\AbstractBlock->_loadCache() called at [vendor/magento/framework/View/Element/AbstractBlock.php:673]
#22 Magento\Framework\View\Element\AbstractBlock->toHtml() called at [vendor/magento/framework/View/Layout.php:564]
#23 Magento\Framework\View\Layout->_renderBlock() called at [vendor/magento/framework/View/Layout.php:540]
#24 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#25 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#26 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#27 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#28 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#29 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#30 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#31 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#32 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#33 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#34 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#35 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#36 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#37 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#38 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#39 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#40 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#41 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#42 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:592]
#43 Magento\Framework\View\Layout->_renderContainer() called at [vendor/magento/framework/View/Layout.php:542]
#44 Magento\Framework\View\Layout->renderNonCachedElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:206]
#45 Magento\Framework\View\Layout\Interceptor->renderNonCachedElement() called at [vendor/magento/framework/View/Layout.php:495]
#46 Magento\Framework\View\Layout->renderElement() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:193]
#47 Magento\Framework\View\Layout\Interceptor->renderElement() called at [vendor/magento/framework/View/Layout.php:961]
#48 Magento\Framework\View\Layout->getOutput() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:492]
#49 Magento\Framework\View\Layout\Interceptor->getOutput() called at [vendor/magento/framework/View/Result/Page.php:258]
#50 Magento\Framework\View\Result\Page->render() called at [vendor/magento/framework/View/Result/Layout.php:171]
#51 Magento\Framework\View\Result\Layout->renderResult() called at [generated/code/Magento/Backend/Model/View/Result/Page/Interceptor.php:37]
#52 Magento\Backend\Model\View\Result\Page\Interceptor->renderResult() called at [vendor/magento/framework/App/Http.php:120]
#53 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#54 Magento\Framework\App\Bootstrap->run() called at [index.php:39]
</pre>

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Issue with missing table after upgrading Mega Menu extension

This was a weird one.

 

I thought it was maybe Magento cache. So cleared that last night. Didn't work so that's when I posted in the Magento forum and put a ticket in with @Landofcoder They got back to me and told me to clear my browser cache, which I felt like a jackass for not trying. It was getting late and frustration was pretty high b/c no critical errors anywhere, etc.

 

That initially didn't work, even after computer restart. So, I tried in Chrome, not Firefox. I had never used the admin in Chrome, so no cache to worry about. It worked. So, went back to Firefox and tried again. It worked. No freaking clue!

 

But, the final answer to this was VES/Land of Coder gave me the wrong version of MegaMenu to install in the first place. 3 weeks later, and lots of lazy, one sentence, support answers they gave me the correct version finally.

 

All seems to work now.

 

Thank so much for all your help @Nishu Jindal You've been great!

View solution in original post

25 REPLIES 25

Re: Issue with missing table after upgrading Mega Menu extension

Hi @frameroom ,

 

Can you please check is there any parent module in the package which is missing or forgot to upgrade that.

I checked the package and found that  ves_all_license table is created from the Ves_All module.

 

Confirm in setup_module table that do we have entry for Ves_All module or not. If there is no entry then please try to install this module.

 

Thanks!

 

-----------------------------------------

Problem solved? Click Accept as Solution!

Re: Issue with missing table after upgrading Mega Menu extension

Thanks for the reply @Nishu Jindal 

 

I checked and the module is in there. Here is a screenshot to show all the VES modules installed and their version number. If the screenshot doesn't show, please see bottom of this post for the info.

 

 

setup_module-VES-all-for-megamenu.PNG

 

If these aren't the latest versions, are you able to provide a link or file to download the latest with an instructions link/file too please?

 

Thanks again!

 

-----setup_module table data-----

 

Ves_All
1.0.2
1.0.2

Ves_BaseWidget
0.1.0
0.1.0

Ves_Blog
1.0.0
1.0.0

1.0.1
1.0.1

Ves_Megamenu
1.1.4
1.1.4

Ves_PageBuilder
1.0.0
1.0.0

Ves_Productlist
1.0.0
1.0.0

Ves_Setup
1.0.0
1.0.0

Ves_Themesettings
1.0.0
1.0.0

Re: Issue with missing table after upgrading Mega Menu extension

Hi @frameroom ,

 

Can you please follow below steps and verify

1. First delete entries from setup_module table (Ves_All and Ves_Megamenu)

please take backup of the table and i am considering you are doing these testes on development instance.

2. Please take backup of all the Ves tables related to megamenu ( we don't want to loose the data)

3. Now run commands 

php bin/magento setup:upgrade

php bin/magento setup:di:compile

php bin/magento setup:static-content:deploy -f

 

Thanks!

----------------------------

Problem solved? Click Accept as Solution!

Re: Issue with missing table after upgrading Mega Menu extension

Hi @frameroom ,

 

Are we able to solve our frontend + backend issue after the last solution. Please confirm.

 

Thanks!

Re: Issue with missing table after upgrading Mega Menu extension

Thanks for following up @Nishu Jindal I had replied but didn't notice for some reason the forum marked it as spam.

 

Currently, the front is working and I can sign into admin, but I have the following 2 issues:

 

1. The Menu top that I expect to show as the main menu isn't showing on the frontend. All sample data is imported and I can access this menu and all Mega Menus in admin>Venustheme>Mega Menu>Manage Menus. Here is a screenshot of all the menus:

 

https://www.screencast.com/t/WkpCecsgo3P

 

which leads to problem #2.

 

2. I can save all the menus except Main Top (main-top) and Main Top - Fixed to Scroll (main-top1). When I try to save them, I get a 404 page. Here is the url of both of them when I try to save after 404:

 

http://m2.vulcansrest.com/manageconsole/vesmegamenu/menu/save/key/51b88857cf7412d52d20c2ad795cf28eb4...

 

I thought it might be the sign in and out of admin thing that happens sometimes. It wasn't.

 

What do you think will fix these 2 things?

 

Thanks!

Re: Issue with missing table after upgrading Mega Menu extension

Hi @frameroom ,

Can you please check your log entries in magento_root/var/log/ folder. Please share if there is any issue related to mega menu. 

 

Also could you please try to delete existing topmenu entry and try to create one dummy entry. It seems like there is some issue in menu top sample data.

 

Thanks!

Re: Issue with missing table after upgrading Mega Menu extension

The logs don't show much from Mega Menu.

 

Here is the last message from system.log and debug.log:

 

[2020-04-29 17:33:49] main.INFO: Broken reference: the 'megamenu_license' element cannot be added as child to 'notices.wrapper', because the latter doesn't exist [] []

 

That looks like it was before I put the license in but you'll know if that is exactly what that means. As far as the most recent entries in system, here they are and they are happening during the issue I'll describe below, though not sure if related at all:

 

system.log

[2020-04-29 18:10:19] main.ERROR: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/themes/modern/theme.js' [] []
[2020-04-29 18:10:19] main.CRITICAL: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/themes/modern/theme.js' [] []
[2020-04-29 18:11:28] main.ERROR: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/tinymce.js' [] []
[2020-04-29 18:11:28] main.CRITICAL: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/tinymce.js' [] []
[2020-04-29 18:12:06] main.INFO: Consumer "async.operations.all" skipped as required connection "amqp" is not configured. Unknown connection name amqp [] []
[2020-04-29 18:12:47] main.ERROR: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/tinymce.js' [] []
[2020-04-29 18:12:47] main.CRITICAL: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/tinymce.js' [] []

 

debug.log

[2020-04-29 18:12:47] main.ERROR: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/tinymce.js' [] []
[2020-04-29 18:12:47] main.CRITICAL: Unable to resolve the source file for 'adminhtml/Magento/backend/en_US/tinymce.js' [] []

 

Here is the current issue:

 

- I deleted the menus Main Top and Main Top - Fixed to Scroll. I made a new Main Menu alias main-top. It has several menu items. One custom link to / and 3 of category links. It will now show in on the frontend (after using "Clear Magento Cache" button in Cache Management, but all the links are #. There are no issues in inspector console.

 

Any ideas?

 

Thanks again @Nishu Jindal  for the assistance. We are almost there with this I think!

 

Re: Issue with missing table after upgrading Mega Menu extension

Hi @frameroom ,

For the links,can you please check ves_megamenu_item table entries for 3 columns

1. link_type (custom_link, category_link)

2. link (url) in case of custom_link

3. category (category_id) in case of category_link

 

For more information, please refer my screenshot.

Screenshot from 2020-04-30 10-24-57.png

 

Thanks!

--------------------------------

Problem solved? Click Accept as Solution!

Re: Issue with missing table after upgrading Mega Menu extension

Hi @Nishu Jindal 

 

Basically, I can see all the category links that correctly show category link in Manage Mega Menu are in the table as with no data in the link column, but show as "category_link" as the type. Here is a screenshot of my admin:

 

https://www.screencast.com/t/bwxj5vEmRF

 

Here is  a screenshot of the table:

 

https://www.screencast.com/t/16E9CdiJAz

 

Now we know the what is causing it, but I guess we need to understand why? Right?

 

What do you think?

 

Thanks again!