AW: [opencms-dev] Opencms installation failure step 6.

[Alexander Lucas]

Hello Steve,

it seems OpenCms is trying to initialize your database twice for any reason.

Please try to drop your database using
    mysqladmin create opencms41
and go back to step 5.

Regards.
Alexander

mailto:alexander.lucas at framfab.de


-----Ursprüngliche Nachricht-----
Von: Steve Tulk [mailto:stevil at stevil.net]
Gesendet: Donnerstag, 25. Januar 2001 17:49
An: opencms-dev at opencms.com
Betreff: [opencms-dev] Opencms installation failure step 6.


I'm unable to complete the installation of opencms.  I'm having trouble in
step 6 during the database initialization with the workplace default
files.

Some of the commands in config/cmssetup.txt will process, but a majority
of them fail.  They begin to fail during:
createPropertydefinition NavText page 0

I get this error:

[CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.mySql.CmsDbAccess] Invalid ar
gument value: Duplicate entry 'NavText-76' for key 2. Caught Exception:
>java.sql.SQLException:
Invalid argument value: Duplicate entry 'NavText-76' for key 2<
        at
com.opencms.file.genericSql.CmsDbAccess.createPropertydefinition(CmsDbAccess
.java:121
4)
        at
com.opencms.file.genericSql.CmsResourceBroker.createPropertydefinition(CmsRe
sourceBro
ker.java:1800)
        at
com.opencms.file.CmsObject.createPropertydefinition(CmsObject.java:548)
        at
com.opencms.core.CmsShellCommands.createPropertydefinition(CmsShellCommands.
java:519)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.opencms.core.CmsShell.call(CmsShell.java:135)
        at com.opencms.core.CmsShell.commands(CmsShell.java:176)
        at com.opencms.core.CmsShell.main(CmsShell.java:207)
>java.sql.SQLException: Invalid argument value: Duplicate entry
'NavText-76' for key 2
>       at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
>       at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
>       at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
>       at
org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:389)
>       at
com.opencms.file.genericSql.CmsDbAccess.createPropertydefinition(CmsDbAccess
.java:121
2)
>       at
com.opencms.file.genericSql.CmsResourceBroker.createPropertydefinition(CmsRe
sourceBro
ker.java:1800)
>       at
com.opencms.file.CmsObject.createPropertydefinition(CmsObject.java:548)
>       at
com.opencms.core.CmsShellCommands.createPropertydefinition(CmsShellCommands.
java:519)
>       at java.lang.reflect.Method.invoke(Native Method)
>       at com.opencms.core.CmsShell.call(CmsShell.java:135)
>       at com.opencms.core.CmsShell.commands(CmsShell.java:176)
>       at com.opencms.core.CmsShell.main(CmsShell.java:207)

Any suggestions?