[ic] read-only products database

Interchange Admin interchange-users@lists.akopia.com
Tue May 8 00:02:00 2001


I can not seem to set Interchange up to allow me to write to the
products database with or without tags.

The line I am using is as follows:

   [data base=products column=avail key=[item-code] value="no"]

>From the manual, if I assume that the permission "is equivalent to:

   Database   products  WRITE_CONTROL 1
   Database   products  WRITE_TAGGED  1"

I get the following error whether I use "[tag flag write]products[/tag]"
or not:

[formatting mine]
   123.456.789.012 TRVokDm8:123.456.789.012 - [07/May/2001:22:39:15 -0500]
   store /cgi-bin/store/ord/basket Attempt to set products::avail::0-0001
   in read-only table

If I add the following to catalog.cfg, I can, indeed write to the
products database using [tag.../tag]:

   Database   products  WRITE_CONTROL 1
   Database   products  WRITE_TAGGED  1

but then "flypage.html" does not work.  Apache says:

[formatting mine]
   [Mon May  7 22:42:57 2001] [error] [client 123.456.789.012] Premature
   end of script headers: /home/thestore/cgi-local/store

and interchange says:

[formatting mine]
   123.456.789.012 TRVokDm8:123.456.789.012 - [07/May/2001:22:42:57 -0500]
   store /cgi-bin/store/0-0003 Runtime error: Could not tie to
   '/home/thestore/interchange /store/products/products.gdbm': Resource
   temporarily unavailable at //usr/lib/interchange/lib/Vend/Table/GDBM.pm
   line 105.

The only way around this that I can see (but haven't tested yet) is
to have another table that is not products that has only the sku and
the "avail" that I need to update.  But this implies that you can not
use "flypage" and have write access to your products table.

Any tips, clues, etc.??  This is a MAJOR problem at this point.

RedHat Linux:::::::: 6.2
interchange version: interchange-4.6.5-1.rh6
perl version:::::::: perl-5.00503-10

Thanks.

jaime
--
interch            | I read recently that human beings use only 15%
@    Jaime Viehweg | of their brains capacity.  Makes you wonder
viehweg.net        | what they do with the other 75%.