Project

General

Profile

Actions
Copy link

Feature #101653

closed

Auto-create DB fields from TCA columns for type "check"

Added by Oliver Wand over 1 year ago. Updated 10 months ago.

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

100%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Files

query_result.csv (1.46 KB) query_result.csv Riccardo De Contardi, 2023-09-10 17:12

Related issues 3 (1 open — 2 closed)

Related to TYPO3 Core - Feature #101553: Auto-create DB fields from TCA columnsIn Progress2023-10-13

Actions
Related to TYPO3 Core - Bug #101895: DB Field review_state of tx_extensionmanager_domain_model_extension has wrong formatClosedAnja Leichsenring2023-09-11

Actions
Related to TYPO3 Core - Bug #103915: YouTube oEmbed metadata is not saved when initially createdClosed2024-05-25

Actions
Actions
Copy link
 #1

Updated by Oliver Wand over 1 year ago

Actions
Copy link
 #2

Updated by Gerrit Code Review over 1 year 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

Actions
Copy link
 #3

Updated by Gerrit Code Review over 1 year 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

Actions
Copy link
 #4

Updated by Anja Leichsenring about 1 year ago

  • Tracker changed from Feature to Task
  • TYPO3 Version set to 13
Actions
Copy link
 #5

Updated by Anja Leichsenring about 1 year ago

  • Tracker changed from Task to Feature
  • TYPO3 Version deleted (13)
Actions
Copy link
 #6

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #7

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #8

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #9

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #10

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #11

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #12

Updated by Gerrit Code Review about 1 year 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

Actions
Copy link
 #13

Updated by Anja Leichsenring about 1 year ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #14

Updated by Riccardo De Contardi about 1 year ago

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

Actions
Copy link
 #15

Updated by Michael Schams about 1 year 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.

Actions
Copy link
 #16

Updated by Anja Leichsenring about 1 year ago

  • Related to Bug #101895: DB Field review_state of tx_extensionmanager_domain_model_extension has wrong format added
Actions
Copy link
 #17

Updated by Benni Mack 10 months ago

  • Status changed from Resolved to Closed
Actions
Copy link
 #18

Updated by Stefan Bürk 6 months ago

  • Related to Bug #103915: YouTube oEmbed metadata is not saved when initially created added
Actions
Copy link

Also available in: Atom PDF