rich1.0phorkiehttps://p.cweiske.de/Drupal entity browser: Crash with inconsistent dataChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/803 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="803">
<div class="phork-file">
<div class="phork-content">
<div class="document">
<p>System: Drupal 8.7 with entity_browser 1.8.0</p>
<div class="section" id="problem">
<h1>Problem</h1>
<p>We have some entries in database table <tt class="docutils literal">media_field_data</tt> that are not in table <tt class="docutils literal">media</tt>.</p>
<p>When opening the entity browser to select an image, a crash occurs:</p>
<pre class="literal-block">
The website encountered an unexpected error. Please try again later.
Error: Call to a member function getEntityTypeId() on null in Drupal\entity_browser\Plugin\views\field\SelectForm->getRowId() (line 29 of modules/contrib/entity_browser/src/Plugin/views/field/SelectForm.php).
</pre>
</div>
<div class="section" id="solution">
<h1>Solution</h1>
<p>Delete all the broken media entries.</p>
</div>
</div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/803/rev-raw/81ac08d837c8b89507a739361a1cfad58d7dcca2/1-README.rst" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/803#1-README.rst">1-README.rst</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
</pre></td><td class="de1"><pre class="de1"><span class="kw1">DELETE</span> <span class="kw1">FROM</span> media_field_data
<span class="kw1">WHERE</span> mid <span class="kw1">IN</span> <span class="br0">(</span>
  <span class="kw1">SELECT</span> mid <span class="kw1">FROM</span> <span class="br0">(</span>
    <span class="kw1">SELECT</span> media_field_data<span class="sy0">.</span>mid
    <span class="kw1">FROM</span> <span class="st0">`media_field_data`</span>
    <span class="kw1">LEFT</span> <span class="kw1">JOIN</span> media <span class="kw1">ON</span> media_field_data<span class="sy0">.</span>mid <span class="sy0">=</span> media<span class="sy0">.</span>mid
    <span class="kw1">WHERE</span> media<span class="sy0">.</span>mid <span class="kw1">IS</span> <span class="kw1">NULL</span>
  <span class="br0">)</span> <span class="kw1">AS</span> foo
<span class="br0">)</span>;
 
<span class="kw1">DELETE</span> <span class="kw1">FROM</span> media_field_revision
<span class="kw1">WHERE</span> mid <span class="kw1">IN</span> <span class="br0">(</span>
  <span class="kw1">SELECT</span> mid <span class="kw1">FROM</span> <span class="br0">(</span>
    <span class="kw1">SELECT</span> media_field_revision<span class="sy0">.</span>mid
    <span class="kw1">FROM</span> <span class="st0">`media_field_revision`</span>
    <span class="kw1">LEFT</span> <span class="kw1">JOIN</span> media <span class="kw1">ON</span> media_field_revision<span class="sy0">.</span>mid <span class="sy0">=</span> media<span class="sy0">.</span>mid
    <span class="kw1">WHERE</span> media<span class="sy0">.</span>mid <span class="kw1">IS</span> <span class="kw1">NULL</span>
  <span class="br0">)</span> <span class="kw1">AS</span> foo
<span class="br0">)</span>;
 </pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/803/rev-raw/81ac08d837c8b89507a739361a1cfad58d7dcca2/2-fix.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/803#2-fix.sql">2-fix.sql</a>
</div>
</div>
<div class="phork-file">
<div class="phork-content">
<div class="code"><pre class="txt">The website encountered an unexpected error. Please try again later.
Error: Call to a member function getEntityTypeId() on null in Drupal\entity_browser\Plugin\views\field\SelectForm->getRowId() (line 29 of modules/contrib/entity_browser/src/Plugin/views/field/SelectForm.php).
Drupal\entity_browser\Plugin\views\field\SelectForm->getRowId(Object) (Line: 36)
Drupal\entity_browser\Plugin\views\field\SelectForm->render(Object) (Line: 1155)
Drupal\views\Plugin\views\field\FieldPluginBase->advancedRender(Object) (Line: 236)
template_preprocess_views_view_field(Array, 'views_view_field', Array) (Line: 287)
Drupal\Core\Theme\ThemeManager->render('views_view_field', Array) (Line: 437)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 1747)
Drupal\views\Plugin\views\field\FieldPluginBase->theme(Object) (Line: 761)
Drupal\views\Plugin\views\style\StylePluginBase->elementPreRenderRow(Array)
call_user_func(Array, Array) (Line: 378)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 195)
Drupal\Core\Render\Renderer->render(Array) (Line: 709)
Drupal\views\Plugin\views\style\StylePluginBase->renderFields(Array) (Line: 576)
Drupal\views\Plugin\views\style\StylePluginBase->renderGrouping(Array, Array, 1) (Line: 468)
Drupal\views\Plugin\views\style\StylePluginBase->render(Array) (Line: 2111)
Drupal\views\Plugin\views\display\DisplayPluginBase->render() (Line: 131)
Drupal\webprofiler\Views\TraceableViewExecutable->render() (Line: 33)
Drupal\entity_browser\Plugin\views\display\EntityBrowser->execute() (Line: 104)
Drupal\entity_browser\Plugin\views\display\EntityBrowser->preview() (Line: 1662)
Drupal\views\ViewExecutable->preview('entity_browser_1', Array) (Line: 194)
Drupal\views\Controller\ViewAjaxController->Drupal\views\Controller\{closure}() (Line: 582)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 195)
Drupal\views\Controller\ViewAjaxController->ajaxView(Object)
call_user_func_array(Array, Array) (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 582)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 151)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 68)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 67)
Drupal\simple_oauth\HttpMiddleware\BasicAuthSwap->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: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 38)
Drupal\webprofiler\StackMiddleware\WebprofilerMiddleware->handle(Object, 1, 1) (Line: 52)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 693)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
</pre></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/803/rev-raw/81ac08d837c8b89507a739361a1cfad58d7dcca2/3-exception.txt" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/803#3-exception.txt">3-exception.txt</a>
</div>
</div>
</div>