database error creating massive log files
-
I get this error added to my “error_log” every few seconds and it keeps growing the text file until the goes past resources
[23-Aug-2015 04:27:47 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Show Dates) UNION ALL SELECT b.*,'Yearly' AS type FROM mf_spiffy_calendar AS b' at line 1 for query SELECT a.*,'Normal' AS type FROM mf_spiffy_calendar AS a WHERE a.event_begin <= '2015-08-1' AND a.event_end >= '2015-08-1' AND a.event_recur = 'S' AND event_category in (Show Dates) UNION ALL SELECT b.*,'Yearly' AS type FROM mf_spiffy_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2015-08-1') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0 AND event_category in (Show Dates) UNION ALL SELECT c.*,'Yearly' AS type FROM mf_spiffy_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2015-08-1') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2015-08-1')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats AND event_category in (Show Dates) UNION ALL SELECT d.*,'Monthly' AS type FROM mf_spiffy_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2015-08-1') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0 AND event_category in (Show Dates) UNION ALL SELECT e.*,'Monthly' AS type FROM mf_spiffy_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2015-08-1') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2015-08-1'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats AND event_category in (Show Dates) UNION ALL SELECT f.*,'MonthSun' AS type FROM mf_spiffy_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2015-08-1') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0 AND event_category in (Show Dates) UNION ALL SELECT g.*,'MonthSun' AS type FROM mf_spiffy_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2015-08-1') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2015-08-1'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats AND event_category in (Show Dates) UNION ALL SELECT h.*,'Weekly' AS type FROM mf_spiffy_calendar AS h WHERE h.event_recur = 'W' AND '2015-08-1' >= h.event_begin AND h.event_repeats = 0 AND event_category in (Show Dates) UNION ALL SELECT i.*,'Weekly' AS type FROM mf_spiffy_calendar AS i WHERE i.event_recur = 'W' AND '2015-08-1' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2015-08-1') - TO_DAYS(i.event_end)) AND event_category in (Show Dates) ORDER BY event_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/FCPH2014/page.php'), get_footer, locate_template, load_template, require_once('/themes/FCPH2014/footer.php'), dynamic_sidebar, call_user_func_array, Spiffy_Calendar->widget_events_calendar, Spiffy_Calendar->minical, Spiffy_Calendar->grab_events [23-Aug-2015 04:27:47 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Show Dates) UNION ALLthis is VER 1.3.1
I had to deactivate the plugin to prevent it from creating more massive error logs.
any thoughts?
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
The topic ‘database error creating massive log files’ is closed to new replies.