[ic] pgsql - options table error

Jeff Fearn interchange-users@interchange.redhat.com
Wed Dec 5 19:41:00 2001


>* Jeff Fearn wrote on Wed, Dec 05, 2001 at 07:39 +0000:
> > 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. )
>
>this messages seems not be be generated by:
>
> >         my $rc = $sth->execute(@$vary)
> >                 or die ::errmsg("execute %s: %s", $sql, $DBI::errstr);
>
>this line, since you would see the SQL statement I think. But
>ICs errorhandling is a little... well... strange sometimes.

Well that is obvious ... wonder how I missed that :}

>I would try to get the statement, maybe it's malformed or so.

SQL =  update options SET 
description=?,o_master=?,wholesale=?,o_default=?,o_widget=?,mv_shipmode=?,o_group=?,o_width=?,price=?,o_footer=?,sku=?,differential=?,o_matrix=?,volume=?,o_height=?,o_modular=?,weight=?,o_enable=?,o_label=?,o_include=?,o_exclude=?,o_sort=?,phantom=?,o_value=?,o_header=? 
WHERE code = 'RH033-Date'

This is populated with the data:

::::select::Date:0:::RH033::::0::::Date::25Jan2002=25January2002:001,

This is a : joined array, should o_master be in there at all? Obviously it 
is being set to NULL, but should it not use the default value? o_master is 
actually being displayed on the "Select for table edit" page. Which you get 
to by editing a variant option, from the option edit page ... that is 
confusing :}

I believe I may have deleted the profile in there, if so how would I edit 
the current profile to get the poriginal settings back?

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


>Steffen

Thanks for your help Steffen :)

Jeff.


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