php - 错误消息: MySQL server has gone away

Question

Warning: mysql_query() [function.mysql-query]:
MySQL server has gone away in C:\wamp\www\amp10\hrd_consultant_ho_all_display.php on line 254

Warning: mysql_query() [function.mysql-query]: Error reading result set's header in C:\wamp\www\amp10\hrd_consultant_ho_all_display.php on line 254

Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\amp10\hrd_consultant_ho_all_display.php on line 254

我从查询中收到了上述错误，但我不知道如何解决它。下面是我的代码。新手接受任何帮助...谢谢

SELECT * , (SELECT CASE WHEN audited = 1 THEN 'YES' ELSE 'NO' END FROM activity_ref WHERE         
activity_ref.ref_no = activity_plan.ref_no ) AS test_audited
FROM 
activity_plan
inner join user on activity_plan.sales_officer=user.username
INNER JOIN activity_liquid ON activity_plan.aplan_no = activity_liquid.aplan_no
where activity_plan.date between '$date1' and '$date2' and user.branch='no' and     
user.position='Consultant' and activity_plan.validate_1st_status!='pending'  order by     
activity_plan.sales_officer asc,activity_plan.aplan_no asc  

Answer 1

您的 PHP 脚本可能需要很长时间才能执行，因此您可能需要增加 php.ini 中的 max_execution_time 值，

max_execution_time=600 这是 10 分钟