On 2009-08-04 10:20:22 -0500, fREW Schmidt wrote: > I am trying to set up Session::Store::DBIC but I am getting no love. > Here is all of the relevant (afaik) data: > > Error: > > [Tue Aug 4 09:54:25 2009] acd_server.pl: > > DBIx::Class::ResultSet::find_or_create(): DBI Exception: DBD::ODBC::st > > fetchrow_array failed: [Microsoft][SQL Native Client]String data, right > > truncation (SQL-01004) [for Statement "SELECT me.id, me.session_data, > > me.expires FROM Session me WHERE ( me.id = ? )" with ParamValues: > > 1='session:c28d6383a2b334128738f4b70ee08ff7df5cd737'] at > > c:/strawberry/perl/site/lib/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm > > line 73
That session ID is 48 characters long, but your table was created with a column length of 72 characters (as recommended in the docs). Could you try creating the table using a VARCHAR instead of CHAR? Perhaps MSSQL is being strict about the length of the input string. If this turns out to be the case, think you could throw together a doc patch? > SQL Creation Script > > CREATE TABLE dbo.Session > > ( > > id char(72) NOT NULL, > > session_data text, > > expires int > > ) ON [PRIMARY] > > TEXTIMAGE_ON [PRIMARY] > > GO -- Daniel Westermann-Clark _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
