AbanteCart Community

Shopping Cart Operations => Support => Topic started by: nerdinho on May 23, 2016, 05:35:06 PM

Title: There has been a critical error processing your request
Post by: nerdinho on May 23, 2016, 05:35:06 PM

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

Quote

2016-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?

Title: Re: There has been a critical error processing your request
Post by: abolabo on May 26, 2016, 07:55:22 AM

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.

Title: Re: There has been a critical error processing your request
Post by: mblogs30 on August 27, 2017, 08:42:18 AM

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?

Title: Re: There has been a critical error processing your request
Post by: abolabo on September 04, 2017, 03:26:02 AM

Hello.
Please try to enable banner manager extension and check what banner block presents in your layout