On 2024-11-21 at 14:12:51, 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 (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,930,933,935,937,939,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,959,960,961,962,965,966,967,969,971,972,973,974,976,985,986,987,988,989,990,994,995,996,997,998,999,1003,1016,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1137,1138,1139,1140,1147,1152,1155,1156,1157,1158,1159,1160,1161,1178,1180,1183,1184) order by fld_mod_date desc limit -5, 5
Mr.
