更新缓存不成功
By
sky100
at 2015-07-21 • 0人收藏 • 2662人看过
Unhandled Exception. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1970-05-16' for key 'PRIMARY'You can find the error back in the log.
啥情况？
17 个回复 | 最后更新于 2015-07-21
回复#3 @sky100 :
你用这个替换你的dashboard.php：
<?php
include(dirname(__FILE__) . '/common.php');
require(dirname(__FILE__) . '/language/' . ForumLanguage . '/dashboard.php');
Auth(5);
$BasicMessage = '';
$PageMessage = '';
$AdvancedMessage = '';
$CacheMessage = '';
$Action = Request('POST', 'Action', false);
switch ($Action) {
case 'Cache':
set_time_limit(0);
UpdateConfig(array(
'NumFiles' => intval($DB->single('SELECT count(ID) FROM ' . $Prefix . 'upload')),
'NumTopics' => intval($DB->single('SELECT count(*) FROM ' . $Prefix . 'topics WHERE IsDel=0')),
'NumPosts' => intval($DB->single('SELECT sum(Replies) FROM ' . $Prefix . 'topics WHERE IsDel=0')),
'NumUsers' => intval($DB->single('SELECT count(ID) FROM ' . $Prefix . 'users')),
'NumTags' => intval($DB->single('SELECT count(ID) FROM ' . $Prefix . 'tags'))
));
$DB->query('UPDATE ' . $Prefix . 'users u
SET u.Topics=(SELECT count(*) FROM ' . $Prefix . 'topics t
WHERE t.UserName=u.UserName and IsDel=0),
u.Replies=(SELECT count(*) FROM ' . $Prefix . 'posts p
WHERE p.UserName=u.UserName and p.IsTopic=0),
u.Followers=(SELECT count(*) FROM ' . $Prefix . 'favorites f
WHERE f.FavoriteID=u.ID and Type=3)
');
$DB->query('UPDATE ' . $Prefix . 'topics t
SET t.Replies=(SELECT count(*) FROM ' . $Prefix . 'posts p
WHERE p.TopicID=t.ID and p.IsTopic=0 and p.IsDel=0),
t.Favorites=(SELECT count(*) FROM ' . $Prefix . 'favorites f
WHERE f.FavoriteID=t.ID and Type=1)
');
$DB->query('UPDATE ' . $Prefix . 'tags t
SET t.TotalPosts=(SELECT count(*) FROM ' . $Prefix . 'posttags p
WHERE p.TagID=t.ID),
t.Followers=(SELECT count(*) FROM ' . $Prefix . 'favorites f
WHERE f.FavoriteID=t.ID and Type=2)
');
$DB->query('DELETE FROM ' . $Prefix . 'statistics');
$StatisticsTime = strtotime(date('Y-m-d', $DB->single('SELECT PostTime FROM ' . $Prefix . 'topics ORDER BY ID LIMIT 1')));
while ($StatisticsTime < ($TimeStamp - 86400)) {
$StatisticsTimeAddOneDay = $StatisticsTime + 86400;
//echo date('Y-m-d', $StatisticsTime);
//echo '<br />';
$DB->query('INSERT INTO `' . $Prefix . 'statistics`
(
`DaysUsers`,
`DaysPosts`,
`DaysTopics`,
`TotalUsers`,
`TotalPosts`,
`TotalTopics`,
`DaysDate`,
`DateCreated`
)
SELECT
(SELECT count(*) FROM ' . $Prefix . 'users u
WHERE u.UserRegTime >= ' . $StatisticsTime . '
AND u.UserRegTime < ' . $StatisticsTimeAddOneDay . ' ),
(SELECT count(*) FROM ' . $Prefix . 'posts p
WHERE p.PostTime >= ' . $StatisticsTime . '
AND p.PostTime < ' . $StatisticsTimeAddOneDay . '
AND p.IsTopic = 0),
(SELECT count(*) FROM ' . $Prefix . 'topics t
WHERE t.PostTime >= ' . $StatisticsTime . '
AND t.PostTime < ' . $StatisticsTimeAddOneDay . '
AND t.IsDel = 0),
(SELECT count(*) FROM ' . $Prefix . 'users u
WHERE u.UserRegTime < ' . $StatisticsTimeAddOneDay . ' ),
(SELECT count(*) FROM ' . $Prefix . 'posts p
WHERE p.TopicID NOT IN (SELECT ID FROM ' . $Prefix . 'topics t
WHERE t.PostTime < ' . $StatisticsTimeAddOneDay . '
AND t.IsDel = 1)
AND p.PostTime < ' . $StatisticsTimeAddOneDay . '
AND p.IsTopic = 0 ),
(SELECT count(*) FROM ' . $Prefix . 'topics t
WHERE t.PostTime < ' . $StatisticsTimeAddOneDay . '
AND t.IsDel = 0),
:DaysDate,
:DateCreated
FROM dual
WHERE NOT EXISTS(
SELECT * FROM `' . $Prefix . 'statistics`
WHERE DaysDate = :DaysDate2
)
', array(
'DaysDate' => date('Y-m-d', $StatisticsTime),
'DaysDate2' => date('Y-m-d', $StatisticsTime),
'DateCreated' => $StatisticsTimeAddOneDay - 1
));
$StatisticsTime = $StatisticsTimeAddOneDay;
}
if ($MCache) {
if (extension_loaded('memcached') || extension_loaded('memcache')) {
//MemCached or MemCache
$MCache->flush();
} elseif (extension_loaded('redis')) {
//Redis
//https://github.com/phpredis/phpredis
$MCache->flushAll();
}
}
$CacheMessage = $Lang['Successfully_Refreshed'];
break;
default:
$NewConfig = $_POST;
//Fool-proofing
if ($Action == 'Basic') {
$NewConfig['TopicsPerPage'] = intval(Request('Post', 'TopicsPerPage', 20));
$NewConfig['PostsPerPage'] = intval(Request('Post', 'PostsPerPage', 20));
$NewConfig['MaxTagsNum'] = intval(Request('Post', 'MaxTagsNum', 5));
$NewConfig['MaxTagChars'] = intval(Request('Post', 'MaxTagChars', 128));
$NewConfig['MaxPostChars'] = intval(Request('Post', 'MaxPostChars', 65536));
}
//Fool-proofing
if ($Action == 'Advanced') {
if ($NewConfig['MobileDomainName'] == $_SERVER['HTTP_HOST']) {
$NewConfig['MobileDomainName'] = $Config['MobileDomainName'];
}
if ($NewConfig['AppDomainName'] == $_SERVER['HTTP_HOST']) {
$NewConfig['AppDomainName'] = $Config['AppDomainName'];
}
}
foreach ($NewConfig as $Key => $Value) {
if (!array_key_exists($Key, $Config) || $Value == $Config[$Key]) {
unset($NewConfig[$Key]);
} else {
$Config[$Key] = $NewConfig[$Key];
}
}
UpdateConfig($NewConfig);
switch ($Action) {
case 'Basic':
$BasicMessage = str_replace('{{NewConfig}}', count($NewConfig), $Lang['Basic_Settings_Successfully_Saved']);
break;
case 'Page':
$PageMessage = str_replace('{{NewConfig}}', count($NewConfig), $Lang['Page_Settings_Successfully_Saved']);
break;
case 'Advanced':
$AdvancedMessage = str_replace('{{NewConfig}}', count($NewConfig), $Lang['Advanced_Settings_Successfully_Saved']);
break;
default:
break;
}
break;
}
$DB->CloseConnection();
// 页面变量
$PageTitle = $Lang['System_Settings'];
$ContentFile = $TemplatePath . 'dashboard.php';
include($TemplatePath . 'layout.php'); 
登录后方可回帖
粤公网安备 44030602003677号
服务器时间是准确的吗？