medarob
commented
2 months ago This seems to be a TYPO3 restriction/bug and can be changed with the following code in ext_tables.sql.
The default value for the publisher field is 45 characters. This changes it to 100.
# Table structure for table 'sys_file_metadata'
#
# Allow publisher field with longer entries
CREATE TABLE sys_file_metadata (
publisher varchar(100) DEFAULT ''
);
Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 'INSERT INTO
sys_file_metadata(file,pid,crdate,tstamp,cruser_id,l10n_diffsource,width,height,content_creation_date,content_modification_date,creator_tool,pages,title,unit,publisher) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [27273, 0, 1714654440, 1714654440, 2, "", 339, 191, 1713787124, 1714654283, "macOS Version 14.4.1 (Build 23E224) Quartz PDFContext", "89", "Oracle", "mm", "macOS Version 14.4.1 (Build 23E224) Quartz PDFContext"]: Data too long for column 'publisher' at row 1 | Doctrine\DBAL\Exception\DriverException thrown in file /var/www/typo3/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 128. Requested URL: https://domain.tld/typo3/ajax/file/process?token=--AnonymizedToken--Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 'INSERT INTO
sys_file_metadata(file,pid,crdate,tstamp,cruser_id,l10n_diffsource,width,height,content_creation_date,content_modification_date,creator,creator_tool,unit,pages,publisher,title) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [27267, 0, 1714653959, 1714653959, 2, "", 339, 191, 1712672533, 1712672560, "PDF-XChange Office Addin", "PDF-XChange Standard (10.2.1 build 385) [GDI] [Windows 10 Enterprise x64 (Build 19044)]", "mm", "17", "PDF-XChange Standard (10.2.1 build 385) [GDI] [Windows 10 Enterprise x64 (Build 19044)]", "Pr\u00e4sentationstitel in max. zwei Zeilen"]: Data too long for column 'publisher' at row 1 | Doctrine\DBAL\Exception\DriverException thrown in file /var/www/typo3/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 128. Requested URL: https://domain.tld/typo3/ajax/file/process?token=--AnonymizedToken--It seems like that
macOS Version 14.4.1 (Build 23E224) Quartz PDFContextandPDF-XChange Standard (10.2.1 build 385) [GDI] [Windows 10 Enterprise x64 (Build 19044)]are too long for thepublisherfield?The resulting problem is, that the metadata fields in TYPO3 can't be edited for those files because they are not available:
Currently I'm not sure where I can change this. It would be better if the field could accept a longer value.