[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