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

[Michael Billanitsch]

Thx a lot. Now it works!
Micha

> -----Ursprüngliche Nachricht-----
> Von: Udo Garmann [mailto:ugarmann at mediacircle.de]
> Gesendet: Donnerstag, 4. Januar 2001 14:47
> An: opencms-dev at www.opencms.com
> Betreff: AW: [opencms-dev] install problems: Sql exception
> 
> 
> 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.createPropertydefiniti
> on(CmsDbAccess
> .java:1194)
>         at
> com.opencms.file.genericSql.CmsResourceBroker.createPropertyde
> finition(CmsRe
> sourceBroker.java:1715)
>         at
> com.opencms.file.CmsObject.createPropertydefinition(CmsObject.
java:559)
>         at
> com.opencms.core.CmsShellCommands.createPropertydefinition(Cms
ShellCommands.
> 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
>