Looks like it worked!

INFO  2005-08-18 13:44:38,625 | RebuildUserIndexOperation:doRun |
Completed rebuilding index for all users in '170.517' secs
INFO  2005-08-18 13:44:38,647 | WriteToIndexOperation:run | Search
index operation complete

Now I have a new issue.  If I do a search on my "rd" blog, I get a
stack trace - but it works fine on my "rn" blog.  Any ideas?

http://raibledesigns.com/search/rd?q=julie

http://raibledesigns.com/search/rn?q=julie

The error is:

ERROR 2005-08-18 13:47:25,103 | BasePageServlet:handleRequest |
EXCEPTION: in RollerServlet
org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'format' in  class java.text.SimpleDateFormat threw exception
class java.lang.IllegalArgumentException : Cannot format given Object
as a Date
        at 
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:246)
        at 
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
        at 
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
        at 
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)




On 8/18/05, Matt Raible <[EMAIL PROTECTED]> wrote:
> On 8/18/05, Dave Johnson <[EMAIL PROTECTED]> wrote:
> > There is a snippet about ConsistencyCheck at the end of the 1.0 upgrade
> > guide:
> > <http://www.rollerweblogger.org/wiki/Wiki.jsp?page=UpgradeGuide_1_0>
> 
> Thanks Dave - looks like I have quite a few orphans.
> 
> http://raibledesigns.com/consistencycheck.log
> 
> I've backed up my database, and I'm about to run this with -purge.  If
> my site is offline in the near future, you'll know why. ;-)
> 
> Matt
> 
> >
> > - Dave
> >
> >
> > On Aug 18, 2005, at 1:58 PM, Matt Raible wrote:
> >
> > > 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.getWeblo
> > >>>>>>> gEn
> > >>>>>>> t
> > >>>>>>> ries(HibernateWeblogManagerImpl.java:307)
> > >>>>>>>        at org.roller.business.WeblogManagerImpl.getWeblogEntries
> > >>>>>>> (WeblogManagerImpl.java:297)
> > >>>>>>>        at
> > >>>>>>> org.roller.business.search.operations.RebuildUserIndexOperation.d
> > >>>>>>> oRu
> > >>>>>>> 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.doQueryAndInitializeNonLazyCollect
> > >>>>>>> ion
> > >>>>>>> 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.getWeblo
> > >>>>>>> gEn
> > >>>>>>> t
> > >>>>>>> ries(HibernateWeblogManagerImpl.java:302)
> > >>>>>>>        at org.roller.business.WeblogManagerImpl.getWeblogEntries
> > >>>>>>> (WeblogManagerImpl.java:297)
> > >>>>>>>        at
> > >>>>>>> org.roller.business.search.operations.RebuildUserIndexOperation.d
> > >>>>>>> oRu
> > >>>>>>> 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
> > >>>>>>>
> > >>>>>>
> > >>>>>
> > >>>>>
> > >>>>
> > >>>
> > >>>
> > >>
> > >
> >
> >
>

Reply via email to