Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Demo Demo
Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
February 21, 2012 6:33 AM
Answer

Demo Demo

Rank: New Member

Posts: 2

Join Date: November 8, 2010

Recent Posts

Hi all!

I hope you can help me to migrate my Liferay setup from 6.0.6 to 6.1. Unfortunateley, it's still configured with HSQLDB because I cannot migrate the data to MySQL DB.

During the Upgrade from 6.0.6 to 6.1.0 CE GA1 I get two error messages:

First start:
integrity constraint violation: unique constraint or index violation: IX_ED5CA615

Second Liferay start without changing anything in portal-ext.properties:
user lacks privilege or object not found: IGFOLDER

My portal-ext.properties file contains only:
# store all images on the filesystem
image.hook.impl=com.liferay.portal.image.FileSystemHook

Full catalina.out file output:
  1
  2Feb 21, 2012 1:11:08 PM org.apache.catalina.core.AprLifecycleListener init
  3INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
  4Feb 21, 2012 1:11:09 PM org.apache.coyote.AbstractProtocol init
  5INFO: Initializing ProtocolHandler ["http-bio-8080"]
  6Feb 21, 2012 1:11:09 PM org.apache.coyote.AbstractProtocol init
  7INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
  8Feb 21, 2012 1:11:09 PM org.apache.catalina.startup.Catalina load
  9INFO: Initialization processed in 409 ms
 10Feb 21, 2012 1:11:09 PM org.apache.catalina.core.StandardService startInternal
 11INFO: Starting service Catalina
 12Feb 21, 2012 1:11:09 PM org.apache.catalina.core.StandardEngine startInternal
 13INFO: Starting Servlet Engine: Apache Tomcat/7.0.23
 14Feb 21, 2012 1:11:09 PM org.apache.catalina.startup.HostConfig deployDescriptor
 15INFO: Deploying configuration descriptor /opt/liferay-portal-6.1.0/tomcat-7.0.23/conf/Catalina/localhost/ROOT.xml
 16Loading jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
 1713:11:10,181 INFO  [EasyConf:122] Refreshed the configuration of all components
 1813:11:10,439 INFO  [ConfigurationLoader:56] Properties for jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal loaded from [file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/classes/portal-ext.properties, jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties]
 19Loading jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
 20Loading file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/classes/portal-ext.properties
 2113:11:17,719 INFO  [DialectDetector:80] Determine dialect for HSQL Database Engine 2
 2213:11:17,720 WARN  [DialectDetector:95] Liferay is configured to use Hypersonic as its database. Do NOT use Hypersonic in production. Hypersonic is an embedded database useful for development and demo'ing purposes. The database settings can be changed in portal-ext.properties.
 2313:11:17,753 INFO  [DialectDetector:145] Found dialect org.hibernate.dialect.HSQLDialect
 24Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / January 6, 2012)
 2513:11:39,993 INFO  [BaseDB:406] Database supports case sensitive queries
 2613:11:40,126 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
 2713:11:40,144 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
 2813:11:40,724 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
 2913:11:40,748 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
 3013:11:40,826 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
 3113:11:40,849 INFO  [Table:171] Starting backup of BlogsEntry to /opt/liferay-portal-6.1.0/tomcat-7.0.23/temp/temp-db-BlogsEntry-1329829900848
 3213:11:40,857 INFO  [Table:207] Finished backup of BlogsEntry to /opt/liferay-portal-6.1.0/tomcat-7.0.23/temp/temp-db-BlogsEntry-1329829900848 in 8 ms
 3313:11:40,870 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
 3413:11:41,868 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
 3513:11:41,889 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
 3613:11:42,057 INFO  [Table:171] Starting backup of DLFileVersion to /opt/liferay-portal-6.1.0/tomcat-7.0.23/temp/temp-db-DLFileVersion-1329829902057
 3713:11:42,078 INFO  [Table:207] Finished backup of DLFileVersion to /opt/liferay-portal-6.1.0/tomcat-7.0.23/temp/temp-db-DLFileVersion-1329829902057 in 21 ms
 3813:11:42,150 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
 3913:11:42,155 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
 4013:11:42,159 INFO  [Table:171] Starting backup of Group_ to /opt/liferay-portal-6.1.0/tomcat-7.0.23/temp/temp-db-Group_-1329829902159
 4113:11:42,161 INFO  [Table:207] Finished backup of Group_ to /opt/liferay-portal-6.1.0/tomcat-7.0.23/temp/temp-db-Group_-1329829902159 in 2 ms
 4213:11:42,175 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
 4313:11:42,265 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: integrity constraint violation: unique constraint or index violation: IX_ED5CA615
 44com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: integrity constraint violation: unique constraint or index violation: IX_ED5CA615
 45    at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
 46    at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267)
 47    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
 48    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
 49    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
 50    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
 51    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
 52    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5001)
 53    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
 54    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 55    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
 56    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)
 57    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
 58    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
 59    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
 60    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
 61    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
 62    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
 63    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 64    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 65    at java.lang.Thread.run(Thread.java:662)
 66Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: integrity constraint violation: unique constraint or index violation: IX_ED5CA615
 67    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
 68    at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
 69    at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
 70    at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
 71    at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
 72    at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
 73    at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
 74    at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
 75    ... 20 more
 76Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: integrity constraint violation: unique constraint or index violation: IX_ED5CA615
 77    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
 78    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:225)
 79    at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:67)
 80    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
 81    ... 27 more
 82Caused by: java.sql.SQLException: integrity constraint violation: unique constraint or index violation: IX_ED5CA615
 83    at org.hsqldb.jdbc.Util.sqlException(Util.java:232)
 84    at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4640)
 85    at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedStatement.java:311)
 86    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
 87    at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.addDLFileEntry(UpgradeImageGallery.java:126)
 88    at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.updateIGImageEntries(UpgradeImageGallery.java:548)
 89    at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:244)
 90    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
 91    ... 30 more
 92Stopping the server due to unexpected startup errors
 93Feb 21, 2012 1:12:33 PM org.apache.catalina.core.AprLifecycleListener init
 94INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
 95Feb 21, 2012 1:12:33 PM org.apache.coyote.AbstractProtocol init
 96INFO: Initializing ProtocolHandler ["http-bio-8080"]
 97Feb 21, 2012 1:12:33 PM org.apache.coyote.AbstractProtocol init
 98INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
 99Feb 21, 2012 1:12:33 PM org.apache.catalina.startup.Catalina load
100INFO: Initialization processed in 513 ms
101Feb 21, 2012 1:12:33 PM org.apache.catalina.core.StandardService startInternal
102INFO: Starting service Catalina
103Feb 21, 2012 1:12:33 PM org.apache.catalina.core.StandardEngine startInternal
104INFO: Starting Servlet Engine: Apache Tomcat/7.0.23
105Feb 21, 2012 1:12:33 PM org.apache.catalina.startup.HostConfig deployDescriptor
106INFO: Deploying configuration descriptor /opt/liferay-portal-6.1.0/tomcat-7.0.23/conf/Catalina/localhost/ROOT.xml
107Loading jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
10813:12:34,721 INFO  [EasyConf:122] Refreshed the configuration of all components
10913:12:35,000 INFO  [ConfigurationLoader:56] Properties for jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal loaded from [file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/classes/portal-ext.properties, jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties]
110Loading jar:file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
111Loading file:/opt/liferay-portal-6.1.0/tomcat-7.0.23/webapps/ROOT/WEB-INF/classes/portal-ext.properties
11213:12:43,559 INFO  [DialectDetector:80] Determine dialect for HSQL Database Engine 2
11313:12:43,560 WARN  [DialectDetector:95] Liferay is configured to use Hypersonic as its database. Do NOT use Hypersonic in production. Hypersonic is an embedded database useful for development and demo'ing purposes. The database settings can be changed in portal-ext.properties.
11413:12:43,593 INFO  [DialectDetector:145] Found dialect org.hibernate.dialect.HSQLDialect
115Starting Liferay Portal Community Edition 6.1.0 CE (Paton / Build 6100 / January 6, 2012)
11613:13:05,518 INFO  [BaseDB:406] Database supports case sensitive queries
11713:13:05,649 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
11813:13:05,650 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
11913:13:05,672 WARN  [BaseDB:382] object name already exists in statement [alter table AssetCategory add description longvarchar null]: alter table AssetCategory add description longvarchar null;
120
12113:13:05,676 WARN  [BaseDB:382] object name already exists in statement [alter table AssetEntry add classTypeId bigint]: alter table AssetEntry add classTypeId bigint;
122
12313:13:05,680 WARN  [BaseDB:382] object name already exists in statement [alter table AssetEntry add layoutUuid varchar(75) null]: alter table AssetEntry add layoutUuid varchar(75) null;
124
12513:13:05,707 WARN  [BaseDB:382] object name already exists in statement [alter table BlogsEntry add description longvarchar null]: alter table BlogsEntry add description longvarchar null;
126
12713:13:05,710 WARN  [BaseDB:382] object name already exists in statement [alter table BlogsEntry add smallImage bit]: alter table BlogsEntry add smallImage bit;
128
12913:13:05,713 WARN  [BaseDB:382] object name already exists in statement [alter table BlogsEntry add smallImageId varchar(75) null]: alter table BlogsEntry add smallImageId varchar(75) null;
130
13113:13:05,716 WARN  [BaseDB:382] object name already exists in statement [alter table BlogsEntry add smallImageURL longvarchar null]: alter table BlogsEntry add smallImageURL longvarchar null;
132
13313:13:05,718 WARN  [BaseDB:382] object name already exists in statement [alter table BookmarksEntry add userName varchar(75) null]: alter table BookmarksEntry add userName varchar(75) null;
134
13513:13:05,722 WARN  [BaseDB:382] object name already exists in statement [alter table BookmarksEntry add resourceBlockId bigint]: alter table BookmarksEntry add resourceBlockId bigint;
136
13713:13:05,724 WARN  [BaseDB:382] object name already exists in statement [alter table BookmarksEntry add description varchar(75) null]: alter table BookmarksEntry add description varchar(75) null;
138
13913:13:05,727 WARN  [BaseDB:382] user lacks privilege or object not found: COMMENTS: update BookmarksEntry set description = comments;
140
14113:13:05,729 WARN  [BaseDB:382] user lacks privilege or object not found: COMMENTS: alter table BookmarksEntry drop column comments;
142
14313:13:05,732 WARN  [BaseDB:382] object name already exists in statement [alter table BookmarksFolder add userName varchar(75) null]: alter table BookmarksFolder add userName varchar(75) null;
144
14513:13:05,734 WARN  [BaseDB:382] object name already exists in statement [alter table BookmarksFolder add resourceBlockId bigint]: alter table BookmarksFolder add resourceBlockId bigint;
146
14713:13:05,737 WARN  [BaseDB:382] object name already exists in statement [alter table CalEvent add location longvarchar null]: alter table CalEvent add location longvarchar null;
148
14913:13:05,740 WARN  [BaseDB:382] user lacks privilege or object not found: IX_975996C0 in statement [drop index IX_975996C0]: drop index IX_975996C0;
150
15113:13:05,742 WARN  [BaseDB:382] object name already exists in statement [alter table Company add active_ bit]: alter table Company add active_ bit;
152
15313:13:05,745 WARN  [BaseDB:382] object name already exists in statement [alter table Country add zipRequired bit]: alter table Country add zipRequired bit;
154
15513:13:05,752 WARN  [BaseDB:382] object name already exists: DDLRECORD in statement [create table DDLRecord (    uuid_ varchar(75) null,    recordId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    versionUserId bigint,    versionUserName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    DDMStorageId bigint,    recordSetId bigint,    version varchar(75) null,    displayIndex int)]: create table DDLRecord (    uuid_ varchar(75) null,    recordId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    versionUserId bigint,    versionUserName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    DDMStorageId bigint,    recordSetId bigint,    version varchar(75) null,    displayIndex int);
156
15713:13:05,754 WARN  [BaseDB:382] object name already exists: DDLRECORDSET in statement [create table DDLRecordSet (    uuid_ varchar(75) null,    recordSetId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    DDMStructureId bigint,    recordSetKey varchar(75) null,    name longvarchar null,    description longvarchar null,    minDisplayRows int,    scope int)]: create table DDLRecordSet (    uuid_ varchar(75) null,    recordSetId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    DDMStructureId bigint,    recordSetKey varchar(75) null,    name longvarchar null,    description longvarchar null,    minDisplayRows int,    scope int);
158
15913:13:05,757 WARN  [BaseDB:382] object name already exists: DDLRECORDVERSION in statement [create table DDLRecordVersion (    recordVersionId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    DDMStorageId bigint,    recordSetId bigint,    recordId bigint,    version varchar(75) null,    displayIndex int,    status int,    statusByUserId bigint,    statusByUserName varchar(75) null,    statusDate timestamp null)]: create table DDLRecordVersion (    recordVersionId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    DDMStorageId bigint,    recordSetId bigint,    recordId bigint,    version varchar(75) null,    displayIndex int,    status int,    statusByUserId bigint,    statusByUserName varchar(75) null,    statusDate timestamp null);
160
16113:13:05,760 WARN  [BaseDB:382] object name already exists: DDMCONTENT in statement [create table DDMContent (    uuid_ varchar(75) null,    contentId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    name longvarchar null,    description longvarchar null,    xml longvarchar null)]: create table DDMContent (    uuid_ varchar(75) null,    contentId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    name longvarchar null,    description longvarchar null,    xml longvarchar null);
162
16313:13:05,762 WARN  [BaseDB:382] object name already exists: DDMSTORAGELINK in statement [create table DDMStorageLink (    uuid_ varchar(75) null,    storageLinkId bigint not null primary key,    classNameId bigint,    classPK bigint,    structureId bigint)]: create table DDMStorageLink (    uuid_ varchar(75) null,    storageLinkId bigint not null primary key,    classNameId bigint,    classPK bigint,    structureId bigint);
164
16513:13:05,765 WARN  [BaseDB:382] object name already exists: DDMSTRUCTURE in statement [create table DDMStructure (    uuid_ varchar(75) null,    structureId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    structureKey varchar(75) null,    name longvarchar null,    description longvarchar null,    xsd longvarchar null,    storageType varchar(75) null,    type_ int)]: create table DDMStructure (    uuid_ varchar(75) null,    structureId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    structureKey varchar(75) null,    name longvarchar null,    description longvarchar null,    xsd longvarchar null,    storageType varchar(75) null,    type_ int);
166
16713:13:05,768 WARN  [BaseDB:382] object name already exists: DDMSTRUCTURELINK in statement [create table DDMStructureLink (    structureLinkId bigint not null primary key,    classNameId bigint,    classPK bigint,    structureId bigint)]: create table DDMStructureLink (    structureLinkId bigint not null primary key,    classNameId bigint,    classPK bigint,    structureId bigint);
168
16913:13:05,770 WARN  [BaseDB:382] object name already exists: DDMTEMPLATE in statement [create table DDMTemplate (    uuid_ varchar(75) null,    templateId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    structureId bigint,    name longvarchar null,    description longvarchar null,    type_ varchar(75) null,    mode_ varchar(75) null,    language varchar(75) null,    script longvarchar null)]: create table DDMTemplate (    uuid_ varchar(75) null,    templateId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    structureId bigint,    name longvarchar null,    description longvarchar null,    type_ varchar(75) null,    mode_ varchar(75) null,    language varchar(75) null,    script longvarchar null);
170
17113:13:05,773 WARN  [BaseDB:382] object name already exists: DLCONTENT in statement [create table DLContent (    contentId bigint not null primary key,    groupId bigint,    companyId bigint,    repositoryId bigint,    path_ varchar(255) null,    version varchar(75) null,    data_ blob,    size_ bigint)]: create table DLContent (    contentId bigint not null primary key,    groupId bigint,    companyId bigint,    repositoryId bigint,    path_ varchar(255) null,    version varchar(75) null,    data_ blob,    size_ bigint);
172
17313:13:05,775 WARN  [BaseDB:382] object name already exists: DLFILEENTRYMETADATA in statement [create table DLFileEntryMetadata (    uuid_ varchar(75) null,    fileEntryMetadataId bigint not null primary key,    DDMStorageId bigint,    DDMStructureId bigint,    fileEntryTypeId bigint,    fileEntryId bigint,    fileVersionId bigint)]: create table DLFileEntryMetadata (    uuid_ varchar(75) null,    fileEntryMetadataId bigint not null primary key,    DDMStorageId bigint,    DDMStructureId bigint,    fileEntryTypeId bigint,    fileEntryId bigint,    fileVersionId bigint);
174
17513:13:05,778 WARN  [BaseDB:382] object name already exists: DLFILEENTRYTYPE in statement [create table DLFileEntryType (    uuid_ varchar(75) null,    fileEntryTypeId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    name varchar(75) null,    description longvarchar null)]: create table DLFileEntryType (    uuid_ varchar(75) null,    fileEntryTypeId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    name varchar(75) null,    description longvarchar null);
176
17713:13:05,780 WARN  [BaseDB:382] object name already exists: DLFILEENTRYTYPES_DDMSTRUCTURES in statement [create table DLFileEntryTypes_DDMStructures (    fileEntryTypeId bigint not null,    structureId bigint not null,    primary key (fileEntryTypeId, structureId))]: create table DLFileEntryTypes_DDMStructures (    fileEntryTypeId bigint not null,    structureId bigint not null,    primary key (fileEntryTypeId, structureId));
178
17913:13:05,783 WARN  [BaseDB:382] object name already exists: DLFILEENTRYTYPES_DLFOLDERS in statement [create table DLFileEntryTypes_DLFolders (    fileEntryTypeId bigint not null,    folderId bigint not null,    primary key (fileEntryTypeId, folderId))]: create table DLFileEntryTypes_DLFolders (    fileEntryTypeId bigint not null,    folderId bigint not null,    primary key (fileEntryTypeId, folderId));
180
18113:13:05,785 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add repositoryId bigint]: alter table DLFileEntry add repositoryId bigint;
182
18313:13:05,788 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add mimeType varchar(75) null]: alter table DLFileEntry add mimeType varchar(75) null;
184
18513:13:05,790 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add fileEntryTypeId bigint]: alter table DLFileEntry add fileEntryTypeId bigint;
186
18713:13:05,793 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add smallImageId bigint]: alter table DLFileEntry add smallImageId bigint;
188
18913:13:05,795 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add largeImageId bigint]: alter table DLFileEntry add largeImageId bigint;
190
19113:13:05,797 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add custom1ImageId bigint]: alter table DLFileEntry add custom1ImageId bigint;
192
19313:13:05,800 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileEntry add custom2ImageId bigint]: alter table DLFileEntry add custom2ImageId bigint;
194
19513:13:05,806 WARN  [BaseDB:382] user lacks privilege or object not found: IX_CE705D48 in statement [drop index IX_CE705D48]: drop index IX_CE705D48;
196
19713:13:05,809 WARN  [BaseDB:382] user lacks privilege or object not found: IX_40B56512 in statement [drop index IX_40B56512]: drop index IX_40B56512;
198
19913:13:05,811 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileRank add fileEntryId bigint]: alter table DLFileRank add fileEntryId bigint;
200
20113:13:05,813 WARN  [BaseDB:382] user lacks privilege or object not found: IX_55C736AC in statement [drop index IX_55C736AC]: drop index IX_55C736AC;
202
20313:13:05,816 WARN  [BaseDB:382] user lacks privilege or object not found: IX_346A0992 in statement [drop index IX_346A0992]: drop index IX_346A0992;
204
20513:13:05,818 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileShortcut add repositoryId bigint]: alter table DLFileShortcut add repositoryId bigint;
206
20713:13:05,821 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileShortcut add toFileEntryId bigint]: alter table DLFileShortcut add toFileEntryId bigint;
208
20913:13:05,823 WARN  [BaseDB:382] user lacks privilege or object not found: IX_B413F1EC in statement [drop index IX_B413F1EC]: drop index IX_B413F1EC;
210
21113:13:05,826 WARN  [BaseDB:382] user lacks privilege or object not found: IX_94E784D2 in statement [drop index IX_94E784D2]: drop index IX_94E784D2;
212
21313:13:05,828 WARN  [BaseDB:382] user lacks privilege or object not found: IX_2F8FED9C in statement [drop index IX_2F8FED9C]: drop index IX_2F8FED9C;
214
21513:13:05,830 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileVersion add modifiedDate timestamp null]: alter table DLFileVersion add modifiedDate timestamp null;
216
21713:13:05,833 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileVersion add repositoryId bigint]: alter table DLFileVersion add repositoryId bigint;
218
21913:13:05,835 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileVersion add fileEntryId bigint]: alter table DLFileVersion add fileEntryId bigint;
220
22113:13:05,837 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileVersion add mimeType varchar(75) null]: alter table DLFileVersion add mimeType varchar(75) null;
222
22313:13:05,840 WARN  [BaseDB:382] object name already exists in statement [alter table DLFileVersion add fileEntryTypeId bigint]: alter table DLFileVersion add fileEntryTypeId bigint;
224
22513:13:05,849 WARN  [BaseDB:382] object name already exists in statement [alter table DLFolder add repositoryId bigint]: alter table DLFolder add repositoryId bigint;
226
22713:13:05,851 WARN  [BaseDB:382] object name already exists in statement [alter table DLFolder add mountPoint bit]: alter table DLFolder add mountPoint bit;
228
22913:13:05,853 WARN  [BaseDB:382] object name already exists in statement [alter table DLFolder add defaultFileEntryTypeId bigint]: alter table DLFolder add defaultFileEntryTypeId bigint;
230
23113:13:05,856 WARN  [BaseDB:382] object name already exists in statement [alter table DLFolder add overrideFileEntryTypes bit]: alter table DLFolder add overrideFileEntryTypes bit;
232
23313:13:05,863 WARN  [BaseDB:382] object name already exists: DLSYNC in statement [create table DLSync (    syncId bigint not null primary key,    companyId bigint,    createDate timestamp null,    modifiedDate timestamp null,    fileId bigint,    fileUuid varchar(75) null,    repositoryId bigint,    parentFolderId bigint,    name varchar(255) null,    event varchar(75) null,    type_ varchar(75) null,    version varchar(75) null)]: create table DLSync (    syncId bigint not null primary key,    companyId bigint,    createDate timestamp null,    modifiedDate timestamp null,    fileId bigint,    fileUuid varchar(75) null,    repositoryId bigint,    parentFolderId bigint,    name varchar(255) null,    event varchar(75) null,    type_ varchar(75) null,    version varchar(75) null);
234
23513:13:05,865 WARN  [BaseDB:382] object name already exists in statement [alter table Group_ add site bit]: alter table Group_ add site bit;
236
23713:13:05,868 WARN  [BaseDB:382] user lacks privilege or object not found: IGFOLDER: alter table IGFolder add userName varchar(75) null;
238
23913:13:05,871 WARN  [BaseDB:382] object name already exists in statement [alter table IGImage add userName varchar(75) null]: alter table IGImage add userName varchar(75) null;
240
24113:13:05,873 WARN  [BaseDB:382] object name already exists in statement [alter table JournalArticle add classNameId bigint null]: alter table JournalArticle add classNameId bigint null;
242
24313:13:05,876 WARN  [BaseDB:382] object name already exists in statement [alter table JournalArticle add classPK bigint null]: alter table JournalArticle add classPK bigint null;
244
24513:13:05,878 WARN  [BaseDB:382] object name already exists in statement [alter table JournalArticle add layoutUuid varchar(75) null]: alter table JournalArticle add layoutUuid varchar(75) null;
246
24713:13:06,003 WARN  [BaseDB:382] user lacks privilege or object not found: IX_FAD05595 in statement [drop index IX_FAD05595]: drop index IX_FAD05595;
248
24913:13:06,005 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add createDate timestamp null]: alter table Layout add createDate timestamp null;
250
25113:13:06,008 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add modifiedDate timestamp null]: alter table Layout add modifiedDate timestamp null;
252
25313:13:06,010 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add keywords longvarchar null]: alter table Layout add keywords longvarchar null;
254
25513:13:06,012 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add robots longvarchar null]: alter table Layout add robots longvarchar null;
256
25713:13:06,015 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add layoutPrototypeUuid varchar(75) null]: alter table Layout add layoutPrototypeUuid varchar(75) null;
258
25913:13:06,017 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add layoutPrototypeLinkEnabled bit null]: alter table Layout add layoutPrototypeLinkEnabled bit null;
260
26113:13:06,019 WARN  [BaseDB:382] object name already exists in statement [alter table Layout add sourcePrototypeLayoutUuid varchar(75) null]: alter table Layout add sourcePrototypeLayoutUuid varchar(75) null;
262
26313:13:06,022 WARN  [BaseDB:382] user lacks privilege or object not found: LAYOUTPROTOTYPEID: alter table Layout drop column layoutPrototypeId;
264
26513:13:06,024 WARN  [BaseDB:382] user lacks privilege or object not found: DLFOLDERID: alter table Layout drop column dlFolderId;
266
26713:13:06,035 WARN  [BaseDB:382] object name already exists: LAYOUTBRANCH in statement [create table LayoutBranch (    LayoutBranchId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    layoutSetBranchId bigint,    plid bigint,    name varchar(75) null,    description longvarchar null,    master bit)]: create table LayoutBranch (    LayoutBranchId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    layoutSetBranchId bigint,    plid bigint,    name varchar(75) null,    description longvarchar null,    master bit);
268
26913:13:06,038 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutPrototype add uuid_ varchar(75) null]: alter table LayoutPrototype add uuid_ varchar(75) null;
270
27113:13:06,041 WARN  [BaseDB:382] object name already exists: LAYOUTREVISION in statement [create table LayoutRevision (    layoutRevisionId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    layoutSetBranchId bigint,    layoutBranchId bigint,    parentLayoutRevisionId bigint,    head bit,    major bit,    plid bigint,    privateLayout bit,    name longvarchar null,    title longvarchar null,    description longvarchar null,    keywords longvarchar null,    robots longvarchar null,    typeSettings longvarchar null,    iconImage bit,    iconImageId bigint,    themeId varchar(75) null,    colorSchemeId varchar(75) null,    wapThemeId varchar(75) null,    wapColorSchemeId varchar(75) null,    css longvarchar null,    status int,    statusByUserId bigint,    statusByUserName varchar(75) null,    statusDate timestamp null)]: create table LayoutRevision (    layoutRevisionId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    layoutSetBranchId bigint,    layoutBranchId bigint,    parentLayoutRevisionId bigint,    head bit,    major bit,    plid bigint,    privateLayout bit,    name longvarchar null,    title longvarchar null,    description longvarchar null,    keywords longvarchar null,    robots longvarchar null,    typeSettings longvarchar null,    iconImage bit,    iconImageId bigint,    themeId varchar(75) null,    colorSchemeId varchar(75) null,    wapThemeId varchar(75) null,    wapColorSchemeId varchar(75) null,    css longvarchar null,    status int,    statusByUserId bigint,    statusByUserName varchar(75) null,    statusDate timestamp null);
272
27313:13:06,043 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSet add createDate timestamp null]: alter table LayoutSet add createDate timestamp null;
274
27513:13:06,046 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSet add modifiedDate timestamp null]: alter table LayoutSet add modifiedDate timestamp null;
276
27713:13:06,048 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSet add layoutSetPrototypeUuid varchar(75) null]: alter table LayoutSet add layoutSetPrototypeUuid varchar(75) null;
278
27913:13:06,051 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSet add layoutSetPrototypeLinkEnabled bit null]: alter table LayoutSet add layoutSetPrototypeLinkEnabled bit null;
280
28113:13:06,053 WARN  [BaseDB:382] user lacks privilege or object not found: LAYOUTSETPROTOTYPEID: alter table LayoutSet drop column layoutSetPrototypeId;
282
28313:13:06,055 WARN  [BaseDB:382] user lacks privilege or object not found: IX_5ABC2905 in statement [drop index IX_5ABC2905]: drop index IX_5ABC2905;
284
28513:13:06,061 WARN  [BaseDB:382] object name already exists: LAYOUTSETBRANCH in statement [create table LayoutSetBranch (    layoutSetBranchId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    privateLayout bit,    name varchar(75) null,    description longvarchar null,    master bit)]: create table LayoutSetBranch (    layoutSetBranchId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    privateLayout bit,    name varchar(75) null,    description longvarchar null,    master bit);
286
28713:13:06,064 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSetPrototype add createDate timestamp null]: alter table LayoutSetPrototype add createDate timestamp null;
288
28913:13:06,066 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSetPrototype add modifiedDate timestamp null]: alter table LayoutSetPrototype add modifiedDate timestamp null;
290
29113:13:06,069 WARN  [BaseDB:382] object name already exists in statement [alter table LayoutSetPrototype add uuid_ varchar(75) null]: alter table LayoutSetPrototype add uuid_ varchar(75) null;
292
29313:13:06,072 WARN  [BaseDB:382] object name already exists in statement [alter table MBCategory add displayStyle varchar(75) null]: alter table MBCategory add displayStyle varchar(75) null;
294
29513:13:06,074 WARN  [BaseDB:382] object name already exists in statement [alter table MBMailingList add allowAnonymous bit]: alter table MBMailingList add allowAnonymous bit;
296
29713:13:06,077 WARN  [BaseDB:382] object name already exists in statement [alter table MBMessage add format varchar(75) null]: alter table MBMessage add format varchar(75) null;
298
29913:13:06,079 WARN  [BaseDB:382] object name already exists in statement [alter table MBMessage add answer bit]: alter table MBMessage add answer bit;
300
30113:13:06,107 WARN  [BaseDB:382] object name already exists in statement [alter table MBThread add companyId bigint]: alter table MBThread add companyId bigint;
302
30313:13:06,109 WARN  [BaseDB:382] object name already exists in statement [alter table MBThread add rootMessageUserId bigint]: alter table MBThread add rootMessageUserId bigint;
304
30513:13:06,111 WARN  [BaseDB:382] object name already exists in statement [alter table MBThread add question bit]: alter table MBThread add question bit;
306
30713:13:06,114 WARN  [BaseDB:382] object name already exists: MBTHREADFLAG in statement [create table MBThreadFlag (    threadFlagId bigint not null primary key,    userId bigint,    modifiedDate timestamp null,    threadId bigint)]: create table MBThreadFlag (    threadFlagId bigint not null primary key,    userId bigint,    modifiedDate timestamp null,    threadId bigint);
308
30913:13:06,116 WARN  [BaseDB:382] object name already exists: MDRACTION in statement [create table MDRAction (    uuid_ varchar(75) null,    actionId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    classPK bigint,    ruleGroupInstanceId bigint,    name longvarchar null,    description longvarchar null,    type_ varchar(255) null,    typeSettings longvarchar null)]: create table MDRAction (    uuid_ varchar(75) null,    actionId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    classPK bigint,    ruleGroupInstanceId bigint,    name longvarchar null,    description longvarchar null,    type_ varchar(255) null,    typeSettings longvarchar null);
310
31113:13:06,119 WARN  [BaseDB:382] object name already exists: MDRRULE in statement [create table MDRRule (    uuid_ varchar(75) null,    ruleId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    ruleGroupId bigint,    name longvarchar null,    description longvarchar null,    type_ varchar(255) null,    typeSettings longvarchar null)]: create table MDRRule (    uuid_ varchar(75) null,    ruleId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    ruleGroupId bigint,    name longvarchar null,    description longvarchar null,    type_ varchar(255) null,    typeSettings longvarchar null);
312
31313:13:06,121 WARN  [BaseDB:382] object name already exists: MDRRULEGROUP in statement [create table MDRRuleGroup (    uuid_ varchar(75) null,    ruleGroupId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    name longvarchar null,    description longvarchar null)]: create table MDRRuleGroup (    uuid_ varchar(75) null,    ruleGroupId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    name longvarchar null,    description longvarchar null);
314
31513:13:06,124 WARN  [BaseDB:382] object name already exists: MDRRULEGROUPINSTANCE in statement [create table MDRRuleGroupInstance (    uuid_ varchar(75) null,    ruleGroupInstanceId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    classPK bigint,    ruleGroupId bigint,    priority int)]: create table MDRRuleGroupInstance (    uuid_ varchar(75) null,    ruleGroupInstanceId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    classPK bigint,    ruleGroupId bigint,    priority int);
316
31713:13:06,126 WARN  [BaseDB:382] object name already exists in statement [alter table Organization_ add treePath longvarchar null]: alter table Organization_ add treePath longvarchar null;
318
31913:13:06,129 WARN  [BaseDB:382] user lacks privilege or object not found: LEFTORGANIZATIONID: alter table Organization_ drop column leftOrganizationId;
320
32113:13:06,131 WARN  [BaseDB:382] user lacks privilege or object not found: RIGHTORGANIZATIONID: alter table Organization_ drop column rightOrganizationId;
322
32313:13:06,133 WARN  [BaseDB:382] object name already exists in statement [alter table PollsVote add companyId bigint]: alter table PollsVote add companyId bigint;
324
32513:13:06,135 WARN  [BaseDB:382] object name already exists in statement [alter table PollsVote add userName varchar(75) null]: alter table PollsVote add userName varchar(75) null;
326
32713:13:06,138 WARN  [BaseDB:382] object name already exists in statement [alter table PollsVote add createDate timestamp null]: alter table PollsVote add createDate timestamp null;
328
32913:13:06,140 WARN  [BaseDB:382] object name already exists in statement [alter table PollsVote add modifiedDate timestamp null]: alter table PollsVote add modifiedDate timestamp null;
330
33113:13:06,142 WARN  [BaseDB:382] object name already exists: PORTALPREFERENCES in statement [create table PortalPreferences (    portalPreferencesId bigint not null primary key,    ownerId bigint,    ownerType int,    preferences longvarchar null)]: create table PortalPreferences (    portalPreferencesId bigint not null primary key,    ownerId bigint,    ownerType int,    preferences longvarchar null);
332
33313:13:06,145 WARN  [BaseDB:382] object name already exists: REPOSITORY in statement [create table Repository (    uuid_ varchar(75) null,    repositoryId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    name varchar(75) null,    description longvarchar null,    portletId varchar(75) null,    typeSettings longvarchar null,    dlFolderId bigint)]: create table Repository (    uuid_ varchar(75) null,    repositoryId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    userName varchar(75) null,    createDate timestamp null,    modifiedDate timestamp null,    classNameId bigint,    name varchar(75) null,    description longvarchar null,    portletId varchar(75) null,    typeSettings longvarchar null,    dlFolderId bigint);
334
33513:13:06,148 WARN  [BaseDB:382] object name already exists: REPOSITORYENTRY in statement [create table RepositoryEntry (    uuid_ varchar(75) null,    repositoryEntryId bigint not null primary key,    groupId bigint,    repositoryId bigint,    mappedId varchar(75) null)]: create table RepositoryEntry (    uuid_ varchar(75) null,    repositoryEntryId bigint not null primary key,    groupId bigint,    repositoryId bigint,    mappedId varchar(75) null);
336
33713:13:06,150 WARN  [BaseDB:382] object name already exists: RESOURCEBLOCK in statement [create table ResourceBlock (    resourceBlockId bigint not null primary key,    companyId bigint,    groupId bigint,    name varchar(75) null,    permissionsHash varchar(75) null,    referenceCount bigint)]: create table ResourceBlock (    resourceBlockId bigint not null primary key,    companyId bigint,    groupId bigint,    name varchar(75) null,    permissionsHash varchar(75) null,    referenceCount bigint);
338
33913:13:06,152 WARN  [BaseDB:382] object name already exists: RESOURCEBLOCKPERMISSION in statement [create table ResourceBlockPermission (    resourceBlockPermissionId bigint not null primary key,    resourceBlockId bigint,    roleId bigint,    actionIds bigint)]: create table ResourceBlockPermission (    resourceBlockPermissionId bigint not null primary key,    resourceBlockId bigint,    roleId bigint,    actionIds bigint);
340
34113:13:06,155 WARN  [BaseDB:382] object name already exists in statement [alter table ResourcePermission add ownerId bigint]: alter table ResourcePermission add ownerId bigint;
342
34313:13:06,157 WARN  [BaseDB:382] object name already exists: RESOURCETYPEPERMISSION in statement [create table ResourceTypePermission (    resourceTypePermissionId bigint not null primary key,    companyId bigint,    groupId bigint,    name varchar(75) null,    roleId bigint,    actionIds bigint)]: create table ResourceTypePermission (    resourceTypePermissionId bigint not null primary key,    companyId bigint,    groupId bigint,    name varchar(75) null,    roleId bigint,    actionIds bigint);
344
34513:13:06,160 WARN  [BaseDB:382] object name already exists: SOCIALACTIVITYACHIEVEMENT in statement [create table SocialActivityAchievement (    activityAchievementId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    createDate bigint,    name varchar(75) null,    firstInGroup bit)]: create table SocialActivityAchievement (    activityAchievementId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    createDate bigint,    name varchar(75) null,    firstInGroup bit);
346
34713:13:06,162 WARN  [BaseDB:382] object name already exists: SOCIALACTIVITYCOUNTER in statement [create table SocialActivityCounter (    activityCounterId bigint not null primary key,    groupId bigint,    companyId bigint,    classNameId bigint,    classPK bigint,    name varchar(75) null,    ownerType int,    currentValue int,    totalValue int,    graceValue int,    startPeriod int,    endPeriod int)]: create table SocialActivityCounter (    activityCounterId bigint not null primary key,    groupId bigint,    companyId bigint,    classNameId bigint,    classPK bigint,    name varchar(75) null,    ownerType int,    currentValue int,    totalValue int,    graceValue int,    startPeriod int,    endPeriod int);
348
34913:13:06,165 WARN  [BaseDB:382] object name already exists: SOCIALACTIVITYLIMIT in statement [create table SocialActivityLimit (    activityLimitId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    classNameId bigint,    classPK bigint,    activityType int,    activityCounterName varchar(75) null,    value varchar(75) null)]: create table SocialActivityLimit (    activityLimitId bigint not null primary key,    groupId bigint,    companyId bigint,    userId bigint,    classNameId bigint,    classPK bigint,    activityType int,    activityCounterName varchar(75) null,    value varchar(75) null);
350
35113:13:06,167 WARN  [BaseDB:382] object name already exists: SOCIALACTIVITYSETTING in statement [create table SocialActivitySetting (    activitySettingId bigint not null primary key,    groupId bigint,    companyId bigint,    classNameId bigint,    activityType int,    name varchar(75) null,    value varchar(1024) null)]: create table SocialActivitySetting (    activitySettingId bigint not null primary key,    groupId bigint,    companyId bigint,    classNameId bigint,    activityType int,    name varchar(75) null,    value varchar(1024) null);
352
35313:13:06,171 WARN  [BaseDB:382] object name already exists in statement [alter table Ticket add type_ int]: alter table Ticket add type_ int;
354
35513:13:06,173 WARN  [BaseDB:382] object name already exists in statement [alter table Ticket add extraInfo longvarchar null]: alter table Ticket add extraInfo longvarchar null;
356
35713:13:06,176 WARN  [BaseDB:382] object name already exists in statement [alter table User_ add emailAddressVerified bit]: alter table User_ add emailAddressVerified bit;
358
35913:13:06,178 WARN  [BaseDB:382] object name already exists in statement [alter table User_ add status int]: alter table User_ add status int;
360
36113:13:06,184 WARN  [BaseDB:382] user lacks privilege or object not found: ACTIVE_: update User_ set status = 5 where active_ = false;
362
36313:13:06,186 WARN  [BaseDB:382] user lacks privilege or object not found: ACTIVE_: alter table User_ drop column active_;
364
36513:13:06,189 WARN  [BaseDB:382] object name already exists in statement [alter table UserGroup add addedByLDAPImport bit]: alter table UserGroup add addedByLDAPImport bit;
366
36713:13:06,191 WARN  [BaseDB:382] object name already exists: USERGROUPS_TEAMS in statement [create table UserGroups_Teams (    userGroupId bigint not null,    teamId bigint not null,    primary key (userGroupId, teamId))]: create table UserGroups_Teams (    userGroupId bigint not null,    teamId bigint not null,    primary key (userGroupId, teamId));
368
36913:13:06,193 WARN  [BaseDB:382] object name already exists: USERNOTIFICATIONEVENT in statement [create table UserNotificationEvent (    uuid_ varchar(75) null,    userNotificationEventId bigint not null primary key,    companyId bigint,    userId bigint,    type_ varchar(75) null,    timestamp bigint,    deliverBy bigint,    payload longvarchar null,    archived bit)]: create table UserNotificationEvent (    uuid_ varchar(75) null,    userNotificationEventId bigint not null primary key,    companyId bigint,    userId bigint,    type_ varchar(75) null,    timestamp bigint,    deliverBy bigint,    payload longvarchar null,    archived bit);
370
37113:13:06,196 WARN  [BaseDB:382] object name already exists: VIRTUALHOST in statement [create table VirtualHost (    virtualHostId bigint not null primary key,    companyId bigint,    layoutSetId bigint,    hostname varchar(75) null)]: create table VirtualHost (    virtualHostId bigint not null primary key,    companyId bigint,    layoutSetId bigint,    hostname varchar(75) null);
372
37313:13:06,198 WARN  [BaseDB:382] object name already exists in statement [alter table WorkflowDefinitionLink add classPK bigint]: alter table WorkflowDefinitionLink add classPK bigint;
374
37513:13:06,200 WARN  [BaseDB:382] object name already exists in statement [alter table WorkflowDefinitionLink add typePK bigint]: alter table WorkflowDefinitionLink add typePK bigint;
376
37713:13:06,204 WARN  [BaseDB:382] user lacks privilege or object not found: QUARTZ_JOB_LISTENERS in statement [drop table QUARTZ_JOB_LISTENERS]: drop table QUARTZ_JOB_LISTENERS;
378
37913:13:06,208 WARN  [BaseDB:382] user lacks privilege or object not found: QUARTZ_TRIGGER_LISTENERS in statement [drop table QUARTZ_TRIGGER_LISTENERS]: drop table QUARTZ_TRIGGER_LISTENERS;
380
38113:13:06,216 WARN  [BaseDB:382] object name already exists: QUARTZ_SIMPROP_TRIGGERS in statement [CREATE TABLE QUARTZ_SIMPROP_TRIGGERS (    SCHED_NAME varchar(120) not null,    TRIGGER_NAME varchar(200) not null,    TRIGGER_GROUP varchar(200) not null,    STR_PROP_1 varchar(512) null,    STR_PROP_2 varchar(512) null,    STR_PROP_3 varchar(512) null,    INT_PROP_1 int null,    INT_PROP_2 int null,    LONG_PROP_1 bigint null,    LONG_PROP_2 bigint null,    DEC_PROP_1 NUMERIC(13,4) null,    DEC_PROP_2 NUMERIC(13,4) null,    BOOL_PROP_1 bit null,    BOOL_PROP_2 bit null,    primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP))]: CREATE TABLE QUARTZ_SIMPROP_TRIGGERS (    SCHED_NAME varchar(120) not null,    TRIGGER_NAME varchar(200) not null,    TRIGGER_GROUP varchar(200) not null,    STR_PROP_1 varchar(512) null,    STR_PROP_2 varchar(512) null,    STR_PROP_3 varchar(512) null,    INT_PROP_1 int null,    INT_PROP_2 int null,    LONG_PROP_1 bigint null,    LONG_PROP_2 bigint null,    DEC_PROP_1 NUMERIC(13,4) null,    DEC_PROP_2 NUMERIC(13,4) null,    BOOL_PROP_1 bit null,    BOOL_PROP_2 bit null,    primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP));
382
38313:13:06,223 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
38413:13:06,227 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: user lacks privilege or object not found: IGFOLDER
385com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: user lacks privilege or object not found: IGFOLDER
386    at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
387    at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267)
388    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
389    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
390    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
391    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
392    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
393    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5001)
394    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
395    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
396    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
397    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)
398    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
399    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
400    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
401    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
402    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
403    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
404    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
405    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
406    at java.lang.Thread.run(Thread.java:662)
407Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: user lacks privilege or object not found: IGFOLDER
408    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
409    at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
410    at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
411    at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
412    at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
413    at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
414    at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
415    at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
416    ... 20 more
417Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: user lacks privilege or object not found: IGFOLDER
418    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
419    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:225)
420    at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:59)
421    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
422    ... 27 more
423Caused by: java.sql.SQLException: user lacks privilege or object not found: IGFOLDER
424    at org.hsqldb.jdbc.Util.sqlException(Util.java:232)
425    at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3893)
426    at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:643)
427    at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
428    at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
429    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
430    at java.lang.reflect.Method.invoke(Method.java:597)
431    at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
432    at $Proxy4.prepareStatement(Unknown Source)
433    at com.liferay.portal.upgrade.v6_1_0.UpgradeUserName.updateTable(UpgradeUserName.java:68)
434    at com.liferay.portal.upgrade.v6_1_0.UpgradeUserName.doUpgrade(UpgradeUserName.java:37)
435    at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
436    ... 30 more
437Stopping the server due to unexpected startup errors
Mika Koivisto
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
March 1, 2012 4:48 PM
Answer

Mika Koivisto

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1513

Join Date: August 7, 2006

Recent Posts

Some how you have a image with same name twice in the same folder. This issue has been fixed in http://issues.liferay.com/browse/LPS-24602. You can manually rename it in your 6.0.6 database. Notice you cannot resume a failed upgrade. You must restore the original database and start from beginning.
Lisa Simpson
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 1:43 PM
Answer

Lisa Simpson

Rank: Junior Member

Posts: 25

Join Date: October 22, 2013

Recent Posts

I'm having a VERY similar error message in going from 5.2.3 to 6.X
My upgrade is dying on: ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: user lacks privilege or object not found: DLFILEVERSION.NAME

Unfortunately, I have no such file nor am I able to locate where it outght to be or I'd create a dummy to allow the upgrade to proceed.
Lisa Simpson
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 2:00 PM
Answer

Lisa Simpson

Rank: Junior Member

Posts: 25

Join Date: October 22, 2013

Recent Posts

FYI - there have been MULTIPLE bug report filed on this very issue. See: https://issues.liferay.com/secure/attachment/43458/catalina.out

https://issues.liferay.com/browse/LPS-18815

If you're looking to see if something is a new bug, you can always check out the handy Time Tracking Report that they've helpfully published to the internet.
Attachments: Time Tracking Report.xls (5,165.0k)
Lisa Simpson
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 2:04 PM
Answer

Lisa Simpson

Rank: Junior Member

Posts: 25

Join Date: October 22, 2013

Recent Posts

Mika Koivisto:
Notice you cannot resume a failed upgrade.


WTH? The version upgrade just fails unrecoverably? It doesn't roll back? Or pick up where it left off? And you call this thing "enterprise"? Seriously??? Pigeon - my IM client - rolls back when the upgrade fails. So does ClamWin. They're both open source. You all should talk to them to see how they do it. If an IM client can do it, surely you all ought to be able to.

Nice to see things around here haven't changed much.
David H Nebinger
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 2:24 PM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 11287

Join Date: September 1, 2006

Recent Posts

Lisa Simpson:
Mika Koivisto:
Notice you cannot resume a failed upgrade.


WTH? The version upgrade just fails unrecoverably? It doesn't roll back? Or pick up where it left off? And you call this thing "enterprise"? Seriously??? Pigeon - my IM client - rolls back when the upgrade fails. So does ClamWin. They're both open source. You all should talk to them to see how they do it. If an IM client can do it, surely you all ought to be able to.


Sure, because database rollbacks also apply to underlying DDL changes, it is a walk in the park to handle that. And we all know that IM clients and portal web applications are pretty much the same level of complexity, so clearly they will be able to help make this rollback thing happen.

Sarcasm aside, upgrades between versions are not easy nor should they be taken lightly or undertaken by the inexperienced. They require planning, testing, sometimes some coding (to upgrade custom plugins, themes, etc.), etc.

I've posted numerous times in the forums that before beginning any upgrade you should have a backup of your database and data directory so you can roll back in case of failure (because DDL changes are not subject to 'rollback' commands).

Lisa Simpson:
I'm having a VERY similar error message in going from 5.2.3 to 6.X


This is quite a different issue than what the OP started with (6.0 to 6.1).

My upgrade is dying on: ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: user lacks privilege or object not found: DLFILEVERSION.NAME


This is a database exception, whatever credentials you're using does not have full DBA privileges (the credentials need to be able to create, alter, and drop tables, constraints, indices, etc.).

I understand you're probably frustrated after trying to attempt an upgrade that didn't go so well. I hope you have some backups so you can roll back and position to try again. We'll help you out as much as we can on a forum...
Lisa Simpson
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 3:22 PM
Answer

Lisa Simpson

Rank: Junior Member

Posts: 25

Join Date: October 22, 2013

Recent Posts

When I try to run the SQL commands manually for the upgrade, here's the error log.... It's not backups. Its the need for them that annoys me. Should you back up before an upgrade? Yeah... DUH! Anyone who doesn't and ends up in the poop totally bought it. Should you have to restore from backup because the upgrade didn't finish on a a product that bills itself as an ENTERPRISE product? No. Frankly it's just not that hard to do. You know what changes you are making with the script. You log each change as things progress in a way that the update process can see what completed and what did not. You add some lines to script that say, "OOPS! We didn't finish this. Let me roll it back for you." And then you have a script that runs that undoes every single change. No harm, no foul, and no tape drive.

If you're going to wave the "Enterprise" flag around, you need to be able to walk it, not just talk it. This is something that real enterprise software does. Liferay has delusions of being "enterprise" software. It calls itself "enterprise". It will even try to get money from you for it's "enterprise" version but it's certainly NOT what I'm used to in any kind of an enterprise product. The "Oh, well... hope you have a backup you can restore from" is SERIOUSLY junior-G man bush-league stuff. There are a LOT of open source projects out there now that do this. Just not Liferay.

Oh, and for this particular database, the user has every right you can grant on MySQL but GRANT, which it shouldn't need. It should NEVER need to have the ability to create more databases, or more users users, and it certainly should never be able to change its own or another user's privileges. I've attached a screen shot of my console showing the rights that my DB user has. Frankly, the SQL that's been provided to perform the upgrade leaves more than a bit to be desired.

1) the command in MySQL is "Commit" not "COMMIT_TRANSACTION"

2) Running a COMMIT on mysql without having an error handler built in to roll the change back is fairly useless. Here's a blog post that discusses the issue in depth which will hopefully educate who ever is writing this SQL on the proper way to do it.

3) Using an IF EXISTS test to see if the table or column is already present and then, if it does exist, using an ALTER statement to make changes to the table rather than attempt to recreate it would stop a LOT of the errors and make the process run quicker. It would also all you to bundle all of this into a block of statements that COULD be rolled back prior to doing a COMMIT.

4) You can't declare primary keys without giving them a size, especially when you're using TEXT as a primary key. And there are good reasons not to use text as a primary key...
Like this one, and this one which is actually for PostgreSQL but gives a basic explanation of good DBA practice, and this one which explains more reasons. Most modern databases have a datatype of UUID that can be used if you need a unique, automagically generated identifier.

5) STRING is not a valid data-type for mysql. There are various data types one can use to hold a string, but STRING itself isn't a datatype.

Query:
CREATE TABLE HIBERNATE_SEQUENCES (
SEQUENCE_NAME VARCHAR(200) NOT NULL,
NEXT_VAL INT NOT NULL,
PRIMARY KEY (SEQUENCE_NAME)
)

Error occured at:2013-04-29 13:29:15
Line no.:5
Error Code: 1050 - Table 'hibernate_sequences' already exists

Query:
CREATE TABLE QRTZ_BLOB_TRIGGERS (
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
BLOB_DATA BINARY(2147483647),
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP)
)

Error occured at:2013-04-29 13:29:51
Line no.:396
Error Code: 1074 - Column length too big for column 'BLOB_DATA' (max = 255); use BLOB or TEXT instead

Query:
update DLFileShortcut set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:24:38
Line no.:140
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
create table AssetCategory (
uuid_ varchar(75) null,
categoryId bigint not null primary key,
groupId bigint,
companyId bigint,
userId bigint,
userName varchar(75) null,
createDate datetime null,
modifiedDate datetime null,
parentCategoryId bigint,
leftCategoryId bigint,
rightCategoryId bigint,
name varchar(75) null,
title longtext null,
vocabularyId bigint
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:16
Error Code: 1050 - Table 'AssetCategory' already exists

Query:
create table AssetCategoryProperty (
categoryPropertyId bigint not null primary key,
companyId bigint,
userId bigint,
userName varchar(75) null,
createDate datetime null,
modifiedDate datetime null,
categoryId bigint,
key_ varchar(75) null,
value varchar(75) null
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:28
Error Code: 1050 - Table 'AssetCategoryProperty' already exists

Query:
create table AssetEntries_AssetCategories (
entryId bigint not null,
categoryId bigint not null,
primary key (entryId, categoryId)
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:34
Error Code: 1050 - Table 'AssetEntries_AssetCategories' already exists

Query:
create table AssetEntries_AssetTags (
entryId bigint not null,
tagId bigint not null,
primary key (entryId, tagId)
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:40
Error Code: 1050 - Table 'AssetEntries_AssetTags' already exists

Query:
create table AssetEntry (
entryId bigint not null primary key,
groupId bigint,
companyId bigint,
userId bigint,
userName varchar(75) null,
createDate datetime null,
modifiedDate datetime null,
classNameId bigint,
classPK bigint,
visible tinyint,
startDate datetime null,
endDate datetime null,
publishDate datetime null,
expirationDate datetime null,
mimeType varchar(75) null,
title varchar(255) null,
description longtext null,
summary longtext null,
url longtext null,
height integer,
width integer,
priority double,
viewCount integer
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:66
Error Code: 1050 - Table 'AssetEntry' already exists

Query:
create table AssetTag (
tagId bigint not null primary key,
groupId bigint,
companyId bigint,
userId bigint,
userName varchar(75) null,
createDate datetime null,
modifiedDate datetime null,
name varchar(75) null,
assetCount integer
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:78
Error Code: 1050 - Table 'AssetTag' already exists

Query:
create table AssetTagProperty (
tagPropertyId bigint not null primary key,
companyId bigint,
userId bigint,
userName varchar(75) null,
createDate datetime null,
modifiedDate datetime null,
tagId bigint,
key_ varchar(75) null,
value varchar(255) null
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:90
Error Code: 1050 - Table 'AssetTagProperty' already exists

Query:
create table AssetTagStats (
tagStatsId bigint not null primary key,
tagId bigint,
classNameId bigint,
assetCount integer
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:97
Error Code: 1050 - Table 'AssetTagStats' already exists

Query:
create table AssetVocabulary (
uuid_ varchar(75) null,
vocabularyId bigint not null primary key,
groupId bigint,
companyId bigint,
userId bigint,
userName varchar(75) null,
createDate datetime null,
modifiedDate datetime null,
name varchar(75) null,
title longtext null,
description longtext null,
settings_ longtext null
) engine InnoDB

Error occured at:2013-11-08 14:25:15
Line no.:112
Error Code: 1050 - Table 'AssetVocabulary' already exists

Query:
alter table BlogsEntry add allowPingbacks tinyint

Error occured at:2013-11-08 14:25:15
Line no.:114
Error Code: 1060 - Duplicate column name 'allowPingbacks'

Query:
alter table BlogsEntry add status integer

Error occured at:2013-11-08 14:25:15
Line no.:115
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table BlogsEntry add statusByUserId bigint

Error occured at:2013-11-08 14:25:15
Line no.:116
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table BlogsEntry add statusByUserName varchar(75)

Error occured at:2013-11-08 14:25:15
Line no.:117
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table BlogsEntry add statusDate datetime

Error occured at:2013-11-08 14:25:15
Line no.:118
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
alter table DLFileEntry add pendingVersion varchar(75) null

Error occured at:2013-11-08 14:25:15
Line no.:129
Error Code: 1060 - Duplicate column name 'pendingVersion'

Query:
alter table DLFileShortcut add status integer

Error occured at:2013-11-08 14:25:15
Line no.:131
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table DLFileShortcut add statusByUserId bigint

Error occured at:2013-11-08 14:25:15
Line no.:132
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table DLFileShortcut add statusByUserName varchar(75)

Error occured at:2013-11-08 14:25:15
Line no.:133
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table DLFileShortcut add statusDate datetime

Error occured at:2013-11-08 14:25:15
Line no.:134
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
update DLFileShortcut set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:25:15
Line no.:140
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
update DLFileVersion set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:25:16
Line no.:155
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
update MBMessage set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:27:36
Line no.:219
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
update WikiPage set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:27:52
Line no.:255
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
create table AssetCategory (
uuid_ VARCHAR(75) null,
categoryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
parentCategoryId LONG,
leftCategoryId LONG,
rightCategoryId LONG,
name VARCHAR(75) null,
title STRING null,
vocabularyId LONG
)

Error occured at:2013-11-08 14:31:06
Line no.:16
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
vocabularyId LONG
)' at line 14

Query:
create table AssetLink (
linkId LONG not null primary key,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
entryId1 LONG,
entryId2 LONG,
type_ INTEGER,
weight INTEGER
)

Error occured at:2013-11-08 14:33:29
Line no.:11
Error Code: 1170 - BLOB/TEXT column 'linkId' used in key specification without a key length

Query:
create table AssetCategory (
uuid_ VARCHAR(75) null,
categoryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
parentCategoryId LONG,
leftCategoryId LONG,
rightCategoryId LONG,
name VARCHAR(75) null,
title STRING null,
vocabularyId LONG
)

Error occured at:2013-11-08 14:33:57
Line no.:16
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
vocabularyId LONG
)' at line 14

Query:
create table AssetCategoryProperty (
categoryPropertyId LONG not null primary key,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
categoryId LONG,
key_ VARCHAR(75) null,
value VARCHAR(75) null
)

Error occured at:2013-11-08 14:33:57
Line no.:28
Error Code: 1170 - BLOB/TEXT column 'categoryPropertyId' used in key specification without a key length

Query:
create table AssetEntries_AssetCategories (
entryId LONG not null,
categoryId LONG not null,
primary key (entryId, categoryId)
)

Error occured at:2013-11-08 14:33:57
Line no.:34
Error Code: 1170 - BLOB/TEXT column 'entryId' used in key specification without a key length

Query:
create table AssetEntries_AssetTags (
entryId LONG not null,
tagId LONG not null,
primary key (entryId, tagId)
)

Error occured at:2013-11-08 14:33:57
Line no.:40
Error Code: 1170 - BLOB/TEXT column 'entryId' used in key specification without a key length


Query:
create table AssetEntry (
entryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
classNameId LONG,
classPK LONG,
visible BOOLEAN,
startDate DATE null,
endDate DATE null,
publishDate DATE null,
expirationDate DATE null,
mimeType VARCHAR(75) null,
title VARCHAR(255) null,
description STRING null,
summary STRING null,
url STRING null,
height INTEGER,
width INTEGER,
priority DOUBLE,
viewCount INTEGER
)

Error occured at:2013-11-08 14:33:57
Line no.:66
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
summary STRING null,
url STRING null,
height INTEGER,
width INT' at line 18

Query:
create table AssetTag (
tagId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
name VARCHAR(75) null,
assetCount INTEGER
)

Error occured at:2013-11-08 14:33:57
Line no.:78
Error Code: 1170 - BLOB/TEXT column 'tagId' used in key specification without a key length

Query:
create table AssetTagProperty (
tagPropertyId LONG not null primary key,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
tagId LONG,
key_ VARCHAR(75) null,
value VARCHAR(255) null
)

Error occured at:2013-11-08 14:33:57
Line no.:90
Error Code: 1170 - BLOB/TEXT column 'tagPropertyId' used in key specification without a key length

Query:
create table AssetTagStats (
tagStatsId LONG not null primary key,
tagId LONG,
classNameId LONG,
assetCount INTEGER
)

Error occured at:2013-11-08 14:33:57
Line no.:97
Error Code: 1170 - BLOB/TEXT column 'tagStatsId' used in key specification without a key length

Query:
create table AssetVocabulary (
uuid_ VARCHAR(75) null,
vocabularyId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
name VARCHAR(75) null,
title STRING null,
description STRING null,
settings_ STRING null
)

Error occured at:2013-11-08 14:33:57
Line no.:112
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
description STRING null,
settings_ STRING null
)' at line 11

Query:
alter table BlogsEntry add allowPingbacks BOOLEAN

Error occured at:2013-11-08 14:33:57
Line no.:114
Error Code: 1060 - Duplicate column name 'allowPingbacks'

Query:
alter table BlogsEntry add status INTEGER

Error occured at:2013-11-08 14:33:57
Line no.:115
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table BlogsEntry add statusByUserId LONG

Error occured at:2013-11-08 14:33:57
Line no.:116
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table BlogsEntry add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:33:57
Line no.:117
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table BlogsEntry add statusDate DATE

Error occured at:2013-11-08 14:33:57
Line no.:118
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:33:57
Line no.:120
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1


Query:
alter table DLFileEntry add pendingVersion VARCHAR(75) null

Error occured at:2013-11-08 14:33:57
Line no.:129
Error Code: 1060 - Duplicate column name 'pendingVersion'

Query:
alter table DLFileShortcut add status INTEGER

Error occured at:2013-11-08 14:33:57
Line no.:131
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table DLFileShortcut add statusByUserId LONG

Error occured at:2013-11-08 14:33:57
Line no.:132
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table DLFileShortcut add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:33:57
Line no.:133
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table DLFileShortcut add statusDate DATE

Error occured at:2013-11-08 14:33:57
Line no.:134
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:33:57
Line no.:136
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
update DLFileShortcut set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:33:57
Line no.:140
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist


Query:
drop index IX_6C5E6512 on DLFileVersion


Error occured at:2013-11-08 14:33:57
Line no.:143
Error Code: 1091 - Can't DROP 'IX_6C5E6512'; check that column/key exists

Query:
alter table DLFileVersion add description STRING null

Error occured at:2013-11-08 14:33:57
Line no.:145
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1


Query:
alter table DLFileVersion add status INTEGER

Error occured at:2013-11-08 14:33:57
Line no.:146
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table DLFileVersion add statusByUserId LONG

Error occured at:2013-11-08 14:33:57
Line no.:147
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table DLFileVersion add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:33:57
Line no.:148
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table DLFileVersion add statusDate DATE

Error occured at:2013-11-08 14:33:57
Line no.:149
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:33:57
Line no.:151
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1


Query:
update DLFileVersion set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:33:57
Line no.:155
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
alter table JournalArticle add status INTEGER

Error occured at:2013-11-08 14:33:57
Line no.:158
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table JournalArticle add statusByUserId LONG

Error occured at:2013-11-08 14:33:57
Line no.:159
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table JournalArticle add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:33:57
Line no.:160
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table JournalArticle add statusDate DATE

Error occured at:2013-11-08 14:33:57
Line no.:161
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:33:57
Line no.:163
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1


Query:
alter table Layout add layoutPrototypeId LONG

Error occured at:2013-11-08 14:34:02
Line no.:172
Error Code: 1060 - Duplicate column name 'layoutPrototypeId'

Query:
create table LayoutPrototype (
layoutPrototypeId LONG not null primary key,
companyId LONG,
name STRING null,
description STRING null,
settings_ STRING null,
active_ BOOLEAN
)

Error occured at:2013-11-08 14:34:02
Line no.:181
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
description STRING null,
settings_ STRING null,
active_ BOOLEAN
' at line 4

Query:
alter table LayoutSet add layoutSetPrototypeId LONG

Error occured at:2013-11-08 14:34:02
Line no.:183
Error Code: 1060 - Duplicate column name 'layoutSetPrototypeId'

Query:
create table LayoutSetPrototype (
layoutSetPrototypeId LONG not null primary key,
companyId LONG,
name STRING null,
description STRING null,
settings_ STRING null,
active_ BOOLEAN
)

Error occured at:2013-11-08 14:34:02
Line no.:192
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
description STRING null,
settings_ STRING null,
active_ BOOLEAN
' at line 4


Query:
create table Lock_ (
uuid_ VARCHAR(75) null,
lockId LONG not null primary key,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
className VARCHAR(75) null,
key_ VARCHAR(200) null,
owner VARCHAR(75) null,
inheritable BOOLEAN,
expirationDate DATE null
)

Error occured at:2013-11-08 14:34:02
Line no.:206
Error Code: 1170 - BLOB/TEXT column 'lockId' used in key specification without a key length

Query:
alter table MBMessage add allowPingbacks BOOLEAN

Error occured at:2013-11-08 14:34:02
Line no.:208
Error Code: 1060 - Duplicate column name 'allowPingbacks'

Query:
alter table MBMessage add status INTEGER

Error occured at:2013-11-08 14:34:02
Line no.:209
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table MBMessage add statusByUserId LONG

Error occured at:2013-11-08 14:34:02
Line no.:210
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table MBMessage add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:34:02
Line no.:211
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table MBMessage add statusDate DATE

Error occured at:2013-11-08 14:34:02
Line no.:212
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:34:02
Line no.:214
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line
1

Query:
update MBMessage set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:34:05
Line no.:219
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
alter table MBThread add status INTEGER

Error occured at:2013-11-08 14:34:06
Line no.:222
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table MBThread add statusByUserId LONG

Error occured at:2013-11-08 14:34:06
Line no.:223
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table MBThread add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:34:06
Line no.:224
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table MBThread add statusDate DATE

Error occured at:2013-11-08 14:34:06
Line no.:225
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:34:06
Line no.:227
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table Release_ add servletContextName VARCHAR(75)

Error occured at:2013-11-08 14:34:06
Line no.:231
Error Code: 1060 - Duplicate column name 'servletContextName'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:34:06
Line no.:233
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table ShoppingItem add groupId LONG

Error occured at:2013-11-08 14:34:06
Line no.:237
Error Code: 1060 - Duplicate column name 'groupId'

Query:
create table UserGroupGroupRole (
userGroupId LONG not null,
groupId LONG not null,
roleId LONG not null,
primary key (userGroupId, groupId, roleId)
)

Error occured at:2013-11-08 14:34:06
Line no.:244
Error Code: 1170 - BLOB/TEXT column 'userGroupId' used in key specification without a key length

Query:
alter table WikiPage add status INTEGER

Error occured at:2013-11-08 14:34:06
Line no.:246
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table WikiPage add statusByUserId LONG

Error occured at:2013-11-08 14:34:06
Line no.:247
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table WikiPage add statusByUserName VARCHAR(75)

Error occured at:2013-11-08 14:34:06
Line no.:248
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table WikiPage add statusDate DATE

Error occured at:2013-11-08 14:34:06
Line no.:249
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:34:06
Line no.:251
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
update WikiPage set statusByUserName = CAST_TEXT(userId)

Error occured at:2013-11-08 14:34:06
Line no.:255
Error Code: 1305 - FUNCTION lportal.CAST_TEXT does not exist

Query:
create table WorkflowDefinitionLink (
workflowDefinitionLinkId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
classNameId LONG,
workflowDefinitionName VARCHAR(75) null,
workflowDefinitionVersion INTEGER
)

Error occured at:2013-11-08 14:34:07
Line no.:269
Error Code: 1170 - BLOB/TEXT column 'workflowDefinitionLinkId' used in key specification without a key length

Query:
create table WorkflowInstanceLink (
workflowInstanceLinkId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
classNameId LONG,
classPK LONG,
workflowInstanceId LONG
)

Error occured at:2013-11-08 14:34:07
Line no.:282
Error Code: 1170 - BLOB/TEXT column 'workflowInstanceLinkId' used in key specification without a key length

Query:
create table AssetLink (
linkId LONG not null primary key,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
entryId1 LONG,
entryId2 LONG,
type_ INTEGER,
weight INTEGER
)

Error occured at:2013-11-08 14:34:42
Line no.:11
Error Code: 1170 - BLOB/TEXT column 'linkId' used in key specification without a key length

Query:
create table Team (
teamId LONG not null primary key,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
groupId LONG,
name VARCHAR(75) null,
description STRING null
)

Error occured at:2013-11-08 14:34:42
Line no.:23
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null
)' at line 10

Query:
create table Users_Teams (
userId LONG not null,
teamId LONG not null,
primary key (userId, teamId)
)

Error occured at:2013-11-08 14:34:42
Line no.:29
Error Code: 1170 - BLOB/TEXT column 'userId' used in key specification without a key length

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:35:10
Line no.:5
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:35:15
Line no.:24
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table SocialEquityAssetEntry (
equityAssetEntryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
assetEntryId LONG,
informationK DOUBLE,
informationB DOUBLE,
informationEquity DOUBLE
)

Error occured at:2013-11-08 14:35:15
Line no.:42
Error Code: 1170 - BLOB/TEXT column 'equityAssetEntryId' used in key specification without a key length

Query:
create table SocialEquityHistory (
equityHistoryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
createDate DATE null,
personalEquity INTEGER
)

Error occured at:2013-11-08 14:35:15
Line no.:51
Error Code: 1170 - BLOB/TEXT column 'equityHistoryId' used in key specification without a key length

Query:
create table SocialEquityLog (
equityLogId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
assetEntryId LONG,
actionId VARCHAR(75) null,
actionDate INTEGER,
type_ INTEGER,
value INTEGER,
validity INTEGER,
active_ BOOLEAN
)

Error occured at:2013-11-08 14:35:15
Line no.:65
Error Code: 1170 - BLOB/TEXT column 'equityLogId' used in key specification without a key length

Query:
create table SocialEquitySetting (
equitySettingId LONG not null primary key,
groupId LONG,
companyId LONG,
classNameId LONG,
actionId VARCHAR(75) null,
type_ INTEGER,
value INTEGER,
validity INTEGER
)

Error occured at:2013-11-08 14:35:15
Line no.:76
Error Code: 1170 - BLOB/TEXT column 'equitySettingId' used in key specification without a key length

Query:
create table SocialEquityUser (
equityUserId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
contributionEquity DOUBLE,
participationK DOUBLE,
participationB DOUBLE,
participationEquity DOUBLE,
personalEquity DOUBLE
)

Error occured at:2013-11-08 14:35:15
Line no.:88
Error Code: 1170 - BLOB/TEXT column 'equityUserId' used in key specification without a key length

Query:
create table Ticket (
ticketId LONG not null primary key,
companyId LONG,
createDate DATE null,
classNameId LONG,
classPK LONG,
key_ VARCHAR(75) null,
expirationDate DATE null
)

Error occured at:2013-11-08 14:35:15
Line no.:98
Error Code: 1170 - BLOB/TEXT column 'ticketId' used in key specification without a key length

Query:
alter table DLFileVersion add changeLog STRING null

Error occured at:2013-11-08 14:35:45
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:35:45
Line no.:10
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
update DLFileVersion set changeLog = description

Error occured at:2013-11-08 14:35:45
Line no.:12
Error Code: 1054 - Unknown column 'changeLog' in 'field list'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 14:35:55
Line no.:18
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
drop table SocialEquityAssetEntry

Error occured at:2013-11-08 14:35:57
Line no.:22
Error Code: 1051 - Unknown table 'SocialEquityAssetEntry'

Query:
create table SocialEquityAssetEntry (
equityAssetEntryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
assetEntryId LONG,
informationK DOUBLE,
informationB DOUBLE
)

Error occured at:2013-11-08 14:35:57
Line no.:32
Error Code: 1170 - BLOB/TEXT column 'equityAssetEntryId' used in key specification without a key length

Query:
drop table SocialEquityHistory

Error occured at:2013-11-08 14:35:57
Line no.:34
Error Code: 1051 - Unknown table 'SocialEquityHistory'

Query:
create table SocialEquityHistory (
equityHistoryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
createDate DATE null,
personalEquity INTEGER
)

Error occured at:2013-11-08 14:35:57
Line no.:43
Error Code: 1170 - BLOB/TEXT column 'equityHistoryId' used in key specification without a key length

Query:
drop table SocialEquityLog

Error occured at:2013-11-08 14:35:57
Line no.:45
Error Code: 1051 - Unknown table 'SocialEquityLog'

Query:
create table SocialEquityLog (
equityLogId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
assetEntryId LONG,
actionId VARCHAR(75) null,
actionDate INTEGER,
active_ BOOLEAN,
expiration INTEGER,
type_ INTEGER,
value INTEGER
)

Error occured at:2013-11-08 14:35:57
Line no.:59
Error Code: 1170 - BLOB/TEXT column 'equityLogId' used in key specification without a key length

Query:
drop table SocialEquitySetting

Error occured at:2013-11-08 14:35:57
Line no.:61
Error Code: 1051 - Unknown table 'SocialEquitySetting'

Query:
create table SocialEquitySetting (
equitySettingId LONG not null primary key,
groupId LONG,
companyId LONG,
classNameId LONG,
actionId VARCHAR(75) null,
dailyLimit INTEGER,
lifespan INTEGER,
type_ INTEGER,
uniqueEntry BOOLEAN,
value INTEGER
)

Error occured at:2013-11-08 14:35:57
Line no.:74
Error Code: 1170 - BLOB/TEXT column 'equitySettingId' used in key specification without a key length

Query:
drop table SocialEquityUser

Error occured at:2013-11-08 14:35:57
Line no.:76
Error Code: 1051 - Unknown table 'SocialEquityUser'

Query:
create table SocialEquityUser (
equityUserId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
contributionK DOUBLE,
contributionB DOUBLE,
participationK DOUBLE,
participationB DOUBLE,
rank INTEGER
)

Error occured at:2013-11-08 14:35:57
Line no.:88
Error Code: 1170 - BLOB/TEXT column 'equityUserId' used in key specification without a key length

Query:
alter table AssetEntry add classUuid varchar(75) null

Error occured at:2013-11-08 14:37:06
Line no.:1
Error Code: 1060 - Duplicate column name 'classUuid'

Query:
alter table DLFileEntry add extension varchar(75) null

Error occured at:2013-11-08 14:37:06
Line no.:3
Error Code: 1060 - Duplicate column name 'extension'

Query:
alter table DLFileVersion add extension varchar(75) null

Error occured at:2013-11-08 14:37:06
Line no.:5
Error Code: 1060 - Duplicate column name 'extension'

Query:
alter table DLFileVersion add title varchar(255) null

Error occured at:2013-11-08 14:37:06
Line no.:6
Error Code: 1060 - Duplicate column name 'title'

Query:
alter table DLFileVersion add extraSettings longtext null

Error occured at:2013-11-08 14:37:06
Line no.:8
Error Code: 1060 - Duplicate column name 'extraSettings'

Query:
alter table Layout add uuid_ varchar(75) null

Error occured at:2013-11-08 14:37:06
Line no.:14
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table MBMessage add rootMessageId bigint

Error occured at:2013-11-08 14:37:06
Line no.:16
Error Code: 1060 - Duplicate column name 'rootMessageId'

Query:
drop table SocialEquityAssetEntry

Error occured at:2013-11-08 14:37:07
Line no.:22
Error Code: 1051 - Unknown table 'SocialEquityAssetEntry'

Query:
drop table SocialEquityHistory

Error occured at:2013-11-08 14:37:07
Line no.:34
Error Code: 1051 - Unknown table 'SocialEquityHistory'

Query:
drop table SocialEquityLog

Error occured at:2013-11-08 14:37:07
Line no.:45
Error Code: 1051 - Unknown table 'SocialEquityLog'

Query:
drop table SocialEquitySetting

Error occured at:2013-11-08 14:37:07
Line no.:61
Error Code: 1051 - Unknown table 'SocialEquitySetting'

Query:
drop table SocialEquityUser

Error occured at:2013-11-08 14:37:07
Line no.:76
Error Code: 1051 - Unknown table 'SocialEquityUser'

Query:
alter table User_ add facebookId bigint

Error occured at:2013-11-08 14:37:07
Line no.:90
Error Code: 1060 - Duplicate column name 'facebookId'

Query:
alter table WikiPageResource add uuid_ varchar(75) null

Error occured at:2013-11-08 14:37:07
Line no.:92
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
drop index IX_55C736AC on DLFileShortcut

Error occured at:2013-11-08 14:38:15
Line no.:224
Error Code: 1091 - Can't DROP 'IX_55C736AC'; check that column/key exists

Query:
drop index IX_346A0992 on DLFileShortcut

Error occured at:2013-11-08 14:38:15
Line no.:225
Error Code: 1091 - Can't DROP 'IX_346A0992'; check that column/key exists

Query:
drop index IX_B413F1EC on DLFileVersion

Error occured at:2013-11-08 14:38:15
Line no.:234
Error Code: 1091 - Can't DROP 'IX_B413F1EC'; check that column/key exists

Query:
drop index IX_94E784D2 on DLFileVersion

Error occured at:2013-11-08 14:38:15
Line no.:235
Error Code: 1091 - Can't DROP 'IX_94E784D2'; check that column/key exists

Query:
drop index IX_2F8FED9C on DLFileVersion

Error occured at:2013-11-08 14:38:15
Line no.:236
Error Code: 1091 - Can't DROP 'IX_2F8FED9C'; check that column/key exists

Query:
alter table Ticket add type_ integer

Error occured at:2013-11-08 14:40:52
Line no.:604
Error Code: 1146 - Table 'lportal.Ticket' doesn't exist

Query:
alter table Ticket add extraInfo longtext null

Error occured at:2013-11-08 14:40:52
Line no.:605
Error Code: 1146 - Table 'lportal.Ticket' doesn't exist

Query:
update Ticket set type_ = 3

Error occured at:2013-11-08 14:40:52
Line no.:609
Error Code: 1146 - Table 'lportal.Ticket' doesn't exist

Query:
alter table BookmarksEntry add treePath STRING null

Error occured at:2013-11-08 15:09:15
Line no.:5
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:15
Line no.:11
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table BookmarksFolder add treePath STRING null

Error occured at:2013-11-08 15:09:15
Line no.:18
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:16
Line no.:24
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table BackgroundTask (
backgroundTaskId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
name VARCHAR(75) null,
servletContextNames VARCHAR(255) null,
taskExecutorClassName VARCHAR(200) null,
taskContext TEXT null,
completed BOOLEAN,
completionDate DATE null,
status INTEGER,
statusMessage TEXT null
)

Error occured at:2013-11-08 15:09:16
Line no.:47
Error Code: 1170 - BLOB/TEXT column 'backgroundTaskId' used in key specification without a key length

Query:
drop index IX_490E7A1E on DDMStructure

Error occured at:2013-11-08 15:09:16
Line no.:308
Error Code: 1091 - Can't DROP 'IX_490E7A1E'; check that column/key exists

Query:
alter table DDMTemplate add smallImageURL STRING

Error occured at:2013-11-08 15:09:17
Line no.:313
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING' at line 1

Query:
alter table DLFileEntry add treePath STRING null

Error occured at:2013-11-08 15:09:18
Line no.:323
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:18
Line no.:328
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table DLFileShortcut add treePath STRING null

Error occured at:2013-11-08 15:09:18
Line no.:332
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:18
Line no.:335
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table DLFileVersion add treePath STRING null

Error occured at:2013-11-08 15:09:18
Line no.:339
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table DLFolder add treePath STRING null

Error occured at:2013-11-08 15:09:19
Line no.:342
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:21
Line no.:349
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table DLSyncEvent (
syncEventId LONG not null primary key,
modifiedTime LONG,
event VARCHAR(75) null,
type_ VARCHAR(75) null,
typePK LONG
)

Error occured at:2013-11-08 15:09:22
Line no.:365
Error Code: 1170 - BLOB/TEXT column 'syncEventId' used in key specification without a key length

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:22
Line no.:371
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table Group_ add treePath STRING null

Error occured at:2013-11-08 15:09:22
Line no.:376
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:09:24
Line no.:381
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table JournalArticle add treePath STRING null

Error occured at:2013-11-08 15:10:02
Line no.:393
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:10:02
Line no.:395
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table JournalFolder (
uuid_ VARCHAR(75) null,
folderId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
parentFolderId LONG,
treePath STRING null,
name VARCHAR(100) null,
description STRING null,
status INTEGER,
statusByUserId LONG,
statusByUserName VARCHAR(75) null,
statusDate DATE null
)

Error occured at:2013-11-08 15:10:09
Line no.:416
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
name VARCHAR(100) null,
description STRING null,
status INTEGER,' at line 11

Query:
create table LayoutFriendlyURL (
uuid_ VARCHAR(75) null,
layoutFriendlyURLId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
plid LONG,
privateLayout BOOLEAN,
friendlyURL VARCHAR(255) null,
languageId VARCHAR(75) null
)

Error occured at:2013-11-08 15:10:28
Line no.:434
Error Code: 1170 - BLOB/TEXT column 'layoutFriendlyURLId' used in key specification without a key length

Query:
drop index IX_228562AD on Lock_

Error occured at:2013-11-08 15:10:31
Line no.:444
Error Code: 1091 - Can't DROP 'IX_228562AD'; check that column/key exists

Query:
drop index IX_DD635956 on Lock_

Error occured at:2013-11-08 15:10:31
Line no.:445
Error Code: 1091 - Can't DROP 'IX_DD635956'; check that column/key exists

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:10:48
Line no.:462
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
drop index IX_88705859 on ResourcePermission

Error occured at:2013-11-08 15:11:26
Line no.:528
Error Code: 1091 - Can't DROP 'IX_88705859'; check that column/key exists

Query:
drop index IX_C94C7708 on ResourcePermission

Error occured at:2013-11-08 15:11:26
Line no.:529
Error Code: 1091 - Can't DROP 'IX_C94C7708'; check that column/key exists

Query:
drop index IX_8D83D0CE on ResourcePermission

Error occured at:2013-11-08 15:11:26
Line no.:530
Error Code: 1091 - Can't DROP 'IX_8D83D0CE'; check that column/key exists

Query:
drop index IX_4A1F4402 on ResourcePermission

Error occured at:2013-11-08 15:11:26
Line no.:531
Error Code: 1091 - Can't DROP 'IX_4A1F4402'; check that column/key exists

Query:
drop index IX_8DB864A9 on ResourcePermission

Error occured at:2013-11-08 15:11:26
Line no.:532
Error Code: 1091 - Can't DROP 'IX_8DB864A9'; check that column/key exists

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:11:32
Line no.:548
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table SocialActivitySet (
activitySetId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
createDate LONG,
modifiedDate LONG,
classNameId LONG,
classPK LONG,
type_ INTEGER,
extraData STRING null,
activityCount INTEGER
)

Error occured at:2013-11-08 15:11:32
Line no.:564
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
activityCount INTEGER
)' at line 11

Query:
create table SystemEvent (
systemEventId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
classNameId LONG,
classPK LONG,
classUuid VARCHAR(75) null,
referrerClassNameId LONG,
parentSystemEventId LONG,
systemEventSetKey LONG,
type_ INTEGER,
extraData TEXT null
)

Error occured at:2013-11-08 15:11:32
Line no.:581
Error Code: 1170 - BLOB/TEXT column 'systemEventId' used in key specification without a key length

Query:
create table TrashEntry (
entryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
classNameId LONG,
classPK LONG,
systemEventSetKey LONG,
typeSettings TEXT null,
status INTEGER
)

Error occured at:2013-11-08 15:11:32
Line no.:595
Error Code: 1170 - BLOB/TEXT column 'entryId' used in key specification without a key length

Query:
create table TrashVersion (
versionId LONG not null primary key,
entryId LONG,
classNameId LONG,
classPK LONG,
typeSettings TEXT null,
status INTEGER
)

Error occured at:2013-11-08 15:11:32
Line no.:604
Error Code: 1170 - BLOB/TEXT column 'versionId' used in key specification without a key length

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:11:32
Line no.:608
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table UserNotificationDelivery (
userNotificationDeliveryId LONG not null primary key,
companyId LONG,
userId LONG,
portletId VARCHAR(200) null,
classNameId LONG,
notificationType INTEGER,
deliveryType INTEGER,
deliver BOOLEAN
)

Error occured at:2013-11-08 15:11:36
Line no.:627
Error Code: 1170 - BLOB/TEXT column 'userNotificationDeliveryId' used in key specification without a key length

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 15:11:37
Line no.:640
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table Address add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:20
Line no.:1
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table BookmarksEntry add treePath STRING null

Error occured at:2013-11-08 16:29:20
Line no.:5
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table BookmarksEntry add status INTEGER

Error occured at:2013-11-08 16:29:20
Line no.:6
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table BookmarksEntry add statusByUserId LONG

Error occured at:2013-11-08 16:29:20
Line no.:7
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table BookmarksEntry add statusByUserName VARCHAR(75) null

Error occured at:2013-11-08 16:29:20
Line no.:8
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table BookmarksEntry add statusDate DATE null

Error occured at:2013-11-08 16:29:20
Line no.:9
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:20
Line no.:11
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table BookmarksFolder add treePath STRING null

Error occured at:2013-11-08 16:29:20
Line no.:18
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table BookmarksFolder add status INTEGER

Error occured at:2013-11-08 16:29:20
Line no.:19
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table BookmarksFolder add statusByUserId LONG

Error occured at:2013-11-08 16:29:20
Line no.:20
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table BookmarksFolder add statusByUserName VARCHAR(75) null

Error occured at:2013-11-08 16:29:20
Line no.:21
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table BookmarksFolder add statusDate DATE null

Error occured at:2013-11-08 16:29:20
Line no.:22
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:20
Line no.:24
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table BackgroundTask (
backgroundTaskId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
name VARCHAR(75) null,
servletContextNames VARCHAR(255) null,
taskExecutorClassName VARCHAR(200) null,
taskContext TEXT null,
completed BOOLEAN,
completionDate DATE null,
status INTEGER,
statusMessage TEXT null
)

Error occured at:2013-11-08 16:29:20
Line no.:47
Error Code: 1170 - BLOB/TEXT column 'backgroundTaskId' used in key specification without a key length

Query:
alter table Contact_ add classNameId LONG

Error occured at:2013-11-08 16:29:20
Line no.:49
Error Code: 1060 - Duplicate column name 'classNameId'

Query:
alter table Contact_ add classPK LONG

Error occured at:2013-11-08 16:29:20
Line no.:50
Error Code: 1060 - Duplicate column name 'classPK'

Query:
alter table Contact_ add emailAddress VARCHAR(75) null

Error occured at:2013-11-08 16:29:20
Line no.:51
Error Code: 1060 - Duplicate column name 'emailAddress'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (228, 'aland-islands', 'AX', 'ALA', '248', '359', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:283
Error Code: 1062 - Duplicate entry '228' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (229, 'bonaire-st-eustatius-saba', 'BQ', 'BES', '535', '599', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:284
Error Code: 1062 - Duplicate entry '229' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (230, 'bouvet-island', 'BV', 'BVT', '74', '047', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:285
Error Code: 1062 - Duplicate entry '230' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (231, 'british-indian-ocean-territory', 'IO', 'IOT', '86', '246', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:286
Error Code: 1062 - Duplicate entry '231' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (232, 'curacao', 'CW', 'CUW', '531', '599', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:287
Error Code: 1062 - Duplicate entry '232' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (233, 'french-southern-territories', 'TF', 'ATF', '260', '033', FALSE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:288
Error Code: 1062 - Duplicate entry '233' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (234, 'guernsey', 'GG', 'GGY', '831', '044', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:289
Error Code: 1062 - Duplicate entry '234' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (235, 'heard-island-mcdonald-islands', 'HM', 'HMD', '334', '061', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:290
Error Code: 1062 - Duplicate entry '235' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (236, 'isle-of-man', 'IM', 'IMN', '833', '044', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:291
Error Code: 1062 - Duplicate entry '236' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (237, 'jersey', 'JE', 'JEY', '832', '044', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:292
Error Code: 1062 - Duplicate entry '237' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (238, 'northern-mariana-islands', 'MP', 'MNP', '580', '670', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:293
Error Code: 1062 - Duplicate entry '238' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (239, 'pitcairn', 'PN', 'PCN', '612', '649', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:294
Error Code: 1062 - Duplicate entry '239' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (240, 'south-georgia-south-sandwich-islands', 'GS', 'SGS', '239', '044', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:295
Error Code: 1062 - Duplicate entry '240' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (241, 'south-sudan', 'SS', 'SSD', '728', '211', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:296
Error Code: 1062 - Duplicate entry '241' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (242, 'sint-maarten', 'SX', 'SXM', '534', '721', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:297
Error Code: 1062 - Duplicate entry '242' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (243, 'st-barthelemy', 'BL', 'BLM', '652', '590', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:298
Error Code: 1062 - Duplicate entry '243' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (244, 'st-martin', 'MF', 'MAF', '663', '590', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:299
Error Code: 1062 - Duplicate entry '244' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (245, 'tokelau', 'TK', 'TKL', '772', '690', FALSE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:300
Error Code: 1062 - Duplicate entry '245' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (246, 'timor-leste', 'TL', 'TLS', '626', '670', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:301
Error Code: 1062 - Duplicate entry '246' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (247, 'united-states-minor-outlying-islands', 'UM', 'UMI', '581', '699', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:302
Error Code: 1062 - Duplicate entry '247' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (248, 'united-states-virgin-islands', 'VI', 'VIR', '850', '340', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:303
Error Code: 1062 - Duplicate entry '248' for key 'PRIMARY'

Query:
insert into Country (countryId, name, a2, a3, number_, idd_, zipRequired, active_) values (249, 'western-sahara', 'EH', 'ESH', '732', '212', TRUE, TRUE)

Error occured at:2013-11-08 16:29:20
Line no.:304
Error Code: 1062 - Duplicate entry '249' for key 'PRIMARY'

Query:
alter table DDMStructure add parentStructureId LONG

Error occured at:2013-11-08 16:29:21
Line no.:306
Error Code: 1060 - Duplicate column name 'parentStructureId'

Query:
drop index IX_490E7A1E on DDMStructure

Error occured at:2013-11-08 16:29:21
Line no.:308
Error Code: 1091 - Can't DROP 'IX_490E7A1E'; check that column/key exists

Query:
alter table DDMTemplate add cacheable BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:310
Error Code: 1060 - Duplicate column name 'cacheable'

Query:
alter table DDMTemplate add smallImage BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:311
Error Code: 1060 - Duplicate column name 'smallImage'

Query:
alter table DDMTemplate add smallImageId LONG

Error occured at:2013-11-08 16:29:21
Line no.:312
Error Code: 1060 - Duplicate column name 'smallImageId'

Query:
alter table DDMTemplate add smallImageURL STRING

Error occured at:2013-11-08 16:29:21
Line no.:313
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING' at line 1

Query:
alter table DLFileEntry drop column versionUserId

Error occured at:2013-11-08 16:29:21
Line no.:318
Error Code: 1091 - Can't DROP 'versionUserId'; check that column/key exists

Query:
alter table DLFileEntry drop column versionUserName

Error occured at:2013-11-08 16:29:21
Line no.:319
Error Code: 1091 - Can't DROP 'versionUserName'; check that column/key exists

Query:
alter table DLFileEntry add classNameId LONG

Error occured at:2013-11-08 16:29:21
Line no.:321
Error Code: 1060 - Duplicate column name 'classNameId'

Query:
alter table DLFileEntry add classPK LONG

Error occured at:2013-11-08 16:29:21
Line no.:322
Error Code: 1060 - Duplicate column name 'classPK'

Query:
alter table DLFileEntry add treePath STRING null

Error occured at:2013-11-08 16:29:21
Line no.:323
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table DLFileEntry add manualCheckInRequired BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:324
Error Code: 1060 - Duplicate column name 'manualCheckInRequired'

Query:
alter table DLFileRank add active_ BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:326
Error Code: 1060 - Duplicate column name 'active_'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:21
Line no.:328
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table DLFileShortcut add treePath STRING null

Error occured at:2013-11-08 16:29:21
Line no.:332
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table DLFileShortcut add active_ BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:333
Error Code: 1060 - Duplicate column name 'active_'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:21
Line no.:335
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table DLFileVersion add treePath STRING null

Error occured at:2013-11-08 16:29:21
Line no.:339
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table DLFileVersion add checksum VARCHAR(75) null

Error occured at:2013-11-08 16:29:21
Line no.:340
Error Code: 1060 - Duplicate column name 'checksum'

Query:
alter table DLFolder add treePath STRING null

Error occured at:2013-11-08 16:29:21
Line no.:342
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table DLFolder add hidden_ BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:343
Error Code: 1060 - Duplicate column name 'hidden_'

Query:
alter table DLFolder add status INTEGER

Error occured at:2013-11-08 16:29:21
Line no.:344
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table DLFolder add statusByUserId LONG

Error occured at:2013-11-08 16:29:21
Line no.:345
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table DLFolder add statusByUserName VARCHAR(75) null

Error occured at:2013-11-08 16:29:21
Line no.:346
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table DLFolder add statusDate DATE null

Error occured at:2013-11-08 16:29:21
Line no.:347
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:21
Line no.:349
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
drop table DLSync

Error occured at:2013-11-08 16:29:21
Line no.:357
Error Code: 1051 - Unknown table 'DLSync'

Query:
create table DLSyncEvent (
syncEventId LONG not null primary key,
modifiedTime LONG,
event VARCHAR(75) null,
type_ VARCHAR(75) null,
typePK LONG
)

Error occured at:2013-11-08 16:29:21
Line no.:365
Error Code: 1170 - BLOB/TEXT column 'syncEventId' used in key specification without a key length

Query:
alter table EmailAddress add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:21
Line no.:367
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table ExpandoRow add modifiedDate DATE null

Error occured at:2013-11-08 16:29:21
Line no.:369
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:21
Line no.:371
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table Group_ add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:21
Line no.:375
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table Group_ add treePath STRING null

Error occured at:2013-11-08 16:29:21
Line no.:376
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
alter table Group_ add manualMembership BOOLEAN

Error occured at:2013-11-08 16:29:21
Line no.:377
Error Code: 1060 - Duplicate column name 'manualMembership'

Query:
alter table Group_ add membershipRestriction INTEGER

Error occured at:2013-11-08 16:29:21
Line no.:378
Error Code: 1060 - Duplicate column name 'membershipRestriction'

Query:
alter table Group_ add remoteStagingGroupCount INTEGER

Error occured at:2013-11-08 16:29:21
Line no.:379
Error Code: 1060 - Duplicate column name 'remoteStagingGroupCount'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:21
Line no.:381
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
drop table Groups_Permissions

Error occured at:2013-11-08 16:29:21
Line no.:388
Error Code: 1051 - Unknown table 'Groups_Permissions'

Query:
alter table Image drop column text_

Error occured at:2013-11-08 16:29:21
Line no.:390
Error Code: 1091 - Can't DROP 'text_'; check that column/key exists

Query:
alter table JournalArticle add folderId LONG

Error occured at:2013-11-08 16:29:21
Line no.:392
Error Code: 1060 - Duplicate column name 'folderId'

Query:
alter table JournalArticle add treePath STRING null

Error occured at:2013-11-08 16:29:21
Line no.:393
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null' at line 1

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:21
Line no.:395
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table JournalFolder (
uuid_ VARCHAR(75) null,
folderId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
parentFolderId LONG,
treePath STRING null,
name VARCHAR(100) null,
description STRING null,
status INTEGER,
statusByUserId LONG,
statusByUserName VARCHAR(75) null,
statusDate DATE null
)

Error occured at:2013-11-08 16:29:22
Line no.:416
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
name VARCHAR(100) null,
description STRING null,
status INTEGER,' at line 11

Query:
alter table Layout add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:418
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table Layout add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:419
Error Code: 1060 - Duplicate column name 'userName'

Query:
create table LayoutFriendlyURL (
uuid_ VARCHAR(75) null,
layoutFriendlyURLId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
plid LONG,
privateLayout BOOLEAN,
friendlyURL VARCHAR(255) null,
languageId VARCHAR(75) null
)

Error occured at:2013-11-08 16:29:22
Line no.:434
Error Code: 1170 - BLOB/TEXT column 'layoutFriendlyURLId' used in key specification without a key length

Query:
alter table LayoutPrototype add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:436
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table LayoutPrototype add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:437
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table LayoutPrototype add createDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:438
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table LayoutPrototype add modifiedDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:439
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
alter table LayoutSetPrototype add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:441
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table LayoutSetPrototype add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:442
Error Code: 1060 - Duplicate column name 'userName'

Query:
drop index IX_228562AD on Lock_

Error occured at:2013-11-08 16:29:22
Line no.:444
Error Code: 1091 - Can't DROP 'IX_228562AD'; check that column/key exists

Query:
drop index IX_DD635956 on Lock_

Error occured at:2013-11-08 16:29:22
Line no.:445
Error Code: 1091 - Can't DROP 'IX_DD635956'; check that column/key exists

Query:
alter table MBBan add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:447
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table MBCategory add status INTEGER

Error occured at:2013-11-08 16:29:22
Line no.:449
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table MBCategory add statusByUserId LONG

Error occured at:2013-11-08 16:29:22
Line no.:450
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table MBCategory add statusByUserName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:451
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table MBCategory add statusDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:452
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
alter table MBDiscussion add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:454
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table MBDiscussion add groupId LONG

Error occured at:2013-11-08 16:29:22
Line no.:455
Error Code: 1060 - Duplicate column name 'groupId'

Query:
alter table MBDiscussion add companyId LONG

Error occured at:2013-11-08 16:29:22
Line no.:456
Error Code: 1060 - Duplicate column name 'companyId'

Query:
alter table MBDiscussion add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:457
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table MBDiscussion add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:458
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table MBDiscussion add createDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:459
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table MBDiscussion add modifiedDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:460
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:22
Line no.:462
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table MBMessage drop column attachments

Error occured at:2013-11-08 16:29:22
Line no.:471
Error Code: 1091 - Can't DROP 'attachments'; check that column/key exists

Query:
alter table MBThread add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:473
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table MBThread add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:474
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table MBThread add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:475
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table MBThread add createDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:476
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table MBThread add modifiedDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:477
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
alter table MBThreadFlag add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:479
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table MBThreadFlag add groupId LONG

Error occured at:2013-11-08 16:29:22
Line no.:480
Error Code: 1060 - Duplicate column name 'groupId'

Query:
alter table MBThreadFlag add companyId LONG

Error occured at:2013-11-08 16:29:22
Line no.:481
Error Code: 1060 - Duplicate column name 'companyId'

Query:
alter table MBThreadFlag add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:482
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table MBThreadFlag add createDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:483
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table Organization_ add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:485
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table Organization_ add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:486
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table Organization_ add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:487
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table Organization_ add createDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:488
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table Organization_ add modifiedDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:489
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
drop table OrgGroupPermission

Error occured at:2013-11-08 16:29:22
Line no.:491
Error Code: 1051 - Unknown table 'OrgGroupPermission'

Query:
alter table PasswordPolicy add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:493
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table PasswordPolicy add regex VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:494
Error Code: 1060 - Duplicate column name 'regex'

Query:
drop index IX_C3A17327 on PasswordPolicyRel

Error occured at:2013-11-08 16:29:22
Line no.:496
Error Code: 1091 - Can't DROP 'IX_C3A17327'; check that column/key exists

Query:
drop index IX_ED7CF243 on PasswordPolicyRel

Error occured at:2013-11-08 16:29:22
Line no.:497
Error Code: 1091 - Can't DROP 'IX_ED7CF243'; check that column/key exists

Query:
drop table Permission_

Error occured at:2013-11-08 16:29:22
Line no.:499
Error Code: 1051 - Unknown table 'Permission_'

Query:
alter table Phone add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:501
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table PollsChoice add groupId LONG

Error occured at:2013-11-08 16:29:22
Line no.:503
Error Code: 1060 - Duplicate column name 'groupId'

Query:
alter table PollsChoice add companyId LONG

Error occured at:2013-11-08 16:29:22
Line no.:504
Error Code: 1060 - Duplicate column name 'companyId'

Query:
alter table PollsChoice add userId LONG

Error occured at:2013-11-08 16:29:22
Line no.:505
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table PollsChoice add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:506
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table PollsChoice add createDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:507
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table PollsChoice add modifiedDate DATE null

Error occured at:2013-11-08 16:29:22
Line no.:508
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
alter table PollsVote add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:22
Line no.:510
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table PollsVote add groupId LONG

Error occured at:2013-11-08 16:29:22
Line no.:511
Error Code: 1060 - Duplicate column name 'groupId'

Query:
alter table RepositoryEntry add companyId LONG

Error occured at:2013-11-08 16:29:23
Line no.:517
Error Code: 1060 - Duplicate column name 'companyId'

Query:
alter table RepositoryEntry add userId LONG

Error occured at:2013-11-08 16:29:23
Line no.:518
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table RepositoryEntry add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:519
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table RepositoryEntry add createDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:520
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table RepositoryEntry add modifiedDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:521
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
alter table RepositoryEntry add manualCheckInRequired BOOLEAN

Error occured at:2013-11-08 16:29:23
Line no.:522
Error Code: 1060 - Duplicate column name 'manualCheckInRequired'

Query:
drop table Resource_

Error occured at:2013-11-08 16:29:23
Line no.:524
Error Code: 1051 - Unknown table 'Resource_'

Query:
drop table ResourceCode

Error occured at:2013-11-08 16:29:23
Line no.:526
Error Code: 1051 - Unknown table 'ResourceCode'

Query:
drop index IX_88705859 on ResourcePermission

Error occured at:2013-11-08 16:29:23
Line no.:528
Error Code: 1091 - Can't DROP 'IX_88705859'; check that column/key exists

Query:
drop index IX_C94C7708 on ResourcePermission

Error occured at:2013-11-08 16:29:23
Line no.:529
Error Code: 1091 - Can't DROP 'IX_C94C7708'; check that column/key exists

Query:
drop index IX_8D83D0CE on ResourcePermission

Error occured at:2013-11-08 16:29:23
Line no.:530
Error Code: 1091 - Can't DROP 'IX_8D83D0CE'; check that column/key exists

Query:
drop index IX_4A1F4402 on ResourcePermission

Error occured at:2013-11-08 16:29:23
Line no.:531
Error Code: 1091 - Can't DROP 'IX_4A1F4402'; check that column/key exists

Query:
drop index IX_8DB864A9 on ResourcePermission

Error occured at:2013-11-08 16:29:23
Line no.:532
Error Code: 1091 - Can't DROP 'IX_8DB864A9'; check that column/key exists

Query:
alter table Role_ add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:534
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table Role_ add userId LONG

Error occured at:2013-11-08 16:29:23
Line no.:535
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table Role_ add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:536
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table Role_ add createDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:537
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table Role_ add modifiedDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:538
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
drop table Roles_Permissions

Error occured at:2013-11-08 16:29:23
Line no.:540
Error Code: 1051 - Unknown table 'Roles_Permissions'

Query:
alter table SocialActivity add activitySetId LONG

Error occured at:2013-11-08 16:29:23
Line no.:542
Error Code: 1060 - Duplicate column name 'activitySetId'

Query:
alter table SocialActivity add parentClassNameId LONG

Error occured at:2013-11-08 16:29:23
Line no.:543
Error Code: 1060 - Duplicate column name 'parentClassNameId'

Query:
alter table SocialActivity add parentClassPK LONG

Error occured at:2013-11-08 16:29:23
Line no.:544
Error Code: 1060 - Duplicate column name 'parentClassPK'

Query:
alter table SocialActivityCounter add active_ BOOLEAN

Error occured at:2013-11-08 16:29:23
Line no.:546
Error Code: 1060 - Duplicate column name 'active_'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:23
Line no.:548
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
create table SocialActivitySet (
activitySetId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
createDate LONG,
modifiedDate LONG,
classNameId LONG,
classPK LONG,
type_ INTEGER,
extraData STRING null,
activityCount INTEGER
)

Error occured at:2013-11-08 16:29:23
Line no.:564
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STRING null,
activityCount INTEGER
)' at line 11

Query:
create table SystemEvent (
systemEventId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
classNameId LONG,
classPK LONG,
classUuid VARCHAR(75) null,
referrerClassNameId LONG,
parentSystemEventId LONG,
systemEventSetKey LONG,
type_ INTEGER,
extraData TEXT null
)

Error occured at:2013-11-08 16:29:23
Line no.:581
Error Code: 1170 - BLOB/TEXT column 'systemEventId' used in key specification without a key length

Query:
create table TrashEntry (
entryId LONG not null primary key,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
classNameId LONG,
classPK LONG,
systemEventSetKey LONG,
typeSettings TEXT null,
status INTEGER
)

Error occured at:2013-11-08 16:29:23
Line no.:595
Error Code: 1170 - BLOB/TEXT column 'entryId' used in key specification without a key length

Query:
create table TrashVersion (
versionId LONG not null primary key,
entryId LONG,
classNameId LONG,
classPK LONG,
typeSettings TEXT null,
status INTEGER
)

Error occured at:2013-11-08 16:29:23
Line no.:604
Error Code: 1170 - BLOB/TEXT column 'versionId' used in key specification without a key length

Query:
alter table User_ add ldapServerId LONG

Error occured at:2013-11-08 16:29:23
Line no.:606
Error Code: 1060 - Duplicate column name 'ldapServerId'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:23
Line no.:608
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1

Query:
alter table UserGroup add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:612
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table UserGroup add userId LONG

Error occured at:2013-11-08 16:29:23
Line no.:613
Error Code: 1060 - Duplicate column name 'userId'

Query:
alter table UserGroup add userName VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:614
Error Code: 1060 - Duplicate column name 'userName'

Query:
alter table UserGroup add createDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:615
Error Code: 1060 - Duplicate column name 'createDate'

Query:
alter table UserGroup add modifiedDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:616
Error Code: 1060 - Duplicate column name 'modifiedDate'

Query:
create table UserNotificationDelivery (
userNotificationDeliveryId LONG not null primary key,
companyId LONG,
userId LONG,
portletId VARCHAR(200) null,
classNameId LONG,
notificationType INTEGER,
deliveryType INTEGER,
deliver BOOLEAN
)

Error occured at:2013-11-08 16:29:23
Line no.:627
Error Code: 1170 - BLOB/TEXT column 'userNotificationDeliveryId' used in key specification without a key length

Query:
alter table UserNotificationEvent add delivered BOOLEAN

Error occured at:2013-11-08 16:29:23
Line no.:629
Error Code: 1060 - Duplicate column name 'delivered'

Query:
drop table Users_Permissions

Error occured at:2013-11-08 16:29:23
Line no.:631
Error Code: 1051 - Unknown table 'Users_Permissions'

Query:
alter table Website add uuid_ VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:633
Error Code: 1060 - Duplicate column name 'uuid_'

Query:
alter table WikiNode add status INTEGER

Error occured at:2013-11-08 16:29:23
Line no.:635
Error Code: 1060 - Duplicate column name 'status'

Query:
alter table WikiNode add statusByUserId LONG

Error occured at:2013-11-08 16:29:23
Line no.:636
Error Code: 1060 - Duplicate column name 'statusByUserId'

Query:
alter table WikiNode add statusByUserName VARCHAR(75) null

Error occured at:2013-11-08 16:29:23
Line no.:637
Error Code: 1060 - Duplicate column name 'statusByUserName'

Query:
alter table WikiNode add statusDate DATE null

Error occured at:2013-11-08 16:29:23
Line no.:638
Error Code: 1060 - Duplicate column name 'statusDate'

Query:
COMMIT_TRANSACTION

Error occured at:2013-11-08 16:29:23
Line no.:640
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMIT_TRANSACTION' at line 1
Attachment

Attachments: Portal6Rights.png (60.0k)
David H Nebinger
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 5:07 PM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 11287

Join Date: September 1, 2006

Recent Posts

Okay, there's probably some disconnect here...

Liferay does provide upgrade scripts, but they are one-shot deals. If you are going to run the upgrade scripts yourself, then you must follow the process. If you are running 5.2.2, for example, and you want to go to 6.1 GA3, you must manually run the 5.2.3 script, followed by each of the incremental scripts until you get to the 6.1 GA3 one. It's very manual and very prone to error.

It's much easier if you just point Liferay at your current database and data directory, then start it up (again have backups before you kick it off). Liferay itself will identify that it has to upgrade the database and most of the time it will be able to handle it (some older versions have failures, so it's always best to use the latest version of the line you're going to run with, i.e. 6.0.6 or 6.1 GA3). It's also recommended to use a known stable version (i.e. 6.0.1 has issues and might fail, but if you go to 6.0.6 your chance of success is greater, same sort of story w/ 6.1, use GA3 but not an earlier 6.1 version).

As far as ranting about 'enterprise', I'm sorry you have such high expectations for the label. To Liferay, the term indicates that it is suitable for running in the enterprise in that it has a higher level of security, ships with regular patch updates, supports integration into common enterprise infrastructure, and comes with support. I don't believe I've ever seen the term 'enterprise' tied to the ability to run an installer that was capable of rolling back upgrade failures, but I guess I run in different circles.

My recommendation: restore your previous DB and data directory, point your target version of Liferay (6.1 GA3) at them and then start it up.
Matthew Kong
RE: Upgrade from 6.0.6 to 6.1.0 CE GA1 failing with two errors
November 8, 2013 5:29 PM
Answer

Matthew Kong

LIFERAY STAFF

Rank: New Member

Posts: 3

Join Date: July 2, 2010

Recent Posts

I think all your concerns about the scripts is because it seems like you're running the generic sql script which is not supposed to be ran against the db. It is used to generate the database specific scripts. Look for "Portal SQL Scripts" in our downloads page . Look for update-x.x.x-x.x.x-mysql.sql

However, I agree with David, it's best to just let the portal run it. You will have to run the verify processes anyways.