Details
Medium Description
Taxonomy tree fails to load when PostgreSQL is used
Steps to reproduce:
1. Set up the project using PostgreSQL
2. Login as admin
3. Go to Tags
Expected:
Taxonomy tree is loaded
Actual:
Tree is not loaded, Internal Server Error notification is displayed
The following is visible in the logs:
[2022-02-07T11:15:45.588909+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.names AS names_4, t0.mainLanguageCode AS mainlanguagecode_5, t0.content_id AS content_id_6, t0."left" AS left_7, t0."right" AS right_8, t0.root AS root_9, t0.lvl AS lvl_10, t0.taxonomy AS taxonomy_11, t0.parent_id AS parent_id_12 FROM ibexa_taxonomy_entries t0 WHERE t0.id IN (?, ?)' with params ["", "1"]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: """ at /Users/mareknocon/Desktop/Sites/v3_2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php line 102 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.names AS names_4, t0.mainLanguageCode AS mainlanguagecode_5, t0.content_id AS content_id_6, t0.\"left\" AS left_7, t0.\"right\" AS right_8, t0.root AS root_9, t0.lvl AS lvl_10, t0.taxonomy AS taxonomy_11, t0.parent_id AS parent_id_12 FROM ibexa_taxonomy_entries t0 WHERE t0.id IN (?, ?)' with params [\"\", \"1\"]:\n\nSQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: \"\" at /Users/mareknocon/Desktop/Sites/v3_2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:102)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: \"\" at /Users/mareknocon/Desktop/Sites/v3_2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)\n[previous exception] [object] (PDOException(code: 22P02): SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: \"\" at /Users/mareknocon/Desktop/Sites/v3_2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} []