Events Calendar MySQL Error in sidebar (7 posts)

  1. databell96
    Posted 7 years ago #

    I'm using the Events Calendar plugin to pull a list of events into the EC Calendar widget. Problem is I get a MySQL Error like this:


    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 '' at line 1]
    SELECT * FROM wp_eventscalendar_main WHERE eventStartDate >= '2009-06-20' OR eventEndDate >= '2009-06-20' ORDER BY eventStartDate, eventStartTime LIMIT

    * Events are coming soon, stay tuned!

    And I'm not sure why. I'm no MySQl expert so does anyone understand why this is happening and if there's a fix?

    Here's the site with the error:

  2. Instant Images
    Posted 7 years ago #

    I see on your website it is working... how did you fix it?

    Im having the same problem here - http://www.hernandorepublicans.org

  3. selfmade64856
    Posted 7 years ago #

    Yes....please do tell :)

  4. SuperCurro
    Posted 7 years ago #

    I've got the same problem, do someone how fix it???

  5. selfmade64856
    Posted 7 years ago #

    Hi guys,
    You might want to try this,

    1. Download the http://wordpress.org/extend/plugins/php-code-widget/
    2. Activate it usual way.
    3. Add the widget to your sidebar.
    4. Copy and past this code into the php widget text area:

    "<?php if (function_exists(SidebarEventsCalendar)) {
    ?>" (Without the "" Quotes)

    5. Save the widget and hopefully.... voila!

    Worked for me running WPMU 2.8.2

    Hope this helps ;)

    Courtney Bostdorff

  6. laplix
    Posted 7 years ago #

    Hello all,
    This is going to be corrected in our next release.

    So go to http://wp-eventscalendar.com to keep up with the news.

    Won't be long...


  7. selfmade64856
    Posted 7 years ago #

    laplix - Hey thanks for the heads-up! Looking forward to the new release ;)

Topic Closed

This topic has been closed to new replies.

About this Topic