Long field names which are shortened by Drupal doesn't work.

Yes, the bug is still there and the patch is fixing the issue. Long field name dedicated tables are built by using a hash to avoid going beyond the max table name length. This was spotted also in 🐛 Missing Table? Closed: works as designed

Can you verify if this is happening in the 2.x branch?

If this can be tested on 2.x branch.

Following up if this can be tried on 2.x branch before closing?

Scratch that found a dup that seems to have gotten this a week ago.

This also happened on database with table prefix in them.

Example : The website encountered an unexpected error. Please try again later.Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.block_content__body' doesn't exist: SELECT `entity_id`, `body_value` FROM block_content__body while the table should be db.drupal_block_content__body instead.

@akmalfikri thanks for the report. Does the proposed patch solve the problem?

@akmalfikri following up if you tested the patch?

This is in the 3.x branch

Automatically closed - issue fixed for 2 weeks with no activity.

Hello,
This is still an issue with latest version (3.1.1)
on Drupal 10.3.9 + CiviCRM
although it does not look due to the long field name.

2024/12/12 11:38:44 [error] 401842#401842: *383659 FastCGI sent in stderr: "PHP message: Uncaught PHP Exception Drupal\Core\Database\DatabaseExceptionWrapper: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'i9_drupal10.civicrm_action_schedule' doesn't exist: SELECT COUNT(*) AS "expression"
FROM
(SELECT 1 AS "expression"
FROM
"civicrm_action_schedule" "t") "subquery"; Array
(
)
" at /var/www/html/circle/drupal10/web/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php line 56" while reading response header from upstream, client:

Is it possible the problem is that we use separate database for drupal and civicrm?

@smustgrave Prefix issue is fixed on latest patch. Thanks!