[ic] Missing options (was Re: Building a new catalog system -- is it this complex?)

[Jeme]

On Fri, 11 Jun 2004 18:19:44 +0100 "John1" <list_subscriber at yahoo.co.uk> wrote:
> On Friday, June 11, 2004 4:24 PM, jeme at rkdpp.com wrote:
> > On Thu, 10 Jun 2004 18:48:26 +0100
> > "John1" <list_subscriber at yahoo.co.uk> wrote:
> >> On Thursday, June 10, 2004 2:49 PM, jeme at rkdpp.com wrote:
> >>> Using the admin interface, I select a product with SKU "AC001" that
> >>> I'd just created.  This product can vary two simple ways: length and
> >>> weight, so I select the "options" tab.  There are radio buttons for
> >>> the type of option, so I select "Simple" and hit "update".  The
> >>> screen appears to refresh, but nothing changes.  If I try to do it
> >>> again, I get a message that says, "table options: set_slice error as
> >>> called by Vend::Interpolate: DBD::Pg::st execute failed: ERROR:
> >>> parser: parse error at or near "WHERE" at
> >>> /usr/lib/interchange/Vend/Table/DBI.pm line 1245. query was:update
> >>> options SET WHERE code = 'AC001' values were:''"
> >> Personally, I would suggest following the simple options example in
> >> the RTFM site faq docs.
> > OK, did that.
> >> Once you get it working this way then go back to the admin GUI and
> >> see what the options you have set up look like from the GUI.
> > Nothing in the GUI, nothing in the catalog.  It's like the entries
> > aren't even there.
> > What am I missing?
>
> I am not sure off the top of my head.

Found it.

And whomever does the maintaining of such things can maybe determine the issue here.

I started with an empty foundation store and got the errors described above.

There is this:
<URL: http://www.icdevgroup.org/pipermail/interchange-users/2003-September/035461.html >

And that describes my problem perfectly and the fix fixes it.

So when my catalog.cfg was created, that line was not present and caused my problems.

Thanks, everyone.
J.