On 10/31/07, Charles Mason <[EMAIL PROTECTED]> 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 ONBased 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
