Hi, I'm using Roller 4.0, and there's a problem with the "Full Preview" operation. When I edit a blog entry and then click on "Full Preview", I get a 404 page not found error. I have added the full set of exceptions at the end of this mail.
I searched for other occurrences of this problem, and a Google search tooke me to the following link: https://issues.apache.org/roller/secure/attachment/10359/roller.log This is obviously an attachment to an existing defect in the Roller defect tracking system, but I was unable to track this back to the actual defect. Does someone know how I can find the defect to which this attachment belongs? Or does someone know the problem? I'm using Roller 4.0 with GlassFish 2 and Derby, with JDK 1.6.0_03-b05. Thanks Stephan Exceptions in the Roller log file: ERROR 2008-10-03 20:25:01,926 PreviewServlet:doGet - Error during rendering for page 4295d763-c3a1-4388-9e18-7989926d9a6d org.apache.roller.weblogger.ui.rendering.RenderingException: Error during rendering at org.apache.roller.weblogger.ui.rendering.velocity.VelocityRenderer.render(VelocityRenderer.java:155) at org.apache.roller.weblogger.ui.rendering.servlets.PreviewServlet.doGet(PreviewServlet.java:250) at javax.servlet.http.HttpServlet.service(HttpServlet.java:718) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:413) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.rendering.filters.RequestMappingFilter.doFilter(RequestMappingFilter.java:140) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.InitFilter.doFilter(InitFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.BootstrapFilter.doFilter(BootstrapFilter.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:138) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265) at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106) --- ROOT CAUSE --- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getPrevLink' in class org.apache.roller.weblogger.ui.rendering.pagers.WeblogEntriesPreviewPa ger threw exception <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered "NULL" at line 1, column 2324. {SELECT t0.id, t0.allowcomments, t0.anchor, t1.id, t1.description, t1.image, t1.name, t2.id, t2.description, t2.image, t2.name, t2.path, t2.websiteid, t1.path, t3.id, t3.ab out, t3.isactive, t3.allowcomments, t3.blacklist, t4.id, t4.description, t4.image, t4.name, t4.path, t4.websiteid, t5.id, t5.activationcode, t5.datecreated, t5.emailaddress , t5.isenabled, t5.fullname, t5.locale, t5.passphrase, t5.screenname, t5.timeZone, t5.username, t3.customstylesheet, t3.datecreated, t3.defaultallowcomments, t6.id, t6.desc ription, t6.image, t6.name, t6.path, t6.websiteid, t3.defaultcommentdays, t3.defaultpageid, t3.defaultplugins, t3.description, t3.editorpage, t3.editortheme, t3.emailaddres s, t3.emailcomments, t3.emailfromaddress, t3.enablebloggerapi, t3.enablemultilang, t3.isenabled, t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, t3.locale, t3.commentmo d, t3.name, t3.pagemodels, t3.showalllangs, t3.timeZone, t3.weblogdayid, t0.commentdays, t0.content_src, t0.content_type, t7.id, t7.activationcode, t7.datecreated, t7.email address, t7.isenabled, t7.fullname, t7.locale, t7.passphrase, t7.screenname, t7.timeZone, t7.username, t0.link, t0.locale, t0.pinnedtomain, t0.plugins, t0.pubtime, t0.right toleft, t0.status, t0.summary, t0.text, t0.title, t0.updatetime, t8.id, t8.about, t8.isactive, t8.allowcomments, t8.blacklist, t8.bloggercatid, t8.userid, t8.customstyleshe et, t8.datecreated, t8.defaultallowcomments, t8.defaultcatid, t8.defaultcommentdays, t8.defaultpageid, t8.defaultplugins, t8.description, t8.editorpage, t8.editortheme, t8. emailaddress, t8.emailcomments, t8.emailfromaddress, t8.enablebloggerapi, t8.enablemultilang, t8.isenabled, t8.displaycnt, t8.handle, t8.icon, t8.lastmodified, t8.locale, t 8.commentmod, t8.name, t8.pagemodels, t8.showalllangs, t8.timeZone, t8.weblogdayid FROM weblogentry t0 LEFT OUTER JOIN weblogcategory t1 ON t0.categoryid = t1.id LEFT OUTER JOIN rolleruser t7 ON t0.userid = t7.id LEFT OUTER JOIN website t8 ON t0.websiteid = t8.id LEFT OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id LEFT OUTER JOIN website t3 ON t1.websiteid = t3.id LEFT OUTER JOIN weblogcategory t4 ON t3.bloggercatid = t4.id LEFT OUTER JOIN rolleruser t5 ON t3.userid = t5.id LEFT OUTER JOIN weblogcategory t6 ON t3.defaultcatid = t6.id WHERE (t0.websiteid = ? AND t0.status = ? AND t0.pubtime < NULL) ORDER BY t0.pubtime DESC} [code=-1, state=42X01] @ 4295d763-c3a1-4388-9e18-798 9926d9a6d[3,17] at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:205) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) at org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:396) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:64) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:86) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) at org.apache.velocity.Template.merge(Template.java:254) at org.apache.roller.weblogger.ui.rendering.velocity.VelocityRenderer.render(VelocityRenderer.java:145) at org.apache.roller.weblogger.ui.rendering.servlets.PreviewServlet.doGet(PreviewServlet.java:250) at javax.servlet.http.HttpServlet.service(HttpServlet.java:718) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:413) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.rendering.filters.RequestMappingFilter.doFilter(RequestMappingFilter.java:140) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.InitFilter.doFilter(InitFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.BootstrapFilter.doFilter(BootstrapFilter.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:138) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) at org.acegisecurity.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.roller.weblogger.ui.core.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568) at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263) at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214) at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265) at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106) Caused by: <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered "NULL" at line 1, column 2324. {SELECT t 0.id, t0.allowcomments, t0.anchor, t1.id, t1.description, t1.image, t1.name, t2.id, t2.description, t2.image, t2.name, t2.path, t2.websiteid, t1.path, t3.id, t3.about, t3.i sactive, t3.allowcomments, t3.blacklist, t4.id, t4.description, t4.image, t4.name, t4.path, t4.websiteid, t5.id, t5.activationcode, t5.datecreated, t5.emailaddress, t5.isen abled, t5.fullname, t5.locale, t5.passphrase, t5.screenname, t5.timeZone, t5.username, t3.customstylesheet, t3.datecreated, t3.defaultallowcomments, t6.id, t6.description, t6.image, t6.name, t6.path, t6.websiteid, t3.defaultcommentdays, t3.defaultpageid, t3.defaultplugins, t3.description, t3.editorpage, t3.editortheme, t3.emailaddress, t3.ema ilcomments, t3.emailfromaddress, t3.enablebloggerapi, t3.enablemultilang, t3.isenabled, t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, t3.locale, t3.commentmod, t3.nam e, t3.pagemodels, t3.showalllangs, t3.timeZone, t3.weblogdayid, t0.commentdays, t0.content_src, t0.content_type, t7.id, t7.activationcode, t7.datecreated, t7.emailaddress, t7.isenabled, t7.fullname, t7.locale, t7.passphrase, t7.screenname, t7.timeZone, t7.username, t0.link, t0.locale, t0.pinnedtomain, t0.plugins, t0.pubtime, t0.righttoleft, t 0.status, t0.summary, t0.text, t0.title, t0.updatetime, t8.id, t8.about, t8.isactive, t8.allowcomments, t8.blacklist, t8.bloggercatid, t8.userid, t8.customstylesheet, t8.da tecreated, t8.defaultallowcomments, t8.defaultcatid, t8.defaultcommentdays, t8.defaultpageid, t8.defaultplugins, t8.description, t8.editorpage, t8.editortheme, t8.emailaddr ess, t8.emailcomments, t8.emailfromaddress, t8.enablebloggerapi, t8.enablemultilang, t8.isenabled, t8.displaycnt, t8.handle, t8.icon, t8.lastmodified, t8.locale, t8.comment mod, t8.name, t8.pagemodels, t8.showalllangs, t8.timeZone, t8.weblogdayid FROM weblogentry t0 LEFT OUTER JOIN weblogcategory t1 ON t0.categoryid = t1.id LEFT OUTER JOIN rol leruser t7 ON t0.userid = t7.id LEFT OUTER JOIN website t8 ON t0.websiteid = t8.id LEFT OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id LEFT OUTER JOIN website t3 ON t1 .websiteid = t3.id LEFT OUTER JOIN weblogcategory t4 ON t3.bloggercatid = t4.id LEFT OUTER JOIN rolleruser t5 ON t3.userid = t5.id LEFT OUTER JOIN weblogcategory t6 ON t3.d efaultcatid = t6.id WHERE (t0.websiteid = ? AND t0.status = ? AND t0.pubtime < NULL) ORDER BY t0.pubtime DESC} [code=-1, state=42X01] at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3784) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155) at org.apache.openjpa.lib.rop.RangeResultObjectProvider.handleCheckedException(RangeResultObjectProvider.java:130) at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40) at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1219) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:987) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:796) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:766) at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:533) at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:227) at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:269) at org.apache.roller.weblogger.business.jpa.JPAWeblogManagerImpl.getNextPrevEntries(JPAWeblogManagerImpl.java:457) at org.apache.roller.weblogger.business.jpa.JPAWeblogManagerImpl.getPreviousEntry(JPAWeblogManagerImpl.java:1210) at org.apache.roller.weblogger.ui.rendering.pagers.WeblogEntriesPermalinkPager.getPrevEntry(WeblogEntriesPermalinkPager.java:156) at org.apache.roller.weblogger.ui.rendering.pagers.WeblogEntriesPermalinkPager.getPrevLink(WeblogEntriesPermalinkPager.java:118) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:137) at org.apache.velocity.util.introspection.UberspectImpl $VelGetterImpl.invoke(UberspectImpl.java:350) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:180) ... 90 more Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Syntax error: Encountered "NULL" at line 1, column 2324. {SELECT t0.id, t0.allowcomments, t0.anchor, t1.id, t1 .description, t1.image, t1.name, t2.id, t2.description, t2.image, t2.name, t2.path, t2.websiteid, t1.path, t3.id, t3.about, t3.isactive, t3.allowcomments, t3.blacklist, t4. id, t4.description, t4.image, t4.name, t4.path, t4.websiteid, t5.id, t5.activationcode, t5.datecreated, t5.emailaddress, t5.isenabled, t5.fullname, t5.locale, t5.passphrase , t5.screenname, t5.timeZone, t5.username, t3.customstylesheet, t3.datecreated, t3.defaultallowcomments, t6.id, t6.description, t6.image, t6.name, t6.path, t6.websiteid, t3 .defaultcommentdays, t3.defaultpageid, t3.defaultplugins, t3.description, t3.editorpage, t3.editortheme, t3.emailaddress, t3.emailcomments, t3.emailfromaddress, t3.enablebl oggerapi, t3.enablemultilang, t3.isenabled, t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, t3.locale, t3.commentmod, t3.name, t3.pagemodels, t3.showalllangs, t3.timeZo ne, t3.weblogdayid, t0.commentdays, t0.content_src, t0.content_type, t7.id, t7.activationcode, t7.datecreated, t7.emailaddress, t7.isenabled, t7.fullname, t7.locale, t7.pas sphrase, t7.screenname, t7.timeZone, t7.username, t0.link, t0.locale, t0.pinnedtomain, t0.plugins, t0.pubtime, t0.righttoleft, t0.status, t0.summary, t0.text, t0.title, t0. updatetime, t8.id, t8.about, t8.isactive, t8.allowcomments, t8.blacklist, t8.bloggercatid, t8.userid, t8.customstylesheet, t8.datecreated, t8.defaultallowcomments, t8.defau ltcatid, t8.defaultcommentdays, t8.defaultpageid, t8.defaultplugins, t8.description, t8.editorpage, t8.editortheme, t8.emailaddress, t8.emailcomments, t8.emailfromaddress, t8.enablebloggerapi, t8.enablemultilang, t8.isenabled, t8.displaycnt, t8.handle, t8.icon, t8.lastmodified, t8.locale, t8.commentmod, t8.name, t8.pagemodels, t8.showalllangs , t8.timeZone, t8.weblogdayid FROM weblogentry t0 LEFT OUTER JOIN weblogcategory t1 ON t0.categoryid = t1.id LEFT OUTER JOIN rolleruser t7 ON t0.userid = t7.id LEFT OUTER J OIN website t8 ON t0.websiteid = t8.id LEFT OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id LEFT OUTER JOIN website t3 ON t1.websiteid = t3.id LEFT OUTER JOIN weblogcat egory t4 ON t3.bloggercatid = t4.id LEFT OUTER JOIN rolleruser t5 ON t3.userid = t5.id LEFT OUTER JOIN weblogcategory t6 ON t3.defaultcatid = t6.id WHERE (t0.websiteid = ? AND t0.status = ? AND t0.pubtime < NULL) ORDER BY t0.pubtime DESC} [code=-1, state=42X01] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:200) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access $000(LoggingConnectionDecorator.java:56) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator $LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:227) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:163) at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator $ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:163) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager $RefCountConnection.prepareStatement(JDBCStoreManager.java:1308) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:152) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:474) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:454) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:344) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:317) at org.apache.openjpa.jdbc.sql.LogicalUnion $UnionSelect.execute(LogicalUnion.java:407) at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:218) at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:208) at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) at org.apache.openjpa.lib.rop.RangeResultObjectProvider.open(RangeResultObjectProvider.java:74) at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) ... 108 more
