On a staging server I have upgraded copy of my existing roller site to
roller 4.0. RC9. I used the installer to upgrade the DB which worked
fine. I successfully built a new frontpage derived theme. That appears
to work fine showing the previous posts from all the blogs from before
the upgrade.
However when I tried to visit one of the actual blogs I get a 404
error. Looking at the output of the logs its clear it was having
problems with the custom themes the blog used. So in the DB I changed
it to Basic. However I now seem to have found a bug in roller 4.0. I
get an exception related to the bookmarks system. If I go to the edit
bookmarks page of the roller-ui I also get the same execption. This
also happens with the other stock themes so I think its more serious
than just a theme problem.
I have posted the exception info below. Any help anyone can give me
would be greatly appreacted.
--- ROOT CAUSE ---
org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getBookmarkFolder' in class
org.apache.roller.weblogger.pojos.wrapper.WeblogWrapper threw
exception <0.9.7-incubating nonfatal user error>
org.apache.openjpa.persistence.ArgumentException: Unknown column
't1.path' in 'field list' {prepstmnt 13247337 SELECT t0.id,
t0.description, t0.name, t1.id, t1.description, t1.name, t1.path,
t1.websiteid, t0.path, t2.id, t2.about, t2.isactive, t2.allowcomments,
t2.blacklist, t3.id, t3.description, t3.image, t3.name, t4.id,
t4.description, t4.image, t4.name, t4.path, t4.websiteid, t3.path,
t5.id, t5.about, t5.isactive, t5.allowcomments, t5.blacklist,
t5.bloggercatid, t5.userid, t5.customstylesheet, t5.datecreated,
t5.defaultallowcomments, t5.defaultcatid, t5.defaultcommentdays,
t5.defaultpageid, t5.defaultplugins, t5.description, t5.editorpage,
t5.editortheme, t5.emailaddress, t5.emailcomments,
t5.emailfromaddress, t5.enablebloggerapi, t5.enablemultilang,
t5.isenabled, t5.displaycnt, t5.handle, t5.icon, t5.lastmodified,
t5.locale, t5.commentmod, t5.name, t5.pagemodels, t5.showalllangs,
t5.timeZone, t5.weblogdayid, t6.id, t6.activationcode, t6.datecreated,
t6.emailaddress, t6.isenabled, t6.fullname, t6.locale, t6.passphrase,
t6.screenname, t6.timeZone, t6.username, t2.customstylesheet,
t2.datecreated, t2.defaultallowcomments, t7.id, t7.description,
t7.image, t7.name, t7.parentid, t7.path, t7.websiteid,
t2.defaultcommentdays, t2.defaultpageid, t2.defaultplugins,
t2.description, t2.editorpage, t2.editortheme, t2.emailaddress,
t2.emailcomments, t2.emailfromaddress, t2.enablebloggerapi,
t2.enablemultilang, t2.isenabled, t2.displaycnt, t2.handle, t2.icon,
t2.lastmodified, t2.locale, t2.commentmod, t2.name, t2.pagemodels,
t2.showalllangs, t2.timeZone, t2.weblogdayid FROM folder t0 LEFT OUTER
JOIN folder t1 ON t0.parentid = t1.id LEFT OUTER JOIN website t2 ON
t0.websiteid = t2.id LEFT OUTER JOIN weblogcategory t3 ON
t2.bloggercatid = t3.id LEFT OUTER JOIN rolleruser t6 ON t2.userid =
t6.id LEFT OUTER JOIN weblogcategory t7 ON t2.defaultcatid = t7.id
LEFT OUTER JOIN weblogcategory t4 ON t3.parentid = t4.id LEFT OUTER
JOIN website t5 ON t3.websiteid = t5.id WHERE (t0.websiteid = ? AND
t0.parentid IS NULL) [params=(String)
40288286119037e10111903f0f120002]} [code=1054, state=42S22] @
basic:sidebar[20,38]
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:286)
........................
Charlie M
