Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: There has been a critical error processing your request  (Read 4329 times)

Offline nerdinho

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
There has been a critical error processing your request
« 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?
« Last Edit: May 23, 2016, 06:02:49 PM by nerdinho »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1816
  • Karma: +264/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: There has been a critical error processing your request
« Reply #1 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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline mblogs30

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: There has been a critical error processing your request
« Reply #2 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?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1816
  • Karma: +264/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: There has been a critical error processing your request
« Reply #3 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
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod