ExPlayer
Пользователь
Доброго времени суток! В sql_slow_bb.log на протяжении последней недели появляется сообщение:
Если я правильно понял, то какая-то задача в кроне не работает.
113 строка в functions_admin.php:
Строки с 98 по 113 в functions_admin.php:
1494727220 | 05-14 05:00:20 | 14 | 0.5 | 01413 | db1 | INSERT INTO tmp_sync_topics SELECT t.topic_id, COUNT(p.post_id) AS total_posts, MIN(p.post_id) AS topic_first_post_id, MAX(p.post_id) AS topic_last_post_id, MAX(p.post_time) AS topic_last_post_time, IF(MAX(a.attach_id), 1, 0) AS topic_attachment FROM bb_topics t LEFT JOIN bb_posts p ON(p.topic_id = t.topic_id) LEFT JOIN bb_attachments a ON(a.post_id = p.post_id) WHERE t.topic_status != 2 GROUP BY t.topic_id # Records: 6318 Duplicates: 0 Warnings: 0 # library/includes/functions_admin.php(113) cron
Если я правильно понял, то какая-то задача в кроне не работает.
113 строка в functions_admin.php:
");Строки с 98 по 113 в functions_admin.php:
DB()->query("
INSERT INTO $tmp_sync_topics
SELECT
t.topic_id,
COUNT(p.post_id) AS total_posts,
MIN(p.post_id) AS topic_first_post_id,
MAX(p.post_id) AS topic_last_post_id,
MAX(p.post_time) AS topic_last_post_time,
IF(MAX(a.attach_id), 1, 0) AS topic_attachment
FROM ". BB_TOPICS ." t
LEFT JOIN ". BB_POSTS ." p ON(p.topic_id = t.topic_id)
LEFT JOIN ". BB_ATTACHMENTS ." a ON(a.post_id = p.post_id)
WHERE t.topic_status != ". TOPIC_MOVED ."
$where_sql
GROUP BY t.topic_id
");
