Update 3.3.0

  • Posts: 26
  • Thank you received: 1
6 years 9 months ago #288406

-- HikaShop version -- : 3.3.0 Business
-- Joomla version -- : 3.8.5
-- PHP version -- : 7.2.2
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

Hello,

I just update with Joomla Updater to 3.3.0 from 3.2.2 I think and I get the following message. Products doesn't apears, just error message.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

I have tried to correct the data base in Joomla tools
Tks for help

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
6 years 9 months ago #288448

Hi,

Please do the modification as explained in www.hikashop.com/support/forum/install-u...mbiguous.html#287405 , activate the "error reporting" and the "debug mode" settings of the Joomla configuration and check the page with the error again.
It will provide the full MySQL query which creates the problem and more information on the error. That will help us understand the situation.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 1
6 years 9 months ago #288454

Hello,

With debug mode and error report on Maximun, that's the message I get:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:650
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652
3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikashop/classes/filter.php:456
4 hikashopFilterClass->getProductList() JROOT/components/com_hikashop/views/product/tmpl/filter.php:100
5 include() JROOT/libraries/src/MVC/View/HtmlView.php:695
6 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:2197
7 hikashopView->loadTemplate() JROOT/components/com_hikashop/views/product/tmpl/listing.php:219
8 include() JROOT/libraries/src/MVC/View/HtmlView.php:695
9 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:2197
10 hikashopView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230
11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2186
12 hikashopView->display() JROOT/components/com_hikashop/views/product/view.html.php:29
13 ProductViewProduct->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820
14 hikashop_getLayout() JROOT/components/com_hikashop/views/category/tmpl/listing.php:124
15 include() JROOT/libraries/src/MVC/View/HtmlView.php:695
16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:2197
17 hikashopView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230
18 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2186
19 hikashopView->display() JROOT/components/com_hikashop/views/category/view.html.php:26
20 CategoryViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
21 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
22 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1649
23 hikashopController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710
24 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
25 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79
26 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382
27 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357
28 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
29 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
30 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303
31 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
6 years 9 months ago #288455

Hi,

So there is a problem with one of the filters configured on your website. You can go in the menu Display>Filters and disable them one by one until you don't have the problem and keep the one(s) creating the error disabled for now.
Also, do the modification I talked about so that we can get the full MySQL query creating the error.

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 1
6 years 9 months ago #288503

Hello,

If I disable all the filters it correct the display problem but as soon as I put one filter the problem come back. I need the filters for a Search menu if I remember well.

The full SQL error mesage it that one:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 SELECT DISTINCT b.product_id FROM xfxwq_hikashop_product_category AS a LEFT JOIN xfxwq_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (a.category_id IN (21)) AND (b.product_quantity!=0) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) )
Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:650
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652
3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikashop/classes/filter.php:456
4 hikashopFilterClass->getProductList() JROOT/components/com_hikashop/views/product/tmpl/filter.php:100
5 include() JROOT/libraries/src/MVC/View/HtmlView.php:695
6 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:2197
7 hikashopView->loadTemplate() JROOT/components/com_hikashop/views/product/tmpl/listing.php:219
8 include() JROOT/libraries/src/MVC/View/HtmlView.php:695
9 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:2197
10 hikashopView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230
11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2186
12 hikashopView->display() JROOT/components/com_hikashop/views/product/view.html.php:29
13 ProductViewProduct->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820
14 hikashop_getLayout() JROOT/components/com_hikashop/views/category/tmpl/listing.php:124
15 include() JROOT/libraries/src/MVC/View/HtmlView.php:695
16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:2197
17 hikashopView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230
18 Joomla\CMS\MVC\View\HtmlView->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2186
19 hikashopView->display() JROOT/components/com_hikashop/views/category/view.html.php:26
20 CategoryViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
21 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
22 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1649
23 hikashopController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710
24 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
25 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79
26 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382
27 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357
28 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
29 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
30 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303
31 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
6 years 9 months ago #288508

Hi,

Thank you for the additional details.
Change the line:

$query='SELECT DISTINCT b.product_id'.$fieldsLimits.' '.preg_replace("/ORDER BY.*?(?=\\s*LIMIT|\\)|$)/mi", "", $copy_query);
to:
$query='SELECT DISTINCT b.product_id'.$fieldsLimits.' '.$copy_query;
in the file /administrator/components/com_hikashop/classes/filter.php and that should fix the issue.

The following user(s) said Thank You: Terresco

Please Log in or Create an account to join the conversation.

  • Posts: 26
  • Thank you received: 1
6 years 9 months ago #288516

Hello, perfect all is in order now. Thank you very much for the help.

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum