Linux and case sensitivity

[Ludwig Magnusson-2]

Hi!

I have been developing a webapp on a windows machine and it works fine.
Howerver, now I am moving it to a linux based envroment and I get a strange
problem. I am using turbine and all database operations that has anything to
do with the table turbine_user_group_role does not work. I catch a mysql
exception saying "the table myapp.TURBINE_USER_GROUP_ROLE" does not exist.

Can this have anything to do with case sensitivity? The table does exist in
my database (lower case)

The weird thing is that torque can read and write to all other tables in my
db.

 

Any ideas?

/Ludwig

[wglass]

Exactly.  MySQL table names are case sensitive in Linux but not in Windows.

WILL

On Thu, Apr 23, 2009 at 11:59 PM, Ludwig Magnusson
<ludwig@...> wrote:

> Hi!
>
> I have been developing a webapp on a windows machine and it works fine.
> Howerver, now I am moving it to a linux based envroment and I get a strange
> problem. I am using turbine and all database operations that has anything to
> do with the table turbine_user_group_role does not work. I catch a mysql
> exception saying "the table myapp.TURBINE_USER_GROUP_ROLE" does not exist.
>
> Can this have anything to do with case sensitivity? The table does exist in
> my database (lower case)
>
> The weird thing is that torque can read and write to all other tables in my
> db.
>
>
>
> Any ideas?
>
> /Ludwig
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@...
For additional commands, e-mail: torque-user-help@...

[Ludwig Magnusson-2]

Right, but does torque handle that?
It's strange that I define my table lower case but torque asks for it in
upper case. I changed the definition of my turbine tables to upper case and
it works now. All my other tables are lower case and working properly...
/Ludwig

-----Original Message-----
From: Will Glass-Husain [mailto:wglasshusain@...]
Sent: den 24 april 2009 16:04
To: Apache Torque Users List
Subject: Re: Linux and case sensitivity

Exactly.  MySQL table names are case sensitive in Linux but not in Windows.

WILL

On Thu, Apr 23, 2009 at 11:59 PM, Ludwig Magnusson
<ludwig@...> wrote:
> Hi!
>
> I have been developing a webapp on a windows machine and it works fine.
> Howerver, now I am moving it to a linux based envroment and I get a
strange
> problem. I am using turbine and all database operations that has anything
to
> do with the table turbine_user_group_role does not work. I catch a mysql
> exception saying "the table myapp.TURBINE_USER_GROUP_ROLE" does not exist.
>
> Can this have anything to do with case sensitivity? The table does exist
in
> my database (lower case)
>
> The weird thing is that torque can read and write to all other tables in
my
> db.
>
>
>
> Any ideas?
>
> /Ludwig
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@...
For additional commands, e-mail: torque-user-help@...


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@...
For additional commands, e-mail: torque-user-help@...

[Thomas Fischer-11]

> Right, but does torque handle that?
> It's strange that I define my table lower case but torque asks for it in
> upper case. I changed the definition of my turbine tables to upper case
and
> it works now. All my other tables are lower case and working properly...

Which torque version are we talking about ? I remember there was an issue
regarding table case, and I seem to remember it has been fixed/changed in
Torque 3.3. Please search Jira for the issue.

     Thomas

[Ludwig Magnusson-2]

I'm using 3.3.
Doesn't really matter now, the problem is solved..

-----Original Message-----
From: Thomas Fischer [mailto:fischer@...]
Sent: den 24 april 2009 16:29
To: Apache Torque Users List
Subject: RE: Linux and case sensitivity

> Right, but does torque handle that?
> It's strange that I define my table lower case but torque asks for it in
> upper case. I changed the definition of my turbine tables to upper case
and
> it works now. All my other tables are lower case and working properly...

Which torque version are we talking about ? I remember there was an issue
regarding table case, and I seem to remember it has been fixed/changed in
Torque 3.3. Please search Jira for the issue.

     Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@...
For additional commands, e-mail: torque-user-help@...