uchome1.5 统计计划任务有BUG

蓝色经典 · 发表于 2008-9-8 01:59:00

根据数据库查看，某人的空间访问只有１次，执行计划任务后，就变成累加了５０多次，觉得很奇怪，
于是跟踪统计计划任务

if($logs['uid']) {
$nums = renum($logs['uid']);
foreach ($nums[0] as $num) {
$_SGLOBAL['db']->query("UPDATE ".tname('space')." SET viewnum=viewnum+$num WHERE uid IN (".simplode($nums[1][$num]).")");
}
}

看到这里，我就在想 foreach 是循环，那就看看这个查询执行了多少次，
首先打印出

$nums

Array
(
[0] => Array
(
[0] => 1
[1] => 1
[2] => 1
[3] => 1
[4] => 1
[5] => 1
[6] => 1
[7] => 2
[8] => 3
[9] => 1
[10] => 2
[11] => 1
[12] => 2
[13] => 1
[14] => 1
[15] => 1
[16] => 5
[17] => 2
[18] => 1
[19] => 1
[20] => 1
[21] => 2
[22] => 1
[23] => 1
[24] => 1
[25] => 1
[26] => 1
[27] => 1
[28] => 1
[29] => 5
[30] => 1
[31] => 7
[32] => 1
[33] => 1
[34] => 1
[35] => 2
[36] => 1
[37] => 1
[38] => 1
[39] => 1
[40] => 1
[41] => 2
[42] => 1
[43] => 1
[44] => 1
[45] => 1
[46] => 1
[47] => 1
[48] => 1
[49] => 2
[50] => 1
[51] => 1
[52] => 1
[53] => 1
[54] => 1
[55] => 1
[56] => 1
[57] => 1
[58] => 1
[59] => 1
[60] => 1
[61] => 1
[62] => 1
[63] => 1
[64] => 1
[65] => 1
)
[1] => Array
(
[1] => Array
(
[0] => 177684
[1] => 164225
[2] => 425745
[3] => 204823
[4] => 214212
[5] => 351259
[6] => 400858
[7] => 329479
[8] => 287553
[9] => 422913
[10] => 370673
[11] => 399438
[12] => 19599
[13] => 436436
[14] => 205764
[15] => 415081
[16] => 365161
[17] => 312458
[18] => 14560
[19] => 406692
[20] => 198902
[21] => 303885
[22] => 87037
[23] => 349020
[24] => 9262
[25] => 233952
[26] => 476193
[27] => 437781
[28] => 159641
[29] => 32577
[30] => 2047
[31] => 254439
[32] => 227680
[33] => 203299
[34] => 461399
[35] => 60057
[36] => 58452
[37] => 322831
[38] => 80692
[39] => 42577
[40] => 240071
[41] => 32040
[42] => 464299
[43] => 489076
[44] => 297585
[45] => 107276
[46] => 27489
[47] => 327854
[48] => 79834
[49] => 299964
[50] => 2208
[51] => 342119
[52] => 330875
[53] => 1057
)
[2] => Array
(
[0] => 131634
[1] => 329471
[2] => 6639
[3] => 1653
[4] => 19634
[5] => 194226
[6] => 11481
[7] => 102415
)
[3] => Array
(
[0] => 101835
)
[5] => Array
(
[0] => 11696
[1] => 102890
)
[7] => Array
(
[0] => 123389
)
)
)

复制代码

回头再来看foreach 语句把$nums[0]拿去循环，肯定是错的。$nums[0]的值是每一个用户的点击次数。
结果本来是增加效率的7次查询，反而运行了65次，而且还累加错误了。难怪用户的访问数是一翻翻的。。

没法子，先把这条计划任务停止，等待官方的解决方案。

[ 本帖最后由蓝色经典于 2008-9-8 02:00 编辑 ]

蓝色经典 · 发表于 2008-9-8 02:36:49

我试了一下，是否应该改成这样？

if($logs['uid']) {
$nums = renum($logs['uid']);
foreach ($nums[1] as $key=>$num) {
$_SGLOBAL['db']->query("UPDATE ".tname('space')." SET viewnum=viewnum+$key WHERE uid IN (".simplode($num).")");

}
}

同理，日志访问数，还有主题访问数都要修改。

[ 本帖最后由蓝色经典于 2008-9-8 02:48 编辑 ]

andy888 · 发表于 2008-9-8 09:35:10

空间的文章访问数也是属于空间访问数的一部份，

sup · 发表于 2008-9-10 11:05:51

已经在RC2里面解决

szdxsw · 发表于 2008-9-10 11:07:16

高手，顶一下

		自动登录	找回密码
密码			立即注册