in reply to DBIx::Class Error: syntax error at or near "NOT" [Solved]

"user_password" NOT NULL, seems to be missing a data type :) Also, DBIx is a wide namespace which is not actually synonymous with DBIC, aka DBIx::Class.

Replies are listed 'Best First'.
Re^2: DBIx Error: syntax error at or near "NOT"
by three18ti (Monk) on Jun 03, 2012 at 16:09 UTC

    I had no idea, thanks for clarifying that. The fact that it goes by DBIC and DBIx::Class is kinda confusing too (now I understand though, one of those ligtbulb moments ;) )

    Also, thanks for the pointer, I couldn;t figure out for the life of my why it was missing (since I had -previously- defined the data type), but it appears that I was overwriting the password field.