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

[Peter Westwood]

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