[wp-hackers] Random Posts and 2.1

[Ryan Boren]

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.