如何从根本上解决这个问题

2016-07-07 15:50 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.ad_id, a.position_id, a.media_type, a.ad_link, a.ad_code, a.ad_name, p.ad_width, p.ad_height, p.position_style, RAND() AS rnd FROM `sq_eake1php`.`ecs_ad` AS a LEFT JOIN `sq_eake1php`.`ecs_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND a.position_id = '2' AND start_time <= '1232506029' AND end_time >= '1232506029' ORDER BY rnd LIMIT 1 ) [2] => Array ( [error] => Can't create/write to file 'C:\WINDOWS\TEMP\#sql_654_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ) )
没次都要在服务器上删除这个'C:\WINDOWS\TEMP\#sql_654_0.MYD' 文件
如何从根本解决这个问题

回答:
1.检测一下权限,是否权限有问题;
2.服务器临时空间满了,清除一下缓存。