Missing a parenthesis closure in the line of code. JS Jobs v1.1.9
File:
/components/com_jsjobs/models/jobalert.php
Change line 554:
$metakeywords[] = " job.metakeywords LIKE LOWER (".$db->Quote('%'.$keywords[$j].'%');
by:
$metakeywords[] = " job.metakeywords LIKE LOWER (".$db->Quote('%'.$keywords[$j].'%')
. ")";
Otherwise error message when running the link provided by the cron:
/administrator/index.php?option=com_jsjobs&c=configuration&view=configuration&layout=cronjob
ERROR 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 x.
Reference:
mariadb.com/kb/en/library/parentheses/