The forum is in read only mode.

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

Correct a CRON line for a future version of JS Job

6 years 4 months ago - 6 years 4 months 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/
Time to create page: 0.054 seconds

Please publish modules in offcanvas position.