You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Charles Mason <ch...@gmail.com> on 2007/10/31 16:43:42 UTC
Roller RC9 4.0 Upgrade Problems
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
Re: Roller RC9 4.0 Upgrade Problems
Posted by Dave <sn...@gmail.com>.
I have not been able to reproduce this problem.
Anybody else see this in upgrade testing?
- Dave
On 11/2/07, Charles Mason <ch...@gmail.com> wrote:
> On 01/11/2007, Anil Gangolli <an...@busybuddha.org> wrote:
> > Charles, can you also include which Roller version you were upgrading from ?
>
> I was upgrading to Roller 4.0 RC9 from Roller 3.1, which was in use
> on a relatively low traffic production site for a few months.
>
> From what I remember the Roller 3.1 database was upgraded from roller
> 3.0 previously, although I can't be 100% sure of that.
>
> Hope that helps.
>
> Charlie M
>
Re: Roller RC9 4.0 Upgrade Problems
Posted by Charles Mason <ch...@gmail.com>.
On 01/11/2007, Anil Gangolli <an...@busybuddha.org> wrote:
> Charles, can you also include which Roller version you were upgrading from ?
I was upgrading to Roller 4.0 RC9 from Roller 3.1, which was in use
on a relatively low traffic production site for a few months.
>From what I remember the Roller 3.1 database was upgraded from roller
3.0 previously, although I can't be 100% sure of that.
Hope that helps.
Charlie M
Re: Roller RC9 4.0 Upgrade Problems
Posted by Anil Gangolli <an...@busybuddha.org>.
Charles, can you also include which Roller version you were upgrading from ?
--a.
Charles Mason wrote:
> On 01/11/2007, Dave <sn...@gmail.com> wrote:
>
>> Based on the stack trace above, it sure looks like the SQL upgrade
>> script failed to create the required column 'path' in the table
>> 'folder'. That is a serious problem and it is somewhat disturbing that
>> you did not get an error message during the auto-upgrade process.
>>
>> Please answer the standard questions (what O/S, Java version, etc.):
>> http://cwiki.apache.org/confluence/display/ROLLER/Roller+Mailing+Lists
>>
>> Also, can you confirm that field is missing from the database?
>>
>> - Dave
>>
>>
>
> I have just checked the "upgraded" DB and you are correct there is no
> path column.
>
> The DB upgrade appeared to go flawlessly, until now I was very
> impressed with the new installer. The rest of the DB upgrade seems to
> be working. Still it is a release candidate so its best caught now
> rather than later. I have include the info you asked for below.
>
> Roller Version: 4.0 RC9
> Operating System: Ubuntu Gusty Gibbon Server
> Web Server: Jboss Web 1.0.1 GA (it's basically tomcat, with APR based
> static content serving)
> DB: MySQL 5.0
> Java: Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
>
> As a work around I manually added the Path column and it now appears
> to work fine.
>
> If there is anything else you need to know let me know. I will have
> another ago to confirm this bug is repeatable.
>
> Hope that helps
>
> Charlie M
>
Re: Roller RC9 4.0 Upgrade Problems
Posted by Charles Mason <ch...@gmail.com>.
On 01/11/2007, Dave <sn...@gmail.com> wrote:
> Based on the stack trace above, it sure looks like the SQL upgrade
> script failed to create the required column 'path' in the table
> 'folder'. That is a serious problem and it is somewhat disturbing that
> you did not get an error message during the auto-upgrade process.
>
> Please answer the standard questions (what O/S, Java version, etc.):
> http://cwiki.apache.org/confluence/display/ROLLER/Roller+Mailing+Lists
>
> Also, can you confirm that field is missing from the database?
>
> - Dave
>
I have just checked the "upgraded" DB and you are correct there is no
path column.
The DB upgrade appeared to go flawlessly, until now I was very
impressed with the new installer. The rest of the DB upgrade seems to
be working. Still it is a release candidate so its best caught now
rather than later. I have include the info you asked for below.
Roller Version: 4.0 RC9
Operating System: Ubuntu Gusty Gibbon Server
Web Server: Jboss Web 1.0.1 GA (it's basically tomcat, with APR based
static content serving)
DB: MySQL 5.0
Java: Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
As a work around I manually added the Path column and it now appears
to work fine.
If there is anything else you need to know let me know. I will have
another ago to confirm this bug is repeatable.
Hope that helps
Charlie M
Re: Roller RC9 4.0 Upgrade Problems
Posted by Dave <sn...@gmail.com>.
On 10/31/07, Charles Mason <ch...@gmail.com> wrote:
> 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...
> 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.
>
> --- ROOT CAUSE ---
> org.apache.openjpa.persistence.ArgumentException: Unknown column
> 't1.path' in 'field list' {prepstmnt 13247337 SELECT t0.id,
...
> 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
Based on the stack trace above, it sure looks like the SQL upgrade
script failed to create the required column 'path' in the table
'folder'. That is a serious problem and it is somewhat disturbing that
you did not get an error message during the auto-upgrade process.
Please answer the standard questions (what O/S, Java version, etc.):
http://cwiki.apache.org/confluence/display/ROLLER/Roller+Mailing+Lists
Also, can you confirm that field is missing from the database?
- Dave