API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 19th, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.75 KB | None | 0 0
raw download clone embed print report
  1. El sitio web encontró un error inesperado. Vuelva a intentarlo más tarde.</br></br><em class="placeholder">Drupal\Core\Database\DatabaseExceptionWrapper</em>: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column &#039;sime.cpi_data.title&#039; which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT comuna.field_comuna_value AS field_comuna_value, cpi_data.title AS title, SUM(IF(tc.field_tipo_caso_value = &#039;asi&#039;, 1, 0)) AS asi, SUM(IF(tc.field_tipo_caso_value = &#039;maltrato&#039;, 1, 0)) AS maltrato, SUM(IF(tc.field_tipo_caso_value = &#039;negligencia&#039;, 1, 0)) AS negligencia, SUM(IF(tc.field_tipo_caso_value NOT IN (&#039;asi&#039;, &#039;maltrato&#039;, &#039;negligencia&#039;), 1, 0)) AS otro, COUNT(*) AS total
  2. FROM
  3. {paragraph__field_tipo_caso} tc
  4. LEFT OUTER JOIN {paragraph__field_leido} l ON tc.bundle = l.bundle AND tc.entity_id = l.entity_id AND tc.revision_id = l.revision_id
  5. LEFT OUTER JOIN {paragraph__field_tipo_informe} i ON tc.bundle = i.bundle AND tc.entity_id = i.entity_id AND tc.revision_id = i.revision_id
  6. LEFT OUTER JOIN {node__field_casos} c ON c.bundle = :bundle AND tc.entity_id = c.field_casos_target_id AND tc.revision_id = c.field_casos_target_revision_id
  7. LEFT OUTER JOIN {node__field_nino} nino ON c.bundle = nino.bundle AND c.entity_id = nino.entity_id AND c.revision_id = nino.revision_id
  8. LEFT OUTER JOIN {node__field_cpi} cpi ON cpi.bundle = :bundle AND nino.field_nino_target_id = cpi.entity_id
  9. LEFT OUTER JOIN {node__field_comuna} comuna ON comuna.bundle = :bundle AND comuna.entity_id = cpi.field_cpi_target_id
  10. LEFT OUTER JOIN {node_field_data} cpi_data ON cpi_data.type = :type AND cpi_data.nid = cpi.field_cpi_target_id
  11. LEFT OUTER JOIN {node__field_datos_personales} dp ON dp.bundle = :bundle AND nino.field_nino_target_id = dp.entity_id
  12. LEFT OUTER JOIN {paragraph__field_fecha_de_nacimiento} fechnac ON dp.field_datos_personales_target_id = fechnac.entity_id AND dp.field_datos_personales_target_revision_id = fechnac.revision_id
  13. LEFT OUTER JOIN {paragraph__field_sexo} genero ON dp.field_datos_personales_target_id = genero.entity_id AND dp.field_datos_personales_target_revision_id = genero.revision_id
  14. WHERE (l.field_leido_value = :db_condition_placeholder_0) AND (i.field_tipo_informe_value = :db_condition_placeholder_1) AND (genero.field_sexo_value IN (:db_condition_placeholder_2, :db_condition_placeholder_3)) AND ((TIMESTAMPDIFF(YEAR, fechnac.field_fecha_de_nacimiento_value, CURDATE()) &gt;= 0)) AND (cpi.field_cpi_target_id IN (:db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6))
  15. GROUP BY comuna.field_comuna_value
  16. ORDER BY comuna.field_comuna_value ASC; Array
  17. (
  18. [:db_condition_placeholder_0] =&gt; 0
  19. [:db_condition_placeholder_1] =&gt; intervencion
  20. [:db_condition_placeholder_2] =&gt; hombre
  21. [:db_condition_placeholder_3] =&gt; mujer
  22. [:db_condition_placeholder_4] =&gt; nuevo CPI
  23. [:db_condition_placeholder_5] =&gt; alicia maravillas
  24. [:db_condition_placeholder_6] =&gt; CPI prueba inasistencia
  25. [:bundle] =&gt; casos
  26. [:type] =&gt; cpi
  27. )
  28. in <em class="placeholder">Drupal\sime_salidas\Controller\CuadroResumenController-&gt;mostrar()</em> (line <em class="placeholder">50</em> of <em class="placeholder">modules/custom/sime_salidas/src/Controller/CuadroResumenController.php</em>). <pre class="backtrace">Drupal\Core\Database\Statement-&gt;execute(Array, Array) (Line: 625)
  29. Drupal\Core\Database\Connection-&gt;query(&#039;SELECT comuna.field_comuna_value AS field_comuna_value, cpi_data.title AS title, SUM(IF(tc.field_tipo_caso_value = &#039;asi&#039;, 1, 0)) AS asi, SUM(IF(tc.field_tipo_caso_value = &#039;maltrato&#039;, 1, 0)) AS maltrato, SUM(IF(tc.field_tipo_caso_value = &#039;negligencia&#039;, 1, 0)) AS negligencia, SUM(IF(tc.field_tipo_caso_value NOT IN (&#039;asi&#039;, &#039;maltrato&#039;, &#039;negligencia&#039;), 1, 0)) AS otro, COUNT(*) AS total
  30. FROM
  31. {paragraph__field_tipo_caso} tc
  32. LEFT OUTER JOIN {paragraph__field_leido} l ON tc.bundle = l.bundle AND tc.entity_id = l.entity_id AND tc.revision_id = l.revision_id
  33. LEFT OUTER JOIN {paragraph__field_tipo_informe} i ON tc.bundle = i.bundle AND tc.entity_id = i.entity_id AND tc.revision_id = i.revision_id
  34. LEFT OUTER JOIN {node__field_casos} c ON c.bundle = :bundle AND tc.entity_id = c.field_casos_target_id AND tc.revision_id = c.field_casos_target_revision_id
  35. LEFT OUTER JOIN {node__field_nino} nino ON c.bundle = nino.bundle AND c.entity_id = nino.entity_id AND c.revision_id = nino.revision_id
  36. LEFT OUTER JOIN {node__field_cpi} cpi ON cpi.bundle = :bundle AND nino.field_nino_target_id = cpi.entity_id
  37. LEFT OUTER JOIN {node__field_comuna} comuna ON comuna.bundle = :bundle AND comuna.entity_id = cpi.field_cpi_target_id
  38. LEFT OUTER JOIN {node_field_data} cpi_data ON cpi_data.type = :type AND cpi_data.nid = cpi.field_cpi_target_id
  39. LEFT OUTER JOIN {node__field_datos_personales} dp ON dp.bundle = :bundle AND nino.field_nino_target_id = dp.entity_id
  40. LEFT OUTER JOIN {paragraph__field_fecha_de_nacimiento} fechnac ON dp.field_datos_personales_target_id = fechnac.entity_id AND dp.field_datos_personales_target_revision_id = fechnac.revision_id
  41. LEFT OUTER JOIN {paragraph__field_sexo} genero ON dp.field_datos_personales_target_id = genero.entity_id AND dp.field_datos_personales_target_revision_id = genero.revision_id
  42. WHERE (l.field_leido_value = :db_condition_placeholder_0) AND (i.field_tipo_informe_value = :db_condition_placeholder_1) AND (genero.field_sexo_value IN (:db_condition_placeholder_2, :db_condition_placeholder_3)) AND ((TIMESTAMPDIFF(YEAR, fechnac.field_fecha_de_nacimiento_value, CURDATE()) &amp;gt;= 0)) AND (cpi.field_cpi_target_id IN (:db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6))
  43. GROUP BY comuna.field_comuna_value
  44. ORDER BY comuna.field_comuna_value ASC&#039;, Array, Array) (Line: 87)
  45. Drupal\Core\Database\Driver\mysql\Connection-&gt;query(&#039;SELECT comuna.field_comuna_value AS field_comuna_value, cpi_data.title AS title, SUM(IF(tc.field_tipo_caso_value = &#039;asi&#039;, 1, 0)) AS asi, SUM(IF(tc.field_tipo_caso_value = &#039;maltrato&#039;, 1, 0)) AS maltrato, SUM(IF(tc.field_tipo_caso_value = &#039;negligencia&#039;, 1, 0)) AS negligencia, SUM(IF(tc.field_tipo_caso_value NOT IN (&#039;asi&#039;, &#039;maltrato&#039;, &#039;negligencia&#039;), 1, 0)) AS otro, COUNT(*) AS total
  46. FROM
  47. {paragraph__field_tipo_caso} tc
  48. LEFT OUTER JOIN {paragraph__field_leido} l ON tc.bundle = l.bundle AND tc.entity_id = l.entity_id AND tc.revision_id = l.revision_id
  49. LEFT OUTER JOIN {paragraph__field_tipo_informe} i ON tc.bundle = i.bundle AND tc.entity_id = i.entity_id AND tc.revision_id = i.revision_id
  50. LEFT OUTER JOIN {node__field_casos} c ON c.bundle = :bundle AND tc.entity_id = c.field_casos_target_id AND tc.revision_id = c.field_casos_target_revision_id
  51. LEFT OUTER JOIN {node__field_nino} nino ON c.bundle = nino.bundle AND c.entity_id = nino.entity_id AND c.revision_id = nino.revision_id
  52. LEFT OUTER JOIN {node__field_cpi} cpi ON cpi.bundle = :bundle AND nino.field_nino_target_id = cpi.entity_id
  53. LEFT OUTER JOIN {node__field_comuna} comuna ON comuna.bundle = :bundle AND comuna.entity_id = cpi.field_cpi_target_id
  54. LEFT OUTER JOIN {node_field_data} cpi_data ON cpi_data.type = :type AND cpi_data.nid = cpi.field_cpi_target_id
  55. LEFT OUTER JOIN {node__field_datos_personales} dp ON dp.bundle = :bundle AND nino.field_nino_target_id = dp.entity_id
  56. LEFT OUTER JOIN {paragraph__field_fecha_de_nacimiento} fechnac ON dp.field_datos_personales_target_id = fechnac.entity_id AND dp.field_datos_personales_target_revision_id = fechnac.revision_id
  57. LEFT OUTER JOIN {paragraph__field_sexo} genero ON dp.field_datos_personales_target_id = genero.entity_id AND dp.field_datos_personales_target_revision_id = genero.revision_id
  58. WHERE (l.field_leido_value = :db_condition_placeholder_0) AND (i.field_tipo_informe_value = :db_condition_placeholder_1) AND (genero.field_sexo_value IN (:db_condition_placeholder_2, :db_condition_placeholder_3)) AND ((TIMESTAMPDIFF(YEAR, fechnac.field_fecha_de_nacimiento_value, CURDATE()) &amp;gt;= 0)) AND (cpi.field_cpi_target_id IN (:db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6))
  59. GROUP BY comuna.field_comuna_value
  60. ORDER BY comuna.field_comuna_value ASC&#039;, Array, Array) (Line: 510)
  61. Drupal\Core\Database\Query\Select-&gt;execute() (Line: 50)
  62. Drupal\sime_salidas\Controller\CuadroResumenController-&gt;mostrar()
  63. call_user_func_array(Array, Array) (Line: 123)
  64. Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber-&gt;Drupal\Core\EventSubscriber\{closure}() (Line: 582)
  65. Drupal\Core\Render\Renderer-&gt;executeInRenderContext(Object, Object) (Line: 124)
  66. Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber-&gt;wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
  67. Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber-&gt;Drupal\Core\EventSubscriber\{closure}() (Line: 151)
  68. Symfony\Component\HttpKernel\HttpKernel-&gt;handleRaw(Object, 1) (Line: 68)
  69. Symfony\Component\HttpKernel\HttpKernel-&gt;handle(Object, 1, 1) (Line: 57)
  70. Drupal\Core\StackMiddleware\Session-&gt;handle(Object, 1, 1) (Line: 47)
  71. Drupal\Core\StackMiddleware\KernelPreHandle-&gt;handle(Object, 1, 1) (Line: 99)
  72. Drupal\page_cache\StackMiddleware\PageCache-&gt;pass(Object, 1, 1) (Line: 78)
  73. Drupal\page_cache\StackMiddleware\PageCache-&gt;handle(Object, 1, 1) (Line: 47)
  74. Drupal\Core\StackMiddleware\ReverseProxyMiddleware-&gt;handle(Object, 1, 1) (Line: 52)
  75. Drupal\Core\StackMiddleware\NegotiationMiddleware-&gt;handle(Object, 1, 1) (Line: 23)
  76. Stack\StackedHttpKernel-&gt;handle(Object, 1, 1) (Line: 666)
  77. Drupal\Core\DrupalKernel-&gt;handle(Object) (Line: 19)
  78. </pre>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!