jasig-ssp IRC Logs-2013-08-05

Owned by Apereo Infrastructure
Last updated: Aug 05, 2013
1 min read

[10:49:04 CDT(-0500)] <TonyUnicon> i guess no standup

[18:36:07 CDT(-0500)] <JasonElwood> Paul- need a little help with a changeset that is failing during an upgrade.

[18:36:17 CDT(-0500)] <JasonElwood> Change Set org/jasig/ssp/database/changesets/000055.xml::Provide code column in student_type table::paul.spaude failed. Error: Error executing SQL UPDATE public.student_type SET code = name: ERROR: value too long for type character varying(10)

[18:36:22 CDT(-0500)] <pspaude1> Yes what changeset?

[18:36:26 CDT(-0500)] <pspaude1> ah ok

[18:37:10 CDT(-0500)] <JasonElwood> remind me of the fix on this one

[18:37:14 CDT(-0500)] <pspaude1> Ok, one of the existing names is too long (10) than the student type code allows

[18:37:54 CDT(-0500)] <JasonElwood> ah crap

[18:37:57 CDT(-0500)] <pspaude1> What happens is the changeset was designed since student type code can't be null to just copy the name over since pre-the changeset everyone was using name as the code

[18:38:01 CDT(-0500)] <JasonElwood> I read the error wrong

[18:39:05 CDT(-0500)] <pspaude1> Ah, ok.

[18:39:18 CDT(-0500)] <JasonElwood> the column was added in a changeset correct?

[18:39:29 CDT(-0500)] <pspaude1> Probably the easiest fix is the change the name to allow it and then after the changeset is complete go back and change the name back.

[18:39:58 CDT(-0500)] <JasonElwood> agreed. strange thing now is that student_type doesn't have a code column

[18:40:27 CDT(-0500)] <JasonElwood> oh. that's the first part of the set.

[18:40:31 CDT(-0500)] <JasonElwood> too long of a day already

[18:41:20 CDT(-0500)] <pspaude1> haha I hear ya.

[18:48:32 CDT(-0500)] <JasonElwood> got it. thanks

[18:50:01 CDT(-0500)] <pspaude1> No problem.