[EventCalendar] PHP issues
swamsley at gmail.com
Fri Jul 31 18:13:55 UTC 2009
I have the exact same issue. Thanks for doing the PHP version test.
The way I got it to work was to comment out the lines in
eventcalendar3.php that call add_filter(...) - lines 584 through 599 in
version 3.1.4 of the plugin, the site starts working again - including
the plugin itself.
I don't know if this is the correct way to fix the problem, but it
*looks* to be working correctly.
Chris Janton wrote:
> 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
> version 5.3
> 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->query, WP_Query->get_posts
> 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
> line 166
> For now - PHP 5.2.10.
> Chris Janton - face at CentosPrime dot COM
> Netminder for Opus1.COM
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
More information about the EventCalendar