Anyone know how to fix this? I get daily complaints from blog readers
that they can't search my site.
Thanks,
Matt
On 8/2/05, Matt Raible <[EMAIL PROTECTED]> wrote:
> What's the syntax for rollerdb.properties? Here's what I get when
> trying to run the script below.
>
> [EMAIL PROTECTED] bin]$ ./checkDatabase.sh
> Exception in thread "main" java.io.FileNotFoundException:
> rollerdb.properties (No such file or directory)
> at java.io.FileInputStream.open(Native Method)
> at java.io.FileInputStream.<init>(FileInputStream.java:106)
> at java.io.FileInputStream.<init>(FileInputStream.java:66)
> at
> org.roller.business.utils.ConsistencyCheck.main(ConsistencyCheck.java:35)
>
>
> Is there an example of this file in Roller's source tree.
>
> Matt
>
> On 7/30/05, Dave Johnson <[EMAIL PROTECTED]> wrote:
> > Have you tried running ConsistencyCheck? It will list the
> > inconsistencies and if you run it with -purge" it will attempt to
> > automatically clean them up.
> >
> > Here's the script I use to run it:
> >
> > #!/bin/sh
> > if [ "$JAVA_HOME" = "" ] ; then
> > echo You must set JAVA_HOME to point to your Java JDK install
> > directory
> > exit 1
> > fi
> > _JDBCJAR=${CATALINA_HOME}/common/lib/mysql-connector-java-3.0.15-ga-
> > bin.jar
> > _CP=../lib/rollerbeans.jar
> > _CP=${_CP}:../lib/commons-logging.jar
> > _CP=${_CP}:${_JDBCJAR}
> >
> > ${JAVA_HOME}/bin/java -classpath ${_CP}
> > org.roller.business.utils.ConsistencyCheck $1 $2 $3 $4
> >
> >
> > - Dave
> >
> >
> >
> >
> > On Jul 28, 2005, at 11:41 PM, Matt Raible wrote:
> >
> > > Max,
> > >
> > > This results in:
> > >
> > > mysql> delete from weblogentry where websiteid not in (select
> > > website.id
> > > -> from website, rolleruser where website.userid = rolleruser.id);
> > > ERROR 1064 (00000): You have an error in your SQL syntax near 'select
> > > website.id
> > > from website, rolleruser where website.userid = rolleruser.id' at line
> > > 1
> > >
> > > I'm using MySQL 3.23.56-Max-log, and I'm guessing the problem is the
> > > subselect doesnt' work in that version.
> > >
> > > Matt
> > >
> > > On 7/27/05, Rudman Max <[EMAIL PROTECTED]> wrote:
> > >> Actually, the stack trace showed the UserData object as being the
> > >> cluprit which means you need to do a join on 'website' and
> > >> 'rolleruser' tables.
> > >>
> > >> Try this:
> > >>
> > >> delete from weblogentry where websiteid not in (select website.id
> > >> from website, rolleruser where website.userid = rolleruser.id)
> > >>
> > >> Max
> > >>
> > >>
> > >> On Jul 27, 2005, at 8:10 PM, Matthew P. Schmidt wrote:
> > >>
> > >>> That's a data inconsistency problem. The following query was
> > >>> harsh, but solved the problem:
> > >>>
> > >>> delete from weblogentry where categoryid not in (select id from
> > >>> weblogcategory)
> > >>>
> > >>> I believe those are the right columns, just double check. That
> > >>> should get rid of any entries that managed to become orphaned.
> > >>>
> > >>> -Matt
> > >>>
> > >>> Matt Raible wrote:
> > >>>
> > >>>
> > >>>> When I try to kick off the search indexing for my site, I get the
> > >>>> following stack trace in my logs. Any idea how to fix this?
> > >>>>
> > >>>> INFO 2005-07-27 16:47:34,168 | WriteToIndexOperation:run | Starting
> > >>>> search index operation
> > >>>> ERROR 2005-07-27 16:47:37,067 |
> > >>>> HibernateWeblogManagerImpl:getWeblogEntries |
> > >>>> net.sf.hibernate.UnresolvableObjectException: No row with the given
> > >>>> identifier exists: 192197110220102822966018600075, of class:
> > >>>> org.roller.pojos.UserData
> > >>>> ERROR 2005-07-27 16:47:37,068 | RebuildUserIndexOperation:doRun |
> > >>>> ERROR adding doc to index
> > >>>> org.roller.RollerException
> > >>>> at
> > >>>> org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEn
> > >>>> t
> > >>>> ries(HibernateWeblogManagerImpl.java:307)
> > >>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> > >>>> (WeblogManagerImpl.java:297)
> > >>>> at
> > >>>> org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> > >>>> n
> > >>>> (RebuildUserIndexOperation.java:114)
> > >>>> at
> > >>>> org.roller.business.search.operations.WriteToIndexOperation.run
> > >>>> (WriteToIndexOperation.java:41)
> > >>>> at EDU.oswego.cs.dl.util.concurrent.PooledExecutor
> > >>>> $Worker.run(Unknown
> > >>>> Source)
> > >>>> at java.lang.Thread.run(Thread.java:595)
> > >>>> --- ROOT CAUSE ---
> > >>>> net.sf.hibernate.UnresolvableObjectException: No row with the given
> > >>>> identifier exists: 192197110220102822966018600075, of class:
> > >>>> org.roller.pojos.UserData
> > >>>> at net.sf.hibernate.UnresolvableObjectException.throwIfNull
> > >>>> (UnresolvableObjectException.java:38)
> > >>>> at net.sf.hibernate.impl.SessionImpl.internalLoad
> > >>>> (SessionImpl.java:1950)
> > >>>> at net.sf.hibernate.type.ManyToOneType.resolveIdentifier
> > >>>> (ManyToOneType.java:69)
> > >>>> at net.sf.hibernate.type.EntityType.resolveIdentifier
> > >>>> (EntityType.java:204)
> > >>>> at net.sf.hibernate.impl.SessionImpl.initializeEntity
> > >>>> (SessionImpl.java:2201)
> > >>>> at net.sf.hibernate.loader.Loader.doQuery(Loader.java:240)
> > >>>> at
> > >>>> net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollection
> > >>>> s
> > >>>> (Loader.java:133)
> > >>>> at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
> > >>>> at net.sf.hibernate.loader.Loader.list(Loader.java:946)
> > >>>> at net.sf.hibernate.loader.CriteriaLoader.list
> > >>>> (CriteriaLoader.java:121)
> > >>>> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:
> > >>>> 3609)
> > >>>> at net.sf.hibernate.impl.CriteriaImpl.list
> > >>>> (CriteriaImpl.java:238)
> > >>>> at
> > >>>> org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEn
> > >>>> t
> > >>>> ries(HibernateWeblogManagerImpl.java:302)
> > >>>> at org.roller.business.WeblogManagerImpl.getWeblogEntries
> > >>>> (WeblogManagerImpl.java:297)
> > >>>> at
> > >>>> org.roller.business.search.operations.RebuildUserIndexOperation.doRu
> > >>>> n
> > >>>> (RebuildUserIndexOperation.java:114)
> > >>>> at
> > >>>> org.roller.business.search.operations.WriteToIndexOperation.run
> > >>>> (WriteToIndexOperation.java:41)
> > >>>> at EDU.oswego.cs.dl.util.concurrent.PooledExecutor
> > >>>> $Worker.run(Unknown
> > >>>> Source)
> > >>>> at java.lang.Thread.run(Thread.java:595)
> > >>>> INFO 2005-07-27 16:47:37,072 | RebuildUserIndexOperation:doRun |
> > >>>> Completed rebuilding index for all users in '2.904' secs
> > >>>> INFO 2005-07-27 16:47:37,073 | WriteToIndexOperation:run | Search
> > >>>> index operation complete
> > >>>>
> > >>>
> > >>
> > >>
> > >
> >
> >
>
