[html-formfu] Model::DBIC inserts empty strings instead of NULL
values
Dmitry Bigunyak
icestar at inbox.ru
Thu Apr 21 21:41:24 GMT 2011
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
email: icestar at inbox.ru
More information about the HTML-FormFu
mailing list