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

Jeme jeme at rkdpp.com
Fri Jun 11 14:22:35 EDT 2004

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.

More information about the interchange-users mailing list