Ok, realized the problem of the duplicate posts was because of the SideBlog plugin not being deactivated (though I did them all). Went through one by one and that was it.
Ryan On 1/9/07, ryan fitzer <[EMAIL PROTECTED]> wrote:
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
-- Ryan Fitzer Dallas, TX http://www.ryanfitzer.com _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
