TYPO3 Exception 1438183881

Note

Below, the TYPO3 community may have provided additional information or solutions for this exception. However, these may or may not apply to your particular case. If you can provide more information, you should come back here and add your experience and solution steps to this issue once you have resolved it.

General TYPO3 troubleshooting tips can be found in the section “Troubleshooting” of the menu, and live support is available in the TYPO3 Slack channel #typo3-cms.

To add your experience, click “Edit on GitHub” above and follow the “Edit on GitHub” workflow. Also check out our tip on Coding Style and reST.

TCA table “…” ctrl['type'] is set to “…”, but this field does not exist in the database of this table

This error happens for example in an extension because the TCA configuration was not suitable for the MySQL table fields defined in ext_tables.sql.

Error Example - TCA:

$TCA['tx_myExtension_table'] = [
  'ctrl' => [
     'title'     => $ll.'table.auteur',
     'label'     => 'nom',
     'tstamp'    => 'tstamp',
     'crdate'    => 'crdate',
     'cruser_id' => 'cruser_id',
     'type'      => 'type',
     ...
     ...

And in ext_tables.sql:

CREATE TABLE tx_myExtension_table (
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
  sys_language_uid int(11) DEFAULT '0' NOT NULL,
  ...
  ...

Missing:

type varchar(100) NOT NULL DEFAULT '0',

or any other type field definition.