[opencms-dev] RV: Beta 2 - case-sensitiveness in MySQL 4

[Claus Priisholm]

Great that it works for you now

Most of the SQL statements are per default written as upper case in the 
source code, so I don't think it is considered a bug.
Maybe one could blame mysql for not making case insensitivity the 
default since it is their choice to depend on the underlying filesystem 
as far as table-naming goes.



On 15/4-2005, at 17.28, Mariano Barcia wrote:

> Claus,
>
> It worked, thank you!
>
> BTW, is this a bug of the beta? Should I report it? IMHO, it should be 
> transparent.
>
> --mariano
>
> -----Mensaje original-----
> De: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] En nombre de Claus Priisholm
> Enviado el: Jueves, 14 de Abril de 2005 03:22 a.m.
> Para: The OpenCms mailing list
> Asunto: Re: [opencms-dev] RV: Beta 2 - case-sensitiveness in MySQL 4
>
> You can tell mysql to ignore the case of table names (actual behaviour
> is determined by the underlying file system as tables are stored as
> files).
>
> Coding style should of course ensure a consistent naming but mistakes
> happen and you won't notice them if you develop on a case-insensitive
> filesystem like the on in Windows. So I generally set this property in
> the my.cnf file:
>
> [mysqld]
> lower_case_table_names=1
>
>
>
>
> On 14/4-2005, at 1.49, Mariano Barcia wrote:
>
>> Dear all,
>>
>> We have an OpenCMS (Beta 1) installation that is having trouble
>> migrating from one MySQL server to another. We have dumped and
>> sourced the dabatase in another server, and then, we get this error on
>> opencms startup:
>>
>> [Code 400 - OpenCms init error]
>> Root cause was: org.opencms.main.CmsException: Database init failed
>> [Code 33 - DriverManager init error]
>> Root cause was: org.opencms.main.CmsException: Critical error while
>> initializing org.opencms.db.mysql.CmsUserDriver [Code 33 -
>> DriverManager init error]
>> Root cause was: java.lang.RuntimeException:
>> org.opencms.db.CmsSqlException: [org.opencms.db.mysql.CmsUserDriver]
>> where:
>> org.opencms.db.generic.CmsUserDriver.existsGroup(CmsUserDriver.java:
>> 380), why: java.sql.SQLException: General error message from
>> server: "Table 'kneobasecms.CMS_GROUPS' doesn't exist"query:
>> com.mysql.jdbc.PreparedStatement at 1c8f91e: SELECT * FROM CMS_GROUPS
>> WHERE GROUP_NAME='Administrators' [Code 301 - SQL Exception]
>> Root cause was: java.sql.SQLException: General error message from
>> server: "Table 'kneobasecms.CMS_GROUPS' doesn't exist"
>>
>> The table "CMS_GROUPS" does exist, but as "cms_groups".
>>
>> Does OCMS v6 Beta 1 or Beta 2 behaves accordingly with
>> case-sensitiveness in MySQL 4?
>>
>> Thanks in advance.
>> --mariano
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
> --
> Claus Priisholm, CodeDroids ApS
> +45 48 22 46 46
> email: cpr (you-know-what) interlet.dk - cpr (you-know-what)
> codedroids.com
> skype: claus_priisholm
> http://www.interlet.dk - http://www.codedroids.com
>
>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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
>
>
--
Claus Priisholm, CodeDroids ApS
+45 48 22 46 46
email: cpr (you-know-what) interlet.dk - cpr (you-know-what) 
codedroids.com
skype: claus_priisholm
http://www.interlet.dk - http://www.codedroids.com