I get the following SQl error instep 8:
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND newsletter_subject = ‘Rock Around the Jukebox 2016′ AND queue_start_at = ’20’ at line 1. The SQL statement executed was: SELECT * FROM `newsletter_queue` `t` WHERE template_id = 5 AND newsletter_type = AND newsletter_subject = ‘Rock Around the Jukebox 2016’ AND queue_start_at = ‘2016-10-04 08:08:18’ LIMIT 1
Anything I can do to prevent this?
7 answers
Hi there,
What is version of our tool in your working now? You could do steps as followings to solve the issue:
Step 1: Download the php file at HERE
Step 2: Upload replace downloaded file to the file at path: pub/ub-tool/protected/controllers/Step8Controller.php
Step 3: Once done, you can continue with data migration in the step #8 of our tool.
And tell me know how it goes.
Regards,
Mall.
Now the conversion is working but the front end is not working anymore.
After re-indexing and cleaning the cache opening and saving all stores I get this error in the frontend:
1 exception(s):
Exception #0 (Magento\Framework\Exception\NoSuchEntityException): No such entity with id = 14
Exception #0 (Magento\Framework\Exception\NoSuchEntityException): No such entity with id = 14
#0 /home/jukeboxs/public_html/vendor/magento/module-catalog/Model/CategoryRepository.php(141): Magento\Framework\Exception\NoSuchEntityException::singleField('id', '14')
#1 /home/jukeboxs/public_html/app/code/Ubertheme/UbMegaMenu/Helper/Mega.php(785): Magento\Catalog\Model\CategoryRepository->get('14', '3')
#2 /home/jukeboxs/public_html/app/code/Ubertheme/UbMegaMenu/Helper/Mega.php(119): Ubertheme\UbMegaMenu\Helper\Mega->_getActiveItem(Array)
#3 /home/jukeboxs/public_html/app/code/Ubertheme/UbMegaMenu/Block/Menu.php(124): Ubertheme\UbMegaMenu\Helper\Mega->rebuildData(Array)
#4 /home/jukeboxs/public_html/app/code/Ubertheme/UbMegaMenu/Block/Menu.php(102): Ubertheme\UbMegaMenu\Block\Menu->_generateMenuHtml('1')
#5 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(659): Ubertheme\UbMegaMenu\Block\Menu->_toHtml()
#6 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#7 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('main.ub.mega.me...')
#8 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main.ub.mega.me...')
#9 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main.ub.mega.me...')
#10 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main.ub.mega.me...', true)
#11 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(503): Magento\Framework\View\Layout\Interceptor->renderElement('main.ub.mega.me...', true)
#12 /home/jukeboxs/public_html/vendor/magento/module-theme/view/frontend/templates/html/container.phtml(10): Magento\Framework\View\Element\AbstractBlock->getChildHtml()
#13 /home/jukeboxs/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/jukeboxs/...')
#14 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(255): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Framework\View\Element\Template), '/home/jukeboxs/...', Array)
#15 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(279): Magento\Framework\View\Element\Template->fetchView('/home/jukeboxs/...')
#16 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(659): Magento\Framework\View\Element\Template->_toHtml()
#17 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#18 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('store.menu')
#19 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('store.menu')
#20 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('store.menu')
#21 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('store.menu', true)
#22 /home/jukeboxs/public_html/vendor/magento/module-theme/view/frontend/templates/html/sections.phtml(26): Magento\Framework\View\Layout\Interceptor->renderElement('store.menu')
#23 /home/jukeboxs/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/jukeboxs/...')
#24 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(255): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Framework\View\Element\Template), '/home/jukeboxs/...', Array)
#25 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(279): Magento\Framework\View\Element\Template->fetchView('/home/jukeboxs/...')
#26 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(659): Magento\Framework\View\Element\Template->_toHtml()
#27 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#28 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('navigation.sect...')
#29 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('navigation.sect...')
#30 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('navigation.sect...')
#31 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('navigation.sect...', true)
#32 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('navigation.sect...')
#33 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('page.top')
#34 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.top')
#35 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.top')
#36 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.top', true)
#37 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('page.top')
#38 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('page.wrapper')
#39 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper')
#40 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.wrapper')
#41 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.wrapper', true)
#42 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('page.wrapper')
#43 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('root')
#44 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('root')
#45 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('root')
#46 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('root', true)
#47 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(938): Magento\Framework\View\Layout\Interceptor->renderElement('root')
#48 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Framework\View\Layout->getOutput()
#49 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(494): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array)
#50 /home/jukeboxs/public_html/vendor/magento/framework/View/Result/Page.php(243): Magento\Framework\View\Layout\Interceptor->getOutput()
#51 /home/jukeboxs/public_html/vendor/magento/framework/View/Result/Layout.php(164): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#52 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#53 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Framework\View\Result\Page\Interceptor->___callParent('renderResult', Array)
#54 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'renderResult', Object(Magento\Framework\View\Result\Page\Interceptor), Array, 'result-varnish-...')
#55 /home/jukeboxs/public_html/vendor/magento/module-page-cache/Model/Controller/Result/VarnishPlugin.php(74): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor))
#56 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\PageCache\Model\Controller\Result\VarnishPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#57 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'renderResult', Object(Magento\Framework\View\Result\Page\Interceptor), Array, 'result-builtin-...')
#58 /home/jukeboxs/public_html/vendor/magento/module-page-cache/Model/Controller/Result/BuiltinPlugin.php(67): Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor))
#59 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(142): Magento\PageCache\Model\Controller\Result\BuiltinPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#60 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Result/Page/Interceptor.php(130): Magento\Framework\View\Result\Page\Interceptor->___callPlugins('renderResult', Array, Array)
#61 /home/jukeboxs/public_html/vendor/magento/framework/App/Http.php(139): Magento\Framework\View\Result\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#62 /home/jukeboxs/public_html/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#63 /home/jukeboxs/public_html/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#64 {main}
Hi there,
1 exception(s):
Exception #0 (Magento\Framework\Exception\NoSuchEntityException): No such entity with id = 14
Exception #0 (Magento\Framework\Exception\NoSuchEntityException): No such entity with id = 14
#0 /home/jukeboxs/public_html/vendor/magento/module-catalog/Model/CategoryRepository.php(141): Magento\Framework\Exception\NoSuchEntityException::singleField(‘id’, ’14’)
#1 /home/jukeboxs/public_html/app/code/Ubertheme/UbMegaMenu/Helper/Mega.php(785): Magento\Catalog\Model\CategoryRepository->get(’14’, ‘3’)
That issue because in back-end of UBMegaMenu, you have setting a menu item with category_id = 14 in first time. But seem you have deleted that category from your categories tree? Let’s try re-update your menu items in back-end of the UBMegamenu extension.
And clean the Magento cache and tell me know how it goes.
Regards,
Mall.
Nothing wrong with the menu. How can I see what is category 14?
There is a strange thing on each product page in the backend.
When I try to save a product I get this error:
Required parameter ‘theme_dir’ was not passed
Hi there,
How can I see what is category 14?
You can find that menu item by run bellow SQL statement:
SELECT * FROM `ubmegamenu_item` WHERE `category_id` = 14;
When I try to save a product I get this error:
Required parameter ‘theme_dir’ was not passed
Seem that issue was not relates to our tool. What did you do with your site? Kindly re-check recent your activity with your site.
You could view more about that issue at here: https://magento.stackexchange.com/questions/100011/required-parameter-theme-dir-was-not-passed
Regards,
Mall.
Thanks,
All is working again.
Hi there,
Yeah, let’s contact me if you need further assistance.
Regards,
Mall.
