You have an error in your SQL syntax

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

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?

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

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

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

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.

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.

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?

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.

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

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

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