Smart Search Indexer - MariaDB SQL Syntax Error

Did you find a bug in Joomla! 3.x but aren't sure? This forum is the place to help figure out if the problem is a bug and how to report it. If you are an experienced Joomla! user and are certain that you have found a bug please use the Bug Tracker to submit your issue.
This forum is for discussion about bugs and to get help with reporting them to the Bug Tracker: https://issues.joomla.org

Moderator: ooffick

Forum rules
Please use the official Bug Tracker to report a bug: https://issues.joomla.org
Post Reply
smirre
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Fri Jul 11, 2008 4:45 pm

Smart Search Indexer - MariaDB SQL Syntax Error

Post by smirre » Mon Oct 01, 2018 7:31 am

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
You do not have the required permissions to view the files attached to this post.
[Joomla 3.8.12]

smirre
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Fri Jul 11, 2008 4:45 pm

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Post by smirre » Mon Oct 01, 2018 4:02 pm

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
[Joomla 3.8.12]

smirre
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Fri Jul 11, 2008 4:45 pm

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Post by smirre » Tue Oct 02, 2018 6:48 pm

anyone you can help me here?
[Joomla 3.8.12]

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 35867
Joined: Sat Apr 05, 2008 9:58 pm

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Post by Webdongle » Tue Oct 02, 2018 9:35 pm

http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"The definition of insanity is doing the same thing over and over again, but expecting different results": Albert Einstein

smirre
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Fri Jul 11, 2008 4:45 pm

Re: Smart Search Indexer - MariaDB SQL Syntax Error

Post by smirre » Wed Oct 03, 2018 6:47 am

hi Webdongle, thx for info.
i have published there my problem.
i think my post could deleted here know...
[Joomla 3.8.12]


Post Reply

Return to “Joomla! 3.x Bug Reporting”