Bug #24679
closed
be_layout foreign_table_where
Added by Steffen Gebert almost 14 years ago.
Updated over 12 years ago.
Description
If a General Record Storage Page (GRSP) is configured, which is very likely the case, when you use tt_news, then TYPO3 searches for be_layout records only on the GRSP page and the PAGE_TSCONFIG_ID.
If no GRSP is configured, it uses records from everywhere.
I suggest do always include records from the page, which properties are currently edited, to make the feature a bit more fool-proof.
'foreign_table_where' => 'AND ( ( ###PAGE_TSCONFIG_ID### = 0 AND ###STORAGE_PID### = 0 ) OR ( be_layouts.pid = ###PAGE_TSCONFIG_ID### OR be_layouts.pid = ###STORAGE_PID### ) ) AND be_layouts.hidden = 0',
'
(issue imported from #M17161)
Files
Actually this should have been the case anyway, so if it's not yet done, I guess I will have to fix it.
BTW: Currently it's not possible to create layout records with pid = 0 which is a bug we should fix as well - so IMHO this could be done in one go.
Any concerns?
Attached patch will add both, rootLevel and CURRENT_PID
V2 will take PAGE_TSCONFIG_ID into account as well.
It will only give the user access to records of the current page, when there is no PAGE_TSCONFIG_ID restricting the access to another page.
Just have to wait for Ingo renaming the table and fields from be_layout to backend_layout #24117
V3 did not apply to current trunk for some reason
Attached is V4
rootLevel has to be -1 instead of 1 and CURRENT_PID actually should have been THIS_UID.
Attached patch fixes these bugs.
It seems there is a bug in the concept of the rootLevel settings:
Notice: that the -1 value will still select foreign_table records for selectox boxes only from root (pid=0)
So it just doesn't work, which is why we have to remove it for now
Attached V6 just changes the foreign_table_where
- Target version deleted (
4.5.0)
I have the same issue with Typo3 4.5.x.
A customer have a page where he wants to add a General Record Storage Page.
When he do this he can't change the backend_layout anymore and it will be displayed that an invalid value is selected.
Also available in: Atom
PDF