[wp-hackers] Random Posts and 2.1

[Ryan Boren]

Ryan Boren wrote:
> Michael B wrote:
>> Anyway, both are kicking out a mysql error:
>>
>>> WHERE .post_date <= '2006-10-25 19:04:47' AND ( .post_status = ]
>>> SELECT DISTINCT * FROM WHERE .post_date <= '2006-10-25 19:04:47' AND (
>>> .post_status = 'publish' OR .post_status = 'sticky' ) AND 
>>> .post_password =
>>> '' GROUP BY .ID
>>
>>
>> I'm guessing there's some new way posts are referenced in the 
>> database, and
>> these plugins are improperly referencing the database.  Any 
>> suggestions on
>> where to look to properly call the new schema?
> 
> Those plugins are using the deprecated $table_prefix instead of 
> $wpdb->prefix.

Oops. I meant it's using $tableposts instead of $wpdb->posts.

Ryan