[wp-testers] Your mission, should you choose to accept it

[ryan fitzer]

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 <peter.westwood at ftwr.co.uk> 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 <peter.westwood at ftwr.co.uk>
> http://blog.ftwr.co.uk
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers
>



-- 
Ryan Fitzer
Dallas, TX
http://www.ryanfitzer.com