[ic] pgsql - options table error

[Jeff Fearn]

Hi :) IC 4.8.3, pgsql, perl v5.6.0, RedHat 7.1

I have recently started having a problem creating new options, or even 
editing existing options, for a product with matrix options. I get the 
following error:

Sorry, there was an error in processing this form action. Please report the 
error or try again later. (DBD::Pg::st execute failed: ERROR: ExecReplace: 
Fail to add null value in not null attribute o_master at 
/usr/lib/interchange/lib/Vend/Table/DBI.pm line 985. )

lines from 983:

        my $sth = $s->[$DBI]->prepare($sql)
                or die ::errmsg("prepare %s: %s", $sql, $DBI::errstr);
        my $rc = $sth->execute(@$vary)
                or die ::errmsg("execute %s: %s", $sql, $DBI::errstr);

I conclude from this that the sql statement is actually being passed to 
pgsql for execution. The definition of options has not changed. I can see 
via phpPgAdmin that the field is NOT NULL and has DEFAULT ''. I have 
recently changed wich fields are displayed on the options maintenance page, 
but can not see how that would affect anything.


P.S. any idea why a field that has 0 or 1 in it is a varchar(64) and not a 
int(1)? :}

Thanks, Jeff.


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp