[ic] matrix options fail to generate all combinations

James P. Kinney III jkinney at localnetsolutions.com
Tue Dec 7 08:49:17 EST 2004

I am having trouble witrh the matrix options in 5.2. I generate a new
item, save it, then go to create the options for it. This item has two
options, size an material. Both size and material affect the price.

So I create both options with the details and the price variants. When I
press the "Generate all combinations" button, nothing happens. The
error.log shows a database error based on a null value for sku on a not
null field. The setup for the options shows that a number will be
generated if left blank. 

Error line starts below:

sesewing /cgi-bin/sesewing/admin/item_option_old.html Safe: DBD::Pg::st
execute failed: ERROR:  ExecInsert: Fail to add null value in not null
attribute sku at /usr/lib/interchange/lib/Vend/Table/DBI.pm line 1386.

The it lists the debugging output that shows the backend perl code.

If I create a simple type option, it works just fine. It still fails
regardless of price variants being included. 

What is a good starting point to get this working?
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://www.icdevgroup.org/pipermail/interchange-users/attachments/20041207/52f8fe06/attachment.bin

More information about the interchange-users mailing list