Jump to:

4938 Posts in 16594 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Database issue, developed site on Windows, deployed to *nix.

Getting SilverStripe up and running on your computer and on your web server.

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

Page: 1
Go to End
Author Topic: 1870 Views
  • patrik
    Avatar
    Community Member
    9 Posts

    Database issue, developed site on Windows, deployed to *nix. Link to this post

    Hi,

    First of, pardon me for my bad English...

    I'm usually developing my Silverstripe applications on windows, and i always hosting them on different Linux distributions.

    The problem is that since Windows is not case sensitive the database tables all becomes lowercased. Then when i deploy to the Live servers all data is gone.

    That is because:

    1) All imported tables containing data is lowercased.
    2) Mysql on linux is case sensitive on table names.
    3) Silverstripe uses camelcased database tables.

    Currently i'm using an ugly skript where i have two databases, one with the /dev/build created database and one with the lowercased, imported data. The script then compares those two, renaming the lowercased tables to uppercased versions taken from the tables created from the dev/build.

    But this is getting really annoying, especialy on shared hosts, where you don't have direct shell access and can do the procedure quickly, but have to do everything in some kind of web admin.

    I'm sure im not the only one having this issue.

    How does the rest of the Silverstripe community deploy sites developed on Windows to *nix servers?

  • FullWebService
    Avatar
    Community Member
    38 Posts

    Re: Database issue, developed site on Windows, deployed to *nix. Link to this post

    Hi Patrik,

    There is a ticket about this very issue: http://open.silverstripe.org/ticket/2476

    The solution provided works great for me and with the upcoming 2.4 release this shouldn't be an issue anymore (yay!).

    Hope it helps.

  • JuLo
    Avatar
    Community Member
    37 Posts

    Re: Database issue, developed site on Windows, deployed to *nix. Link to this post

    I'm fairly new to this thing, but had the same problem.

    The fix offered in ticket 2476 almost works, but I had to manually rename the table Permission and the table Member, before it can go through and "repair" all the tables.

    Thought I'd put it out there in case someone had the same issue. (or someone wants to reopen the ticket and add these two tables; although I don't know why they are not included in the other loop)

    JuLo

  • Double-A-Ron
    Avatar
    Community Member
    604 Posts

    Re: Database issue, developed site on Windows, deployed to *nix. Link to this post

    http://doc.silverstripe.org/doku.php?id=installation-on-windows-wamp

    Item #6. Make sure you do this before you next SS installation on WAMP.

    Aaron

    1870 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.