AW: [opencms-dev] install problems: Sql exception

[Udo Garmann]

Hi Michael,

I've got almost the same system configuration as you but didn't manage to
get the system to work. But it is a minor security problem I guess and
shouldn't bother you.

A similar error to yours I got when database entries already existed before
calling the java command line for initialization of OpenCMS. Perhaps you
should delete the database (using the mySQL drop database command) and go
through the setup steps of OpenCMS again.

I hope, this is an answer to your problem.

Bye,

Udo

Dr.-Ing. Udo Garmann

MediaCircle GmbH
Reichsstrasse 7
93055 Regensburg

Telefon: +49 (0) 9 41 60 80 70
Homepage: http://www.mediacircle.de

-----Ursprüngliche Nachricht-----
Von: mbillanitsch at onyx.tv [mailto:mbillanitsch at onyx.tv]
Gesendet: Donnerstag, 4. Januar 2001 14:33
An: 'opencms-dev at opencms.com'
Betreff: [opencms-dev] install problems: Sql exception


Hello,
I tried to install opencms 4.1.46 (enviroment: SuSE 7.0, Apache 1.3.12,
ApacheJServ 1.1.2, JDK 1.3, JSDK 2.1, MySQL 3.22.32). I did everything I
wrote in the documentation, but I'm still not lucky. When I try to start the
system I get the following message:

[CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.mySql.CmsDbAccess] Invalid argument value: Duplicate entry
'NavText-0' for key 2. Caught Exception: >java.sql.SQLException: Invalid
argument value: Duplicate entry 'NavText-0' for key 2<
        at java.lang.Throwable.<init>(Throwable.java:96)
        at java.lang.Exception.<init>(Exception.java:44)
        at com.opencms.core.CmsException.<init>(CmsException.java:332)
        at
com.opencms.file.genericSql.CmsDbAccess.createPropertydefinition(CmsDbAccess
.java:1194)
        at
com.opencms.file.genericSql.CmsResourceBroker.createPropertydefinition(CmsRe
sourceBroker.java:1715)
        at
com.opencms.file.CmsObject.createPropertydefinition(CmsObject.java:559)
        at
com.opencms.core.CmsShellCommands.createPropertydefinition(CmsShellCommands.
java:511)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.opencms.core.CmsShell.call(CmsShell.java:129)
        at com.opencms.core.CmsShell.commands(CmsShell.java:170)
        at com.opencms.core.CmsShell.main(CmsShell.java:201)

has anybody an advice?
kind regards,
michael

_________________________
ONYX Television GmbH
Online Dept.
Michael Billanitsch
Im Mediapark 6b
D-50670 Köln
Fon:   +49 (0)221 57437-686
Mobil: +49 (0)177 3113861
Fax:   +49 (0)221 57437-690
eMail: mbillanitsch at onyx.tv
http://www.onyx.tv

To: opencms-dev at opencms.com