Feature #101653
closed
Auto-create DB fields from TCA columns for type "check"
Added by Oliver Wand 9 months ago. Updated 4 months ago.
100%
Files
| query_result.csv (1.46 KB) query_result.csv | Riccardo De Contardi, 2023-09-10 17:12 |
Updated by Oliver Wand 9 months ago
- Related to Feature #101553: Auto-create DB fields from TCA columns added
Updated by Gerrit Code Review 9 months 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/+/80513
Updated by Gerrit Code Review 9 months 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/+/80513
Updated by Anja Leichsenring 8 months ago
- Tracker changed from Feature to Task
- TYPO3 Version set to 13
Updated by Anja Leichsenring 8 months ago
- Tracker changed from Task to Feature
- TYPO3 Version deleted (
13)
Updated by Gerrit Code Review 8 months 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/+/80513
Updated by Gerrit Code Review 8 months 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/+/80513
Updated by Gerrit Code Review 8 months 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/+/80513
Updated by Gerrit Code Review 8 months 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/+/80513
Updated by Gerrit Code Review 8 months ago
Patch set 7 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/+/80513
Updated by Gerrit Code Review 8 months ago
Patch set 8 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/+/80513
Updated by Gerrit Code Review 8 months ago
Patch set 9 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/+/80513
Updated by Anja Leichsenring 8 months ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset f21d1b4e81ae1770515f48bd328e6a00eeb2a489.
Updated by Riccardo De Contardi 8 months ago
- File query_result.csv query_result.csv added
I report here what I found performing git reset --hard origin/main && git pull --rebase origin main on my latest main and I have seen in admin tools that some DB updates are required. But this one fails:
ALTER TABLE `tx_extensionmanager_domain_model_extension` CHANGE `review_state` `review_state` SMALLINT UNSIGNED DEFAULT 0 NOT NULL Current value: review_state INT DEFAULT 0 NOT NULL
error:
Database update failed Error: Out of range value for column 'review_state' at row 8
I looked at the DB and seen that on the table tx_extensionmanager_domain_model_extension a lot of lines (starting from 8 ) have review_state = -1.
So I run
select extension_key,review_state from tx_extensionmanager_domain_model_extension where review_state = -1 group by extension_key order by extension_key asc and found 85 extensions (see attached file)
I don't know if it is a problem of my installation which is old so it could have some dirt
Updated by Michael Schams 8 months ago
The database field review_state must not be UNSIGNED as negative values are valid. For example, -1 indicates the extension status insecure. The TYPO3 Security Team sets this status to mark extension versions with known security vulnerabilities.
Updated by Anja Leichsenring 8 months ago
- Related to Bug #101895: DB Field review_state of tx_extensionmanager_domain_model_extension has wrong format added
Updated by