On Tue, Aug 4, 2009 at 4:12 PM, Daniel Westermann-Clark <[email protected]>wrote:
> 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 > > Unfortunately I'm getting the same error. Any other ideas? -- fREW Schmidt http://blog.afoolishmanifesto.com
_______________________________________________ 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/
