Próbált már valaki bundle-t upgrade-elni 6.0.5-ről a 6.0.6. trunk-ból letöltött, majd fordított verziójára? Volt már, aki sikerrel járt?
Nekem az adatbázis frissítés közben elszáll a folyamat. Egyelőre nem másolnám be a log-ot, csak ha lesz érdeklődő.
Nekem az adatbázis frissítés közben elszáll a folyamat. Egyelőre nem másolnám be a log-ot, csak ha lesz érdeklődő.
Hello!
Amikor először elindítottam a folyamatot, akkor ez történt:
17:25:35,765 INFO [DialectDetector:79] Determine dialect for PostgreSQL 8
17:25:35,873 INFO [DialectDetector:141] Found dialect org.hibernate.dialect.PostgreSQLDialect
17:25:41,508 INFO [PortalImpl:283] Global lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/lib/ext/
17:25:41,540 INFO [PortalImpl:303] Portal lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / December 1, 2010)
17:26:03,002 INFO [BaseDB:398] Database supports case sensitive queries
17:26:03,120 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_6
17:26:03,148 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeSchema
17:26:03,235 WARN [BaseDB:374] ERROR: relation "socialequitygroupsetting" already exists: create table SocialEquityGroupSetting ( equityGroupSettingId LONG not null primary key, groupId LONG, companyId LONG, classNameId LONG, type_ INTEGER, enabled BOOLEAN);
17:26:03,239 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeRSS
17:26:03,246 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
17:26:03,248 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
17:26:03,732 WARN [BaseDB:374] ERROR: relation "formsstructureentry" already exists: create table FormsStructureEntry ( uuid_ VARCHAR(75) null, structureEntryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, structureId VARCHAR(75) null, name VARCHAR(75) null, description STRING null, xsd TEXT null);
17:26:03,736 WARN [BaseDB:374] ERROR: relation "formsstructureentrylink" already exists: create table FormsStructureEntryLink ( structureEntryLinkId LONG not null primary key, structureId VARCHAR(75) null, className VARCHAR(75) null, classPK LONG);
17:26:03,885 WARN [BaseDB:374] ERROR: relation "layoutrevision" already exists: create table LayoutRevision ( layoutRevisionId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, layoutSetBranchId LONG, parentLayoutRevisionId LONG, head BOOLEAN, major BOOLEAN, plid LONG, name STRING null, title STRING null, description STRING null, keywords STRING null, robots STRING null, typeSettings TEXT null, iconImage BOOLEAN, iconImageId LONG, themeId VARCHAR(75) null, colorSchemeId VARCHAR(75) null, wapThemeId VARCHAR(75) null, wapColorSchemeId VARCHAR(75) null, css STRING null, status INTEGER, statusByUserId LONG, statusByUserName VARCHAR(75) null, statusDate DATE null);
17:26:03,895 WARN [BaseDB:374] ERROR: relation "layoutsetbranch" already exists: create table LayoutSetBranch ( layoutSetBranchId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, privateLayout BOOLEAN, name VARCHAR(75) null, description STRING null);
17:26:04,151 WARN [BaseDB:374] ERROR: relation "repository" already exists: create table Repository ( repositoryId LONG not null primary key, groupId LONG, companyId LONG, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, description STRING null, portletId VARCHAR(75) null, type_ INTEGER, typeSettings VARCHAR(75) null, dlFolderId LONG);
17:26:04,156 WARN [BaseDB:374] ERROR: relation "repositoryentry" already exists: create table RepositoryEntry ( repositoryEntryId LONG not null primary key, repositoryId LONG, mappedId VARCHAR(75) null);
17:26:04,201 WARN [BaseDB:374] ERROR: relation "usergroups_teams" already exists: create table UserGroups_Teams ( userGroupId LONG not null, teamId LONG not null, primary key (userGroupId, teamId));
17:26:04,204 WARN [BaseDB:374] ERROR: relation "virtualhost" already exists: create table VirtualHost ( virtualHostId LONG not null primary key, companyId LONG, layoutSetId LONG, hostname VARCHAR(75) null);
17:26:04,224 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
17:26:04,263 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
17:26:04,853 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
17:26:05,471 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
17:26:05,505 ERROR [MainServlet:212] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at com.liferay.portal.events.StartupAction.run(StartupAction.java:55)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1193)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:209)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:93)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:124)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:49)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:197)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:44)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 36 more
Caused by: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2562)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2431)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getLong(NewProxyResultSet.java:2625)
at com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards.doUpgrade(UpgradeMessageBoards.java:45)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 39 more
Stopping the server due to unexpected startup errors
Aztán újra elindítottam a procedúrát, akkor pedig ez:
17:26:41,275 INFO [DialectDetector:79] Determine dialect for PostgreSQL 8
17:26:41,322 INFO [DialectDetector:141] Found dialect org.hibernate.dialect.PostgreSQLDialect
17:26:46,889 INFO [PortalImpl:283] Global lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/lib/ext/
17:26:46,895 INFO [PortalImpl:303] Portal lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / December 1, 2010)
17:27:07,108 INFO [BaseDB:398] Database supports case sensitive queries
17:27:07,127 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_6
17:27:07,129 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeSchema
17:27:07,153 WARN [BaseDB:374] ERROR: column "uuid_" of relation "journalarticleresource" already exists: alter table JournalArticleResource add uuid_ VARCHAR(75) null;
17:27:07,166 WARN [BaseDB:374] ERROR: relation "socialequitygroupsetting" already exists: create table SocialEquityGroupSetting ( equityGroupSettingId LONG not null primary key, groupId LONG, companyId LONG, classNameId LONG, type_ INTEGER, enabled BOOLEAN);
17:27:07,177 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeRSS
17:27:07,181 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
17:27:07,182 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
17:27:07,191 WARN [BaseDB:374] ERROR: column "description" of relation "assetcategory" already exists: alter table AssetCategory add description STRING null;
17:27:07,196 WARN [BaseDB:374] ERROR: column "description" of relation "blogsentry" already exists: alter table BlogsEntry add description STRING null;
17:27:07,202 WARN [BaseDB:374] ERROR: column "smallimage" of relation "blogsentry" already exists: alter table BlogsEntry add smallImage BOOLEAN null;
17:27:07,206 WARN [BaseDB:374] ERROR: column "smallimageid" of relation "blogsentry" already exists: alter table BlogsEntry add smallImageId VARCHAR(75) null;
17:27:07,213 WARN [BaseDB:374] ERROR: column "smallimageurl" of relation "blogsentry" already exists: alter table BlogsEntry add smallImageURL STRING null;
17:27:07,225 WARN [BaseDB:374] ERROR: column "description" of relation "bookmarksentry" already exists: alter table BookmarksEntry add description VARCHAR(75) null;
17:27:07,231 WARN [BaseDB:374] ERROR: column "comments" does not exist
Position: 41: update BookmarksEntry set description = comments;
17:27:07,246 WARN [BaseDB:374] ERROR: column "comments" of relation "bookmarksentry" does not exist: alter table BookmarksEntry drop column comments;
17:27:07,252 WARN [BaseDB:374] ERROR: column "location" of relation "calevent" already exists: alter table CalEvent add location STRING null;
17:27:07,259 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfileentry" already exists: alter table DLFileEntry add repositoryId LONG;
17:27:07,279 WARN [BaseDB:374] ERROR: index "ix_ce705d48" does not exist: drop index IX_CE705D48 on DLFileRank;
17:27:07,288 WARN [BaseDB:374] ERROR: index "ix_40b56512" does not exist: drop index IX_40B56512 on DLFileRank;
17:27:07,295 WARN [BaseDB:374] ERROR: column "fileentryid" of relation "dlfilerank" already exists: alter table DLFileRank add fileEntryId LONG;
17:27:07,299 WARN [BaseDB:374] ERROR: index "ix_55c736ac" does not exist: drop index IX_55C736AC on DLFileShortcut;
17:27:07,307 WARN [BaseDB:374] ERROR: index "ix_346a0992" does not exist: drop index IX_346A0992 on DLFileShortcut;
17:27:07,311 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfileshortcut" already exists: alter table DLFileShortcut add repositoryId LONG;
17:27:07,315 WARN [BaseDB:374] ERROR: column "tofileentryid" of relation "dlfileshortcut" already exists: alter table DLFileShortcut add toFileEntryId LONG;
17:27:07,320 WARN [BaseDB:374] ERROR: index "ix_b413f1ec" does not exist: drop index IX_B413F1EC on DLFileVersion;
17:27:07,323 WARN [BaseDB:374] ERROR: index "ix_94e784d2" does not exist: drop index IX_94E784D2 on DLFileVersion;
17:27:07,328 WARN [BaseDB:374] ERROR: index "ix_2f8fed9c" does not exist: drop index IX_2F8FED9C on DLFileVersion;
17:27:07,331 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfileversion" already exists: alter table DLFileVersion add repositoryId LONG;
17:27:07,335 WARN [BaseDB:374] ERROR: column "fileentryid" of relation "dlfileversion" already exists: alter table DLFileVersion add fileEntryId LONG;
17:27:07,344 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfolder" already exists: alter table DLFolder add repositoryId LONG;
17:27:07,347 WARN [BaseDB:374] ERROR: column "mountpoint" of relation "dlfolder" already exists: alter table DLFolder add mountPoint BOOLEAN null;
17:27:07,355 WARN [BaseDB:374] ERROR: relation "formsstructureentry" already exists: create table FormsStructureEntry ( uuid_ VARCHAR(75) null, structureEntryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, structureId VARCHAR(75) null, name VARCHAR(75) null, description STRING null, xsd TEXT null);
17:27:07,359 WARN [BaseDB:374] ERROR: relation "formsstructureentrylink" already exists: create table FormsStructureEntryLink ( structureEntryLinkId LONG not null primary key, structureId VARCHAR(75) null, className VARCHAR(75) null, classPK LONG);
17:27:07,364 WARN [BaseDB:374] ERROR: column "keywords" of relation "layout" already exists: alter table Layout add keywords STRING null;
17:27:07,373 WARN [BaseDB:374] ERROR: column "robots" of relation "layout" already exists: alter table Layout add robots STRING null;
17:27:07,376 WARN [BaseDB:374] ERROR: column "dlfolderid" of relation "layout" does not exist: alter table Layout drop column dlFolderId;
17:27:07,380 WARN [BaseDB:374] ERROR: relation "layoutrevision" already exists: create table LayoutRevision ( layoutRevisionId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, layoutSetBranchId LONG, parentLayoutRevisionId LONG, head BOOLEAN, major BOOLEAN, plid LONG, name STRING null, title STRING null, description STRING null, keywords STRING null, robots STRING null, typeSettings TEXT null, iconImage BOOLEAN, iconImageId LONG, themeId VARCHAR(75) null, colorSchemeId VARCHAR(75) null, wapThemeId VARCHAR(75) null, wapColorSchemeId VARCHAR(75) null, css STRING null, status INTEGER, statusByUserId LONG, statusByUserName VARCHAR(75) null, statusDate DATE null);
17:27:07,393 WARN [BaseDB:374] ERROR: relation "layoutsetbranch" already exists: create table LayoutSetBranch ( layoutSetBranchId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, privateLayout BOOLEAN, name VARCHAR(75) null, description STRING null);
17:27:07,396 WARN [BaseDB:374] ERROR: column "displaystyle" of relation "mbcategory" already exists: alter table MBCategory add displayStyle VARCHAR(75) null;
17:27:07,401 WARN [BaseDB:374] ERROR: column "format" of relation "mbmessage" already exists: alter table MBMessage add format VARCHAR(75) null;
17:27:07,423 WARN [BaseDB:374] ERROR: column "companyid" of relation "mbthread" already exists: alter table MBThread add companyId LONG;
17:27:07,427 WARN [BaseDB:374] ERROR: column "rootmessageuserid" of relation "mbthread" already exists: alter table MBThread add rootMessageUserId LONG;
17:27:07,431 WARN [BaseDB:374] ERROR: relation "repository" already exists: create table Repository ( repositoryId LONG not null primary key, groupId LONG, companyId LONG, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, description STRING null, portletId VARCHAR(75) null, type_ INTEGER, typeSettings VARCHAR(75) null, dlFolderId LONG);
17:27:07,435 WARN [BaseDB:374] ERROR: relation "repositoryentry" already exists: create table RepositoryEntry ( repositoryEntryId LONG not null primary key, repositoryId LONG, mappedId VARCHAR(75) null);
17:27:07,439 WARN [BaseDB:374] ERROR: column "extradata" of relation "socialequitylog" already exists: alter table SocialEquityLog add extraData VARCHAR(255) null;
17:27:07,442 WARN [BaseDB:374] ERROR: column "status" of relation "user_" already exists: alter table User_ add status int;
17:27:07,456 WARN [BaseDB:374] ERROR: column "active_" does not exist
Position: 35: update User_ set status = 5 where active_ = FALSE;
17:27:07,459 WARN [BaseDB:374] ERROR: column "active_" of relation "user_" does not exist: alter table User_ drop column active_;
17:27:07,463 WARN [BaseDB:374] ERROR: relation "usergroups_teams" already exists: create table UserGroups_Teams ( userGroupId LONG not null, teamId LONG not null, primary key (userGroupId, teamId));
17:27:07,466 WARN [BaseDB:374] ERROR: relation "virtualhost" already exists: create table VirtualHost ( virtualHostId LONG not null primary key, companyId LONG, layoutSetId LONG, hostname VARCHAR(75) null);
17:27:07,469 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
17:27:07,477 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
17:27:07,481 ERROR [MainServlet:212] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at com.liferay.portal.events.StartupAction.run(StartupAction.java:55)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1193)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:209)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:93)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:124)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:49)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:197)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:42)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 36 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateFileRanks(UpgradeDocumentLibrary.java:111)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:36)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 39 more
Stopping the server due to unexpected startup errors
Utána azzal próbálkoztam, hogy a régi, futó liferay példányomon belülről átmigráltam az adatokat egy MySQL adatbázisba, és utána már ment az upgrade. Akkor annyi volt a gond, hogy a karakterkódolás nem volt jó (ő és ű helyett kérdőjelek), illetve a képgaléria fájljai hiányoztak. Mindemellett a képgaléria javascript funkcionalitása se működött. Amikor utólagosan feltöltöttem új képeket, és rájuk kattintottam a képgalériában, nem nyílt meg az AlloyUI diavetítés. Ez azért kritikus, mert ezt az egész bohóckodást azért kezdtem el, hogy a diavetítés menjen IE alatt is.
Szóval ha valakinek van arra ötlete, hogy egy huszárvágással, bundle upgrade nélkül hogyan lehet elérni, hogy a liferay beépített képgalériájának a javascriptes diavetítés funkciója működjön IE alatt is, akkor azért még hálásabb lennék.
Köszönöm a segítséget!
Üdv,
Balázs
Amikor először elindítottam a folyamatot, akkor ez történt:
17:25:35,765 INFO [DialectDetector:79] Determine dialect for PostgreSQL 8
17:25:35,873 INFO [DialectDetector:141] Found dialect org.hibernate.dialect.PostgreSQLDialect
17:25:41,508 INFO [PortalImpl:283] Global lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/lib/ext/
17:25:41,540 INFO [PortalImpl:303] Portal lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / December 1, 2010)
17:26:03,002 INFO [BaseDB:398] Database supports case sensitive queries
17:26:03,120 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_6
17:26:03,148 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeSchema
17:26:03,235 WARN [BaseDB:374] ERROR: relation "socialequitygroupsetting" already exists: create table SocialEquityGroupSetting ( equityGroupSettingId LONG not null primary key, groupId LONG, companyId LONG, classNameId LONG, type_ INTEGER, enabled BOOLEAN);
17:26:03,239 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeRSS
17:26:03,246 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
17:26:03,248 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
17:26:03,732 WARN [BaseDB:374] ERROR: relation "formsstructureentry" already exists: create table FormsStructureEntry ( uuid_ VARCHAR(75) null, structureEntryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, structureId VARCHAR(75) null, name VARCHAR(75) null, description STRING null, xsd TEXT null);
17:26:03,736 WARN [BaseDB:374] ERROR: relation "formsstructureentrylink" already exists: create table FormsStructureEntryLink ( structureEntryLinkId LONG not null primary key, structureId VARCHAR(75) null, className VARCHAR(75) null, classPK LONG);
17:26:03,885 WARN [BaseDB:374] ERROR: relation "layoutrevision" already exists: create table LayoutRevision ( layoutRevisionId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, layoutSetBranchId LONG, parentLayoutRevisionId LONG, head BOOLEAN, major BOOLEAN, plid LONG, name STRING null, title STRING null, description STRING null, keywords STRING null, robots STRING null, typeSettings TEXT null, iconImage BOOLEAN, iconImageId LONG, themeId VARCHAR(75) null, colorSchemeId VARCHAR(75) null, wapThemeId VARCHAR(75) null, wapColorSchemeId VARCHAR(75) null, css STRING null, status INTEGER, statusByUserId LONG, statusByUserName VARCHAR(75) null, statusDate DATE null);
17:26:03,895 WARN [BaseDB:374] ERROR: relation "layoutsetbranch" already exists: create table LayoutSetBranch ( layoutSetBranchId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, privateLayout BOOLEAN, name VARCHAR(75) null, description STRING null);
17:26:04,151 WARN [BaseDB:374] ERROR: relation "repository" already exists: create table Repository ( repositoryId LONG not null primary key, groupId LONG, companyId LONG, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, description STRING null, portletId VARCHAR(75) null, type_ INTEGER, typeSettings VARCHAR(75) null, dlFolderId LONG);
17:26:04,156 WARN [BaseDB:374] ERROR: relation "repositoryentry" already exists: create table RepositoryEntry ( repositoryEntryId LONG not null primary key, repositoryId LONG, mappedId VARCHAR(75) null);
17:26:04,201 WARN [BaseDB:374] ERROR: relation "usergroups_teams" already exists: create table UserGroups_Teams ( userGroupId LONG not null, teamId LONG not null, primary key (userGroupId, teamId));
17:26:04,204 WARN [BaseDB:374] ERROR: relation "virtualhost" already exists: create table VirtualHost ( virtualHostId LONG not null primary key, companyId LONG, layoutSetId LONG, hostname VARCHAR(75) null);
17:26:04,224 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
17:26:04,263 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
17:26:04,853 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
17:26:05,471 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
17:26:05,505 ERROR [MainServlet:212] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at com.liferay.portal.events.StartupAction.run(StartupAction.java:55)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1193)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:209)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:93)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:124)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:49)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:197)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:44)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 36 more
Caused by: org.postgresql.util.PSQLException: The column name MBThread.threadId was not found in this ResultSet.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2562)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2431)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getLong(NewProxyResultSet.java:2625)
at com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards.doUpgrade(UpgradeMessageBoards.java:45)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 39 more
Stopping the server due to unexpected startup errors
Aztán újra elindítottam a procedúrát, akkor pedig ez:
17:26:41,275 INFO [DialectDetector:79] Determine dialect for PostgreSQL 8
17:26:41,322 INFO [DialectDetector:141] Found dialect org.hibernate.dialect.PostgreSQLDialect
17:26:46,889 INFO [PortalImpl:283] Global lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/lib/ext/
17:26:46,895 INFO [PortalImpl:303] Portal lib directory /home/balg/ProfIT/Projektek/Beauty Land/liferay_bundle/tomcat-6.0.29/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / December 1, 2010)
17:27:07,108 INFO [BaseDB:398] Database supports case sensitive queries
17:27:07,127 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_6
17:27:07,129 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeSchema
17:27:07,153 WARN [BaseDB:374] ERROR: column "uuid_" of relation "journalarticleresource" already exists: alter table JournalArticleResource add uuid_ VARCHAR(75) null;
17:27:07,166 WARN [BaseDB:374] ERROR: relation "socialequitygroupsetting" already exists: create table SocialEquityGroupSetting ( equityGroupSettingId LONG not null primary key, groupId LONG, companyId LONG, classNameId LONG, type_ INTEGER, enabled BOOLEAN);
17:27:07,177 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeRSS
17:27:07,181 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
17:27:07,182 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
17:27:07,191 WARN [BaseDB:374] ERROR: column "description" of relation "assetcategory" already exists: alter table AssetCategory add description STRING null;
17:27:07,196 WARN [BaseDB:374] ERROR: column "description" of relation "blogsentry" already exists: alter table BlogsEntry add description STRING null;
17:27:07,202 WARN [BaseDB:374] ERROR: column "smallimage" of relation "blogsentry" already exists: alter table BlogsEntry add smallImage BOOLEAN null;
17:27:07,206 WARN [BaseDB:374] ERROR: column "smallimageid" of relation "blogsentry" already exists: alter table BlogsEntry add smallImageId VARCHAR(75) null;
17:27:07,213 WARN [BaseDB:374] ERROR: column "smallimageurl" of relation "blogsentry" already exists: alter table BlogsEntry add smallImageURL STRING null;
17:27:07,225 WARN [BaseDB:374] ERROR: column "description" of relation "bookmarksentry" already exists: alter table BookmarksEntry add description VARCHAR(75) null;
17:27:07,231 WARN [BaseDB:374] ERROR: column "comments" does not exist
Position: 41: update BookmarksEntry set description = comments;
17:27:07,246 WARN [BaseDB:374] ERROR: column "comments" of relation "bookmarksentry" does not exist: alter table BookmarksEntry drop column comments;
17:27:07,252 WARN [BaseDB:374] ERROR: column "location" of relation "calevent" already exists: alter table CalEvent add location STRING null;
17:27:07,259 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfileentry" already exists: alter table DLFileEntry add repositoryId LONG;
17:27:07,279 WARN [BaseDB:374] ERROR: index "ix_ce705d48" does not exist: drop index IX_CE705D48 on DLFileRank;
17:27:07,288 WARN [BaseDB:374] ERROR: index "ix_40b56512" does not exist: drop index IX_40B56512 on DLFileRank;
17:27:07,295 WARN [BaseDB:374] ERROR: column "fileentryid" of relation "dlfilerank" already exists: alter table DLFileRank add fileEntryId LONG;
17:27:07,299 WARN [BaseDB:374] ERROR: index "ix_55c736ac" does not exist: drop index IX_55C736AC on DLFileShortcut;
17:27:07,307 WARN [BaseDB:374] ERROR: index "ix_346a0992" does not exist: drop index IX_346A0992 on DLFileShortcut;
17:27:07,311 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfileshortcut" already exists: alter table DLFileShortcut add repositoryId LONG;
17:27:07,315 WARN [BaseDB:374] ERROR: column "tofileentryid" of relation "dlfileshortcut" already exists: alter table DLFileShortcut add toFileEntryId LONG;
17:27:07,320 WARN [BaseDB:374] ERROR: index "ix_b413f1ec" does not exist: drop index IX_B413F1EC on DLFileVersion;
17:27:07,323 WARN [BaseDB:374] ERROR: index "ix_94e784d2" does not exist: drop index IX_94E784D2 on DLFileVersion;
17:27:07,328 WARN [BaseDB:374] ERROR: index "ix_2f8fed9c" does not exist: drop index IX_2F8FED9C on DLFileVersion;
17:27:07,331 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfileversion" already exists: alter table DLFileVersion add repositoryId LONG;
17:27:07,335 WARN [BaseDB:374] ERROR: column "fileentryid" of relation "dlfileversion" already exists: alter table DLFileVersion add fileEntryId LONG;
17:27:07,344 WARN [BaseDB:374] ERROR: column "repositoryid" of relation "dlfolder" already exists: alter table DLFolder add repositoryId LONG;
17:27:07,347 WARN [BaseDB:374] ERROR: column "mountpoint" of relation "dlfolder" already exists: alter table DLFolder add mountPoint BOOLEAN null;
17:27:07,355 WARN [BaseDB:374] ERROR: relation "formsstructureentry" already exists: create table FormsStructureEntry ( uuid_ VARCHAR(75) null, structureEntryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, structureId VARCHAR(75) null, name VARCHAR(75) null, description STRING null, xsd TEXT null);
17:27:07,359 WARN [BaseDB:374] ERROR: relation "formsstructureentrylink" already exists: create table FormsStructureEntryLink ( structureEntryLinkId LONG not null primary key, structureId VARCHAR(75) null, className VARCHAR(75) null, classPK LONG);
17:27:07,364 WARN [BaseDB:374] ERROR: column "keywords" of relation "layout" already exists: alter table Layout add keywords STRING null;
17:27:07,373 WARN [BaseDB:374] ERROR: column "robots" of relation "layout" already exists: alter table Layout add robots STRING null;
17:27:07,376 WARN [BaseDB:374] ERROR: column "dlfolderid" of relation "layout" does not exist: alter table Layout drop column dlFolderId;
17:27:07,380 WARN [BaseDB:374] ERROR: relation "layoutrevision" already exists: create table LayoutRevision ( layoutRevisionId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, layoutSetBranchId LONG, parentLayoutRevisionId LONG, head BOOLEAN, major BOOLEAN, plid LONG, name STRING null, title STRING null, description STRING null, keywords STRING null, robots STRING null, typeSettings TEXT null, iconImage BOOLEAN, iconImageId LONG, themeId VARCHAR(75) null, colorSchemeId VARCHAR(75) null, wapThemeId VARCHAR(75) null, wapColorSchemeId VARCHAR(75) null, css STRING null, status INTEGER, statusByUserId LONG, statusByUserName VARCHAR(75) null, statusDate DATE null);
17:27:07,393 WARN [BaseDB:374] ERROR: relation "layoutsetbranch" already exists: create table LayoutSetBranch ( layoutSetBranchId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, privateLayout BOOLEAN, name VARCHAR(75) null, description STRING null);
17:27:07,396 WARN [BaseDB:374] ERROR: column "displaystyle" of relation "mbcategory" already exists: alter table MBCategory add displayStyle VARCHAR(75) null;
17:27:07,401 WARN [BaseDB:374] ERROR: column "format" of relation "mbmessage" already exists: alter table MBMessage add format VARCHAR(75) null;
17:27:07,423 WARN [BaseDB:374] ERROR: column "companyid" of relation "mbthread" already exists: alter table MBThread add companyId LONG;
17:27:07,427 WARN [BaseDB:374] ERROR: column "rootmessageuserid" of relation "mbthread" already exists: alter table MBThread add rootMessageUserId LONG;
17:27:07,431 WARN [BaseDB:374] ERROR: relation "repository" already exists: create table Repository ( repositoryId LONG not null primary key, groupId LONG, companyId LONG, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, description STRING null, portletId VARCHAR(75) null, type_ INTEGER, typeSettings VARCHAR(75) null, dlFolderId LONG);
17:27:07,435 WARN [BaseDB:374] ERROR: relation "repositoryentry" already exists: create table RepositoryEntry ( repositoryEntryId LONG not null primary key, repositoryId LONG, mappedId VARCHAR(75) null);
17:27:07,439 WARN [BaseDB:374] ERROR: column "extradata" of relation "socialequitylog" already exists: alter table SocialEquityLog add extraData VARCHAR(255) null;
17:27:07,442 WARN [BaseDB:374] ERROR: column "status" of relation "user_" already exists: alter table User_ add status int;
17:27:07,456 WARN [BaseDB:374] ERROR: column "active_" does not exist
Position: 35: update User_ set status = 5 where active_ = FALSE;
17:27:07,459 WARN [BaseDB:374] ERROR: column "active_" of relation "user_" does not exist: alter table User_ drop column active_;
17:27:07,463 WARN [BaseDB:374] ERROR: relation "usergroups_teams" already exists: create table UserGroups_Teams ( userGroupId LONG not null, teamId LONG not null, primary key (userGroupId, teamId));
17:27:07,466 WARN [BaseDB:374] ERROR: relation "virtualhost" already exists: create table VirtualHost ( virtualHostId LONG not null primary key, companyId LONG, layoutSetId LONG, hostname VARCHAR(75) null);
17:27:07,469 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
17:27:07,477 INFO [UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
17:27:07,481 ERROR [MainServlet:212] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at com.liferay.portal.events.StartupAction.run(StartupAction.java:55)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1193)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:209)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:93)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:124)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:49)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:197)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:42)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 36 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "folderid" does not exist
Position: 29
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateFileRanks(UpgradeDocumentLibrary.java:111)
at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:36)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 39 more
Stopping the server due to unexpected startup errors
Utána azzal próbálkoztam, hogy a régi, futó liferay példányomon belülről átmigráltam az adatokat egy MySQL adatbázisba, és utána már ment az upgrade. Akkor annyi volt a gond, hogy a karakterkódolás nem volt jó (ő és ű helyett kérdőjelek), illetve a képgaléria fájljai hiányoztak. Mindemellett a képgaléria javascript funkcionalitása se működött. Amikor utólagosan feltöltöttem új képeket, és rájuk kattintottam a képgalériában, nem nyílt meg az AlloyUI diavetítés. Ez azért kritikus, mert ezt az egész bohóckodást azért kezdtem el, hogy a diavetítés menjen IE alatt is.
Szóval ha valakinek van arra ötlete, hogy egy huszárvágással, bundle upgrade nélkül hogyan lehet elérni, hogy a liferay beépített képgalériájának a javascriptes diavetítés funkciója működjön IE alatt is, akkor azért még hálásabb lennék.
Köszönöm a segítséget!
Üdv,
Balázs
