Support » Plugin: Events Manager - Calendar, Bookings, Tickets, and more! » You have an error in your SQL syntax

  • Resolved nathanrowe82

    (@nathanrowe82)


    Hi when I add a location to an event, And hit publish, I get:

    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 location_status FROM wp_em_locations WHERE location_id=

    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]
    UPDATE wp_em_locations SET location_status=NULL WHERE location_id=

    http://wordpress.org/extend/plugins/events-manager/

Viewing 13 replies - 1 through 13 (of 13 total)
  • Thread Starter nathanrowe82

    (@nathanrowe82)

    Ok, So this error appears if you do not add a Location name. Seems to be missing validation before hitting the database.

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    I just tried this and don’t get this problem. Any extra info to reproduce the problem? e.g.

    Is this when adding an event, or specifically a location? Also, in your front-end or admin area, and are you using MultiSite?

    Thread Starter nathanrowe82

    (@nathanrowe82)

    Hi Marcus,

    Thanks for your fast reply. Ok so it seams to happen when I create an event that has “This event does not have a physical location.” checked.

    if I save it, then edit it, and add a location without the “location name” field, I get the sql error.

    I know that is would be a rare occurrence, but I was playing with the plugin, and stubbled across it.

    Thanks

    Hiya,

    It may be that something else is stopping EM doing it’s usual validation, which would normally stop the event from being saved.

    Could you try disabling all other plugins and try the default theme? They may conflict with EM…

    Phil

    Thread Starter nathanrowe82

    (@nathanrowe82)

    Hi Phil,

    Yep tested that. Theme: Twenty Twelve, this is the only plugin active. Could it be a server related issue, if your not seeing the same thing?

    Nate

    Thread Starter nathanrowe82

    (@nathanrowe82)

    Further error messages, from the above, that I had not posted (url’s shortened):

    Warning: Cannot modify header information – headers already sent by (output started at …/wp-includes/wp-db.php:1056) in …/wp-content/plugins/events-manager/classes/em-notices.php on line 35

    Warning: Cannot modify header information – headers already sent by (output started at …/wp-includes/wp-db.php:1056) in …/wp-includes/pluggable.php on line 876

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    I tried that too just now and still no errors. I am doing it with WP_DEBUG enabled so it’d show up but still nothing.

    I dont’ see why it’d be a server issue in this case.

    You never answered these:

    Is this when adding an event, or specifically a location? Also, in your front-end or admin area, and are you using MultiSite?

    chances are it’s a specific setup as well as submitting with ‘no location’ checked.

    Thread Starter nathanrowe82

    (@nathanrowe82)

    Hi Marcus,

    No Multisite, just a single install.

    It appears to happen on editing the location of an event that was previously set to “This event does not have a physical location”.

    Adding / editing an event any other way works fine. just when witching”This event does not have a physical location” off and trying to update with an actual location.

    Hope this helps to narrow down the error.

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    Thanks, I tried on both front and backend with your steps, and still can’t get this error to show up.

    I don’t see why messing with the events page would cause this though… this is specifically to do with editing locations I’d think, as it’s trying to change the status of a location to NULL (i.e. deleted)

    Are you on the latest plugin update? Also, have you made any modifications to the plugin?

    Thread Starter nathanrowe82

    (@nathanrowe82)

    Hi Marcus,

    OK, so it seams I am also getting some other errors too, on the booking page when not logged in also:

    Notice: Undefined variable: EM_Bookings in …/wp-content/plugins/events-manager/templates/templates/my-bookings.php on line 97

    this only appears when debugging is on.

    Please not I have reinstalled WP, and the plugin on Twenty Twelve theme, and still get the above errors. Sorry I have no more helpful info on this. as I can’t work out what is causing it.

    Thread Starter nathanrowe82

    (@nathanrowe82)

    Same on tags page:

    Fatal error: Class ‘EM_Tags’ not found in …/wp-content/plugins/events-manager/templates/templates/tags-list.php on line 12

    Thread Starter nathanrowe82

    (@nathanrowe82)

    And…

    On the events page, when no events in db:

    Notice: Trying to get property of non-object in …/wp-includes/class-wp-walker.php on line 205

    Notice: Trying to get property of non-object in …/wp-includes/class-wp-walker.php on line 205

    Notice: Trying to get property of non-object in …/wp-includes/class-wp-walker.php on line 127

    Notice: Trying to get property of non-object in …/wp-includes/category-template.php on line 939

    Notice: Trying to get property of non-object in …/wp-includes/category-template.php on line 940

    Notice: Trying to get property of non-object in …/wp-includes/category-template.php on line 941

    Notice: Trying to get property of non-object in …/wp-includes/class-wp-walker.php on line 131

    Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    try reinstalling EM, sounds ilke something went wrong during the process accordgin to

    Fatal error: Class 'EM_Tags' not found in .../wp-content/plugins/events-manager/templates/templates/tags-list.php on line 12

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘You have an error in your SQL syntax’ is closed to new replies.