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

[Ron Phipps]

> From: interchange-users-admin@interchange.redhat.com
[mailto:interchange-
> users-admin@interchange.redhat.com] On Behalf Of Nestor Diaz
> 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 the solution per Mike a few weeks back:

"We are missing [flag type=write table=merchandising] at
the top of the page that generates it. Put that near the top of
lib/UI/pages/admin/build_related.html and I am guessing it will work."

I have verified this solution does fix the problem.

Good luck,
-Ron


> 
> 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
> >
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users