Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th January 2012, 02:12
Blackbit Blackbit is offline
Junior Member
 
Join Date: Feb 2011
Posts: 11
Thanks: 3
Thanked 4 Times in 3 Posts
Default Module Creation with TEXTAREA

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
Reply With Quote
Sponsored Links
  #2  
Old 25th January 2012, 11:41
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,669
Thanks: 819
Thanked 5,317 Times in 4,170 Posts
 
Default

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;
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Blackbit (25th January 2012)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Freeradius and Mysql uvstudios HOWTO-Related Questions 4 19th February 2014 12:11
Proftpd + MySQL virtual users, can't connect geekman HOWTO-Related Questions 28 27th September 2010 18:03
FreeRadius + MySQL working, but I don't know how to customise SQL queries awe Installation/Configuration 4 4th April 2010 23:28
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
Webmin docs missing namit Server Operation 11 5th January 2006 09:51


All times are GMT +2. The time now is 13:16.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.