[TYPO3-core] RFC #12718: TCEforms exec_foreign_table_where_query fails with an Oracle error

[Oliver Hader]

Hi,

Am 24.11.09 10:27, schrieb Xavier Perseguers:
> Hi,
> 
> This is a SVN patch request.
> 
> Type: Bugfix
> 
> Bugtracker reference:
> http://bugs.typo3.org/view.php?id=12718
> 
> Branches: trunk
> 
> Problem:
> 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 (meaning you have to use
> DBAL of course :D), 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.
> Additional Information

+1 by reading

However, I'd like to have this tested without TemplaVoila. I think it
should be possible to reproduce with just a regular new page record and
a custom select field there that uses the ###REC_FIELD_...### statement.

olly
-- 
Oliver Hader
TYPO3 Release Manager 4.3