Jump to:

3462 Posts in 1065 Topics by 740 members

Data Model Questions

SilverStripe Forums » Data Model Questions » The Windows->Linux lowercase MySQL problem...

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 2331 Views
  • MartinPhone
    Avatar
    Community Member
    57 Posts

    The Windows->Linux lowercase MySQL problem... Link to this post

    I've seen a few posts in the archive detailing various fixes to the migrating from a Windows to a Linux server. A lot of these posts are quite old, and a lot of the time the code snippets posted are already in the MySQLDatabase.php file, suggesting they'd have run already. But my database does still have only lowercase tables and it doesn't seem to work on the Linux box. So I'm a bit confused.

    How do I fix this? I've naturally run dev/build plenty of times on the Windows box and I can't run dev/build on the linux box.

    Is this even still an issue? Is it likely to be something else entirely?

  • sonet
    Avatar
    Community Member
    33 Posts

    Re: The Windows->Linux lowercase MySQL problem... Link to this post

    Did you switch:

    lower_case_table_names = 2

    in your mysql.ini?

    You can refer to for more infO:

    http://dev.mysql.com/doc/refman/4.1/en/identifier-case-sensitivity.html

  • simon_w
    Avatar
    Forum Moderator
    474 Posts

    Re: The Windows->Linux lowercase MySQL problem... Link to this post

    You need to run dev/build on the Linux box. There should be no reason why you can't.

  • MartinPhone
    Avatar
    Community Member
    57 Posts

    Re: The Windows->Linux lowercase MySQL problem... Link to this post

    Thank you for your replies!

    I did switch

    lower_case_table_names = 2 (on the windows box, then tried a dev/build) and it gave the same 'cannot respond' error - (I had assumed because it wasn't finding the tables it wanted).

    But of course if the vanilla dev/build should work on the linux box without any problems, and rename the tables ... then I guess the server can't be configured correctly... at least I know where to look. Just needed confirmation that it wasn't the issue. Thank you.

    edit: What would be the harm in setting lower_case_table_names = 1 on the linux box?... just wondering... haven't tried it yet.

  • Ingo
    Avatar
    Forum Moderator
    801 Posts

    Re: The Windows->Linux lowercase MySQL problem... Link to this post

    Some previous discussions and a reopened ticket on that one: http://open.silverstripe.org/ticket/2476 - patches welcome

    2331 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.