- This topic has 9 replies, 2 voices, and was last updated 12 years ago by
.
-
Posts
-
Notice the => post_id IN () )
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 ‘) ) ) coors’ at line 15]
SELECT Max(lat) max_lat, Max(lng) max_lng, Min(lat) min_lat, Min(lng) min_lng FROM
(SELECT post_id AS venue_id, CASE WHEN meta_key = ‘_VenueLat’ THEN meta_value end AS LAT, CASE WHEN meta_key = ‘_VenueLng’ THEN meta_value end AS LNG FROM wp_postmeta WHERE ( meta_key = ‘_VenueLat’ OR meta_key = ‘_VenueLng’) AND post_id IN
(SELECT meta_value FROM wp_postmeta WHERE meta_key=’_EventVenueID’ AND post_id IN () )
) coorsIt seems like even if I manually import an event (276999135793758), I still get the SQL error. This event is 6 days in the future and appears imported because when I try to re-import it, it says:
“The event “Blah, Blah” was already imported from Facebook. Please note that as a result, no events were successfully imported.”
Is the development team seeing this with ?
changed title to just plugin query to backend throws sql error every time (1 item imported manually for April 5th (6 days ahead)\wp-content\plugins\events-calendar-pro\lib\tribe-geoloc.class.php
Line 14. OK, it’s the GeoLocation information. Maybe for Google Maps query… so I just shut off Google Maps….– General(tab)/Map Settings/ Enable Google Maps is unchecked (off)
– Facebook(tab)/Import Settings/Enable Google Maps on imported events is unchecked (off)but the SQL error remains. And my April 6th event isn’t shown.
You’d definitely need to make sure your upcoming (“dummy”) event is assigned to a venue with a valid address, so that it has geolocation data associated with it – apologies if that wasn’t clear.
Does that help here?
Yes. I think maybe it’s just the interface & Facebook.
“Events” is a menu pick at the top of the WP Admin, but it’s the LEFT sidebar “Events”. They’re both different.When you add an event manually, it seems like maybe you can fumble around in the “Event”/”Add New Event” dialog (regardless of how you got there) and realize you can / have to add a venue and location as you build the event.
BUT, when you import from Facebook by Event ID (I bought the Facebook auto-import too), the importer doesn’t seem to parse out the venue, address, etc, so you end up with an event with no venue or geo location information (like the imported event 276999135793758) and it fails with this “0 record” error because there is no venue or location for the event.
Perhaps just use a dummy venue and address (maybe of the Tri.be location) if something doesn’t parse right. An average user wouldn’t have figured this out.
- The topic ‘3.5 Facebook Events query throws database error’ is closed to new replies.