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

[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

Cheers

-- 
Xavier Perseguers
DBAL Leader

http://forge.typo3.org/projects/show/extension-dbal
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 12718.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091124/64bfc7a1/attachment.txt>