On Tue, January 9, 2007 2:45 pm, ryan fitzer wrote: > Using the 2007-01-09 build on MAMP > > I'm getting a database error (used on a custom theme) with the > Customizable > Post > Listings<http://www.coffee2code.com/archives/2004/08/27/plugin-customizable-post-listings/>( > I know it's an older plugin, but it's worked through > 2.0.6 ): > > > *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 'LEFT JOIN ON (.ID = .post_id) WHERE .post_date <= > '2007-01-09 10:00:35' AND ( .' at line 1] > SELECT DISTINCT * FROM LEFT JOIN ON (.ID = .post_id) WHERE .post_date > <= '2007-01-09 10:00:35' AND ( .post_status = 'publish' OR .post_status > = > 'sticky' ) AND .post_password = '' AND ( .category_id = '2,' OR > .category_id > = '3,' OR .category_id = '4,' OR .category_id = '5,' OR .category_id = > '7' ) > GROUP BY .ID ORDER BY .post_date DESC LIMIT 0, 10 >
That looks like the plugin uses the old deprecated globals ($tablecomments and friends) to access the tables names (http://wordpress.org/development/2006/12/naughty-or-nice/). westi -- Peter Westwood <[EMAIL PROTECTED]> http://blog.ftwr.co.uk _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
