bbPress and WooCommerce extensions not working

[adamziel]

Update April 22nd – to resolve this issue, go through the discussion, test Playground with the plugins that were mentioned, run a few SQL queries with the discussed syntaxes, and confirm it works. Also, with BBPress I my thread replies were stored in the db but were not visible on the website. Let's confirm this is also an issue in vanilla WordPress. If it isn't, let's figure out what's wrong with Playground.

---

Milan Petrovic said on Twitter:

and a lot of stuff related to MySQL not working at all, most likely because they have been disabled on the MySQL instance they are running.

most plugins don't work due to database issues or plugin requirements (you can't test any extension for WooCommerce or plugin for bbPress...).

Let's investigate this.

[adamziel]

Any query that depends on getting data from information_schema is not returning anything; queries that use 'SHOW TABLE STATUS' also broken, and I noticed some normal queries that use group are returning no results.

[adamziel]

I have plugins for bbPress; if you run preview, nothing happens since bbPress is missing. Even if bbPress is active, it is empty, there is nothing to show. Without plugin requirements, Preview can't install required plugins. Without demo data, users have nothing to see.

[adamziel]

Relevant bbPress plugins: https://plugins.dev4press.com/

[dev4press]

Relevant bbPress plugins: https://plugins.dev4press.com/

I have many bbPress on WordPress.org, if that is easier to test for, since they can be used directly in the Playground:

https://wordpress.org/plugins/gd-bbpress-tools/
https://wordpress.org/plugins/gd-bbpress-attachments/
https://wordpress.org/plugins/gd-forum-manager-for-bbpress/
https://wordpress.org/plugins/gd-members-directory-for-bbpress/
https://wordpress.org/plugins/gd-power-search-for-bbpress/
https://wordpress.org/plugins/gd-topic-polls/

[adamziel]

I just tried bbpress in Playground and found the following two issues so far:

• It give a blank page on forums list on twentytwentythree. It seems to be an issue with the theme as it works correctly with twentytwentyone.
• BBPress uses FORCE INDEX in one of its queries and that isn't yet supported by the SQLite integration.

[adamziel]

Once these two PRs are merged, this issue should be ready for re-testing:

• Support FORCE INDEX queries sqlite-database-integration#95
• Support SHOW TABLE STATUS sqlite-database-integration#75

[bgrgicak]

@adamziel is this issue resolved?

[adamziel]

@bgrgicak maybe — it needs testing with bbpress and the plugins mentioned above. If those work, then yes

[bgrgicak]

It give a blank page on forums list on twentytwentythree. It seems to be an issue with the theme as it works correctly with twentytwentyone.

I can see the same issue when using wp-env.

I tried installing BBPress and the listed plugins. I was able to activate all plugins and use BBPress to create a forum, topics and add comments. I also tested attachment uploads using the attachment plugin.
Everything seems to work as expected (on twentytwentyone).

[bgrgicak]

I'm closing this issue as there are no clear next steps, we can reopen it if needed.