• Resolved Edward

    (@stormgod)


    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 ALL

    this is VER 1.3.1
    I had to deactivate the plugin to prevent it from creating more massive error logs.
    any thoughts?

    https://wordpress.org/plugins/spiffy-calendar/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Is “Show Dates” the name of your category? If so, could you rename it to remove the space and see if that helps?

    What is the shortcode you are using? Are you specifying category by name or number?

    * You should be selecting category by number only.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘database error creating massive log files’ is closed to new replies.