解决

点击搜索图标->勾选"所有栏目"->解决

分析

异常时,请求地址中缺少 '_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';
最后修改:2020 年 12 月 30 日 04 : 34 PM
如果觉得文章帮助了您,您可以随意赞赏。