Details
-
Bug
-
Resolution: Fixed
-
High
-
4.6.0beta1
-
None
Description
When creating a new section, while running eZ Publish with a Postgres database, the debug returns the following
Warning: PHP: E_WARNING
pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
LINE 2: ...ezsection WHERE identifier='find_test' AND id != '' ORDER B...
^ in /var/www/ezp/.run/lib/ezdb/classes/ezpostgresqldb.php on line 197
Error: eZPostgreSQLDB
Error: error executing query: SELECT id, name, navigation_part_identifier, locale, identifier
FROM ezsection WHERE identifier='find_test' AND id != '' ORDER BY name ASC: ERROR: invalid input syntax for integer: ""
LINE 2: ...ezsection WHERE identifier='find_test' AND id != '' ORDER B...
^
this only happens if the first try fails.
Steps to reproduce
Setup - Add section 1. Log in as admin in admin interface 2. Click "Setup" in top menu 3. Click "Sections" in left menu 4. Click "New section" button Name : Find test 5. Click "OK" button 6. Verify it throws an error "Identifier can not be empty" 7. Type the following: Name: Find test Identifier: find_test 8. Press "ok" button