search

georgringer / news

TYPO3 Extension news
GNU General Public License v2.0
264 stars 357 forks source link

Bug when changing the database field “import_id” in the “sys_category” table #2529

Open morange opened 3 days ago

morange commented 3 days ago

Bug Report

Current Behavior When updating from TYPO3 v11.5.39 to v12.4.20 with the Extension News version 11.4.2, the following error message is displayed in the “Analyze Database Structure”:


Current value: import_id VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATEutf8mb4_general_ci```

**Expected behavior/output**
In the Database Analyzer, I expected the database to be adjusted as described there.

**Environment**
- TYPO3 version(s): 14.4.20
- news version: 11.4.2
- Is your TYPO3 installation set up with Composer (Composer Mode): Composer Mode
- OS: macOS 14.7
-  ddev1.23.4

**Possible Solution**
Executed via phpMyAdmin:
```UPDATE sys_category SET import_id="" WHERE ISNULL(import_id);```
DavidBruchmann commented 1 day ago

TYPO3 version(s): 14.4.20

Welcome in the future? Also the change you got shown in the Database Analyzer is not clearly mentioned, the leading line you saw seems being cut in your report.