The SQL storage cannot change the schema for an existing entity type (media) with data.

The website encountered an unexpected error. Please try again later.Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'revision.revision_user' in 'field list': SELECT revision.vid AS vid, revision.langcode AS langcode, revision.revision_user AS revision_user, revision.revision_created AS revision_created, revision.revision_log_message AS revision_log_message, revision.revision_default AS revision_default, base.mid AS mid, base.bundle AS bundle, base.uuid AS uuid, CASE base.vid WHEN revision.vid THEN 1 ELSE 0 END AS isDefaultRevision FROM {media} base INNER JOIN {media_revision} revision ON revision.vid = base.vid WHERE base.mid IN (:db_condition_placeholder_0); Array ( [:db_condition_placeholder_0] => 1187 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->getFromStorage() (line 455 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php). <pre class="backtrace">Drupal\Core\Database\Statement->execute(Array, Array) (Line: 625) Drupal\Core\Database\Connection->query('SELECT revision.vid AS vid, revision.langcode AS langcode, revision.revision_user AS revision_user, revision.revision_created AS revision_created, revision.revision_log_message AS revision_log_message, revision.revision_default AS revision_default, base.mid AS mid, base.bundle AS bundle, base.uuid AS uuid, CASE base.vid WHEN revision.vid THEN 1 ELSE 0 END AS isDefaultRevision FROM {media} base INNER JOIN {media_revision} revision ON revision.vid = base.vid WHERE base.mid IN (:db_condition_placeholder_0)', Array, Array) (Line: 87) Drupal\Core\Database\Driver\mysql\Connection->query('SELECT revision.vid AS vid, revision.langcode AS langcode, revision.revision_user AS revision_user, revision.revision_created AS revision_created, revision.revision_log_message AS revision_log_message, revision.revision_default AS revision_default, base.mid AS mid, base.bundle AS bundle, base.uuid AS uuid, CASE base.vid WHEN revision.vid THEN 1 ELSE 0 END AS isDefaultRevision FROM {media} base INNER JOIN {media_revision} revision ON revision.vid = base.vid WHERE base.mid IN (:db_condition_placeholder_0)', Array, Array) (Line: 510) Drupal\Core\Database\Query\Select->execute() (Line: 455) Drupal\Core\Entity\Sql\SqlContentEntityStorage->getFromStorage(Array) (Line: 426) Drupal\Core\Entity\Sql\SqlContentEntityStorage->doLoadMultiple(Array) (Line: 242) Drupal\Core\Entity\EntityStorageBase->loadMultiple(Array) (Line: 212) Drupal\Core\Entity\EntityStorageBase->load('1187') (Line: 524) Drupal\Core\Entity\Entity::load('1187') (Line: 38) Drupal\aao_additions\Plugin\Field\FieldFormatter\AAOImageFormatter->viewElements(Object, 'en') (Line: 80) Drupal\Core\Field\FormatterBase->view(Object, NULL) (Line: 262) Drupal\Core\Entity\Entity\EntityViewDisplay->buildMultiple(Array) (Line: 321) Drupal\Core\Entity\EntityViewBuilder->buildComponents(Array, Array, Array, 'full') (Line: 22) Drupal\node\NodeViewBuilder->buildComponents(Array, Array, Array, 'full') (Line: 263) Drupal\Core\Entity\EntityViewBuilder->buildMultiple(Array) (Line: 220) Drupal\Core\Entity\EntityViewBuilder->build(Array) call_user_func(Array, Array) (Line: 378) Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195) Drupal\Core\Render\Renderer->render(Array, ) (Line: 226) Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() (Line: 582) Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 227) Drupal\Core\Render\MainContent\HtmlRenderer->prepare(Array, Object, Object) (Line: 117) Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object, Object) (Line: 90) Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object, 'kernel.view', Object) call_user_func(Array, Object, 'kernel.view', Object) (Line: 111) Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.view', Object) (Line: 156) Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 68) Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 57) Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 47) Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 99) Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 78) Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 47) Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 50) Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23) Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 664) Drupal\Core\DrupalKernel->handle(Object) (Line: 19) </pre>

<pre> $ ../vendor/bin/drush entity-updates The following updates are pending: media entity type : The Media entity type needs to be updated. The Revision create time field needs to be installed. The Revision user field needs to be installed. The Revision log message field needs to be installed. The Revision timestamp field needs to be uninstalled. The Revision publisher ID field needs to be uninstalled. The Revision Log field needs to be uninstalled. media_type entity type : The Media type entity type needs to be installed. Do you wish to run all pending updates? (y/n): y Drupal\Core\Entity\EntityStorageException: The SQL storage cannot [error] change the schema for an existing entity type (media) with data. in Drupal\Core\Entity\Sql\SqlContentEntityStorageSchema->onEntityTypeUpdate() (line 347 of /Users/jason/Sites/artobject/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorageSchema.php). Failed: Drupal\Core\Entity\EntityStorageException: !message in [error] Drupal\Core\Entity\Sql\SqlContentEntityStorageSchema->onEntityTypeUpdate() (line 347 of /Users/jason/Sites/artobject/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorageSchema.php). Cache rebuild complete. [ok] Finished performing updates. [ok] </pre>

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 4 months ago →
🇳🇿New Zealand quietone
There has been no discussion on the support request for 4 years suggesting that solutions have been found. And I don't see discussion that this is a core bug. I think it is time to close this.

The Drupal Core issue queue is not the ideal place for support requests (that option is mostly there for filing support issues for contributed modules and themes). There are several support options listed on our support page → (Community > Support at the top of Drupal.org) and there is Drupal Slack → . Drupal Slack and the Forums, which are our two main support mechanisms in the Drupal community.