I'm trying to install this module, but when i enable it, after some seconds, i get this error message:

user warning: BLOB/TEXT column 'buttons' can't have a default value query: CREATE TABLE nicedit_settings ( `nesid` INT NOT NULL auto_increment, `name` VARCHAR(32) NOT NULL DEFAULT '', `fullpanel` TINYINT NOT NULL DEFAULT 0, `buttons` TEXT NOT NULL DEFAULT '', PRIMARY KEY (nesid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Webserver\drupal\includes\database.inc on line 509.

Comments

bass’s picture

bass commented

Looks like the default value for Buttons does not work.
Using following to create the table by yourself :
DROP TABLE IF EXISTS `nicedit_settings`;
CREATE TABLE `dp6smart`.`nicedit_settings` (
`nesid` int(10) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`fullpanel` int(1) NOT NULL default '0',
`buttons` text NOT NULL,
PRIMARY KEY (`nesid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

But it works at most of place; but doesn't work well with following two things;

(1) submission form settings
(2) split the summry buttone

Don't know what to do?
Help!!!