Also, not sure what effect it had but I updated the install to the beta Ryan posted and the post duplication issue has gone away. Thanks for the link. I'll see if I can update the plugin for my needs.
Ryan On 1/9/07, Peter Westwood <[EMAIL PROTECTED]> wrote:
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
-- Ryan Fitzer Dallas, TX http://www.ryanfitzer.com _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
