|
Jon Ang
|
April 2, 2015 at 2:57 am
Hello,
Trying to delete venues (latest EE 4.6.18p) gives me the following
An EE_Error exception was thrown! code: EEM_Base - _do_wpdb_query - 1206
"WPDB 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""
click to view backtrace and class/method details
/home/vogueclu/public_html/mydomain/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php ( line no: 1206 )
The venues are not tied to any existing events, it’s been all deleted from trash.
Any thoughts?
Cheers!
|
|
Tony
|
April 2, 2015 at 6:28 am
Hi Jon,
I’ve not been able to reproduce this on my test sites, venues delete without issue both venues that have not been used for any events and venues that have been assigned to events and then those events removed.
Can we take a closer look at this on your site? If so can you provide temporary log in details using this form:
https://eventespresso.com/send-login-details/
Please include details of how to reproduce and on which venue we can do this on.
|
|
Jon Ang
|
April 6, 2015 at 10:54 am
Hello,
I have tested again, venues fail to delete only if they are drafts.
Publishing the venues and deleting them afterwards worked
Can you try if that happens in your test site?
|
|
Lorenzo Orlando Caum
|
April 6, 2015 at 11:28 am
Hi Jon, are these the correct steps?
Create a venue through the venue editor and save it as a draft –> Delete the venue through the Venues overview screen
It seems to work for the steps above:
http://cl.ly/112h0U0B3L1u
—
Lorenzo
|
|
Jon Ang
|
April 8, 2015 at 2:21 am
Hello,
Deleting the entire set off EE4 files and uploading a fresh copy fixed it.
Quite possibly an old file left behind messing it up
|
