Bug 355727 – Schema does not work against mysql 5.1 in TRADITIONAL sql-mode

• Status: RESOLVED WONTFIX
• Product: Gentoo Hosted Projects

[Description Petteri Räty (RETIRED) 2011-02-20 18:10:47 UTC]

** Execute db:schema:load
rake aborted!
Mysql::Error: BLOB/TEXT column 'content' can't have a default value: CREATE TABLE `answers` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `content` text DEFAULT '' NOT NULL, `approved` tinyint(1) DEFAULT 0, `reference` tinyint(1) DEFAULT 0, `feedback` varchar(255) DEFAULT '', `created_at` datetime, `updated_at` datetime, `question_id` int(11) NOT NULL, `owner_id` int(11), `correct` tinyint(1), `type` varchar(255)) ENGINE=InnoDB

Don't know if we want to do something about it but at least we probably can't upgrade to 5.1 before we do something about it.

[Comment 1 Robin Johnson 2011-02-20 19:30:12 UTC]

Works on the server:
http://paste.pocoo.org/show/341868/

MySQL 5.1.50 on there.
It should not be passing a DEFAULT keyword for the 'content' column.

[Comment 2 Petteri Räty (RETIRED) 2011-02-20 19:36:35 UTC]

I have 5.1.53 locally.

[Comment 3 Petteri Räty (RETIRED) 2011-03-19 18:25:58 UTC]

This was due to sql-mode = "TRADITIONAL" in my.cnf. I think we should just document that this mode doesn't work.

[Comment 4 Joachim Bartosik (RETIRED) 2011-09-01 21:45:10 UTC]

Please take a look at

https://github.com/ahenobarbi/Gentoo-Recruiters-App/commit/7d1d4e5b6b9c6e6199a9c7c9d4536c812bea0984

[Comment 5 Joachim Bartosik (RETIRED) 2013-04-08 22:02:12 UTC]

The application is no longer maintained or used.