Skip to content

Instantly share code, notes, and snippets.

@dawehner
Created December 4, 2016 16:04
Show Gist options
  • Select an option

  • Save dawehner/e67817d5e7a77a9f3ed172a0f84de001 to your computer and use it in GitHub Desktop.

Select an option

Save dawehner/e67817d5e7a77a9f3ed172a0f84de001 to your computer and use it in GitHub Desktop.
Auf der Website ist ein unvorhergesehener Fehler aufgetreten. Bitte versuchen Sie es später nochmal.
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'langcode' in field list is ambiguous: SELECT node_field_data.langcode AS node_field_data_langcode, node_field_data.created AS node_field_data_created, node_field_data.nid AS nid, node_field_revision_workbench_revision_tracker.vid AS node_field_revision_workbench_revision_tracker_vid, langcode AS langcode FROM {node_field_data} node_field_data LEFT JOIN {workbench_revision_tracker} workbench_revision_tracker ON node_field_data.nid = workbench_revision_tracker.entity_id AND (workbench_revision_tracker.entity_type = :views_join_condition_0 AND workbench_revision_tracker.langcode = node_field_data.langcode) LEFT JOIN {node_field_revision} node_field_revision_workbench_revision_tracker ON workbench_revision_tracker.revision_id = node_field_revision_workbench_revision_tracker.vid AND (workbench_revision_tracker.entity_type = :views_join_condition_2 AND node_field_revision_workbench_revision_tracker.langcode = workbench_revision_tracker.langcode) INNER JOIN {node__field_id_edition} node__field_id_edition ON node_field_data.nid = node__field_id_edition.entity_id AND (node__field_id_edition.deleted = :views_join_condition_4 AND node__field_id_edition.langcode = node_field_data.langcode) WHERE (( (node__field_id_edition.field_id_edition_target_id = :node__field_id_edition_field_id_edition_target_id) )AND(( (node_field_data.type IN (:db_condition_placeholder_6)) AND (node_field_revision_workbench_revision_tracker.moderation_state IN (:db_condition_placeholder_7)) )OR( (node_field_data.type IN (:db_condition_placeholder_8)) AND (node_field_revision_workbench_revision_tracker.moderation_state IN (:db_condition_placeholder_9)) ))) ORDER BY node_field_data_created DESC LIMIT 26 OFFSET 0; Array ( [:node__field_id_edition_field_id_edition_target_id] => 2 [:db_condition_placeholder_6] => zeb_initiative [:db_condition_placeholder_7] => initiative_draft [:db_condition_placeholder_8] => zeb_monitorsteckbrief [:db_condition_placeholder_9] => monitor_review [:views_join_condition_0] => node [:views_join_condition_2] => node [:views_join_condition_4] => 0 ) in Drupal\Core\Database\Connection->handleQueryException() (line 668 of core/lib/Drupal/Core/Database/Connection.php).
Drupal\Core\Database\Statement->execute(Array, Array) (Line: 610)
Drupal\Core\Database\Connection->query('SELECT node_field_data.langcode AS node_field_data_langcode, node_field_data.created AS node_field_data_created, node_field_data.nid AS nid, node_field_revision_workbench_revision_tracker.vid AS node_field_revision_workbench_revision_tracker_vid, langcode AS langcode
FROM
{node_field_data} node_field_data
LEFT JOIN {workbench_revision_tracker} workbench_revision_tracker ON node_field_data.nid = workbench_revision_tracker.entity_id AND (workbench_revision_tracker.entity_type = :views_join_condition_0 AND workbench_revision_tracker.langcode = node_field_data.langcode)
LEFT JOIN {node_field_revision} node_field_revision_workbench_revision_tracker ON workbench_revision_tracker.revision_id = node_field_revision_workbench_revision_tracker.vid AND (workbench_revision_tracker.entity_type = :views_join_condition_2 AND node_field_revision_workbench_revision_tracker.langcode = workbench_revision_tracker.langcode)
INNER JOIN {node__field_id_edition} node__field_id_edition ON node_field_data.nid = node__field_id_edition.entity_id AND (node__field_id_edition.deleted = :views_join_condition_4 AND node__field_id_edition.langcode = node_field_data.langcode)
WHERE (( (node__field_id_edition.field_id_edition_target_id = :node__field_id_edition_field_id_edition_target_id) )AND(( (node_field_data.type IN (:db_condition_placeholder_6)) AND (node_field_revision_workbench_revision_tracker.moderation_state IN (:db_condition_placeholder_7)) )OR( (node_field_data.type IN (:db_condition_placeholder_8)) AND (node_field_revision_workbench_revision_tracker.moderation_state IN (:db_condition_placeholder_9)) )))
ORDER BY node_field_data_created DESC
LIMIT 26 OFFSET 0', Array, Array) (Line: 81)
Drupal\Core\Database\Driver\mysql\Connection->query('SELECT node_field_data.langcode AS node_field_data_langcode, node_field_data.created AS node_field_data_created, node_field_data.nid AS nid, node_field_revision_workbench_revision_tracker.vid AS node_field_revision_workbench_revision_tracker_vid, langcode AS langcode
FROM
{node_field_data} node_field_data
LEFT JOIN {workbench_revision_tracker} workbench_revision_tracker ON node_field_data.nid = workbench_revision_tracker.entity_id AND (workbench_revision_tracker.entity_type = :views_join_condition_0 AND workbench_revision_tracker.langcode = node_field_data.langcode)
LEFT JOIN {node_field_revision} node_field_revision_workbench_revision_tracker ON workbench_revision_tracker.revision_id = node_field_revision_workbench_revision_tracker.vid AND (workbench_revision_tracker.entity_type = :views_join_condition_2 AND node_field_revision_workbench_revision_tracker.langcode = workbench_revision_tracker.langcode)
INNER JOIN {node__field_id_edition} node__field_id_edition ON node_field_data.nid = node__field_id_edition.entity_id AND (node__field_id_edition.deleted = :views_join_condition_4 AND node__field_id_edition.langcode = node_field_data.langcode)
WHERE (( (node__field_id_edition.field_id_edition_target_id = :node__field_id_edition_field_id_edition_target_id) )AND(( (node_field_data.type IN (:db_condition_placeholder_6)) AND (node_field_revision_workbench_revision_tracker.moderation_state IN (:db_condition_placeholder_7)) )OR( (node_field_data.type IN (:db_condition_placeholder_8)) AND (node_field_revision_workbench_revision_tracker.moderation_state IN (:db_condition_placeholder_9)) )))
ORDER BY node_field_data_created DESC
LIMIT 26 OFFSET 0', Array, Array) (Line: 493)
Drupal\Core\Database\Query\Select->execute() (Line: 1466)
Drupal\views\Plugin\views\query\Sql->execute(Object) (Line: 1413)
Drupal\views\ViewExecutable->execute(NULL) (Line: 1441)
Drupal\views\ViewExecutable->render() (Line: 171)
Drupal\views\Plugin\views\display\Page->execute() (Line: 1617)
Drupal\views\ViewExecutable->executeDisplay('page_re', Array) (Line: 78)
Drupal\views\Element\View::preRenderViewElement(Array)
call_user_func(Array, Array) (Line: 376)
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: 574)
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) (Line: 111)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.view', Object) (Line: 144)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 62)
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: 652)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment