[Catalyst] error using session and authn plug-ins under apache

[Daniel Westermann-Clark]

On 2006-07-31 11:13:30 -0400, leonard.a.jaffe at jpmchase.com wrote:
> Switching to Session::Store::DBIC yields this error:
> [error] Caught exception in engine
> "DBIx::Class::ResultSet::update_or_create(): Error executing 'INSERT
> INTO sessions (expires, id) VALUES (?, ?)': DBD::mysql::st execute
> failed: Field 'session_data' doesn't have a default value at
> D:/Perl/site/lib/DBIx/Class/Storage/DBI.pm line 743."

Hmm, does MySQL allow NULL in TEXT fields?  Did you explicitly tell it
NOT NULL when creating the sessions table?

Because of the order in which Catalyst::Plugin::Session saves its
data, the row for a session is initially created with a NULL value for
the data field.

-- 
Daniel Westermann-Clark