Issue with missing table after upgrading Mega Menu extension

[frameroom]

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>

[Nishu Jindal]

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!

[frameroom]

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.

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

[Nishu Jindal]

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!

[Nishu Jindal]

Hi @frameroom ,

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

Thanks!

[frameroom]

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!

[Nishu Jindal]

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!

[frameroom]

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!

[Nishu Jindal]

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.

Thanks!

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

Problem solved? Click Accept as Solution!

[frameroom]

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!