解决
点击搜索图标->勾选"所有栏目"->解决
分析
异常时,请求地址中缺少 '_headers' 参数的值,未发现数据库有执行异常查询,则错误在前端,在前段查看时看见搜索图标有下拉选择,点进去后,发现所有搜索项均未被勾选,则确定是此处错误,勾选"所有栏目"后,正常。
正常时与异常时
正常时
# 请求地址
https://domian.com/mail/?_task=addressbook&_action=search&_q=ceshi&_headers=name%2Cfirstname%2Csurname%2Cemail%2C*&_scope=base&_source=0&_remote=1&_unlock=loading1600760395600&_=1600760388787
# Debug
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [1] SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = '8ckr5qjdkebtdvceokhujd3fb7';
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [2] SELECT * FROM `users` WHERE `user_id` = '960';
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [3] SELECT * FROM `users` WHERE `mail_host` = 'localhost' AND `username` = '[global_addressbook_user]';
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [4] SELECT COUNT(c.`contact_id`) AS cnt FROM `contacts` AS c WHERE c.`del` <> 1 AND c.`user_id` = '960' AND ((`words` LIKE '%ceshi%'));
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [5] SELECT COUNT(c.`contact_id`) AS cnt FROM `contacts` AS c WHERE c.`del` <> 1 AND c.`user_id` = '74' AND ((`words` LIKE '%ceshi%'));
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [6] SELECT * FROM `contacts` AS c WHERE c.`del` <> 1 AND c.`user_id` = '74' AND (`words` LIKE '%ceshi%') ORDER BY
CONCAT(c.`surname`, c.`firstname`, c.`name`, c.`email`) ASC LIMIT 9999;
Sep 22 11:57:32 mail roundcube: <8ckr5qjd> [7] UPDATE `session` SET `changed` = now(), `vars` =
'bGFuZ3VhZ2V8czo1OiJ6aF9DTiI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp
省略...
6MDtzOjE6IioiO2k6MTtzOjY6Inpob3V3aiI7fX0=' WHERE `sess_id` = '8ckr5qjdkebtdvceokhujd3fb7';
异常时
# 请求地址:
https://domian.com/mail/?_task=addressbook&_action=search&_q=ceshi&_headers=&_scope=base&_remote=1&_unlock=loading1600760311319&_=1600759855322
# Debug:
Sep 22 11:58:55 mail roundcube: <951u9mvt> [1] SELECT `vars`, `ip`, `changed`, now() AS ts FROM `session` WHERE `sess_id` = '951u9mvt8ik1sq080u4h324mg7';
Sep 22 11:58:55 mail roundcube: <951u9mvt> [2] SELECT * FROM `users` WHERE `user_id` = '4';
Sep 22 11:58:55 mail roundcube: <951u9mvt> [3] SELECT * FROM `users` WHERE `mail_host` = 'localhost' AND `username` = '[global_addressbook_user]';
Sep 22 11:58:55 mail roundcube: <951u9mvt> [4] UPDATE `session` SET `changed` = now(), `vars` =
'bGFuZ3VhZ2V8czo1OiJ6aF9DTiI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp
省略...
6e2k6MDthOjA6e31pOjE7czo2OiJ6aG91d2oiO319' WHERE `sess_id` = '951u9mvt8ik1sq080u4h324mg7';