You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Stephan Mühlstrasser <st...@web.de> on 2008/10/03 20:44:11 UTC

404 error when clicking button "Full Preview" with Roller 4.0

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