Error on microsite 1 at /admin/microsites

[finnlewis]

@ekes : This might be an artificial error, as microsite admins probably won't be trying to access /admin/microsites on a microsite, but @msayoung stumbled across it.

Create a microsite : localgov-micro-1.lndo.site Create a user: admin1 Add user to the microsite as an admin role: Log into localgov-micro-1.lndo.site Visit /admin/microsites

See this error:

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Microsites[localgov_microsites_overview]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base_table.id' in 'where clause': SELECT "groups_field_data"."id" AS "id" FROM "groups_field_data" "groups_field_data" WHERE (((("groups_field_data"."status" = :db_condition_placeholder_0) AND (("groups_field_data"."id" IN (:db_condition_placeholder_1)) OR (("groups_field_data"."uid" = :db_condition_placeholder_2) AND ("groups_field_data"."id" IN (:db_condition_placeholder_3))))) OR (("groups_field_data"."status" = :db_condition_placeholder_4) AND ("groups_field_data"."id" IN (:db_condition_placeholder_5)))) AND (("groups_field_data"."status" = :db_condition_placeholder_6) AND ("groups_field_data"."type" IN (:db_condition_placeholder_7)))) AND ("base_table"."id" = :db_condition_placeholder_8) LIMIT 51 OFFSET 0; Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => 3 [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => 1 [:db_condition_placeholder_5] => 1 [:db_condition_placeholder_6] => 1 [:db_condition_placeholder_7] => microsite [:db_condition_placeholder_8] => 1 ) in main() (line 19 of index.php).

Drupal\views\ViewExecutable->execute(NULL) (Line: 1454)
Drupal\views\ViewExecutable->render() (Line: 199)
Drupal\views\Plugin\views\display\Page->execute() (Line: 1630)
Drupal\views\ViewExecutable->executeDisplay('collection', Array) (Line: 81)
Drupal\views\Element\View::preRenderViewElement(Array)
call_user_func_array(Array, Array) (Line: 101)
Drupal\Core\Render\Renderer->doTrustedCallback(Array, Array, 'Render #pre_render callbacks must be methods of a class that implements \Drupal\Core\Security\TrustedCallbackInterface or be an anonymous function. The callback was %s. See https://www.drupal.org/node/2966725', 'exception', 'Drupal\Core\Render\Element\RenderCallbackInterface') (Line: 772)
Drupal\Core\Render\Renderer->doCallback('#pre_render', Array, Array) (Line: 363)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 201)
Drupal\Core\Render\Renderer->render(Array, ) (Line: 241)
Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() (Line: 564)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 242)
Drupal\Core\Render\MainContent\HtmlRenderer->prepare(Array, Object, Object) (Line: 132)
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: 142)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch(Object, 'kernel.view') (Line: 163)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 80)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 58)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 48)
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: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 708)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)

[ekes]

Dupe https://github.com/localgovdrupal/localgov_microsites_group/issues/38

[ekes]

Can we please use the existing issue on the module?