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 > > >>>>>>> > > >>>>>> > > >>>>> > > >>>>> > > >>>> > > >>> > > >>> > > >> > > > > > > > >