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.getWeblogEnt > >> ries(HibernateWeblogManagerImpl.java:307) > >> at org.roller.business.WeblogManagerImpl.getWeblogEntries > >> (WeblogManagerImpl.java:297) > >> at > >> org.roller.business.search.operations.RebuildUserIndexOperation.doRun > >> (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.doQueryAndInitializeNonLazyCollections > >> (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.getWeblogEnt > >> ries(HibernateWeblogManagerImpl.java:302) > >> at org.roller.business.WeblogManagerImpl.getWeblogEntries > >> (WeblogManagerImpl.java:297) > >> at > >> org.roller.business.search.operations.RebuildUserIndexOperation.doRun > >> (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 > >> > > > >