After upgrading to v3.1.30.5P, I am getting following SQL error in my error_log files: [10-Feb-2013 19:21:45] PHP Warning: implode() [< a href='function.implode'>function.implode a>]: Invalid arguments passed in /home5/bostonde/public_html/wp-content/uploads/espresso/templates/shopping_cart.php on line 21 [10-Feb-2013 19:21:45] 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 e.event_status != ‘D’ ORDER BY e.start_date’ at line 1 for query SELECT e.*, r.cat_id, c.category_name FROM bdc_events_detail e JOIN bdc_events_category_rel r ON r.event_id = e.id JOIN bdc_events_category_detail c ON c.id = r.cat_id WHERE e.id in () AND e.event_status != ‘D’ ORDER BY e.start_date made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, event_espresso_run, event_espresso_shopping_cart
This topic was modified 11 years, 10 months ago by Suhaib Siddiqi.
This topic was modified 4 years, 9 months ago by Seth Shoultes. Reason: Removed broken link
You have templates in the wp-content/uploads/espresso directory. Please rename them (there is a button in the Template Settings page or you can do it via FTP) to force Event Espresso to use the default templates.
That will resolve the issue. If you have modified the files in the uploads/espresso directory you will need to compare the original files to the new files to see what has changed and apply those changes to your modified files.
I modified a few files in upload/espresso/templates after copying templates folder to upload/espresso/templates directory. But, it was done a long time ago. The error started appearing now, after recent upgrade. I deleted /wp-content/uploads/espresso/templates/shopping_cart.php file. The error is gone.
The support post ‘WordPress Database Error after upgrade to 3.1.30.5P’ 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.
Support forum for Event Espresso 3 and Event Espresso 4.