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
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;