#94562Link field - insufficiently checked input leads to reference index error
Description
Description:
Editors try to enter a phone number without using the wizard next to the link field. This causes errors like the following when saving the content element and also during referenceindex:update.
An exception occurred while executing ‘INSERT INTO `sys_refindex` (`tablename`, `recuid`, `field`, `flexpointer`, `softref_key`, `softref_id`, `sorting`, `deleted`, `workspace`, `ref_table`, `ref_uid`, `ref_string`, `hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“sys_file_reference”, 273664,
“link”, “”, “typolink”, “091c6845bc9ae493200c100e8a92c110:0”, -1, 0, 0, “pages”, 1234567890, “”, “27a9027f6e7866acd34f158860fc865d”]:
Out of range value for column ‘ref_uid’ at row 1
This occures in TYPO3 10 and TYPO3 11.
To reproduce this problem
- Create a content element (with image field).
- In the file reference / image use the link field or use the content element link field and enter 012345678910.
- Optional: start the cli -> referenceindex:update
The number is interpreted as a content id / ref_uid.
Reviews 6
- 12.4 87111[BUGFIX] Verify softref ref_uid target in refindex
- 13.4 87110[BUGFIX] Verify softref ref_uid target in refindex
- main 87101[BUGFIX] Verify softref ref_uid target in refindex
- 13.4 87104[BUGFIX] Prevent BackendUtility::getRecord() postgresql out of range
- 12.4 87105[BUGFIX] Prevent BackendUtility::getRecord() postgresql out of range
- main 87103[BUGFIX] Prevent BackendUtility::getRecord() postgresql out of range