Module Creation with TEXTAREA

Discussion in 'Developers' Forum' started by Blackbit, Jan 25, 2012.

  1. Blackbit

    Blackbit New Member

    Hi!

    I'm writing a new module and i use the sources from svn://svn.ispconfig.org/ispconfig3/trunk/interface/ to automatically create the modules' tables and lang-files. I get the following problem when i add a textarea:

    Code:
    [...]plugin_license text DEFAULT 'NULL' NOT NULL , PRIMARY KEY (plugin_id))) -> mysqli_query BLOB/TEXT column 'plugin_license' can't have a default value
    In the .tform.php i have defined:

    Code:
     'plugin_license' => array(
                            'datatype'      => 'TEXT',
                            'formtype'      => 'TEXTAREA',
                            'default'       => '',
                            'value'         => '',
                            'cols'          => '30',
                            'rows'          => '10'
            ),
    
    Even the definition without the defaults for "default" and "value" doesn't work.

    It's MySQL 5.5.16. Maybe thats my problem?

    ISPConfig-Version:

    Revision: 2904
    Node Kind: directory
    Schedule: normal
    Last Changed Author: moglia
    Last Changed Rev: 2893
    Last Changed Date: 2012-01-19 00:05:06 +0100 (Thu, 19 Jan 2012)


    Regards,
    Blackbit
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    It might be that there are problems in the svn trunk as we currently rework the mysql library to use mysqli and the changes are not fully tested yet.

    Try to edit the file interface/lib/classes/tform_tpl_generator.inc.php line 271 and change:

    $defaultValue = 'NULL';

    to:

    $defaultValue = false;
     

Share This Page