[opencms-dev] Critical bug in all version >7.5.4

Thu Jan 19 14:24:28 CET 2012

Hi Tobias,

My Collation is Case Insensitive, this is the default value for OpenCms (create_db.sql : CREATE DATABASE ${database} COLLATE SQL_Latin1_General_CP1_CI_AS; )

This is also an (old) bug report : http://bugzilla.opencms.org/show_bug.cgi?id=1670 <http://bugzilla.opencms.org/show_bug.cgi?id=1670> 

have you got an idea of the risk changing the collation on a production website ?

Regards,

Julien

De : opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] De la part de Tobias Herrmann
Envoyé : jeudi 19 janvier 2012 11:52
À : The OpenCms mailing list
Objet : Re: [opencms-dev] Critical bug in all version >7.5.4

Hi Julien,

my knowledge of the SQL Server configuration is rather basic. Is your collation mode case sensitive or insensitive? 

Using Collation mode 'SQL_Latin1_General_CP1_CS_AS' with OpenCms 7.5.4 I can't reproduce your problem.

Greetings, Tobias

--

Alkacon Software GmbH - The OpenCms Experts

http://www.alkacon.com  --  http://www.opencms.org

Am 18.01.2012 15:56, schrieb Julien Lechevanton: 

Hi,

This is very simple with OpenCms 7.5.2, SQL Server, collation mode : CI

Take a folder such as "test" containing subfolders. Rename it to "Test", it disappear from offline project and a cycle reference appear in the structure_path field.

We had a similar issue on mysql : 

folder A

|_ folder B  (locked from another user)

Rename folder A, ignore warning and publish > bug, this may not appear every time.

By the way, there is no possibility to repair those contents without executing SQL Querries....maybe a "light" vfs doctor could do the trick ? 

(an example query listing structure_path inconsistency :

select * from CMS_OFFLINE_STRUCTURE, CMS_ONLINE_STRUCTURE where (CMS_OFFLINE_STRUCTURE.RESOURCE_PATH != CMS_ONLINE_STRUCTURE.RESOURCE_PATH or CMS_OFFLINE_STRUCTURE.PARENT_ID != CMS_ONLINE_STRUCTURE.PARENT_ID) and CMS_OFFLINE_STRUCTURE.STRUCTURE_ID = CMS_ONLINE_STRUCTURE.STRUCTURE_ID;

)

Regards,

Julien

De : opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] De la part de Tobias Herrmann
Envoyé : mercredi 18 janvier 2012 13:15
À : The OpenCms mailing list
Objet : Re: [opencms-dev] Critical bug in all version >7.5.4

Hi Julien,

we still can't reproduce this issue. Please provide detailed information about your setup and a step by step guide how to reproduce the problem.

Greetings, Tobias

--

Alkacon Software GmbH - The OpenCms Experts

http://www.alkacon.com  --  http://www.opencms.org

Am 17.01.2012 15:52, schrieb Julien Lechevanton: 

Hi all,

This bug is critical, is there a workaround ?

Regards,

Julien

De : opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] De la part de Deiverson Silveira
Envoyé : lundi 21 novembre 2011 13:55
À : The OpenCms mailing list
Objet : Re: [opencms-dev] Critical bug in all version >7.5.4

My mistake only version >7.5.4... in my project 7.5.3 with SQL Server 2005 work, but in 7.5.4, 8.0.x, stay with problem

2011/11/21 Deiverson Silveira <deiverson at solutioncms.com>

Really, in my projects in PostGreSQL and Oracle I don't have problem, but only SQL Server 2005, more project in SQL Server 2005. =[

2011/11/21 Alexander Kandzior <alex at opencms.org>

I am quite certain that this is database related. Which DB are you using? Please include precise version info.

Kind Regards,

Alex.

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

Alexander Kandzior

Alkacon Software GmbH  - The OpenCms Experts                 

http://www.alkacon.com - http://www.opencms.org                  

From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Tobias Herrmann
Sent: Monday, November 21, 2011 9:37 AM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Critical bug in all version OpenCms

Hi,

could you explain step by step what you do to produce this error?
I have tried to reproduce it, but it works for me. I have created a folder 'New' with a file 'index.html' and published both. Than I renamed the folder to 'new'. At this point '/New/index.html' is still accessible online, once I publish both only '/new/index.html' is accessible online. 

Greetings, Tobias

--

Alkacon Software GmbH - The OpenCms Experts

http://www.alkacon.com -- http://www.opencms.org

Am 18.11.2011 18:52, schrieb Deiverson Silveira: 

I test in 8.0.3... some bug... 

create folder with name "News1"... and rename for "news1"... dissapear...and critical if publish and make this process, because I dont acesse offline folder.

I dont can register in bugzilla (bugzilla.opencms.org)

-- 

www.solutioncms.com

The Brazilian  

Official Provider OpenCms

_______________________________________________
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/cgi-bin/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/cgi-bin/mailman/listinfo/opencms-dev

-- 

www.solutioncms.com

The Brazilian 

Official Provider OpenCms

-- 

www.solutioncms.com

The Brazilian 

Official Provider OpenCms

_______________________________________________
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/cgi-bin/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/cgi-bin/mailman/listinfo/opencms-dev

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