[ic] [AGAIN] Attempt to set merchandising::times_ordered::os29000 in read-only table

Nestor Diaz interchange-users@interchange.redhat.com
Tue Sep 18 11:01:01 2001


Hi ! i am trying to set the "other who bougth" funcionaility but when i
click on the (Merchandising->Generate other who...) the pages shows
everyting ok, however the error.log shows the following, i test it under
my system and under the demo store at akopia, but the problem remains, it
there any way to fix that? i test it under 4.6 and 4.8 with construct and
foundation respectively and none of them work.

Here is a snapshot of the problem:

----------------

http://demo.interchange.redhat.com/cgi-bin/ic3/admin/do_view.html?id=omIaCztq&mv_arg=error%2elog&mv_pc=410

216.72.218.173 omIaCztq:216.72.218.173 - [18/September/2001:10:55:08
-0400] ic3 /cgi-bin/ic3/admin/build_related.html Attempt to set
merchandising::others_bought::os29000 in read-only table
216.72.218.173 omIaCztq:216.72.218.173 - [18/September/2001:10:55:08
-0400] ic3 /cgi-bin/ic3/admin/build_related.html Attempt to set
merchandising::times_ordered::os29000 in read-only table

----------------

Thanks,

--
nestor a. diaz
ingeniero de desarrollo
engendro.com - soluciones especializadas en linux
mailto:nestor@engendro.com - call:voip.engendro.com
http://www.engendro.com/Nosotros/Personal/Nestor

On Tue, 18 Sep 2001 adam@opusvl.com wrote:

> what would happen if you were to rewrite the
> query to be something like below ?
> 
>  [sql type="set" base="CompanyInfo" interpolate="1"]
>   UPDATE CompanyInfo SET
>    contactname = '[value contactname]',
>    company = '[value company]'
>  [/sql]
> 
> does it also return an error ?
> 
> adam
> 
> Support wrote:
> > 
> > Hello everyone --
> > 
> > Here is a quick question...
> > 
> > [query interpolate=1 sql="UPDATE CompanyInfo SET contactname='[value
> > contactname]', company='[value company]'"][seti
> > name="updated"]DONE.[/seti][/query]
> > 
> > But, in the error.log (catalog) I get the following error message:
> > 
> > [18/September/2001:08:54:43 -0400] webstore
> > /cgi-bin/webstore/process.html SQL query failed for CompanyInfo: DBI
> > tables must be updated natively.
> > 
> > Any ideas?  Running Interchange 4.8.1 - "AllowGlobal webstore" in the
> > interchange.cfg file is already enabled for the catalog.  MySQL
> > database.
> > 
> > Thanks,
> > 
> > Jason Korkin
> > President
> > Korksoft LLC
> 
> -- 
>  -- 110010100 --
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>