Issue 849 - migrate.php errors on new MySQL database; uncaught exception on table indefero_sessions (indefero)

[no-r...@ceondo.com]

Hello,

A new issue has been created and assigned
to you:

849 - migrate.php errors on new MySQL database; uncaught exception on table indefero_sessions
Project: Indefero
Status: New
Reported by: Stephen Repetski
Labels:
Type:Defect
Priority:Medium

Description:

Attempting to install Indefero to a clean database results in the following issue:

root@svn:/usr/share/indefero/src# php /usr/share/pluf/src/migrate.php --conf=IDF/conf/idf.php -a -i -d
PHP include path: .:/usr/share/php:/usr/share/pear:/usr/share/pluf/src
Install all the apps
Pluf_Migrations_Install_setup
PHP Fatal error: Uncaught exception 'Exception' with message '1101 - BLOB/TEXT column 'session_data' can't have a default value - CREATE TABLE `indefero_sessions` (
`id` mediumint(9) unsigned not null auto_increment NOT NULL,
`session_key` varchar(100) NOT NULL default '',
`session_data` longtext NOT NULL default '',
`expire` datetime NOT NULL default 0,
PRIMARY KEY (`id`))ENGINE=InnoDB DEFAULT CHARSET=utf8;' in /usr/share/pluf/src/Pluf/DB/MySQL.php:121
Stack trace:
#0 /usr/share/pluf/src/Pluf/DB/Schema.php(71): Pluf_DB_MySQL->execute('CREATE TABLE `i...')
#1 /usr/share/pluf/src/Pluf/Migrations/Install.php(48): Pluf_DB_Schema->createTables()
#2 /usr/share/pluf/src/Pluf/Migration.php(179): Pluf_Migrations_Install_setup()
#3 /usr/share/pluf/src/Pluf/Migration.php(86): Pluf_Migration->installApp('Pluf')
#4 /usr/share/pluf/src/migrate.php(227): Pluf_Migration->install()
#5 {main}
thrown in /usr/share/pluf/src/Pluf/DB/MySQL.php on line 121


MySQL server is CentOS running MySQL 5.6

--
Issue: http://projects.ceondo.com/p/indefero/issues/849/