There has been a critical error processing your request

Started by nerdinho, May 23, 2016, 05:35:06 PM

Previous topic - Next topic

nerdinho

I'm having problems with my translation.

When select the translation in storefront, and click add product to cart an error is generated in the application:

Error Log
Quote2016-05-23 23:16:45 - database error: AbanteCart core v.1.2.7 SQL Error: 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 ')
ORDER BY rm.object_id ASC, rm.sort_order ASC, rl.resource_id ASC' at line 22
Error No: 1064
SQL:
SELECT
rm.object_id,
rl.resource_id,
COALESCE(rd.name,rdd.name) as name,
COALESCE(rd.title,rdd.title) as title,
COALESCE(rd.description,rdd.description) as description,
COALESCE(rd.resource_path,rdd.resource_path) as resource_path,
COALESCE(rd.resource_code,rdd.resource_code) as resource_code,
rm.default,
rm.sort_order
FROM abc_resource_library rl
LEFT JOIN abc_resource_map rm
ON rm.resource_id = rl.resource_id
LEFT JOIN abc_resource_descriptions rd
ON (rl.resource_id = rd.resource_id
AND rd.language_id = '2')
LEFT JOIN abc_resource_descriptions rdd
ON (rl.resource_id = rdd.resource_id
AND rdd.language_id = '1')
WHERE rm.object_name = 'products'
AND rl.type_id = 1
AND rm.object_id IN ()
ORDER BY rm.object_id ASC, rm.sort_order ASC, rl.resource_id ASC in <b>C:\Desenvolvimento\dev.abantecart.com\public_html\core\database\amysqli.php</b> on line <b>106</b>

I do not know what is causing this error can someone help me?

abolabo

solution is replacement of file core/engine/resource.php with this https://raw.githubusercontent.com/abantecart/abantecart-src/bbc86dff1ff48987b5b8df1b838173c0db217995/public_html/core/engine/resources.php

Error related to empty descriptions of products. When you added new languages you should to save it's name in your new language.
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

mblogs30



There has been a critical error processing your request

No template layout found for page_id/controller ::! Requested data: template: tem_1, page_id: , layout_id: Execution stack: - /home/wolvesmarket/public_html/ac/core/lib/layout_manager.php(121): genExecTrace('full') - /home/wolvesmarket/public_html/ac/extensions/banner_manager/admin/controller/pages/extension/banner_manager.php(928): ALayoutManager->__construct('tem_1') - /home/wolvesmarket/public_html/ac/extensions/banner_manager/admin/controller/pages/extension/banner_manager.php(757): ControllerPagesExtensionBannerManager->_getBlockForm() - [internal function]: ControllerPagesExtensionBannerManager->edit_block('content0') - /home/wolvesmarket/public_html/ac/core/engine/dispatcher.php(288): call_user_func_array(Array, Array) - /home/wolvesmarket/public_html/ac/core/engine/dispatcher.php(380): ADispatcher->dispatch(Object(ControllerCommonPage)) - /home/wolvesmarket/public_html/ac/core/engine/page.php(98): ADispatcher->dispatch() - /home/wolvesmarket/public_html/ac/core/engine/router.php(155): APage->build('extension/banne...') - /home/wolvesmarket/public_html/ac/core/engine/router.php(75): ARouter->_route() - /home/wolvesmarket/public_html/ac/index.php(86): ARouter->processRoute('extension/banne...') in /home/wolvesmarket/public_html/ac/core/lib/layout_manager.php on line 122


What to do now?

abolabo

Hello.
Please try to enable banner manager extension and check what banner block presents in your layout
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

Forum Rules Code of conduct
AbanteCart.com 2010 -