[opencms-dev] Unable to initialize user driver during Upgrade to V7.0.3

djano djanousek at iesabroad.org
Mon Nov 26 19:15:02 CET 2007


Michael,

Thanks for the prompt response.  Unfortunately the db-update.log is of
little or no help.  The update ran without any errors with the exception of
a duplicate entry within the CMS_CONTENTS table seen below.  However this
does not seem like it would directly relate to the user driver issue.

1213:	executing query: INSERT INTO CMS_CONTENTS (CMS_CONTENTS.RESOURCE_ID,
CMS_CONTENTS.FILE_CONTENT, CMS_CONTENTS.PUBLISH_TAG_FROM,
CMS_CONTENTS.PUBLISH_TAG_TO, CMS_CONTENTS.ONLINE_FLAG) (SELECT DISTINCT
CMS_ONLINE_CONTENTS.RESOURCE_ID, CMS_ONLINE_CONTENTS.FILE_CONTENT,
MAX(CMS_BACKUP_RESOURCES.PUBLISH_TAG),
MAX(CMS_BACKUP_RESOURCES.PUBLISH_TAG), 1 AS ONLINE_FLAG FROM
CMS_ONLINE_CONTENTS, CMS_BACKUP_RESOURCES WHERE
CMS_ONLINE_CONTENTS.RESOURCE_ID = CMS_BACKUP_RESOURCES.RESOURCE_ID GROUP BY
CMS_ONLINE_CONTENTS.RESOURCE_ID ) UNION ( SELECT DISTINCT
CMS_ONLINE_CONTENTS.RESOURCE_ID, CMS_ONLINE_CONTENTS.FILE_CONTENT, 7267,
7267, 1 AS ONLINE_FLAG FROM CMS_ONLINE_CONTENTS WHERE
CMS_ONLINE_CONTENTS.RESOURCE_ID NOT IN (SELECT
CMS_BACKUP_RESOURCES.RESOURCE_ID FROM CMS_BACKUP_RESOURCES) )
1214:	com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Duplicate entry '0002ad99-3f6e-11dc-be7c-001372dcf54b-6504' for key 1
1215:		at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
1216:		at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
1217:		at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
1218:		at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
1219:		at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
1220:		at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
1221:		at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
1222:		at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
1223:		at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
1224:		at
org.opencms.setup.CmsSetupDb.updateSqlStatement(CmsSetupDb.java:580)
1225:		at
org.opencms.setup.update6to7.generic.CmsUpdateDBContentTables.transferOnlineContents(CmsUpdateDBContentTables.java:169)
1226:		at
org.opencms.setup.update6to7.generic.CmsUpdateDBContentTables.internalExecute(CmsUpdateDBContentTables.java:138)
1227:		at
org.opencms.setup.update6to7.A_CmsUpdateDBPart.execute(A_CmsUpdateDBPart.java:88)
1228:		at
org.opencms.setup.update6to7.CmsUpdateDBManager.updateDatabase(CmsUpdateDBManager.java:297)
1229:		at
org.opencms.setup.update6to7.CmsUpdateDBManager.run(CmsUpdateDBManager.java:269)
1230:		at
org.opencms.setup.update6to7.CmsUpdateDBThread.run(CmsUpdateDBThread.java:140)
-- 
View this message in context: http://www.nabble.com/Unable-to-initialize-user-driver-during-Upgrade-to-V7.0.3-tf4876184.html#a13954701
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.




More information about the opencms-dev mailing list