|
Error querying dates for calendar.
DEBUG MODE
SQL Error : 144 Table './unique_fmnew/phpbbfm_topics' is marked as crashed and last (automatic?) repair failed
SELECT
c.*,
t.topic_title,
t.title_compl_infos,
t.title_pos,
t.title_compl_color,
t.topic_views,
t.topic_replies,
f.forum_name,
f.auth_read,
pt.post_text,
pt.bbcode_uid,
ec.*,
(cal_interval_units = 'DAY' && cal_interval = 1 && '2024-04-01 00:00:00' = INTERVAL (cal_interval * (cal_repeat - 1)) DAY + cal_date) as block_end
FROM
phpbbfm_mycalendar as c,
phpbbfm_topics as t,
phpbbfm_forums as f,
phpbbfm_posts_text as pt,
phpbbfm_mycalendar_event_types as ec
WHERE
ec.forum_id = c.forum_id
AND ec.event_type_id = c.event_type_id
AND c.forum_id = f.forum_id
AND c.topic_id = t.topic_id
AND f.events_forum > 0
AND pt.post_id = t.topic_first_post_id
AND '2024-04-01 00:00:00' >= cal_date
AND ( cal_repeat = 0 OR ( cal_repeat > 0 AND ((cal_interval_units = 'DAY' AND ('2024-04-01 00:00:00' <= INTERVAL (cal_interval * (cal_repeat - 1)) DAY + cal_date))
OR (cal_interval_units = 'WEEK' AND ('2024-04-01 00:00:00' <= INTERVAL ((cal_interval * (cal_repeat - 1)) * 7) DAY + cal_date))
OR (cal_interval_units = 'MONTH' AND ('2024-04-01 00:00:00' <= INTERVAL (cal_interval * (cal_repeat - 1)) MONTH + cal_date))
OR (cal_interval_units = 'YEAR' AND ('2024-04-01 00:00:00' <= INTERVAL (cal_interval * (cal_repeat - 1)) YEAR + cal_date)))))
AND (( cal_interval_units = 'DAY' AND (TO_DAYS('2024-04-01 00:00:00') - TO_DAYS(cal_date)) % cal_interval = 0)
OR (cal_interval_units = 'WEEK' AND (TO_DAYS('2024-04-01 00:00:00') - TO_DAYS(cal_date)) % (7 * cal_interval) = 0)
OR (cal_interval_units = 'MONTH' AND DAYOFMONTH(cal_date) = DAYOFMONTH('2024-04-01 00:00:00') AND PERIOD_DIFF(DATE_FORMAT('2024-04-01 00:00:00', '%Y%m'), DATE_FORMAT(cal_date, '%Y%m')) % cal_interval = 0)
OR (cal_interval_units = 'YEAR' AND DATE_FORMAT(cal_date, '%m%d') = DATE_FORMAT('2024-04-01 00:00:00', '%m%d') AND (YEAR('2024-04-01 00:00:00') - YEAR(cal_date)) % cal_interval = 0))
ORDER BY cal_interval_units ASC, cal_date ASC, cal_repeat DESC
Line : 183 File : calendar.php |
|
|