[BUG] Doesn't work with PostgreSQL

[wazum]

Summary / Description

With a PostgreSQL database an error occurs when trying to paste a reference:

2: SQL error: "An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "false" CONTEXT: unnamed portal parameter $7 = '...'" (tt_content:NEW234134)

Version

Latest

Steps to reproduce

Install, copy content and try to insert a reference.

Possible bugfix

Ensure that the expected data types in execute_processCmdmap, etc., are indeed of the correct type.

[DavidBruchmann]

Thanks for reporting the issue.
I've one 2 questions:

• Do you use v3 (for TYPO3 12) or v4 (for TYPO3 13)?
• what is the key / fieldname that is provoking the error? As the value is "false" I had to take a different approach than just casting the datatype.

[wazum]

ehaerer/paste-reference (4.0.2) has been selected with TYPO3 CMS 13 automatically

[DavidBruchmann]

I've created a new branch v4-dev, it's early state and some things still have to be checked and fixed, primarily compatibility with EXT:container.
If you could test it and give feedback if your issue is solved with it, that would be great.

Note that I don't see why the extension is failing in your case, or if the issue is somehow a core-issue -- even if everything is working fine without the extension.
Nevertheless there is a chance that the issue is fixed perhaps not-knowingly, especially as I don't have tested an installation with PostgreSQL.

[DavidBruchmann]

@wazum perhaps you can explain, what you you did before getting the error.
Actually I've problems to trigger this part of the code (see below) at all, and I don't know how to reproduce it.

@Kephson perhaps you can give a hint here too.

There are three different ajax-calls whereas the first one includes a parameter array with the key NEW234134:
https://github.com/Kephson/paste_reference/blob/TYPO3_13/Resources/Public/JavaScript/paste-reference-drag-drop.js#L90-L146,
but all things I perform in the backend, call the 2nd Ajax-Query with the condition if (copyAction) { ... } only:
https://github.com/Kephson/paste_reference/blob/TYPO3_13/Resources/Public/JavaScript/paste-reference-drag-drop.js#L147-L181
The third Ajax-call is neither triggered:
https://github.com/Kephson/paste_reference/blob/TYPO3_13/Resources/Public/JavaScript/paste-reference-drag-drop.js#L182-L209

I tried it to trigger the different Ajax-Queries in the according code parts of v3 for TYPO3 v12 too, with the same result: all my manual actions in the backend trigger only the part copyAction.