suitecrm - 客户关系管理套件,创建用户问题
问题描述
我的问题是,当我在按下保存后尝试从 Suite CRM(用户管理)创建普通用户时,服务器在没有任何响应的情况下加载,同时另一个活动用户收到消息(无法连接到数据库),直到我需要重启服务器?
解决方案
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][INFO] Query: SELECT alerts.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM alerts LEFT JOIN users jt0 ON alerts.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON alerts.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON alerts.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where (alerts.assigned_user_id = '8dfa3f2c-e526-6242-6732-585643139abd' AND is_read != '1') AND alerts.deleted=0
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][INFO] Query Execution Time:0.0002281665802002
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][DEBUG] process_full_list_query: result is mysqli_result Object
(
[current_field] => 0
[field_count] => 23
[lengths] =>
[num_rows] => 0
[type] => 0
)
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][WARN] Saving error level. Try to remove the error_reporting() function from your code.
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][WARN] Pop error level. Try to remove the error_reporting() function from your code.
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][DEBUG] Hook called: ::server_round_trip
Wed Sep 11 11:33:41 2019 [30147][8dfa3f2c-e526-6242-6732-585643139abd][DEBUG] Calling MySQLi::disconnect()
推荐阅读
- laravel-5 - Laravel 命令在 AWS EC2 上由 Cron 执行时返回不同的输出
- mysql - 查询获取差异的问题
- postman - 使用 postman 中的 setNextRequest 使用来自 json 的新迭代数据运行下一个请求
- c# - 如何从 Acumatica API 获取客户活动
- python - Python - for 循环的问题(猜颜色 - 游戏)
- python - 在 Python 中标记文件时设置位数
- javascript - 使用键盘快捷键运行 chrome 扩展
- angular - 角度 2 问题“可观察类型上不存在地图”
- python - 将字典嵌套到python中的单个字典
- apache-spark - 如何在 Apache Spark 中分解 JSON 数组