.. include:: /Includes.rst.txt

==========================
TYPO3 Exception 1438183881
==========================

.. include:: /If-you-encounter-this-exception.rst.txt

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 :file:`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 :file:`ext_tables.sql`:

.. code-block:: 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.