[opencms-dev] System error when creating a new project.

[Bosky, Dave]

The install went fine without any issues. I didn't experience any unique
constraint violations. 
The only issue I had was with the invalid parameter bindings....
 
-----Original Message-----
From: Eduard Nesterov [mailto:edn at quadrix.com] 
Sent: Wednesday, April 07, 2004 12:10 PM
To: opencms-dev at opencms.org
Subject: Re: [opencms-dev] System error when creating a new project.



Hi Dave,

I am trying to get opencms to work with MS SQL Server and not able to
install it correctly due to the unique constraint violation at the end of
the installation process (while importing org.opencms.welcome.zip module).
Did you have any problems installing opencms or it went OK.

Ed

Bosky, Dave wrote:


Thanks Geoff!  Removing those 2 entries seemed to resolve the issues with

SQL Server.

Do you have any other recommendations to offer regarding the use of open cms

with SQL Server?



Thanks again,

Dave



-----Original Message-----

From: Geoff Winkless [mailto:opencms at geoff.dj <mailto:opencms at geoff.dj> ] 

Sent: Wednesday, April 07, 2004 9:42 AM

To: opencms-dev at opencms.org <mailto:opencms-dev at opencms.org> 

Subject: RE: [opencms-dev] System error when creating a new project.





07 April 2004 13:51, Bosky, Dave wrote:

  

I just installed opencms without any issues and was steping my way 

through the documentation creating the sample 'Nice Try' project but 

after entering the project name, channels, etc. I get the System Error 

listed below.

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

com.opencms.core.CmsException: 4 Sql exception.

Detailed error:

[com.opencms.file.mssql.CmsDbAccess][Microsoft][SQLServer 200 Driver

for JDBC]Invalid parameter binding(s).

    



There are several fixes for SQL Server available. 



If you're happy modifying the contents of your database to add some stored

procedures I posted some optimisations to the list on 19th Feb (don't know

if you can download attachments from the archive... anyone?)



The specific problem you have encountered is a (much-discussed) bug which

requires the modification to the opencms.properties file in the

com.opencms.core.mssql directory in the opencms.jar library. Simply delete

the C_RESOURCES_GET_FILESINFOLDER and C_RESOURCES_GET_SUBFOLDER entries and

your problem should go away.



http://www.opencms.org/bugzilla/show_bug.cgi?id=91
<http://www.opencms.org/bugzilla/show_bug.cgi?id=91> 



Geoff





______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System. For

more information please visit http://www.messagelabs.com/email
<http://www.messagelabs.com/email>  

______________________________________________________________________

_______________________________________________

This mail is send to you from the opencms-dev mailing list

To change your list options, or to unsubscribe from the list, please visit

http://mail.opencms.org/mailman/listinfo/opencms-dev
<http://mail.opencms.org/mailman/listinfo/opencms-dev> 





HTC Disclaimer:  The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.

_______________________________________________

This mail is send to you from the opencms-dev mailing list

To change your list options, or to unsubscribe from the list, please visit

http://mail.opencms.org/mailman/listinfo/opencms-dev
<http://mail.opencms.org/mailman/listinfo/opencms-dev> 





  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040407/c195117e/attachment.htm>