Project

General

Profile

Actions

Bug #98103

closed

Unknown column 't3ver_wsid' in 'where clause' for records without versioningWS set

Added by David Hoeckele almost 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2022-08-09
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
11
PHP Version:
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

Since TYPO3 11.5.14 it's not possible to save records in backend anymore if the versioningWS option is not set in TCA (https://docs.typo3.org/m/typo3/reference-tca/main/en-us/Ctrl/Properties/VersioningWS.html)

Following error appears:
An exception occurred while executing 'SELECT `uid`, `l10n_state`, `sys_language_uid`, `l10n_parent` FROM `tx_table_name` WHERE (`uid` IN (?)) AND (`t3ver_wsid` = 0) AND (`tx_table_name`.`deleted` = 0)' with params [19]: Unknown column 't3ver_wsid' in 'where clause'

Seems to be corresponding to this bugfix: https://github.com/typo3/typo3/commit/dfc8e8156c


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #97989: Editing page 'media' field in workspace fatals in 'custom value' modeClosed2022-07-21

Actions
Related to TYPO3 Core - Bug #103097: Avoid calling LogDataTrait::formatLogDetails in non-static contextResolved2024-02-10

Actions
Actions #1

Updated by Chris Müller almost 2 years ago

Yes, I can confirm this. I have explicitly set versioningWS to false in TCA and getting this error when saving record in backend. Reinstalling 11.5.13 and the error is gone.

Actions #2

Updated by Chris Müller almost 2 years ago

  • Is Regression set to Yes
Actions #3

Updated by Gerrit Code Review almost 2 years ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75401

Actions #4

Updated by Gerrit Code Review almost 2 years ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75401

Actions #5

Updated by Benni Mack almost 2 years ago

  • Related to Bug #97989: Editing page 'media' field in workspace fatals in 'custom value' mode added
Actions #6

Updated by Gerrit Code Review almost 2 years ago

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75401

Actions #7

Updated by Gerrit Code Review almost 2 years ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75401

Actions #8

Updated by Gerrit Code Review almost 2 years ago

Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75401

Actions #9

Updated by Gerrit Code Review almost 2 years ago

Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75401

Actions #10

Updated by Gerrit Code Review almost 2 years ago

Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/75418

Actions #11

Updated by Stefan Bürk almost 2 years ago

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

Updated by Benni Mack over 1 year ago

  • Status changed from Resolved to Closed
Actions #13

Updated by Oliver Hader 3 months ago

  • Related to Bug #103097: Avoid calling LogDataTrait::formatLogDetails in non-static context added
Actions

Also available in: Atom PDF