Bug #21656
closed
TCEforms exec_foreign_table_where_query fails with an Oracle error
0%
Description
When using TemplaVoilà and clicking on "Create new Template Object" on Page templates, this opens a TCEforms which should contain a list of existing TO to be used as parent.
The TCA query fails with
ORA-01722: invalid number This may indicate a table defined in tables.php is not existing in the database!
First part of the error message is from Oracle, the "This may indicate"... comes from t3lib_BEfunc.
Reason is that marker ###REC_FIELD_UID### is replaced, at this point by something like 'NEW4b0b5634a1789' while Oracle expects a number for a UID field (as with any UID fields in TYPO3 tables).
Solution: Test whether REC_FIELD_UID contains a number and if not put "0" instead, this will lead to same result.
(issue imported from #M12718)
Files
Updated by Alexander Opitz over 11 years ago
- Status changed from New to Needs Feedback
- Target version deleted (
0)
The issue is very old, does this issue exists in newer versions of TYPO3 CMS (4.5 or 6.1)?
Updated by Alexander Opitz about 11 years ago
- Status changed from Needs Feedback to Closed
- Is Regression set to No
No feedback for over 90 days.