Le site Web a rencontré une erreur inattendue. Veuillez essayer de nouveau plus tard.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42601]: Syntax error: 7 ERREUR: erreur de syntaxe sur ou près de « , » LINE 7: ... AND SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + AB... ^: SELECT n.nid FROM tb_node n JOIN tb_node__field_latitude lat ON lat.entity_id = n.nid JOIN tb_node__field_longitude lng ON lng.entity_id = n.nid WHERE type = 'commodite' AND SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + ABS(POWER(lng.field_longitude_value - , 2))) * 110 < 5 ORDER BY SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + ABS(POWER(lng.field_longitude_value - , 2))) * 110 ASC; Array ( ) in streicher_preprocess_node() (line 160 of themes/custom/streicher/streicher.theme).
Drupal\Core\Database\Statement->execute(Array, Array) (Line: 625)
Drupal\Core\Database\Connection->query('
      SELECT n.nid
      FROM tb_node n
      JOIN tb_node__field_latitude lat ON lat.entity_id = n.nid
      JOIN tb_node__field_longitude lng ON lng.entity_id = n.nid
      WHERE type = 'commodite'
      AND SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + ABS(POWER(lng.field_longitude_value - , 2))) * 110 &lt; 5
      ORDER BY SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + ABS(POWER(lng.field_longitude_value - , 2))) * 110 ASC', Array, Array) (Line: 201)
Drupal\Core\Database\Driver\pgsql\Connection->query('
      SELECT n.nid
      FROM tb_node n
      JOIN tb_node__field_latitude lat ON lat.entity_id = n.nid
      JOIN tb_node__field_longitude lng ON lng.entity_id = n.nid
      WHERE type = 'commodite'
      AND SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + ABS(POWER(lng.field_longitude_value - , 2))) * 110 &lt; 5
      ORDER BY SQRT(ABS(POWER(lat.field_latitude_value - , 2)) + ABS(POWER(lng.field_longitude_value - , 2))) * 110 ASC
    ') (Line: 160)
streicher_preprocess_node(Array, 'node', Array) (Line: 287)
Drupal\Core\Theme\ThemeManager->render('node', Array) (Line: 437)
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: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->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)