I'm getting this error when first clicking save configuration in admin/modules.

user warning: BLOB/TEXT column 'settings' can't have a default value query: CREATE TABLE tinymce_settings ( name varchar(128) NOT NULL default '', settings text NOT NULL default '', PRIMARY KEY (name) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in \includes\database.mysql.inc on line 121.

This is on a clean install of drupal 4.7.6, and tinymce module 4.7.x-1.x-dev 2007-Jan-27, no other modules other than what came out of the box enabled.
tinymce 2.0.9
MySQL 5.0.27
Windows XP
Apache 2.2.4
PHP 5.2.0

I believe the problem is that there may have been a MySQL syntax change from 4.x to 5.0 where the default keyword is not allowed on a text field, but I could easily be wrong here.

Creating the table manually in mysql without using the default value for the column seems to be a possible workaround for the problem.

Comments

larrychu’s picture

larrychu commented

See this bug report for mysql for more information. Default '' (empty string) value for text field is silently supported, but may be broken by backup tools (mysqldump for example). The fix that seems to have been introduced in MySQL 5.0.25, broke any STRICT databases relying on such functionality.

A feature request in MySQL for 5.1 to support default values for text fields exists (see here).

Nonetheless the tinymce.install script is relying on unsupported feature in pre 5.0.25 versions of MySQL. I suggest removing the default '' from the text field.

My Proposal to fix this is something like this:

In tinymce.install:

       db_query("CREATE TABLE {tinymce_settings} (
                 name varchar(128) NOT NULL default '',
+                settings text NOT NULL,
-                settings text NOT NULL default '',
                 PRIMARY KEY (name)
                ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
kreynen’s picture

kreynen commented
Status: Active » Closed (fixed)

Closing old install issues