Cascade saving and a 'sign'
17 views
Skip to first unread message
bvn13
Feb 15, 2012, 1:28:23 AM2/15/12
to rose-db...@googlegroups.com
I try a cascade saving for the first time and get an error.
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "NaN" at /usr/lib/perl5/site_perl/5.12.3/Rose/DB/Object.pm line 1181.
insert() - DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "NaN" at /usr/lib/perl5/site_perl/5.12.3/Rose/DB/Object.pm line 1181.
It seems it's about the following data, generated by Rose:
$VAR1 = bless( {
'link' => bless( {
'value' => [
0
],
'sign' => 'NaN'
}, 'Math::BigInt' ),
'__xrdbopriv_modified_columns' => {
'link' => 1,
'is_individual' => 1,
'medicine' => 1,
'details' => 1,
'mnn' => 1
},
....
What is the 'sign' field?
How to fix this error?
Is this situation documented anywhere?
John Siracusa
Feb 15, 2012, 8:35:32 AM2/15/12
to rose-db...@googlegroups.com
It looks like Math::BigInt thinks the value for that column is NaN
(Not a Number). I've never seen that happen before, but maybe the
Math::BigInt documentation has some hints.
-John
bvn13
Feb 16, 2012, 2:07:57 AM2/16/12
to rose-db...@googlegroups.com
John, it's ridiculous, but a 'sign' IS NOT my column! :)
It is a mystic...
And some more facts... I test my script on all three computers I have. In two cases of them this error occurs, but in one case the different error occurs:
insert() - Cannot bind a reference
that's all!
I join two files to this message:
1) my Rose::DB-structure of DB in classes
2) an exemplar of my object I try to save in cascade mode.
maybe, this helps to get a solve...
0 new messages