Support

Home Forums Event Espresso Premium iPhone App / JSON issues? XML?

iPhone App / JSON issues? XML?

Posted: October 20, 2013 at 5:19 pm


Evan Zelig

October 20, 2013 at 5:19 pm

I am trying to use the iPhone app with my ticketing and it is not working. The error I am receiving in the error log is:

ordPress 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 for query SELECT id, is_active, event_status, registration_start, registration_startT, registration_end, registration_endT FROM wp_events_detail e WHERE id IN ( ) made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, call_user_func_array, EspressoAPI_Router->template_redirect, EspressoAPI_Generic_Controller->handleRequest, EspressoAPI_Generic_Controller->generalRequest, EspressoAPI_Generic_Controller->generalRequestGet, EspressoAPI_Generic_Resource_Facade_Read_Functions->getMany, EspressoAPI_Generic_Resource_Facade_Read_Functions->extractMyUniqueModelsFromSqlResults, EspressoAPI_Events_Resource->_extractMyUniqueModelsFromSqlResults, espresso_format_content, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, event_espresso_cart_link
[20-Oct-2013 14:47:03] 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 for query SELECT id, is_active, event_status, registration_start, registration_startT, registration_end, registration_endT FROM wp_events_detail e WHERE id IN ( ) made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, call_user_func_array, EspressoAPI_Router->template_redirect, EspressoAPI_Generic_Controller->handleRequest, EspressoAPI_Generic_Controller->generalRequest, EspressoAPI_Generic_Controller->generalRequestGet, EspressoAPI_Generic_Resource_Facade_Read_Functions->getMany, EspressoAPI_Generic_Resource_Facade_Read_Functions->extractMyUniqueModelsFromSqlResults, EspressoAPI_Events_Resource->_extractMyUniqueModelsFromSqlResults, espresso_format_content, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, event_espresso_cart_link

I am unable to open up the JSON test and it comes out as a Blank page.


Evan Zelig

October 20, 2013 at 5:21 pm

Additionally these are the Plugins I am using

All-in-One Event Calendar by Timely by Timely Network Inc version 1.10.1-standard,
Better WP Security by Bit51 version 3.5.6,
Clean Options by Mittineague version 1.3.2,
Event Espresso – MailChimp Integration by version 1.1,
Event Espresso – Multi Event Registration by Seth Shoultes version 1.0.4,
Event Espresso – Ticketing by Event Espresso version 2.0.10.2.p,
Event Espresso Volume Discounts by Seth Shoultes version 0.4,
Event Espresso by Event Espresso version 3.1.35.1.P,
Genesis Simple Sidebars by Nathan Rice version 2.0.1,
Genesis Title Toggle by Bill Erickson version 1.5,
Genesis Widgetized Not Found & 404 by David Decker – DECKERWEB version 1.5.0,
Gravity Forms by rocketgenius version 1.7.11,
Gravity Forms MailChimp Add-On by rocketgenius version 2.3,
Gravity Forms PayPal Add-On by rocketgenius version 1.9,
ITRO Popup Plugin by I.T.RO.(c) Sez. Informatica version 4.5.3,
Jetpack by WordPress.com by Automattic version 2.5,
Lizatom Shortcodes by Lizatom.com version 1.4.1,
NextGEN Gallery by Photocrati by Photocrati Media version 2.0.31,
Quick Page/Post Redirect Plugin by Don Fischer version 5.0.3,
Soliloquy by Thomas Griffin version 1.5.3,
TinyMCE Advanced by Andrew Ozz version 3.5.8,
TranslateThis Button by Translate Company version 0.1,
UpdraftPlus – Backup/Restore by UpdraftPlus.Com, DavidAnderson version 1.7.20,
WordPress SEO by Joost de Valk version 1.4.18


Josh

  • Support Staff

October 21, 2013 at 11:13 am

Hi there,

Looks like what’s missing here is the Espresso API plugin. Can you install that one and try again? Also, it might be good to temporarily disable your other calendar plugin to rule out any conflicts.

The support post ‘iPhone App / JSON issues? XML?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso