-
会员列表分页MySQL Error，暴露数据表
-
-
会员列表分页（/index.php?c=user&a=list&page=分页数），如果URL中把分页数的数字改为大于实际拥有分页数后显示 MySQL Error，显示如下，xxx是数据表前缀：MySQL Error
Message: MySQL Query Error
SQL: SELECT v.*, s.emailrz, s.mobilerz, s.idnumberrz, s.videorz, s.star, vip.vipenddate, p.* FROM xxx_user AS v LEFT JOIN xxx_user_status AS s ON v.userid=s.userid LEFT JOIN xxx_user_validate AS vip ON v.userid=vip.userid LEFT JOIN xxx_user_profile AS p ON v.userid=p.userid WHERE v.userid IN () ORDER BY v.userid DESC
Error: 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 ') ORDER BY v.userid DESC' at line 1
Errno.: 1064官方演示没有这个问题，请问如何解决？
-
2505 次浏览
1 条评论
收藏
1个评论
-
-
--
2020-12-01 10:00
-
收到BUG反馈，新补丁将会修复该BUG。
-
-
回复 · 0条回复
-
作者信息
-
关注
-
试
免费试用
-
咨询热线
-
咨询热线
020-82299 259
-
在线咨询
