Bug #86612
closedImpossible to add/create new pages on PostgreSQL environment through some of the menus
0%
Description
Hi all,
I've been working with TYPO3 v8 and would like firstly to thank everyone for this awesome work.
I've been mainly focusing on Postgre installations (due to business needs in my company) and tried to migrate one installation from v8 to v9. The migration went without problems and everything is solid.
Problem occurs when user tries to create or add a new page in the Backend via right click menu in the page tree with the New page option (Page and List module) or through the List module under Page view.
Only way I managed to add new pages via drag&drop interface in the page tree.
Existing pages (added in the v8 installation) have been successfully migrated, but no new pages can be added in described way. Tried the fresh TYPO3 v9 installation and the same thing occurs.
The error displayed is:
An exception occurred while executing 'SELECT "s"."uid", "s"."pid", "s"."hidden", "s"."title", "s"."flag" FROM "sys_language" "s", "pages" "o" WHERE ("o"."sys_language_uid" = "s"."uid") AND ("o"."l10n_parent" = ?) AND (("o"."deleted" = 0) AND (("o"."t3ver_wsid" = 0) OR ("o"."t3ver_state" <= 0))) GROUP BY "s"."uid", "s"."pid", "s"."hidden", "s"."title", "s"."flag", "s"."sorting" ORDER BY "s"."sorting" ASC' with params ["NEW5bbd037e1f6e2950384548"]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "NEW5bbd037e1f6e2950384548"
The system used to run v8 and v9 is the same.
Server configurations are:
Apache/2.4.29
PHP/7.2
PostgreSQL/10.5
By the error dump, it seems to me as if temporary page uid is not converted to the real uid, the query looks like one that is created with the query beginning on the line 634 of
./typo3/sysext/recordlist/Classes/RecordList.php
but that is as far as I've gotten for now (given my still low knowledge of TYPO3 core files). And not really sure if I'm looking at the right direction as it seems it's only connected to the specific menus.
Files