Created
April 2, 2016 16:23
-
-
Save PoisonousJohn/02be797be3d664028cc86184d49930f1 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"error": { | |
"code": 500, | |
"message": "Internal Server Error", | |
"exception": [ | |
{ | |
"message": "An exception occurred while executing 'SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NULL THEN c1_.translation ELSE c2_.translation END) AS sclr_1, c0_.depth AS depth_2, c3_.id AS id_3, c4_.id AS id_4, (CASE WHEN c1_.locale IS NOT NULL THEN c1_.locale ELSE c2_.locale END) AS sclr_5, c0_.default_locale AS default_locale_6 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories AND (c1_.locale = 'en') LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories AND (c2_.locale = c0_.default_locale) LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.depth ASC' with params [2]:\n\nSQLSTATE[42803]: Grouping error: 7 ERROR: column \"c1_.translation\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NUL...\n ^", | |
"class": "Doctrine\\DBAL\\Exception\\DriverException", | |
"trace": [ | |
{ | |
"namespace": "", | |
"short_class": "", | |
"class": "", | |
"type": "", | |
"function": "", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php", | |
"line": 91, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL\\Driver", | |
"short_class": "AbstractPostgreSQLDriver", | |
"class": "Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver", | |
"type": "->", | |
"function": "convertException", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php", | |
"line": 116, | |
"args": [ | |
[ | |
"string", | |
"An exception occurred while executing 'SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NULL THEN c1_.translation ELSE c2_.translation END) AS sclr_1, c0_.depth AS depth_2, c3_.id AS id_3, c4_.id AS id_4, (CASE WHEN c1_.locale IS NOT NULL THEN c1_.locale ELSE c2_.locale END) AS sclr_5, c0_.default_locale AS default_locale_6 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories AND (c1_.locale = 'en') LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories AND (c2_.locale = c0_.default_locale) LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.depth ASC' with params [2]:\n\nSQLSTATE[42803]: Grouping error: 7 ERROR: column \"c1_.translation\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NUL...\n ^" | |
], | |
[ | |
"object", | |
"Doctrine\\DBAL\\Driver\\PDOException" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL", | |
"short_class": "DBALException", | |
"class": "Doctrine\\DBAL\\DBALException", | |
"type": "::", | |
"function": "driverExceptionDuringQuery", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php", | |
"line": 836, | |
"args": [ | |
[ | |
"object", | |
"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver" | |
], | |
[ | |
"object", | |
"Doctrine\\DBAL\\Driver\\PDOException" | |
], | |
[ | |
"string", | |
"SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NULL THEN c1_.translation ELSE c2_.translation END) AS sclr_1, c0_.depth AS depth_2, c3_.id AS id_3, c4_.id AS id_4, (CASE WHEN c1_.locale IS NOT NULL THEN c1_.locale ELSE c2_.locale END) AS sclr_5, c0_.default_locale AS default_locale_6 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories AND (c1_.locale = 'en') LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories AND (c2_.locale = c0_.default_locale) LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.depth ASC" | |
], | |
[ | |
"array", | |
{ | |
"1": [ | |
"string", | |
"2" | |
] | |
} | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL", | |
"short_class": "Connection", | |
"class": "Doctrine\\DBAL\\Connection", | |
"type": "->", | |
"function": "executeQuery", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php", | |
"line": 50, | |
"args": [ | |
[ | |
"string", | |
"SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NULL THEN c1_.translation ELSE c2_.translation END) AS sclr_1, c0_.depth AS depth_2, c3_.id AS id_3, c4_.id AS id_4, (CASE WHEN c1_.locale IS NOT NULL THEN c1_.locale ELSE c2_.locale END) AS sclr_5, c0_.default_locale AS default_locale_6 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories AND (c1_.locale = 'en') LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories AND (c2_.locale = c0_.default_locale) LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.depth ASC" | |
], | |
[ | |
"array", | |
[ | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"2" | |
] | |
] | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"101" | |
] | |
] | |
], | |
[ | |
"null", | |
null | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM\\Query\\Exec", | |
"short_class": "SingleSelectExecutor", | |
"class": "Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php", | |
"line": 321, | |
"args": [ | |
[ | |
"object", | |
"Doctrine\\DBAL\\Connection" | |
], | |
[ | |
"array", | |
[ | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"2" | |
] | |
] | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"101" | |
] | |
] | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "Query", | |
"class": "Doctrine\\ORM\\Query", | |
"type": "->", | |
"function": "_doExecute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 969, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "executeIgnoreQueryCache", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 924, | |
"args": [ | |
[ | |
"null", | |
null | |
], | |
[ | |
"string", | |
"2" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 739, | |
"args": [ | |
[ | |
"null", | |
null | |
], | |
[ | |
"string", | |
"2" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "getArrayResult", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Component/Rest/ListBuilder/Doctrine/DoctrineListBuilder.php", | |
"line": 147, | |
"args": [] | |
}, | |
{ | |
"namespace": "Sulu\\Component\\Rest\\ListBuilder\\Doctrine", | |
"short_class": "DoctrineListBuilder", | |
"class": "Sulu\\Component\\Rest\\ListBuilder\\Doctrine\\DoctrineListBuilder", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Bundle/CategoryBundle/Controller/CategoryController.php", | |
"line": 320, | |
"args": [] | |
}, | |
{ | |
"namespace": "Sulu\\Bundle\\CategoryBundle\\Controller", | |
"short_class": "CategoryController", | |
"class": "Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController", | |
"type": "->", | |
"function": "getCategoryListRepresentation", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Bundle/CategoryBundle/Controller/CategoryController.php", | |
"line": 156, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
}, | |
{ | |
"namespace": "Sulu\\Bundle\\CategoryBundle\\Controller", | |
"short_class": "CategoryController", | |
"class": "Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController", | |
"type": "->", | |
"function": "cgetAction", | |
"file": null, | |
"line": null, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
}, | |
{ | |
"namespace": "", | |
"short_class": "", | |
"class": "", | |
"type": "", | |
"function": "call_user_func_array", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3054, | |
"args": [ | |
[ | |
"array", | |
[ | |
[ | |
"object", | |
"Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController" | |
], | |
[ | |
"string", | |
"cgetAction" | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "HttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\HttpKernel", | |
"type": "->", | |
"function": "handleRaw", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3016, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "HttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\HttpKernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3165, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
], | |
[ | |
"boolean", | |
true | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel\\DependencyInjection", | |
"short_class": "ContainerAwareHttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\DependencyInjection\\ContainerAwareHttpKernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 2406, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
], | |
[ | |
"boolean", | |
true | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "Kernel", | |
"class": "Symfony\\Component\\HttpKernel\\Kernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/web/admin.php", | |
"line": 44, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
} | |
] | |
}, | |
{ | |
"message": "SQLSTATE[42803]: Grouping error: 7 ERROR: column \"c1_.translation\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NUL...\n ^", | |
"class": "Doctrine\\DBAL\\Driver\\PDOException", | |
"trace": [ | |
{ | |
"namespace": "", | |
"short_class": "", | |
"class": "", | |
"type": "", | |
"function": "", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php", | |
"line": 93, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL\\Driver", | |
"short_class": "PDOStatement", | |
"class": "Doctrine\\DBAL\\Driver\\PDOStatement", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php", | |
"line": 828, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL", | |
"short_class": "Connection", | |
"class": "Doctrine\\DBAL\\Connection", | |
"type": "->", | |
"function": "executeQuery", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php", | |
"line": 50, | |
"args": [ | |
[ | |
"string", | |
"SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NULL THEN c1_.translation ELSE c2_.translation END) AS sclr_1, c0_.depth AS depth_2, c3_.id AS id_3, c4_.id AS id_4, (CASE WHEN c1_.locale IS NOT NULL THEN c1_.locale ELSE c2_.locale END) AS sclr_5, c0_.default_locale AS default_locale_6 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories AND (c1_.locale = 'en') LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories AND (c2_.locale = c0_.default_locale) LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.depth ASC" | |
], | |
[ | |
"array", | |
[ | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"2" | |
] | |
] | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"101" | |
] | |
] | |
], | |
[ | |
"null", | |
null | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM\\Query\\Exec", | |
"short_class": "SingleSelectExecutor", | |
"class": "Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php", | |
"line": 321, | |
"args": [ | |
[ | |
"object", | |
"Doctrine\\DBAL\\Connection" | |
], | |
[ | |
"array", | |
[ | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"2" | |
] | |
] | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"101" | |
] | |
] | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "Query", | |
"class": "Doctrine\\ORM\\Query", | |
"type": "->", | |
"function": "_doExecute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 969, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "executeIgnoreQueryCache", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 924, | |
"args": [ | |
[ | |
"null", | |
null | |
], | |
[ | |
"string", | |
"2" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 739, | |
"args": [ | |
[ | |
"null", | |
null | |
], | |
[ | |
"string", | |
"2" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "getArrayResult", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Component/Rest/ListBuilder/Doctrine/DoctrineListBuilder.php", | |
"line": 147, | |
"args": [] | |
}, | |
{ | |
"namespace": "Sulu\\Component\\Rest\\ListBuilder\\Doctrine", | |
"short_class": "DoctrineListBuilder", | |
"class": "Sulu\\Component\\Rest\\ListBuilder\\Doctrine\\DoctrineListBuilder", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Bundle/CategoryBundle/Controller/CategoryController.php", | |
"line": 320, | |
"args": [] | |
}, | |
{ | |
"namespace": "Sulu\\Bundle\\CategoryBundle\\Controller", | |
"short_class": "CategoryController", | |
"class": "Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController", | |
"type": "->", | |
"function": "getCategoryListRepresentation", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Bundle/CategoryBundle/Controller/CategoryController.php", | |
"line": 156, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
}, | |
{ | |
"namespace": "Sulu\\Bundle\\CategoryBundle\\Controller", | |
"short_class": "CategoryController", | |
"class": "Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController", | |
"type": "->", | |
"function": "cgetAction", | |
"file": null, | |
"line": null, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
}, | |
{ | |
"namespace": "", | |
"short_class": "", | |
"class": "", | |
"type": "", | |
"function": "call_user_func_array", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3054, | |
"args": [ | |
[ | |
"array", | |
[ | |
[ | |
"object", | |
"Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController" | |
], | |
[ | |
"string", | |
"cgetAction" | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "HttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\HttpKernel", | |
"type": "->", | |
"function": "handleRaw", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3016, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "HttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\HttpKernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3165, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
], | |
[ | |
"boolean", | |
true | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel\\DependencyInjection", | |
"short_class": "ContainerAwareHttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\DependencyInjection\\ContainerAwareHttpKernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 2406, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
], | |
[ | |
"boolean", | |
true | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "Kernel", | |
"class": "Symfony\\Component\\HttpKernel\\Kernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/web/admin.php", | |
"line": 44, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
} | |
] | |
}, | |
{ | |
"message": "SQLSTATE[42803]: Grouping error: 7 ERROR: column \"c1_.translation\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NUL...\n ^", | |
"class": "PDOException", | |
"trace": [ | |
{ | |
"namespace": "", | |
"short_class": "", | |
"class": "", | |
"type": "", | |
"function": "", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php", | |
"line": 91, | |
"args": [] | |
}, | |
{ | |
"namespace": "", | |
"short_class": "PDOStatement", | |
"class": "PDOStatement", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php", | |
"line": 91, | |
"args": [ | |
[ | |
"null", | |
null | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL\\Driver", | |
"short_class": "PDOStatement", | |
"class": "Doctrine\\DBAL\\Driver\\PDOStatement", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php", | |
"line": 828, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\DBAL", | |
"short_class": "Connection", | |
"class": "Doctrine\\DBAL\\Connection", | |
"type": "->", | |
"function": "executeQuery", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php", | |
"line": 50, | |
"args": [ | |
[ | |
"string", | |
"SELECT c0_.id AS id_0, (CASE WHEN c1_.translation IS NOT NULL THEN c1_.translation ELSE c2_.translation END) AS sclr_1, c0_.depth AS depth_2, c3_.id AS id_3, c4_.id AS id_4, (CASE WHEN c1_.locale IS NOT NULL THEN c1_.locale ELSE c2_.locale END) AS sclr_5, c0_.default_locale AS default_locale_6 FROM ca_categories c0_ LEFT JOIN ca_category_translations c1_ ON c0_.id = c1_.idCategories AND (c1_.locale = 'en') LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories AND (c2_.locale = c0_.default_locale) LEFT JOIN ca_categories c3_ ON c0_.idCategoriesParent = c3_.id LEFT JOIN ca_categories c4_ ON c0_.id = c4_.idCategoriesParent WHERE c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.depth ASC" | |
], | |
[ | |
"array", | |
[ | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"2" | |
] | |
] | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"101" | |
] | |
] | |
], | |
[ | |
"null", | |
null | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM\\Query\\Exec", | |
"short_class": "SingleSelectExecutor", | |
"class": "Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php", | |
"line": 321, | |
"args": [ | |
[ | |
"object", | |
"Doctrine\\DBAL\\Connection" | |
], | |
[ | |
"array", | |
[ | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"2" | |
] | |
] | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"string", | |
"101" | |
] | |
] | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "Query", | |
"class": "Doctrine\\ORM\\Query", | |
"type": "->", | |
"function": "_doExecute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 969, | |
"args": [] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "executeIgnoreQueryCache", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 924, | |
"args": [ | |
[ | |
"null", | |
null | |
], | |
[ | |
"string", | |
"2" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php", | |
"line": 739, | |
"args": [ | |
[ | |
"null", | |
null | |
], | |
[ | |
"string", | |
"2" | |
] | |
] | |
}, | |
{ | |
"namespace": "Doctrine\\ORM", | |
"short_class": "AbstractQuery", | |
"class": "Doctrine\\ORM\\AbstractQuery", | |
"type": "->", | |
"function": "getArrayResult", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Component/Rest/ListBuilder/Doctrine/DoctrineListBuilder.php", | |
"line": 147, | |
"args": [] | |
}, | |
{ | |
"namespace": "Sulu\\Component\\Rest\\ListBuilder\\Doctrine", | |
"short_class": "DoctrineListBuilder", | |
"class": "Sulu\\Component\\Rest\\ListBuilder\\Doctrine\\DoctrineListBuilder", | |
"type": "->", | |
"function": "execute", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Bundle/CategoryBundle/Controller/CategoryController.php", | |
"line": 320, | |
"args": [] | |
}, | |
{ | |
"namespace": "Sulu\\Bundle\\CategoryBundle\\Controller", | |
"short_class": "CategoryController", | |
"class": "Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController", | |
"type": "->", | |
"function": "getCategoryListRepresentation", | |
"file": "/var/www/sulu.lo/vendor/sulu/sulu/src/Sulu/Bundle/CategoryBundle/Controller/CategoryController.php", | |
"line": 156, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
}, | |
{ | |
"namespace": "Sulu\\Bundle\\CategoryBundle\\Controller", | |
"short_class": "CategoryController", | |
"class": "Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController", | |
"type": "->", | |
"function": "cgetAction", | |
"file": null, | |
"line": null, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
}, | |
{ | |
"namespace": "", | |
"short_class": "", | |
"class": "", | |
"type": "", | |
"function": "call_user_func_array", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3054, | |
"args": [ | |
[ | |
"array", | |
[ | |
[ | |
"object", | |
"Sulu\\Bundle\\CategoryBundle\\Controller\\CategoryController" | |
], | |
[ | |
"string", | |
"cgetAction" | |
] | |
] | |
], | |
[ | |
"array", | |
[ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "HttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\HttpKernel", | |
"type": "->", | |
"function": "handleRaw", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3016, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "HttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\HttpKernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 3165, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
], | |
[ | |
"boolean", | |
true | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel\\DependencyInjection", | |
"short_class": "ContainerAwareHttpKernel", | |
"class": "Symfony\\Component\\HttpKernel\\DependencyInjection\\ContainerAwareHttpKernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/app/bootstrap.php.cache", | |
"line": 2406, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
], | |
[ | |
"string", | |
"1" | |
], | |
[ | |
"boolean", | |
true | |
] | |
] | |
}, | |
{ | |
"namespace": "Symfony\\Component\\HttpKernel", | |
"short_class": "Kernel", | |
"class": "Symfony\\Component\\HttpKernel\\Kernel", | |
"type": "->", | |
"function": "handle", | |
"file": "/var/www/sulu.lo/web/admin.php", | |
"line": 44, | |
"args": [ | |
[ | |
"object", | |
"Symfony\\Component\\HttpFoundation\\Request" | |
] | |
] | |
} | |
] | |
} | |
] | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment