Project

General

Profile

Actions

Bug #68643

closed

Non-existing fields _ORIG_pid and _ORIG_uid in SQL statement

Added by Albrecht Köhnlein over 9 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Workspaces
Target version:
-
Start date:
2015-07-30
Due date:
% Done:

100%

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

Description

I have an extension where I added IRRE elements to tt_content and inside this IRRE elements, I have FAL relations.

tt_content
- IRRE: topics
-- FAL relations

When I change the topic records inside a workspace, I don't see the FAL relations anymore. But there is an SQL error:

SELECT uid, pid, content, title, description, file, preview, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, t3ver_oid, t3ver_id, t3ver_wsid, t3ver_label, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, sorting, sys_language_uid, l10n_parent, l10n_diffsource, accessory, limit_to_region, limit_to_region_mode, _ORIG_pid, _ORIG_uid FROM tx_myextension_domain_model_topic WHERE pid=-1 AND t3ver_oid=502 AND t3ver_wsid=24 AND tx_myextension_domain_model_topic.deleted=0 LIMIT 1

As you can see there are the fields _ORIG_pid and _ORIG_uid added to the statement, but they don't exist in database.

The problem is, in function PageRepository::versionOL(), the field list is built including this two non-existing fields. When I change the implode() stuff into wildcard '*', everything works fine.


Files


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #66135: Computed properties are queried in workspace contextClosed2015-03-30

Actions
Actions #1

Updated by Gerrit Code Review over 9 years ago

  • Status changed from New to Under Review

Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42158

Actions #2

Updated by Gerrit Code Review over 9 years ago

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42160

Actions #3

Updated by Albrecht Köhnlein over 9 years ago

Here is an example extension for demonstration.

  1. install it
  2. create new content element "Special/Download"
  3. add some IRRE items with files and previews
  4. switch to another workspace
  5. change files and previews

In the frontend the files and images are included in two ways:

  • directly with {variable}
  • with <c:Object> view helper
Actions #4

Updated by Gerrit Code Review over 9 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42160

Actions #5

Updated by Gerrit Code Review over 9 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42160

Actions #6

Updated by Gerrit Code Review over 9 years ago

Patch set 4 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/42158

Actions #7

Updated by Albrecht Köhnlein over 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #8

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF