[html-formfu] Model::DBIC inserts empty strings instead of NULL values

Dmitry Bigunyak icestar at inbox.ru
Thu Apr 28 09:39:26 GMT 2011


Does anybody read this mailing-list? Maybe someone has the same problem 
or knows how to solve it?
Any suggestions are appreciated.

22.04.2011 01:41, Dmitry Bigunyak пишет:
> Hello!
> I faced with this problem after upgraded from version 
> HTML-FormFu-Model-DBIC-0.06000 to the next one.
>
> In version 0.06000 if I had a table with varchar column and 
> is_nullable option was set I got NULL values inserted for it on 
> submit. In my example I have a column 'username' with UNIQUE 
> constraint for it.
> The next release-0.08002 broke my application. In that release author 
> made a bugfix:
>
> ' - Fix: Was trying to pass undef to NOT NULL columns - changed check 
> from ( $is_nullable || ... ) to ( $is_nullable && ... ) appears to 
> have been unintentionally changed in svn r93 when the code was a part 
> of DBIx::Class::HTML::FormFu.'
>
> Instead of NULL values the module started insert empty strings and I 
> got a lot of "Duplicate entry '' for key" errors. So, I posted a bug 
> report to the CPAN bug tracker and had to downgrade.
>
> Today the last release version is 0.09000, but I still can't upgrade. 
> I thought about using ignore_if_empty option, but I lose ability to 
> unset the column value to NULL with it.
>
> Can someone suggest me the way to solve this problem.
> Thanks

-- 
Dmitry Bigunyak
e-mail: icestar at inbox.ru




More information about the HTML-FormFu mailing list