[TYPO3-mvc] 2: SQL error: '' () Error on creating new data

Johannes C. Schulz - EnzephaloN IT-Solutions info at enzephalon.de
Fri Jun 24 17:54:54 CEST 2011


Hello together

 

I started with a new extension. All works fine, but one of the models throws
an error while creating in backend:

 

It has only 3 properties

 

'name' => array(

      'exclude'   => 0,

      'label'           =>
'LLL:EXT:enz_hotellist/Resources/Private/Language/locallang_db.xml:tx_enzhot
ellist_domain_model_property.name',

      'config'    => array(

            'type' => 'input',

            'size' => 30,

            'eval' => 'trim,required',

            ),

      ),

'image' => array(

      'exclude'   => 0,

      'label'           =>
'LLL:EXT:enz_hotellist/Resources/Private/Language/locallang_db.xml:tx_enzhot
ellist_domain_model_property.image',

      'config'    => array(

            'type' => 'group',

            'internal_type' => 'file_reference',

            'allowed' => 'gif,png,jpeg,jpg',

            'max_size' => $GLOBALS['TYPO3_CONF_VARS']['BE']['maxFileSize'],

            'show_thumbs' => 1,

            'size' => 1,

            'minitems' => 0,

            'maxitems' => 1,

      )

),

'show' => array(

      'exclude'   => 0,

      'label'           =>
'LLL:EXT:enz_hotellist/Resources/Private/Language/locallang_db.xml:tx_enzhot
ellist_domain_model_property.show',

      'config'    => array(

            'type' => 'check',

            'default' => 1,

      ),

),

 

The databsefields are also right

 

3          name    varchar(255)    utf8_general_ci            Ja

4          image   varchar(255)    utf8_general_ci            Ja 

5          show    tinyint(4)                      UNSIGNED    Nein     0

 

But if I try to create a new item in backend, it throws the error: 2: SQL
error: '' () 

In Protokoll stands: SQL error: '%s' (%s) (msg#1.1.12)

 

Do you understand this error message?

 

Best regards

Johannes



More information about the TYPO3-project-typo3v4mvc mailing list