[redhat-ccm-list] Getting a caching error. Was "Getting a stylesheet compilation error. Please help."

[Tom Baik]

Hi Dennis,

Thanks for your continued help.

I am now getting the following error when I try deleting the row:

"lucene_ids_host_id_f_fcxb8 referential integrity violation - key in
web_hosts still referenced from lucene_ids"

Please help?

Tom




--- Dennis Gregorovic <dgregor at redhat.com> wrote:
> delete from web_hosts where host_id = <host id>;
> 
> replace <host id> with the host id value of the row that you want to
> delete.
> 
> -- Dennis
> 
> On Wed, 2004-04-28 at 16:39, Tom Baik wrote:
> > Okay, I get three row returned by running "select * from
> web_hosts;"
> > with different port numbers and hosts that I've tried.  Just to
> make
> > sure I do this properly, what is the command to remove two of the
> rows?
> >  Thanks.
> > 
> > Tom
> >   
> > 
> > 
> > --- Dennis Gregorovic <dgregor at redhat.com> wrote:
> > > It looks like what's going on here is that there is an errant
> entry
> > > in
> > > the database for the host [name=localhost, port=80].  You can
> check
> > > this
> > > out in psql by running "select * from web_hosts;".  You *should*
> only
> > > have one row returned, with 'localhost' as the server name and
> '8080'
> > > as
> > > the port number.  (This is assuming that your site is running off
> of
> > > http://localhost:8080/, which is what was indicated in previous
> > > emails)
> > > 
> > > -- Dennis
> > > 
> > > On Wed, 2004-04-28 at 15:15, Tom Baik wrote:
> > > > Thanks for helping with this.  I did not have the waf.web.host
> > > > parameter set and when I set it I finally was able to enter the
> > > CMS!!!
> > > > 
> > > > Now I am getting the following error in the catalina-stdout.log
> > > file:
> > > > 
> > > > ERROR caching.CacheServlet$HTTPRequester - Failure sending
> cache
> > > > invalidate:
> > > >
> > >
> >
>
http://localhost/expireCache?id=SiteNodeCache&key=%2Fcontent%2F&hash=381697369
> > > > 
> > > > The web.xml file seems to be configured properly.  What else
> could
> > > be
> > > > causing this error?
> > > > 
> > > > Regards,
> > > > Tom Baik
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > --- "Daniel P. Berrange" <berrange at redhat.com> wrote:
> > > > > On Sat, Apr 24, 2004 at 02:03:46PM -0700, Tom Baik wrote:
> > > > > > I'm getting a stylesheet compilation error.  The logs say
> that
> > > a
> > > > > call
> > > > > > is being made to this file <xsl:import
> > > > > > href="/__ccm__/servlet/content-type/index.xsl"/> but that
> file
> > > does
> > > > > not
> > > > > > exist.
> > > > > 
> > > > > This is not a physical file - its autogenerated based on set
> of
> > > > > contet
> > > > > types you have installed. There are two possibilities that
> spring
> > > to
> > > > > mind:
> > > > > 
> > > > > 
> > > > >  * The web.xml that is deployed is missing the mapping for 
> this
> > > URL
> > > > >    '/__ccm__/servlet/content-type/index.xsl'.
> > > > >   
> > > > > Or
> > > > >   
> > > > >  * The value of waf.web.host and waf.web.server are incorrect
> -
> > > eg
> > > > >    missing a port number, or a different port number to that
> in
> > > > >    apache / resin configs.
> > > > > 
> > > > > Dan.
> > > > > -- 
> > > > > |=-             Daniel P. Berrange  -  berrange at redhat.com   
>    
> > >    
> > > > >   -=|
> > > > > |=-   Red Hat, 338 Euston Road, London, NW1 3BT.  +44 (0)7977
> 267
> > > 243
> > > > >   -=|
> > > > > |=-                                                          
>    
> > >    
> > > > >   -=|
> > > > > |=- GnuPG: 7D3B9505   F3C9 553F A1DA 4AC2 5648 23C1 B3DF F742
> > > 7D3B
> > > > > 9505 -=| 
> > > > > 
> > > > 
> > > > > ATTACHMENT part 2 application/pgp-signature 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 	
> > > > 		
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Win a $20,000 Career Makeover at Yahoo! HotJobs  
> > > > http://hotjobs.sweepstakes.yahoo.com/careermakeover
> > > > 
> > > 
> > 
> > 
> > 
> > 	
> > 		
> > __________________________________
> > Do you Yahoo!?
> > Win a $20,000 Career Makeover at Yahoo! HotJobs  
> > http://hotjobs.sweepstakes.yahoo.com/careermakeover
> 



	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover