Project

General

Profile

Actions
Copy link

Bug #21656

closed

TCEforms exec_foreign_table_where_query fails with an Oracle error

Added by Xavier Perseguers about 15 years ago. Updated about 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2009-11-24
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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

12718.diff (754 Bytes) 12718.diff Administrator Admin, 2009-11-24 10:25
Actions
Copy link

Also available in: Atom PDF