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

[Mariano Barcia]

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