Title: database error creating massive log files
Last modified: August 30, 2016

---

# database error creating massive log files

 *  Resolved [Edward](https://wordpress.org/support/users/stormgod/)
 * (@stormgod)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/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 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/](https://wordpress.org/plugins/spiffy-calendar/)

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

 *  [SunnyThemes](https://wordpress.org/support/users/sunnythemes/)
 * (@sunnythemes)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-creating-massive-log-files/#post-6465688)
 * 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?
 *  [SunnyThemes](https://wordpress.org/support/users/sunnythemes/)
 * (@sunnythemes)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-creating-massive-log-files/#post-6465694)
 * * 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.

 * ![](https://ps.w.org/spiffy-calendar/assets/icon-256x256.png?rev=2398731)
 * [Spiffy Calendar](https://wordpress.org/plugins/spiffy-calendar/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/spiffy-calendar/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/spiffy-calendar/)
 * [Active Topics](https://wordpress.org/support/plugin/spiffy-calendar/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/spiffy-calendar/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/spiffy-calendar/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [log](https://wordpress.org/support/topic-tag/log/)

 * 2 replies
 * 2 participants
 * Last reply from: [SunnyThemes](https://wordpress.org/support/users/sunnythemes/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-creating-massive-log-files/#post-6465694)
 * Status: resolved