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

[Claus Priisholm]

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