#_REMOVEBOOKINGFORM_IF_REGISTERED throws SQL error

[Anonymous]

Hi –

Great plug-in. So far it’s working out great.

I have found that the #_REMOVEBOOKINGFORM_IF_REGISTERED throws a SQL error, when the WordPress user is logged in, but has never registered for an event. It appears there is no value for “person_id” in the query.

I believe this might also be happening for #_ADDBOOKINGFORM_IF_NOT_REGISTERED, as I am using them both and seeing the same SQL error twice.

I don’t have a link, but the error is:

—

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 ‘AND event_id= 12’ at line 1]

SELECT * FROM wp_dbem_bookings WHERE person_id = AND event_id= 12

—

There is still a form displayed beneath the errors, and it works fine if the user books the event – and the problem (for that user) then goes away. However, it is an ugly error for a first-time booker! Maybe I missed a config setting or something. Any help is appreciated.

Thanks,

Ken K

EDIT: Using version 3.3.4 with WP 3.1

[Franky]

indeed a bug, caused by me forgetting to add single quotes where it is needed. Can you try this changeset:

http://plugins.trac.wordpress.org/changeset/364809

[Anonymous]

Yes sir! That did the trick. Thanks for the quick support and fix! Very much appreciated.

[Author]

Posts