TYPO3 Core

exec_INSERTquery
array(4 items)
   caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars)
   ERROR => "Field 'keywords' doesn't have a default value" (45 chars)
   lastBuiltQuery => "INSERT INTO sys_file_metadata (file,pid,crdate,tstamp,cruser_id,l10n_diffsou
      rce) VALUES ('84','0','1465386489','1465386489','2','')" (131 chars)
   debug_backtrace => "{closure}#21 // TYPO3\CMS\Backend\Http\Application->run#20 // TYPO3\CMS\Core
      \Core\Bootstrap->handleRequest#94 // TYPO3\CMS\Backend\Http\BackendModuleReq
      uestHandler->handleRequest#302 // TYPO3\CMS\Backend\Http\BackendModuleReques
      tHandler->dispatchModule#92 // TYPO3\CMS\Extbase\Core\Bootstrap->run#214 // 
      TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#193 // TYPO3\CMS\Extbase\Mvc
      \Web\BackendRequestHandler->handleRequest#206 // TYPO3\CMS\Extbase\Mvc\Dispa
      tcher->dispatch#32 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->pro
      cessRequest#86 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callAct
      ionMethod#176 // call_user_func_array#283 // TYPO3\CMS\Filelist\Controller\F
      ileListController->indexAction# // TYPO3\CMS\Filelist\FileList->generateList
      #398 // TYPO3\CMS\Filelist\FileList->getTable#236 // TYPO3\CMS\Filelist\File
      List->formatFileList#420 // TYPO3\CMS\Filelist\FileList->linkWrapFile#803 //
       TYPO3\CMS\Core\Resource\File->_getMetaData#659 // TYPO3\CMS\Core\Resource\F
      ile->loadMetaData#123 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->f
      indByFile#187 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->findByFil
      eUid#62 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->createMetaDataR
      ecord#103 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#13
      9 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#223" (1350 chars)

exec_INSERTquery
array(4 items)
   caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars)
   ERROR => "Field 'keywords' doesn't have a default value" (45 chars)
   lastBuiltQuery => "INSERT INTO sys_file_metadata (file,pid,crdate,tstamp,cruser_id,l10n_diffsou
      rce) VALUES ('84','0','1465386489','1465386489','2','')" (131 chars)
   debug_backtrace => "{closure}#21 // TYPO3\CMS\Backend\Http\Application->run#20 // TYPO3\CMS\Core
      \Core\Bootstrap->handleRequest#94 // TYPO3\CMS\Backend\Http\BackendModuleReq
      uestHandler->handleRequest#302 // TYPO3\CMS\Backend\Http\BackendModuleReques
      tHandler->dispatchModule#92 // TYPO3\CMS\Extbase\Core\Bootstrap->run#214 // 
      TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#193 // TYPO3\CMS\Extbase\Mvc
      \Web\BackendRequestHandler->handleRequest#206 // TYPO3\CMS\Extbase\Mvc\Dispa
      tcher->dispatch#32 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->pro
      cessRequest#86 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callAct
      ionMethod#176 // call_user_func_array#283 // TYPO3\CMS\Filelist\Controller\F
      ileListController->indexAction# // TYPO3\CMS\Filelist\FileList->generateList
      #398 // TYPO3\CMS\Filelist\FileList->getTable#236 // TYPO3\CMS\Filelist\File
      List->formatFileList#420 // TYPO3\CMS\Filelist\FileList->linkWrapFile#803 //
       TYPO3\CMS\Core\Resource\File->_getMetaData#659 // TYPO3\CMS\Core\Resource\F
      ile->loadMetaData#123 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->f
      indByFile#187 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->update#79
       // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->findByFileUid#166 // T
      YPO3\CMS\Core\Resource\Index\MetaDataRepository->createMetaDataRecord#103 //
       TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#139 // TYPO3\C
      MS\Core\Database\DatabaseConnection->debug#223" (1414 chars)

exec_INSERTquery
array(4 items)
   caller => "TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery" (60 chars)
   ERROR => "Field 'keywords' doesn't have a default value" (45 chars)
   lastBuiltQuery => "INSERT INTO sys_file_metadata (file,pid,crdate,tstamp,cruser_id,l10n_diffsou
      rce) VALUES ('84','0','1465386489','1465386489','2','')" (131 chars)
   debug_backtrace => "{closure}#21 // TYPO3\CMS\Backend\Http\Application->run#20 // TYPO3\CMS\Core
      \Core\Bootstrap->handleRequest#94 // TYPO3\CMS\Backend\Http\BackendModuleReq
      uestHandler->handleRequest#302 // TYPO3\CMS\Backend\Http\BackendModuleReques
      tHandler->dispatchModule#92 // TYPO3\CMS\Extbase\Core\Bootstrap->run#214 // 
      TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#193 // TYPO3\CMS\Extbase\Mvc
      \Web\BackendRequestHandler->handleRequest#206 // TYPO3\CMS\Extbase\Mvc\Dispa
      tcher->dispatch#32 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->pro
      cessRequest#86 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callAct
      ionMethod#176 // call_user_func_array#283 // TYPO3\CMS\Filelist\Controller\F
      ileListController->indexAction# // TYPO3\CMS\Filelist\FileList->generateList
      #398 // TYPO3\CMS\Filelist\FileList->getTable#236 // TYPO3\CMS\Filelist\File
      List->formatFileList#420 // TYPO3\CMS\Filelist\FileList->linkWrapFile#803 //
       TYPO3\CMS\Core\Resource\File->_getMetaData#659 // TYPO3\CMS\Core\Resource\F
      ile->loadMetaData#123 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->f
      indByFile#187 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->findByFil
      eUid#81 // TYPO3\CMS\Core\Resource\Index\MetaDataRepository->createMetaDataR
      ecord#103 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#13
      9 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#223" (1350 chars)

Uncaught TYPO3 Exception
#1437656456: $uid must be positive integer, 0 given (More information)

InvalidArgumentException thrown in file
/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Form/FormDataProvider/AbstractDatabaseRecordProvider.php in line 39.

14 TYPO3\CMS\Backend\Form\FormDataProvider\AbstractDatabaseRecordProvider::getRecordFromDatabase("sys_file_metadata", 0)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Form/FormDataProvider/DatabaseEditRow.php:
00036:         }
00037: 
00038:         $databaseRow = $this->getRecordFromDatabase($result['tableName'], $result['vanillaUid']);
00039:         if (!array_key_exists('pid', $databaseRow)) {
00040:             throw new \UnexpectedValueException(

13 TYPO3\CMS\Backend\Form\FormDataProvider\DatabaseEditRow::addData(array)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Form/FormDataGroup/TcaDatabaseRecord.php:
00049:             }
00050: 
00051:             $result = $provider->addData($result);
00052:         }
00053: 

12 TYPO3\CMS\Backend\Form\FormDataGroup\TcaDatabaseRecord::compile(array)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Form/FormDataCompiler.php:
00097:         $resultKeysBeforeFormDataGroup = array_keys($result);
00098: 
00099:         $result = $this->formDataGroup->compile($result);
00100: 
00101:         if (!is_array($result)) {

11 TYPO3\CMS\Backend\Form\FormDataCompiler::compile(array)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:
01107:                                 }
01108: 
01109:                                 $formData = $formDataCompiler->compile($formDataCompilerInput);
01110: 
01111:                                 // Set this->viewId if possible

10 TYPO3\CMS\Backend\Controller\EditDocumentController::makeEditForm()

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:
00998:             }
00999:             // Creating the editing form, wrap it with buttons, document selector etc.
01000:             $editForm = $this->makeEditForm();
01001:             if ($editForm) {
01002:                 $this->firstEl = reset($this->elementsData);

9 TYPO3\CMS\Backend\Controller\EditDocumentController::main()

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:
02016: 
02017:         $this->init();
02018:         $this->main();
02019: 
02020:         $response->getBody()->write($this->moduleTemplate->renderContent());

8 TYPO3\CMS\Backend\Controller\EditDocumentController::mainAction(TYPO3\CMS\Core\Http\ServerRequest, TYPO3\CMS\Core\Http\Response)
7 call_user_func_array(array, array)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Http/RouteDispatcher.php:
00052:         $targetIdentifier = $route->getOption('target');
00053:         $target = $this->getCallableFromTarget($targetIdentifier);
00054:         return call_user_func_array($target, array($request, $response));
00055:     }
00056: 

6 TYPO3\CMS\Backend\Http\RouteDispatcher::dispatch(TYPO3\CMS\Core\Http\ServerRequest, TYPO3\CMS\Core\Http\Response)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Http/RequestHandler.php:
00159:         /** @var RouteDispatcher $dispatcher */
00160:         $dispatcher = GeneralUtility::makeInstance(RouteDispatcher::class);
00161:         return $dispatcher->dispatch($request, $response);
00162:     }
00163: }

5 TYPO3\CMS\Backend\Http\RequestHandler::dispatch(TYPO3\CMS\Core\Http\ServerRequest)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Http/RequestHandler.php:
00092:         // Check if the router has the available route and dispatch.
00093:         if ($routingEnabled) {
00094:             return $this->dispatch($request);
00095:         }
00096: 

4 TYPO3\CMS\Backend\Http\RequestHandler::handleRequest(TYPO3\CMS\Core\Http\ServerRequest)

/var/www/typo3_src-7.6.9/typo3/sysext/core/Classes/Core/Bootstrap.php:
00300: 
00301:         // Execute the command which returns a Response object or NULL
00302:         $this->response = $requestHandler->handleRequest($request);
00303:         return $this;
00304:     }

3 TYPO3\CMS\Core\Core\Bootstrap::handleRequest(TYPO3\CMS\Core\Http\ServerRequest)

/var/www/typo3_src-7.6.9/typo3/sysext/backend/Classes/Http/Application.php:
00092:         }
00093: 
00094:         $this->bootstrap->handleRequest($this->request);
00095: 
00096:         if ($execute !== null) {

2 TYPO3\CMS\Backend\Http\Application::run()

/var/www/typo3_src-7.6.9/typo3/index.php:
00018: call_user_func(function () {
00019:     $classLoader = require __DIR__ . '/../vendor/autoload.php';
00020:     (new \TYPO3\CMS\Backend\Http\Application($classLoader))->run();
00021: });

1 {closure}()

/var/www/typo3_src-7.6.9/typo3/index.php:
00019:     $classLoader = require __DIR__ . '/../vendor/autoload.php';
00020:     (new \TYPO3\CMS\Backend\Http\Application($classLoader))->run();
00021: });

What System do you have? Windows / Linux / Mac? and version?
Have you tried the new TYPO3 7.6.9?
What is your PHP Version in Detail? 7.?
What is your MySQL Version?
Does it work without filemetadata extension?

System is Ubuntu 16.04 with all latest update.
Typo3 was already at 7.6.9.
PHP version is 7.0.4-7ubuntu2.1

# mysql --version
mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using  EditLine wrapper

It does not work with/without filemetadata extension.

I can reproduce it. I have nearly the same system.
But it works, if i remove filemetadata and delete all the tables in the installtool (rename and delete)
So i think it is a bug in filemetadata.

You are right, when I disable filemetadata, remove all tables and clear all caches it works. Looks really like a bug in filemetadata.

For the sake of completeness: If I enable it again the error occurs again.

Same Problem here.

Using a local extension to manipulate filemetadata sql definition can be used as a dirty fix.

CREATE TABLE sys_file_metadata (
  keywords text,
  note text
);

Notice the removal of "...NOT NULL".

Running TYPO3 7.6.9 on Ubuntu 16.04.

mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using  EditLine wrapper
PHP Version 7.0.4-7ubuntu2.1

+1 Typo2 7.6.9

Steps to reproduce by me:
1. create content with file + metadata, default language
2. translate this content in other language
3. edit translated content - edit translated file metadata - make exception 1437656456

Typo3 v7.6.10 still the same behaviour.

The problem here is that you translate the content element and not the sys_file_metadata which is connected to a sys_file.
The content element has a reference with a sys_file_reference.

The question is, do we need to create a translated sys_file_metadata when translating a content element.

The exception is thrown because there is no record to edit....

This (Field 'keywords' doesn't have a default value) is also happening when adding a image via TypoScript like this:

lib.footerLogo = IMAGE
    lib.footerLogo {
        file = EXT:provider_extension/Resources/Public/Images/logo.png
        stdWrap {
            typolink {
                parameter = 1
            }
        }
    }

Even if sysext filemetadata is disabled.

hmm I just updated to Typo3 7.6.11, and it currently works, can the others confirm this?

7.6.11 still has this bug

Wouter Wolters wrote:

The problem here is that you translate the content element and not the sys_file_metadata which is connected to a sys_file.
The content element has a reference with a sys_file_reference.

The question is, do we need to create a translated sys_file_metadata when translating a content element.

The exception is thrown because there is no record to edit....

If you edit the metadata of the file in the default language and then select the new language from the dropdown, than it works.

But this way is confusing for all editors.
I would expect if you (try to) edit the metadata of a file that is referenced to a translation of a record, it should create the translation of the metadata behind the secene.

Hello

we experienced the same problem as described on a TYPO3 CMS version 8.7.1.
Could you please fix that on the actual branch of 8.7 or shall i open a new ticket for the 8.7 branch?

Thanks.

Regards,
Angelo

Angelo Previtali wrote:

Hello

we experienced the same problem as described on a TYPO3 CMS version 8.7.1.
Could you please fix that on the actual branch of 8.7 or shall i open a new ticket for the 8.7 branch?

Thanks.

Regards,
Angelo

Hello,
I have the same problem on TYPO3 v8.7.4. But this work when using FLUX inline.fal field. It doesn't work when I use it in my extension.
Best,
Zoran

Can confirm this bug for TYPO3 8.7.4 and I'm pretty sure it has nothing to do with EXT:filemetadata. I removed the extension and its fields from DB but nothing changes. My investigation match with what Walter describes in https://forge.typo3.org/issues/76262#note-12

The error is not triggered by translating content or editing the file reference of the translated content but by clicking the edit button on the file reference of the translated content.

Here's the full stack trace for the error:

#1437656456: $uid must be positive integer, 0 given (More information)

InvalidArgumentException thrown in file
/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/AbstractDatabaseRecordProvider.php in line 42.

16 TYPO3\CMS\Backend\Form\FormDataProvider\AbstractDatabaseRecordProvider::getRecordFromDatabase("sys_file_metadata", 0)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/DatabaseEditRow.php:
00036:         }
00037: 
00038:         $databaseRow = $this->getRecordFromDatabase($result['tableName'], $result['vanillaUid']);
00039:         if (!array_key_exists('pid', $databaseRow)) {
00040:             throw new \UnexpectedValueException(

15 TYPO3\CMS\Backend\Form\FormDataProvider\DatabaseEditRow::addData(array)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataGroup/OrderedProviderList.php:
00057:             }
00058: 
00059:             $result = $provider->addData($result);
00060:         }
00061: 

14 TYPO3\CMS\Backend\Form\FormDataGroup\OrderedProviderList::compile(array)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataGroup/TcaDatabaseRecord.php:
00037:         );
00038: 
00039:         return $orderedProviderList->compile($result);
00040:     }
00041: }

13 TYPO3\CMS\Backend\Form\FormDataGroup\TcaDatabaseRecord::compile(array)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataCompiler.php:
00097:         $resultKeysBeforeFormDataGroup = array_keys($result);
00098: 
00099:         $result = $this->formDataGroup->compile($result);
00100: 
00101:         if (!is_array($result)) {

12 TYPO3\CMS\Backend\Form\FormDataCompiler::compile(array)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:
01042:                                 }
01043: 
01044:                                 $formData = $formDataCompiler->compile($formDataCompilerInput);
01045: 
01046:                                 // Set this->viewId if possible

11 TYPO3\CMS\Backend\Controller\EditDocumentController::makeEditForm()

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:
00945: 
00946:             // Creating the editing form, wrap it with buttons, document selector etc.
00947:             $editForm = $this->makeEditForm();
00948:             if ($editForm) {
00949:                 $this->firstEl = reset($this->elementsData);

10 TYPO3\CMS\Backend\Controller\EditDocumentController::main()

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:
01970: 
01971:         $this->init();
01972:         $this->main();
01973: 
01974:         $response->getBody()->write($this->moduleTemplate->renderContent());

9 TYPO3\CMS\Backend\Controller\EditDocumentController::mainAction(TYPO3\CMS\Core\Http\ServerRequest, TYPO3\CMS\Core\Http\Response)
8 call_user_func_array(array, array)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/RouteDispatcher.php:
00052:         $targetIdentifier = $route->getOption('target');
00053:         $target = $this->getCallableFromTarget($targetIdentifier);
00054:         return call_user_func_array($target, [$request, $response]);
00055:     }
00056: 

7 TYPO3\CMS\Backend\Http\RouteDispatcher::dispatch(TYPO3\CMS\Core\Http\ServerRequest, TYPO3\CMS\Core\Http\Response)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/RequestHandler.php:
00137:         /** @var RouteDispatcher $dispatcher */
00138:         $dispatcher = GeneralUtility::makeInstance(RouteDispatcher::class);
00139:         return $dispatcher->dispatch($request, $response);
00140:     }
00141: }

6 TYPO3\CMS\Backend\Http\RequestHandler::dispatch(TYPO3\CMS\Core\Http\ServerRequest)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/RequestHandler.php:
00070:         // Check if the router has the available route and dispatch.
00071:         try {
00072:             return $this->dispatch($request);
00073:         } catch (InvalidRequestTokenException $e) {
00074:             // When token was invalid redirect to login

5 TYPO3\CMS\Backend\Http\RequestHandler::handleRequest(TYPO3\CMS\Core\Http\ServerRequest)

/var/www/vendor/typo3/cms/typo3/sysext/core/Classes/Core/Bootstrap.php:
00313: 
00314:         // Execute the command which returns a Response object or NULL
00315:         $this->response = $requestHandler->handleRequest($request);
00316:         return $this;
00317:     }

4 TYPO3\CMS\Core\Core\Bootstrap::handleRequest(TYPO3\CMS\Core\Http\ServerRequest)

/var/www/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/Application.php:
00090:         }
00091: 
00092:         $this->bootstrap->handleRequest($this->request);
00093: 
00094:         if ($execute !== null) {

3 TYPO3\CMS\Backend\Http\Application::run()

/var/www/vendor/typo3/cms/typo3/sysext/backend/Resources/Private/Php/backend.php:
00022:     $classLoader = require __DIR__ . '/../../../../../../vendor/autoload.php';
00023: 
00024:     (new \TYPO3\CMS\Backend\Http\Application($classLoader))->run();
00025: });

2 {closure}()

/var/www/vendor/typo3/cms/typo3/sysext/backend/Resources/Private/Php/backend.php:
00023: 
00024:     (new \TYPO3\CMS\Backend\Http\Application($classLoader))->run();
00025: });

1 require("/var/www/vendor/typo3/cms/typo3/sysext/backend/Resources/Private/Php/backend.php")

/var/www/vendor/typo3/cms/typo3/index.php:
00001: <?php
00002: 
00003: require __DIR__ . '/sysext/backend/Resources/Private/Php/backend.php';

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/54778

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/54822

Hmm how come this is marked as resolved when it's still not fixed for TYPO3 7.6? See patch at https://review.typo3.org/#/c/56568/