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

Correct a CRON line for a future version of JS Job

5 months 1 day ago - 5 months 1 day ago #5087 by René Paul
Missing a parenthesis closure in the line of code. JS Jobs v1.1.9


Change line 554:
$metakeywords[] = " job.metakeywords LIKE LOWER (".$db->Quote('%'.$keywords[$j].'%');

$metakeywords[] = " job.metakeywords LIKE LOWER (".$db->Quote('%'.$keywords[$j].'%') . ")";

Otherwise error message when running the link provided by the cron:


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/

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

Time to create page: 0.334 seconds

Please publish modules in offcanvas position.