roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mlus <m...@39596.com>
Subject Upgrade from 4.0.1 to 5.0
Date Fri, 01 Jul 2011 17:24:53 GMT
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.

Mime
View raw message