Problems upgrading

Problems upgrading

Hi there,

I'm having problems upgrading Zoho with the latest service pack

I've dowloaded Zoho_Virtual_Office_3_1_0_SP-3_0.ppm

Installed upgrades:
AdventNet_Zoho_Virtual_Office_3_0_0_SP-0_3.ppm
AdventNet_Zoho_Virtual_Office_I18n_1.ppm
Zoho_Virtual_Office_3_1_0_SP-1_0.ppm
Zoho_Virtual_Office_3_1_0_SP-1_2.ppm

This is what I get on console:


Apr 18, 2006 12:04:28 PM com.adventnet.vo.updatemgr.util.PQPostProcessor <clinit>
INFO: Inside static PQPostProcessor
Apr 18, 2006 12:04:28 PM com.adventnet.vo.updatemgr.util.PQPostProcessor installINFO: Inside install PQPostProcessor
Apr 18, 2006 12:04:28 PM com.adventnet.vo.updatemgr.util.PQPostProcessor performDBChanges
INFO: Inside performDBChanges PQPostProcessor
Apr 18, 2006 12:04:29 PM com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [sh, ./bin/startDB.sh, 33309, <***PATH**>/VirtualOffice/mysql/tmp]
DB_HOME ./bin/../mysql DB_PORT 33309 TMP_HOME <***PATH**>/VirtualOffice/mysql/tmp
060418 12:04:29 [Warning] Asked for 196608 thread stack, but got 126976
060418 12:04:29 [Warning] One can only use the --user switch if running as root

060418 12:04:29 InnoDB: Started; log sequence number 0 214009627
./bin/../mysql/bin/mysqld: ready for connections.
Version: '4.1.7-pro' socket: '<***PATH***>/VirtualOffice/mysql/tmp/mysql.sock' port: 33309 Official MySQL-pro binary
Apr 18, 2006 12:04:30 PM com.adventnet.vo.updatemgr.util.PQPostProcessor performDBChanges
INFO: MySQL started successfully
Apr 18, 2006 12:04:34 PM com.adventnet.vo.updatemgr.util.PQPostProcessor doMigration
WARNING: MyContact.MAILFREQUENCY may exist alreadyA column with this name : MAILFREQUENCY already exists in this table : MyContact
Apr 18, 2006 12:04:34 PM com.adventnet.vo.updatemgr.util.PQPostProcessor doMigration
WARNING: ssh context may exist already[ModuleContext] Exception occured while inserting rows
Apr 18, 2006 12:04:34 PM com.adventnet.vo.updatemgr.util.PQPostProcessor doMigration
WARNING: TOPICID may alreay exists in Task tableA column with this name : TOPICID already exists in this table : Task
Added column MailOptions.DELETEMESSAGESONSERVER
Added column MailOptions.EXPUNGEFOLDER
Added column PopStatus.FOLDERNAME
Added column MessageArchive.TOBEINDEXED
Successfully created table UserWAPSettingsDef
Successfully created table UserWAPSettings
com.adventnet.persistence.DataAccessException: [OrgSettings] Exception occured while inserting rows
at com.adventnet.persistence.DataAccess.createDataAccessException(DataAccess.java:2559)
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2203) at com.adventnet.persistence.DataAccess.add(DataAccess.java:293)
at com.adventnet.persistence.DataAccess.add(DataAccess.java:250)
at com.adventnet.vo.updatemgr.util.PQPostProcessor.orgSettingsWAPMigration(PQPostProcessor.java:795)
at com.adventnet.vo.updatemgr.util.PQPostProcessor.doMigration(PQPostProcessor.java:300)
at com.adventnet.vo.updatemgr.util.PQPostProcessor.performDBChanges(PQPostProcessor.java:140)
at com.adventnet.vo.updatemgr.util.PQPostProcessor.install(PQPostProcessor.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1259)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1092)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:290)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:224)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: null, message from server: "Duplicate entry '2' for key 1"
at com.adventnet.db.api.RelationalAPI.handleException(RelationalAPI.java:690)
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:665)
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2169) ... 15 more
Caused by: java.sql.BatchUpdateException: null, message from server: "Duplicate entry '2' for key 1"
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1401)
at org.enhydra.jdbc.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:410)
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:661)
... 16 more