Custom blocks with media are not being displayed

Wasn't able to replicate this issue. Wonder if someone could confirm it's still an issue in D10?

I just did a fresh install of Umami on Drupal 10.0.9. As soon as I switch to the Stage workspace the umami_views_block__promoted_items_block_1 and umami_banner_home blocks on the home page disappear.

I am able to recreate this but in the steps to replicate I change:

/admin/config/workflow/workspaces/manage/stage/deploy

to:

/admin/config/workflow/workspaces/manage/stage/publish

For some reason I need to add the desitination parameter or I get a WSOD. I will raise a separate issue for that.

I created an issue to address the fact that we are not logging the error. #3376177

When I surface the error this is what I get:

NOTICE: PHP message: Uncaught PHP Exception Drupal\Core\Database\DatabaseExceptionWrapper: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
GROUP BY "base_table"."revision_id", "base_table"."id") "subquery"' at line 7: SELECT COUNT(*) AS "expression"
FROM
(SELECT 1 AS "expression"
FROM
"content_moderation_state_revision" "base_table"
INNER JOIN "content_moderation_state_field_revision" "content_moderation_state_field_revision" ON "content_moderation_state_field_revision"."revision_id" = "base_table"."revision_id"
WHERE ("content_moderation_state_field_revision"."content_entity_revision_id" IN (:db_condition_placeholder_0)) AND ()
GROUP BY "base_table"."revision_id", "base_table"."id") "subquery"; Array
(
    [:db_condition_placeholder_0] => 5
)
" at /data/app/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php line 46
{ "timestamp": "2023-07-22T13:22:21+0000", "fields": { "client_ip": "-", "remote_addr": "127.0.0.1", "remote_user": "", "request_uri": "/en/admin/config/workflow/workspaces/manage/stage/publish?destination=", "status": "500", "body_bytes_sent": "184", "request_time": "0.373", "http_referrer": "http://localhost:8080/en/admin/config/workflow/workspaces/manage/stage/publish?destination", "http_user_agent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36", "request_id": "-", "cpu": "56.36", "memory": "10485760", "headers": { "Cache-Control": "must-revalidate, no-cache, private"} } }

I've tested this on latest core and cannot reproduce the error. The steps in the IS are quite outdated though, I've updated them with the required steps.

Will leave this open a touch longer, I assume this was an issue in workspaces rather than block_content though.