It looks like the database upgrade script did not run. I see that you have "installation.type=auto" set, which is good. After you started Roller the first time, did you browse to Roller and press the button to start the upgrade script? Any error messages from that would be helpful here.
- Dave On Fri, Jul 1, 2011 at 1:24 PM, mlus <[email protected]> wrote: > Hi, I use Apache Roller version 4.0.1 in tomcat 7. > Now I want to upgrade from 4.0.1 to 5.0 , but can't start roller. > > I try to this , > --------------------------------------------------------------------------------------- > Down load roller-weblogger-5.0.0-for-tomcat.zip . > Rename roller-5.0.0-tomcat.war to roller.war and put it to > $CATALINA_HOME/webapps/ and > unpack roller.war. > > Copy roller_data dir from OLD roller app(4.0.1) to $CATALINA_HOME/ and > create mediafiles dir. > Copy some thema from OLD roller app (4.0.1) to themes. > Create roller-custom.properties. > > installation.type=auto > database.configurationType=jdbc > database.jdbc.driverClass=org.postgresql.Driver > database.jdbc.connectionURL=jdbc:postgresql://[xxxxxx]:5432/rollerdb > database.jdbc.username=[xxxx] > database.jdbc.password=[xxxxxxx] > mail.configurationType=properties > mail.hostname=localhost > mail.username=[xxxxx] > mail.password=[xxxxxx] > > mediafiles.storage.dir=/usr/local/tomcat/roller_data/mediafiles > uploads.dir=/usr/local/tomcat/roller_data/uploads > search.index.dir=/usr/local/tomcat/roller_data/searchindex > uploads.migrate.auto=true > ---------------------------------------------------------------------------------- > > Run tomcat and connect roller , error log found. > > ERROR: column t3.creator does not exist ?????: 265 {prepstmnt 31003522 > SELECT t0.id, t0.about, t0.isactive, t0.allowcomments, t0.blacklist, > 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, t3.bloggercatid, > t3.creator, t3.customstylesheet, t3.datecreated, > t3.defaultallowcomments, t3.defaultcatid, 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.creator, t0.customstylesheet, > t0.datecreated, t0.defaultallowcomments, t4.id, t4.description, > t4.image, t4.name, t4.parentid, t4.path, t4.websiteid, > t0.defaultcommentdays, t0.defaultpageid, t0.defaultplugins, > t0.description, t0.editorpage, t0.editortheme, t0.emailaddress, > t0.emailcomments, t0.emailfromaddress, t0.enablebloggerapi, > t0.enablemultilang, t0.isenabled, t0.displaycnt, t0.handle, t0.icon, > t0.lastmodified, t0.locale, t0.commentmod, t0.name, t0.pagemodels, > t0.showalllangs, t0.timeZone, t0.weblogdayid FROM website t0 LEFT > OUTER JOIN weblogcategory t1 ON t0.bloggercatid = t1.id LEFT OUTER > JOIN weblogcategory t4 ON t0.defaultcatid = t4.id LEFT OUTER JOIN > weblogcategory t2 ON t1.parentid = t2.id LEFT OUTER JOIN website t3 ON > t1.websiteid = t3.id WHERE (t0.isenabled = ?) ORDER BY t0.datecreated > DESC [params=?]} [code=0, state=42703] > > What's wrong ? > > thank you. >
