I upgraded to 2.6.1 and my topic replies are not being displayed. Debug toolbar shows that there are two database errors being thrown, both like this:

SELECT COUNT(wp_posts.ID)
FROM wp_posts FORCE INDEX (PRIMARY, post_parent)
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = '_bbp_reply_to'
WHERE 1=1 AND (wp_posts.ID = 76 OR wp_posts.post_parent = 76)
AND wp_posts.post_type IN ('topic', 'reply')
AND wp_postmeta.meta_key IS NULL
AND (wp_posts.post_status = 'publish')
ORDER BY wp_posts.post_date ASC

Table 'site_name.wp_posts' doesn't exist

The list of forums and topics works fine.

Like many WordPress installations I have a custom prefix for my database tables (“wp_****_”) and it appears that bbPress 2.6.1 is using that for some queries and not others.

[@johnjamesjacoby Keymaster 5 years, 2 months ago]

It’s hard to see what you mean looking at that query, as there are no site_name type databases before any of the tables.

Custom prefixes should all be completely accounted for, but I’ll do an audit to be sure and report back.

The IS NULL meta_key statement is weird.

Is it possible some other plugin is filtering this query that shouldn’t be?

[@mrwiblog Participant 5 years, 2 months ago]

I don’t believe it’s another plugin changing this, as it was working before the bbPress update.

The “site_name” thing was me obfuscating my database name, sorry if it confused matters. Thanks.

[@mrwiblog Participant 5 years, 2 months ago]

Any news on this? I’ve still got 2.5.14 on my development machine, and it works fine there – but the table names aren’t prefixed.