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

Thu Jan 19 15:21:59 CET 2012

Hi Tobias.

+1 for restoring case sensitive collation.

I will change JPA layer to use upper case identifiers.

Best regards
Georgi

On 01/19/2012 04:16 PM, Tobias Herrmann wrote:
> Hi Georgi,
>
> the change does not effect the data within the database. The problem
> comes with case insensitive string comparison. Within the slightly
> delicate rename/move operation case sensitivity is very important.
>
> Greetings, Tobias
>
> --
>
> Alkacon Software GmbH - The OpenCms Experts
>
> http://www.alkacon.com -- http://www.opencms.org
>
>
>
> Am 19.01.2012 14:57, schrieb Georgi Naplatanov:
>> Hi Julien and Tobias.
>>
>> This change has been introduced with JPA integration (OpenCms 8.0.0).
>>
>> The idea of this change was SQL identifiers to be case insensitive on
>> MS SQL Server. I haven't know that this change can affect data in
>> database.
>>
>> Best regards
>> Georgi
>>
>> On 01/19/2012 03:49 PM, Tobias Herrmann wrote:
>>> Hi Julien,
>>>
>>> it should be possible to change the collation on a database level, but I
>>> don't know anything about the failure rate of this operation. You should
>>> in any case make a backup of your tables before you try it.
>>>
>>> And you are right, we somehow introduced this bug for version 8 into out
>>> database setup script. In versions 7.5.x the script was still all-right.
>>> I will fix that for the next releases.
>>>
>>> Greetings, Tobias
>>>
>>> --
>>>
>>> Alkacon Software GmbH - The OpenCms Experts
>>>
>>> http://www.alkacon.com --http://www.opencms.org
>>>
>>>
>>> Am 19.01.2012 14:24, schrieb Julien Lechevanton:
>>>>
>>>> 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
>>>>
>>>> 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>
>>>> [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>
>>>> [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>
>>>> [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
>>>> <mailto: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
>>>> <mailto: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>
>>>> [mailto: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
>>>> <http://bugzilla.opencms.org>)
>>>>
>>>> --
>>>>
>>>> /www.solutioncms.com <http://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 <http://www.solutioncms.com>/
>>>>
>>>> /The Brazilian /
>>>>
>>>> /Official Provider OpenCms/
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> /www.solutioncms.com <http://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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>>
>> _______________________________________________
>> 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
>
>
>