Calendario

Errore sul database di WordPress: [Got error 28 from storage engine]
SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2020-9-3' AND a.event_end >= '2020-9-3' AND a.event_recur = 'S' UNION ALL SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2020-9-3') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0 UNION ALL SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2020-9-3') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2020-9-3')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats UNION ALL SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2020-9-3') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0 UNION ALL SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2020-9-3') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-3'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats UNION ALL SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2020-9-3') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0 UNION ALL SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2020-9-3') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-3'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats UNION ALL SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2020-9-3' >= h.event_begin AND h.event_repeats = 0 UNION ALL SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2020-9-3' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2020-9-3') - TO_DAYS(i.event_end)) ORDER BY event_id

Errore sul database di WordPress: [Got error 28 from storage engine]
SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2020-9-25' AND a.event_end >= '2020-9-25' AND a.event_recur = 'S' UNION ALL SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2020-9-25') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0 UNION ALL SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2020-9-25') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2020-9-25')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats UNION ALL SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2020-9-25') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0 UNION ALL SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2020-9-25') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-25'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats UNION ALL SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2020-9-25') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0 UNION ALL SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2020-9-25') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-25'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats UNION ALL SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2020-9-25' >= h.event_begin AND h.event_repeats = 0 UNION ALL SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2020-9-25' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2020-9-25') - TO_DAYS(i.event_end)) ORDER BY event_id

Mese: Anno:
« Prec Settembre 2020 Succ »
Lunedì Martedì Mercoledì Giovedì Venerdì Sabato Domenica
  1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30