× This is the optional Forum header for the Suggestion Box.

Correct a CRON line for a future version of JS Job

7 months 4 weeks ago - 7 months 4 weeks ago #5087 by René Paul
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/
Time to create page: 0.216 seconds

Please publish modules in offcanvas position.