Nate Keegan wrote:
Tried the following combinations:
Solaris 10 update 3 and Solaris 10 update 4 - global zone, sparse-root
non global zone, whole root non-global zone
GlassFish 2 update 1
MySQL 5.0.37
JDK 5.0
Is anyone on the list using this combination of items (application
server, database, etc) successfully with Roller 4 and Planet Roller?
I upgraded from Roller 3.1rc1 to 4.0, running on
Solaris 10 3/05 non-global zone
JDK 1.6.0_03 (upgraded from 1.5.0_06)
Tomcat 6.0.14 (upgraded from 5.5.9) with jsvc on port 80
MySQL 4.1.18 (from blastwave.org)
I had a couple of problems during the upgrade due to corrupted database entries
(the roller source code helped me figure out where it was failing)
- manual upgrade of the database with the 310-to-400 script had no
errors but roller failed to start with "not bootstrapped" errors.
Auto-upgrade was failing with "java.sql.SQLException: Duplicate entry
weblogger:null" in upgradeTo400(DatabaseInstaller.java:1004)
Fixed by deleting old users from the rag_subscription table
(their blogs were still listed but with NULL user)
- Planet was not updating. Error was "Cannot convert value '0000-00-00 00:00:00'
from column 6 to TIMESTAMP."
Fixed by setting rag_subscription.last_updated=CURRENT_TIMESTAMP for entries
with last_updated=0
- Some Planet entries for external blogs were always duplicated.
Fixed by deleting the subscriptions manually in mysql and redefining them in the
Planet administration page (after deleting them in the Admin page they were
still showing in the database, there might have been duplicated).
