Page 1 of 1

Smart Search Indexer - MariaDB SQL Syntax Error

Posted: Mon Oct 01, 2018 7:31 am
by smirre
Hi.

I noticed that the Smart Search Indexer are failing and does stop always around 90%.

I attached the error message from the backend.
The error came up on both sides when i run the indexer: CLI and Backend

Maybe someone have the same problem or can help me here.

CONFIG:
server: cloudserver - Linux ubuntu 18 x64
server administration: runcloud
Database: 5.5.5-10.2.15-MariaDB-1:10.2.15+maria~bionic-log
PHP: 7.2.8
Webserver: Apache/2.4.34
Joomla: 3.8.12

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Posted: Mon Oct 01, 2018 4:02 pm
by smirre
i tested also to increase the memory size for this mysql entries, without luck:

Code: Select all

tmp_table_size = 64M
max_heap_table_size = 64M 
the error still exists:

Code: Select all

...
* Processed batch 92 in 5.166 seconds.
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 'LIMIT 12' at line 1
i also read this documentations, but I haven't found a workable solution:
https://docs.joomla.org/Smart_Search_co ... on_options
https://docs.joomla.org/Smart_Search_on_large_sites

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Posted: Tue Oct 02, 2018 6:48 pm
by smirre
anyone you can help me here?

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Posted: Tue Oct 02, 2018 9:35 pm
by Webdongle

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Posted: Wed Oct 03, 2018 6:47 am
by smirre
hi Webdongle, thx for info.
i have published there my problem.
i think my post could deleted here know...