[opencms-dev] Installation of 6.3 beta with PostgreSQL throwsexceptions
Ivan Codarin
ivan.codarin at gmail.com
Sun Mar 5 11:44:00 CET 2006
Dear All,
I installed Opencms 6.2 beta on Postgresql 8.1.x without any problem...
Jack could you try to perform a clean install of Opencms on a Postgresql
8.1 instance?
I posted few notes on this list called:
"[opencms-dev] 6.2 Beta - Successfully Installed On PostreSQL 8.1.3"
on February 27th., 2006.
Regards
Ivan
Aleaxnder Kandzior wrote:
> Jack,
>
> thanks for your feedback regarding PostgeSQL. Apparently there is interest
> at last in using PostgeSQL, even though unfortunalty no one is currently
> contributing code to support it.
>
>
>> From postgresql source, I've been building the
>> postgresql.jar (./configure --with-java) and using that
>> alongside the OpenCms provided jar. I haven't seen the
>> problems others seem to be reporting when using postgresql.
>>
>
> Is it the 6.2 beta you are using, or a 6.0.x release version?
>
> And what is the PostgeSQL version number?
>
> Kind Regards,
> Alex.
>
> -------------------
> Alexander Kandzior
>
> Alkacon Software GmbH - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
>
>
>
>> -----Original Message-----
>> From: opencms-dev-bounces at opencms.org
>> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jack Bakker
>> Sent: Friday, February 17, 2006 3:06 PM
>> To: The OpenCms mailing list
>> Subject: Re: [opencms-dev] Installation of 6.3 beta with
>> PostgreSQL throwsexceptions
>>
>> From postgresql source, I've been building the
>> postgresql.jar (./configure --with-java) and using that
>> alongside the OpenCms provided jar. I haven't seen the
>> problems others seem to be reporting when using postgresql.
>>
>> Jack
>>
>> On 17/02/2006 7:06 AM, Aleaxnder Kandzior wrote:
>>
>>> This is a PostgrSQL related issue. Apparently the PostgreSQL driver
>>> needs to be updated.
>>>
>>> Since we from Alkacon do not support this driver directly,
>>>
>> we have to
>>
>>> rely on the community to fix this. Otherwise we will have
>>>
>> to ship the
>>
>>> 6.2 beta without the PostgeSQL driver.
>>>
>>> Kind Regards,
>>> Alex.
>>>
>>> -------------------
>>> Alexander Kandzior
>>>
>>> Alkacon Software GmbH - The OpenCms Experts
>>> http://www.alkacon.com <http://www.alkacon.com/> -
>>> http://www.opencms.org <http://www.opencms.org/>
>>>
>>>
>>>
>>>
>>>
>> --------------------------------------------------------------
>> ----------
>>
>>> *From:* opencms-dev-bounces at opencms.org
>>> [mailto:opencms-dev-bounces at opencms.org] *On Behalf Of
>>>
>> *Dirk Hartmann
>>
>>> *Sent:* Friday, February 17, 2006 12:57 PM
>>> *To:* opencms-dev at opencms.org
>>> *Subject:* [opencms-dev] Installation of beta throws exceptions
>>>
>>> Hello List,
>>>
>>> maybe it is helpful to send you problems with
>>>
>> installation of the
>>
>>> beta. Following exceptions have been thown while standard
>>> installation on tomcat4 with postgres 7.4.3:
>>>
>>>
>>> 12282: ( 2 / 12 ) Importing
>>> /alkacon-documentation/examples_directedit/ ... o.k.
>>> 12281: ( 1 / 12 ) Importing /alkacon-documentation/ ... o.k.
>>> 12280: ------ Importing module ...
>>> com.alkacon.documentation.examples_directedit ...
>>>
>> Import Version 4
>>
>>> 12279: ... 16 more
>>> 12278: at
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProje
>> ctDriver.java:165)
>>
>>> 12277: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
>> ate(DelegatingPreparedStatement.java:101)
>>
>>> 12276: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
>> ate(DelegatingPreparedStatement.java:101)
>>
>>> 12275: at
>>>
>>>
>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(Abst
>> ractJdbc1Statement.java:273)
>>
>>> 12274: at
>>>
>>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
>> bc2Statement.java:50)
>>
>>> 12273: at
>>>
>>>
>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJd
>> bc1Statement.java:517)
>>
>>> 12272: at org.postgresql.core.QueryExecutor.execute
>>> (QueryExecutor.java:43)
>>> 12271: at
>>>
>>>
>> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
>>
>>> 12270: at
>>>
>>>
>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
>>
>>> 12269: at
>>>
>> org.postgresql.util.PSQLException.parseServerError
>>
>>> (PSQLException.java:139)
>>> 12268:
>>> 12267: Caused by: org.postgresql.util.PSQLException:
>>>
>> FEHLER: Wert
>>
>>> zu lang f?Typ character varying(64)
>>> 12266: ... 14 more
>>> 12265: at org.opencms.db.CmsSecurityManager.createProject
>>> (CmsSecurityManager.java:1024)
>>> 12264: at
>>>
>>>
>> org.opencms.db.CmsDriverManager.createProject(CmsDriverManager
>> .java:1398)
>>
>>> 12263: at
>>>
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver
>>
>>> .java:179)
>>>
>>> 12262: Caused by: org.opencms.db.CmsDbSqlException:
>>>
>> An SQL error
>>
>>> occurred when executing the following query: INSERT INTO
>>> CMS_PROJECTS
>>>
>>>
>> (PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_N
>> AME,PROJECT_DESCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
>>
>>>
>>>
>> (58,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6
>> -b188-3bac3da54580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',58,'Import
>>
>>> of module
>>> com.alkacon.documentation.documentation_htmlimport','System
>>> generated project to import module
>>>
>>>
>> "com.alkacon.documentation.documentation_htmlimport".',0,11401
>> 73072812,1).
>>
>>> 12261: at
>>>
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run
>>
>>> (CmsSetupWorkplaceImportThread.java:186)
>>> 12260: at
>>>
>> org.opencms.main.CmsShell.start(CmsShell.java:663)
>>
>>> 12259: at
>>> org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
>>> 12258: at org.opencms.main.CmsShell.executeCommand
>>> (CmsShell.java:767)
>>> 12257: at
>>>
>>>
>> org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsSh
>> ell.java:246)
>>
>>> 12256: at
>>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>>
>>> 12255: at sun.reflect.DelegatingMethodAccessorImpl.invoke
>>> (DelegatingMethodAccessorImpl.java:25)
>>> 12254: at
>>>
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
>> orImpl.java:39)
>>
>>> 12253: at
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>
>>> Method)
>>> 12252: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsS
>> etupBean.java:952)
>>
>>> 12251: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetu
>> pBean.java:1724)
>>
>>> 12250: at
>>> org.opencms.importexport.CmsImportExportManager.importData
>>> (CmsImportExportManager.java:610)
>>> 12249: at
>>>
>>>
>> org.opencms.module.CmsModuleImportExportHandler.importData(Cms
>> ModuleImportExportHandler.java:325)
>>
>>> 12248: at
>>> org.opencms.file.CmsObject.createProject(CmsObject.java :566)
>>> 12247: at
>>>
>>>
>> org.opencms.db.CmsSecurityManager.createProject(CmsSecurityMan
>> ager.java:1027)
>>
>>> 12246: at
>>> org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
>>> 12245: at org.opencms.db.CmsDbContext.throwException
>>> (CmsDbContext.java:213)
>>> 12244: at
>>>
>>>
>> org.opencms.db.CmsDbSqlException.createException(CmsDbSqlExcep
>> tion.java:103)
>>
>>> 12243: org.opencms.db.CmsDbSqlException: Error
>>>
>> creating project
>>
>>> "Import of module
>>>
>> com.alkacon.documentation.documentation_htmlimport ".
>>
>>> 12242: ... 16 more
>>> 12241: at
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProje
>> ctDriver.java:165)
>>
>>> 12240: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate
>>
>>> (DelegatingPreparedStatement.java:101)
>>> 12239: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
>> ate(DelegatingPreparedStatement.java:101)
>>
>>> 12238: at
>>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate
>>> (AbstractJdbc1Statement.java:273)
>>> 12237: at
>>>
>>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
>> bc2Statement.java:50)
>>
>>> 12236: at
>>>
>>>
>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJd
>> bc1Statement.java
>>
>>> :517)
>>> 12235: at
>>> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
>>> 12234: at
>>>
>>>
>> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
>>
>>> 12233: at org.postgresql.core.QueryExecutor.executeV3
>>> (QueryExecutor.java:152)
>>> 12232: at
>>>
>>>
>> org.postgresql.util.PSQLException.parseServerError(PSQLExcepti
>> on.java:139)
>>
>>> 12231:
>>> 12230: Caused by: org.postgresql.util.PSQLException:
>>>
>> FEHLER: Wert
>>
>>> zu lang f?Typ character varying(64)
>>> 12229: ... 14 more
>>> 12228: at
>>>
>>>
>> org.opencms.db.CmsSecurityManager.createProject(CmsSecurityMan
>> ager.java:1024)
>>
>>> 12227: at
>>>
>>>
>>>
>> org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:13
>>
>>> 98)
>>>
>>> 12226: at
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProje
>> ctDriver.java:179)
>>
>>> 12225: Caused by: org.opencms.db.CmsDbSqlException:
>>>
>> An SQL error
>>
>>> occurred when executing the following query: INSERT INTO
>>> CMS_PROJECTS
>>>
>>>
>> (PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_N
>> AME,PROJECT_DESCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
>>
>>>
>>>
>> (57,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6
>> -b188-3bac3da54580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',57,'Import
>>
>>> of module
>>>
>> com.alkacon.documentation.documentation_flexcache','System
>>
>>> generated project to import module
>>>
>>>
>> "com.alkacon.documentation.documentation_flexcache".',0,114017
>> 3072109,1).
>>
>>> 12224: at
>>>
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run
>>
>>> (CmsSetupWorkplaceImportThread.java:186)
>>> 12223: at
>>>
>> org.opencms.main.CmsShell.start(CmsShell.java:663)
>>
>>> 12222: at
>>> org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
>>> 12221: at org.opencms.main.CmsShell.executeCommand
>>> (CmsShell.java:767)
>>> 12220: at
>>>
>>>
>> org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsSh
>> ell.java:246)
>>
>>> 12219: at
>>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>>
>>> 12218: at sun.reflect.DelegatingMethodAccessorImpl.invoke
>>> (DelegatingMethodAccessorImpl.java:25)
>>> 12217: at
>>>
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
>> orImpl.java:39)
>>
>>> 12216: at
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>
>>> Method)
>>> 12215: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsS
>> etupBean.java:952)
>>
>>> 12214: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetu
>> pBean.java:1724)
>>
>>> 12213: at
>>> org.opencms.importexport.CmsImportExportManager.importData
>>> (CmsImportExportManager.java:610)
>>> 12212: at
>>>
>>>
>> org.opencms.module.CmsModuleImportExportHandler.importData(Cms
>> ModuleImportExportHandler.java:325)
>>
>>> 12211: at
>>> org.opencms.file.CmsObject.createProject(CmsObject.java :566)
>>> 12210: at
>>>
>>>
>> org.opencms.db.CmsSecurityManager.createProject(CmsSecurityMan
>> ager.java:1027)
>>
>>> 12209: at
>>> org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
>>> 12208: at org.opencms.db.CmsDbContext.throwException
>>> (CmsDbContext.java:213)
>>> 12207: at
>>>
>>>
>> org.opencms.db.CmsDbSqlException.createException(CmsDbSqlExcep
>> tion.java:103)
>>
>>> 12206: org.opencms.db.CmsDbSqlException: Error
>>>
>> creating project
>>
>>> "Import of module
>>>
>> com.alkacon.documentation.documentation_flexcache ".
>>
>>> 12205: ------ ... the module has been imported
>>> 12204: ------ ... the project has been published
>>> 12203: ------ ... finished updating search index
>>>
>> "Offline project
>>
>>> (VFS)"
>>> 12202: ( 26 ) Indexing file
>>> /sites/default/alkacon-documentation/links/index.html
>>>
>> ... skipped
>>
>>>
>>> 11655: ( 2 / 26 ) Importing
>>> /alkacon-documentation/examples_flex_3/ ... o.k.
>>> 11654: ( 1 / 26 ) Importing /alkacon-documentation/ ... o.k.
>>> 11653: ------ Importing module ...
>>> com.alkacon.documentation.examples_flex_3 ... Import Version 4
>>> 11652: ... 16 more
>>> 11651: at
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProje
>> ctDriver.java:165)
>>
>>> 11650: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate
>>
>>> (DelegatingPreparedStatement.java:101)
>>> 11649: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
>> ate(DelegatingPreparedStatement.java:101)
>>
>>> 11648: at
>>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate
>>> (AbstractJdbc1Statement.java:273)
>>> 11647: at
>>>
>>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
>> bc2Statement.java:50)
>>
>>> 11646: at
>>>
>>>
>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJd
>> bc1Statement.java
>>
>>> :517)
>>> 11645: at
>>> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
>>> 11644: at
>>>
>>>
>> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
>>
>>> 11643: at org.postgresql.core.QueryExecutor.executeV3
>>> (QueryExecutor.java:152)
>>> 11642: at
>>>
>>>
>> org.postgresql.util.PSQLException.parseServerError(PSQLExcepti
>> on.java:139)
>>
>>> 11641:
>>> 11640: Caused by: org.postgresql.util.PSQLException:
>>>
>> FEHLER: Wert
>>
>>> zu lang f?Typ character varying(64)
>>> 11639: ... 14 more
>>> 11638: at
>>>
>>>
>> org.opencms.db.CmsSecurityManager.createProject(CmsSecurityMan
>> ager.java:1024)
>>
>>> 11637: at
>>>
>>>
>>>
>> org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:13
>>
>>> 98)
>>>
>>> 11636: at
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProje
>> ctDriver.java:179)
>>
>>> 11635: Caused by: org.opencms.db.CmsDbSqlException:
>>>
>> An SQL error
>>
>>> occurred when executing the following query: INSERT INTO
>>> CMS_PROJECTS
>>>
>>>
>> (PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_N
>> AME,PROJECT_DESCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
>>
>>>
>>>
>> (52,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6
>> -b188-3bac3da54580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',52,'Import
>>
>>> of module
>>>
>> com.alkacon.documentation.documentation_scriptlet','System
>>
>>> generated project to import module
>>>
>>>
>> "com.alkacon.documentation.documentation_scriptlet".',0,114017
>> 2937349,1).
>>
>>> 11634: at
>>>
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run
>>
>>> (CmsSetupWorkplaceImportThread.java:186)
>>> 11633: at
>>>
>> org.opencms.main.CmsShell.start(CmsShell.java:663)
>>
>>> 11632: at
>>> org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
>>> 11631: at org.opencms.main.CmsShell.executeCommand
>>> (CmsShell.java:767)
>>> 11630: at
>>>
>>>
>> org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsSh
>> ell.java:246)
>>
>>> 11629: at
>>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>>
>>> 11628: at sun.reflect.DelegatingMethodAccessorImpl.invoke
>>> (DelegatingMethodAccessorImpl.java:25)
>>> 11627: at
>>>
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
>> orImpl.java:39)
>>
>>> 11626: at
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>
>>> Method)
>>> 11625: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsS
>> etupBean.java:952)
>>
>>> 11624: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetu
>> pBean.java:1724)
>>
>>> 11623: at
>>> org.opencms.importexport.CmsImportExportManager.importData
>>> (CmsImportExportManager.java:610)
>>> 11622: at
>>>
>>>
>> org.opencms.module.CmsModuleImportExportHandler.importData(Cms
>> ModuleImportExportHandler.java:325)
>>
>>> 11621: at
>>> org.opencms.file.CmsObject.createProject(CmsObject.java :566)
>>> 11620: at
>>>
>>>
>> org.opencms.db.CmsSecurityManager.createProject(CmsSecurityMan
>> ager.java:1027)
>>
>>> 11619: at
>>> org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
>>> 11618: at org.opencms.db.CmsDbContext.throwException
>>> (CmsDbContext.java:213)
>>> 11617: at
>>>
>>>
>> org.opencms.db.CmsDbSqlException.createException(CmsDbSqlExcep
>> tion.java:103)
>>
>>> 11616: org.opencms.db.CmsDbSqlException: Error
>>>
>> creating project
>>
>>> "Import of module
>>>
>> com.alkacon.documentation.documentation_scriptlet ".
>>
>>> 11615: ------ ... the module has been imported
>>> 11614: ------ ... the project has been published
>>> 11613: ------ ... finished updating search index
>>>
>> "Offline project
>>
>>> (VFS)"
>>> 11612: ( 33 ) Indexing file
>>> /sites/default/alkacon-documentation/showsource.jsp ... skipped
>>> 11611: ( 32 ) Indexing file
>>> /sites/default/alkacon-documentation/links/index.html
>>>
>> ... skipped
>>
>>>
>>> 11368: ( 3 / 27 ) Importing
>>> /alkacon-documentation/howto_template/editable.html ... o.k.
>>> 11367: ( 2 / 27 ) Importing
>>> /alkacon-documentation/howto_template/ ... o.k.
>>> 11366: ( 1 / 27 ) Importing /alkacon-documentation/ ... o.k.
>>> 11365: ------ Importing module ...
>>> com.alkacon.documentation.howto_template ... Import Version 4
>>> 11364: ... 16 more
>>> 11363: at
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProje
>> ctDriver.java:165)
>>
>>> 11362: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
>> ate(DelegatingPreparedStatement.java:101)
>>
>>> 11361: at
>>>
>>>
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
>> ate(DelegatingPreparedStatement.java:101)
>>
>>> 11360: at
>>>
>>>
>> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(Abst
>> ractJdbc1Statement.java:273)
>>
>>> 11359: at
>>>
>>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
>> bc2Statement.java:50)
>>
>>> 11358: at
>>>
>>>
>> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJd
>> bc1Statement.java:517)
>>
>>> 11357: at org.postgresql.core.QueryExecutor.execute
>>> (QueryExecutor.java:43)
>>> 11356: at
>>>
>>>
>> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
>>
>>> 11355: at
>>>
>>>
>> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
>>
>>> 11354: at
>>>
>> org.postgresql.util.PSQLException.parseServerError
>>
>>> (PSQLException.java:139)
>>> 11353:
>>> 11352: Caused by: org.postgresql.util.PSQLException:
>>>
>> FEHLER: Wert
>>
>>> zu lang f?Typ character varying(64)
>>> 11351: ... 14 more
>>> 11350: at org.opencms.db.CmsSecurityManager.createProject
>>> (CmsSecurityManager.java:1024)
>>> 11349: at
>>>
>>>
>> org.opencms.db.CmsDriverManager.createProject(CmsDriverManager
>> .java:1398)
>>
>>> 11348: at
>>>
>>>
>>>
>> org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver
>>
>>> .java:179)
>>>
>>> 11347: Caused by: org.opencms.db.CmsDbSqlException:
>>>
>> An SQL error
>>
>>> occurred when executing the following query: INSERT INTO
>>> CMS_PROJECTS
>>>
>>>
>> (PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_N
>> AME,PROJECT_DESCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
>>
>>>
>>>
>> (49,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6
>> -b188-3bac3da54580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',49,'Import
>>
>>> of module
>>>
>> com.alkacon.documentation.documentation_migration','System
>>
>>> generated project to import module
>>>
>>>
>> "com.alkacon.documentation.documentation_migration".',0,114017
>> 2860370,1).
>>
>>> 11346: at
>>>
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run
>>
>>> (CmsSetupWorkplaceImportThread.java:186)
>>> 11345: at
>>>
>> org.opencms.main.CmsShell.start(CmsShell.java:663)
>>
>>> 11344: at
>>> org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
>>> 11343: at org.opencms.main.CmsShell.executeCommand
>>> (CmsShell.java:767)
>>> 11342: at
>>>
>>>
>> org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsSh
>> ell.java:246)
>>
>>> 11341: at
>>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>>
>>> 11340: at sun.reflect.DelegatingMethodAccessorImpl.invoke
>>> (DelegatingMethodAccessorImpl.java:25)
>>> 11339: at
>>>
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
>> orImpl.java:39)
>>
>>> 11338: at
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>
>>> Method)
>>> 11337: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsS
>> etupBean.java:952)
>>
>>> 11336: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetu
>> pBean.java:1724)
>>
>>> 11335: at
>>> org.opencms.importexport.CmsImportExportManager.importData
>>> (CmsImportExportManager.java:610)
>>> 11334: at
>>>
>>>
>> org.opencms.module.CmsModuleImportExportHandler.importData(Cms
>> ModuleImportExportHandler.java:325)
>>
>>> 11333: at
>>> org.opencms.file.CmsObject.createProject(CmsObject.java :566)
>>> 11332: at
>>>
>>>
>> org.opencms.db.CmsSecurityManager.createProject(CmsSecurityMan
>> ager.java:1027)
>>
>>> 11331: at
>>> org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
>>> 11330: at org.opencms.db.CmsDbContext.throwException
>>> (CmsDbContext.java:213)
>>> 11329: at
>>>
>>>
>> org.opencms.db.CmsDbSqlException.createException(CmsDbSqlExcep
>> tion.java:103)
>>
>>> 11328: org.opencms.db.CmsDbSqlException: Error
>>>
>> creating project
>>
>>> "Import of module
>>>
>> com.alkacon.documentation.documentation_migration ".
>>
>>> 11327: ------ ... the module has been imported
>>> 11326: ------ ... the project has been published
>>> 11325: ------ ... finished updating search index
>>>
>> "Offline project
>>
>>> (VFS)"
>>> 11324: ( 28 ) Indexing file
>>> /sites/default/alkacon-documentation/showsource.jsp ... skipped
>>> 11323: ( 27 ) Indexing file
>>> /sites/default/alkacon-documentation/links/index.html
>>>
>> ... skipped
>>
>>>
>>> 11204: ( 3 / 25 ) Importing
>>>
>>>
>> /alkacon-documentation/documentation_modules/administrate_modules.html
>>
>>> ... o.k.
>>> 11203: ( 2 / 25 ) Importing
>>> /alkacon-documentation/documentation_modules/ ... o.k.
>>> 11202: ( 1 / 25 ) Importing /alkacon-documentation/ ... o.k.
>>> 11201: ------ Importing module ...
>>> com.alkacon.documentation.documentation_modules ...
>>>
>> Import Version 4
>>
>>> 11200: at
>>>
>>>
>> org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWo
>> rkplaceImportThread.java:186)
>>
>>> 11199: at
>>>
>> org.opencms.main.CmsShell.start(CmsShell.java:663)
>>
>>> 11198: at
>>> org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
>>> 11197: at
>>> org.opencms.main.CmsShell.executeCommand(CmsShell.java:767)
>>> 11196: at
>>>
>>>
>> org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java
>>
>>> :246)
>>> 11195: at
>>>
>> java.lang.reflect.Method.invoke(Method.java:324)
>>
>>> 11194: at
>>>
>>>
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth
>> odAccessorImpl.java:25)
>>
>>> 11193: at sun.reflect.NativeMethodAccessorImpl.invoke
>>> (NativeMethodAccessorImpl.java:39)
>>> 11192: at
>>>
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>
>>> Method)
>>> 11191: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsS
>> etupBean.java:952)
>>
>>> 11190: at
>>>
>>>
>> org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetu
>> pBean.java:1724)
>>
>>> 11189: at
>>>
>>>
>> org.opencms.importexport.CmsImportExportManager.importData(Cms
>> ImportExportManager.java:610)
>>
>>> 11188: at
>>> org.opencms.module.CmsModuleImportExportHandler.importData
>>> (CmsModuleImportExportHandler.java:359)
>>> 11187: at
>>>
>>>
>> org.opencms.module.CmsModuleImportExportHandler.importModule(C
>> msModuleImportExportHandler.java:499)
>>
>>> 11186:
>>> 11185:
>>>
>> com.alkacon.documentation.howto_httpd_tomcat_modproxy ,
>>
>>> Version 1.0
>>> 11184: ------ Importing module ...
>>> com.alkacon.documentation.howto_multisite ...
>>> org.opencms.configuration.CmsConfigurationException:
>>>
>> Import failed.
>>
>>> The module "com.alkacon.documentation.howto_multisite , Version
>>> 3.0.2" requires the following modules:
>>> 11183: ------ ... the module has been imported
>>> 11182: ------ ... the project has been published
>>> 11181: ------ ... finished updating search index
>>>
>> "Offline project
>>
>>> (VFS)"
>>> 11180: ( 91 ) Indexing file
>>> /sites/default/alkacon-documentation/links/index.html
>>>
>> ... skipped
>>
>>> 11179: ( 90 ) Indexing file
>>> /sites/default/alkacon-documentation/index.html ... skipped
>>>
>>> Greetz, Dirk
>>>
>>>
>>>
>>>
>> ----------------------------------------------------------------------
>>
>>> --
>>>
>>>
>>> _______________________________________________
>>> This mail is sent to you from the opencms-dev mailing list
>>>
>> To change
>>
>>> your list options, or to unsubscribe from the list, please visit
>>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>>
>> --
>>
>> Jack Bakker <jbakker at iable.ca>
>> 416-924-6195 x221
>> iABLE inc.
>> http://www.iable.ca/
>>
>>
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list To
>> change your list options, or to unsubscribe from the list,
>> please visit http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>>
>>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
More information about the opencms-dev
mailing list