[ic] [query] & [more] Error - (was [query] causes [more] to
generate non-unique mv_cache_key)
Stefan Hornburg
racke at linuxia.de
Thu Nov 18 05:39:56 EST 2004
On Thu, 18 Nov 2004 10:07:40 +0000
Sandy Thomson <sandy at scotwebshops.com> wrote:
> On Wed, 2004-11-17 at 10:50 -0600, Dan Bergan wrote:
> > Dan Bergan wrote:
> >
> > > Sandy Thomson wrote:
> > >
> > >> Its very difficult to debug your code, if we cant see your code, if you
> > >> know what I mean.
> > >>
> > >>
> > >>
> > > For a simple test I put the following code into a page on my IC 5.2
> > > demo site and I was able to reproduce my error:
> > > [query sql="select sku from products where sku like 'os28%' order by sku"
> > > type=list
> > > ml=5
> > > more=1
> > > ]
> > > [on-match]
> > > <table width="95%" border="0" cellspacing="0">
> > > <tr class="categorybar">
> > > <td><b>[L]SKU[/L]</b></td>
> > > </tr>
> > > [/on-match]
> > >
> > > [list]
> > > <tr>
> > > <td>
> > > [sql-code]
> > > </td>
> > > </tr>
> > > [/list]
> > >
> > > [on-match]
> > > </table>
> > > [/on-match]
> > >
> > > <BR CLEAR=LEFT>
> > > [more-list]
> > > <BLOCKQUOTE>
> > > [msg arg.0="[matches]" arg.1="[match-count]"]Matches %s of %s
> > > found.[/msg]
> > > <BR>[more]<BR>
> > > </BLOCKQUOTE>
> > > [/more-list]
> > >
> > > [/query]
> > >
> > Sorry, I should probably add a bit more detail...
> > Browse to the page (above), let the session time out (wait 1 hour),
> > click on one of the [more] links, and I get an Internal Server Error.
> >
> > Dan
>
>
> Ok, Im not an interchange guru, but i think its because Interchange
> automatically times out sessions.
>
> If your session times out, it then cant access the cached more pages
> from the search (stored under your as something like
> "tmp/o/V/oV7685.gHGHJSHghdfjakhkDSA", if your session id is oV7685, and
> the hash of the search is gHGHJSHghdfjakhkDSA.
>
> I think the best way to solve this (correct me if im wrong anyone), is
> to increase the timeout. (i think the syntax is SessionExpire in
> catalog.cfg).
No, it shouldn't issue an Internal Server Error because the session
is away.
Bye
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users
mailing list