列未找到：“字段列表”中的1054个未知列“revision.revision_user”：更新后从8.2到8.4

Question

在从8.2更新到8.4时，我遇到了一个错误，在我的例子中，它似乎与block_content有关，也可能与商业有关。我发现其他人也有类似的问题，但没有明确的解决办法。有人经历过吗？

下面是错误日志中的错误：

Uncaught PHP Exception Drupal\Core\Database\DatabaseExceptionWrapper: 
"SQLSTATE[42S22]: Column not found: 1054 Unknown column 
'revision.revision_user' in 'field list': SELECT revision.revision_id 
AS revision_id, revision.langcode AS langcode, revision.revision_user 
AS revision_user, revision.revision_created AS revision_created, 
revision.revision_log AS revision_log, base.id AS id, base.type AS 
type, base.uuid AS uuid, CASE base.revision_id WHEN 
revision.revision_id THEN 1 ELSE 0 END AS isDefaultRevision
FROM 
{block_content} base
INNER JOIN {block_content_revision} revision ON revision.revision_id = 
base.revision_id; Array
(
)
" at /core/lib/Drupal/Core/Database/Connection.php 
line 686

当我尝试运行drush entity-updates时，它会出现以下错误：

block_content entity type : 
  The Revision create time field needs to be updated.
  The Revision user field needs to be updated.
Do you wish to run all pending updates? (y/n): y
Drupal\Core\Entity\EntityStorageException: Exception thrown while 
performing a schema update. [error]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 
'revision_created' in 'where clause':
SELECT 1 AS expression
FROM 
{block_content_revision} t
WHERE revision_created IS NOT NULL
LIMIT 1 OFFSET 0; Array
(
)
 in Drupal\Core\Entity\Sql\SqlContentEntityStorage-
>wrapSchemaException() (line 1513 of /core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

Fatal error: Cannot use Drupal\entity\BundleFieldDefinition as 
BundleFieldDefinition because the name is already in use in /modules/commerce/src/ConfigurableFieldManager.php on 
line 8
Drush command terminated abnormally due to an unrecoverable error.                            
[error]
Error: Cannot use Drupal\entity\BundleFieldDefinition as 
BundleFieldDefinition because the
name is already in use in
/modules/commerce/src/ConfigurableFieldManager.php, 
line 8
The external command could not be executed due to an application 
error.    

如果有任何帮助，网站就会关闭。

Answer 1

根据这个评论，这可能与这个错误报告中的动态实体引用模块相关。

解决方案是应用此补丁或升级到该模块的最新版本。

要手动修复该问题，需要将数据库中的字段从revision_user重命名为revision_user_int。

这里的另一个建议是将：$settings['update_free_access'] = TRUE;添加到您的设置文件中，并运行/update.php再次调用数据库更新。