On 2018-08-19 at 05:03:24, an sql error occured. When asked the trouble, the database said:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-5, 5' at line 1"

The error was thrown from in the function and the offending sql statement is below:


select * from tbl_postjob where 1 and fld_status='1' and fld_jobId in (189,190,191,195,196,202,204,205,210,247,252,253,280,282,294,302,304,305,306,312,313,316,342,343,579,583,584,585,586,701,702,703,704,705,706,707,708,709,710,729,730,731,732,754,761,763,779,783,785,789,790,795,796,797,811,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,869,870,873,874,875,878,882,885,886,893,894,896,898,899,900,905,907,908,911,912,913,914,915,916,920,921,922,923,924,925,926,927,928) order by fld_mod_date desc limit -5, 5
MyFutureJob