[
https://issues.apache.org/jira/browse/ROL-1778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678098#comment-13678098
]
Glen Mazza commented on ROL-1778:
---------------------------------
OK, this happens whether or not there's an accent mark in Derby, the Roller log
notes:
org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered
"NULL" at line 1, column 1967. {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.parentid, t4.path, t4.websiteid, t3.creator, t3.customstylesheet,
t3.datecreated, t3.defaultallowcomments, t5.id, t5.description, t5.image,
t5.name, t5.parentid, t5.path, t5.websiteid, t3.defaultcommentdays,
t3.defaultpageid, t3.defaultplugins, t3.description, t3.editorpage,
t3.editortheme, t3.emailaddress, t3.emailcomments, t3.emailfromaddress,
t3.enablebloggerapi, t3.enablemultilang, t3.isenabled, t3.displaycnt,
t3.handle, t3.icon, t3.lastmodified, t3.locale, t3.commentmod, t3.name,
t3.pagemodels, t3.showalllangs, t3.timeZone, t3.weblogdayid, t0.commentdays,
t0.content_src, t0.content_type, t0.creator, t0.link, t0.locale,
t0.pinnedtomain, t0.plugins, t0.pubtime, t0.righttoleft, t0.status, t0.summary,
t0.text, t0.title, t0.updatetime, t6.id, t6.about, t6.isactive,
t6.allowcomments, t6.blacklist, t6.bloggercatid, t6.creator,
t6.customstylesheet, t6.datecreated, t6.defaultallowcomments, t6.defaultcatid,
t6.defaultcommentdays, t6.defaultpageid, t6.defaultplugins, t6.description,
t6.editorpage, t6.editortheme, t6.emailaddress, t6.emailcomments,
t6.emailfromaddress, t6.enablebloggerapi, t6.enablemultilang, t6.isenabled,
t6.displaycnt, t6.handle, t6.icon, t6.lastmodified, t6.locale, t6.commentmod,
t6.name, t6.pagemodels, t6.showalllangs, t6.timeZone, t6.weblogdayid FROM
weblogentry t0 LEFT OUTER JOIN weblogcategory t1 ON t0.categoryid = t1.id LEFT
OUTER JOIN website t6 ON t0.websiteid = t6.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
weblogcategory t5 ON t3.defaultcatid = t5.id WHERE (t0.websiteid = ? AND
t0.status = ? AND t0.pubtime < NULL) ORDER BY t0.pubtime DESC} [code=30000,
state=42X01]
Where column 1967 is the "t0.pubtime < NULL" (it should be IS NULL instead) --
perhaps MySQL doesn't mind that syntax or perhaps OpenJPA translates it
differently with the MySQL driver.
> Full Preview breal if title has accents
> ---------------------------------------
>
> Key: ROL-1778
> URL: https://issues.apache.org/jira/browse/ROL-1778
> Project: Roller
> Issue Type: Bug
> Components: Weblog Editor
> Affects Versions: 4.0.1
> Environment: Red Hat 5.2 + Sun JDK 1.6 + Tomcat 6.0.18
> Reporter: José Arthur Benetasso Villanova
> Assignee: Glen Mazza
> Priority: Trivial
>
> Full preview fails if title has accents.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
