题单搜索处无法正常工作
  • 板块工单反馈版
  • 楼主Javi
  • 当前回复1
  • 已保存回复1
  • 发布时间2020/7/16 10:28
  • 上次更新2023/11/6 23:02:45
查看原帖
题单搜索处无法正常工作
40003
Javi楼主2020/7/16 10:28

点击此处可以访问出错位置。

官方题单如果搜索一些关键词会导致SQL语法错误,并且会给出出错的语句。

比如说搜索114514可以获得下列错误信息。

An exception occurred while executing 'SELECT tp.`trainingId`, COUNT(1) as cnt FROM training_problem tp WHERE (tp.`upid` IN (52391,52431,53158,42583,42775,43070,43080,43193,43460,43462,43604,43703,43738,43829,43832,43847,43977,44204,44321,44330,44564,44633,44798,44953,45080,45085,45157,45249,45422,45911,45925,46019,46021,46022,46023,46103,46144,46160,46698,121171,133944,137565,143588,143825,144690,150345,151350,151351,153496,156336,156384,164549,165076,166916,170646,174567,174569,179532,179533,179534,180580,180581,184596,196058,196059,196060,1,2,3,7,8,9,10,12,14,15,17,19,24,25,28,29,31,32,35,36,42,44,46,47,48,49,51,55,59,60,61,62,67,68,71,75,78,80,82,83,85,86,88,89,90,91,93,94,96,97,98,101,102,111,113,115,118,125,138,141,149,150,151,157,162,165,168,171,177,179,190,192,197,200,218,219,226,258,270,303,307,309,314,319,328,339,352,359,376,419,420,421,422,423,424,425,427,428,429,433,434,445,463,464,469,478,480,482,486,516,525,531,534,536,540,546,547,548,551,554,563,567,580,597,601,603,615,618,631,634,638,652,657,706,720,727,737,739,765,801,808,821,843,847,876,879,886,888,890,892,896,902,908,909,914,932,939,957,962,980,981,996,1005,1010,1014,1024,1032,1040,1078,1084,1089,1096,1228,1234,1269,1294,1327,1332,1333,1336,1338,1344,1368,1503,1523,1571,1664,1671,1771,1828,1837,1843,2081,2176,2285,2296,2505,2621,2736,2751,2847,2874,2890,2928,2998,3044,3056,3196,3246,3247,3432,3611,3717,3785,3786,3788,3792,3794,3811,4097,4254,4732,5762,5880,5881,5884,5892,5898,5905,5909,5938,5952,5989,6032,6075,6337,6819,6973,7467,7488,7495,7511,7528,7543,7572,7573,7672,7917,7952,7963,7981,8454,8542,9585,11595,15735,15950,18284,19339,22297,22340,23530,36043,42435,42443,62048,62652,62670,63661,65442,65495,66297,66298,69828,72041,81019,105502,110445,110491,122040,145709,157721,164435,168600,174143,174144,174145,179147,184514,184921,184922,184924,184925,184926,184927,184929,184930,184935,186121,186134,186828,47091,47272,47327,48245,53618,53851,54651,57611)) AND (tp.`trainingId` IN ()) GROUP BY tp.`trainingId` ORDER BY tp.`trainingId` asc LIMIT 50': SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) GROUP BY tp.`trainingId` ORDER BY tp.`trainingId` asc LIMIT 50' at line 1

或许可以CTF?如果 @kkksc03 允许的话。

2020/7/16 10:28
加载中...