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

[Michael Moossen]

Hi!

ok, i see. i am sorry to tell you that your database is now most likely 
in an inconsistent state :(

i am wondering what is so special in your installation, since we have 
never encounter such a problem. i will take a carefully look to that query.

for now i would recommend you to setup OpenCms 7 from scratch and to 
import your modules and content.

Kind regards,
Michael

-------------------

Alkacon Software GmbH - The OpenCms Experts
Michael Moossen

http://www.alkacon.com
http://www.opencms.org



djano wrote:
> 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)