Bug #98103
closed
Unknown column 't3ver_wsid' in 'where clause' for records without versioningWS set
100%
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
Updated by Chris Müller about 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.
Updated by Gerrit Code Review about 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
Updated by Gerrit Code Review about 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
Updated by Benni Mack about 2 years ago
- Related to Bug #97989: Editing page 'media' field in workspace fatals in 'custom value' mode added
Updated by Gerrit Code Review about 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
Updated by Gerrit Code Review about 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
Updated by Gerrit Code Review about 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
Updated by Gerrit Code Review about 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
Updated by Gerrit Code Review about 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
Updated by Stefan Bürk about 2 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 3bb31395e71070403e5512aa23e9a374a656f59e.
Updated by Benni Mack almost 2 years ago
- Status changed from Resolved to Closed
Updated by Oliver Hader 7 months ago
- Related to Bug #103097: Avoid calling LogDataTrait::formatLogDetails in non-static context added