[EventCalendar] PHP issues
face at CentosPrime.COM
Fri Jul 31 16:50:06 UTC 2009
apparently all versions of EventCalendar that I have - 3.1.4 and 3.2
My hosting service for one of my blogs recently upgraded PHP to
EventCalendar installed and working as I want for a long time
Today I look at the front page of the blog - no posts at all. In fact,
no posts anywhere you would expect them.
I check a different blog, different host, PHP version 5.2.10
EC works fine
Posts work fine
Get hosting service to back out PHP 5.3 to 5.2.10
EC starts working again
the error messages that we get when it is failing are
[Fri Jul 31 08:27:43 2009] [error] 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 'FROM wp_posts
WHERE 1=1' at line 1 for query SELECT FROM wp_posts WHERE 1=1
made by wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query-
Please note that "SELECT FROM wp_posts WHERE 1=1" is not legal SQL.
Looks like what we want is
"SELECT * FROM wp_posts WHERE 1=1"
We also see PHP Warnings like
PHP Warning: Parameter 1 to ec3_filter_posts_where() expected to be a
reference, value given in /pathtomyblog/news/wp-includes/plugin.php on
For now - PHP 5.2.10.
Chris Janton - face at CentosPrime dot COM
Netminder for Opus1.COM
More information about the EventCalendar