Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Table Names - Windows -> Linux

Our old forums are still available as a read-only archive.

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

Page: 1
Go to End
Author Topic: 2558 Views
  • Double-A-Ron
    Avatar
    Community Member
    603 Posts

    Table Names - Windows -> Linux Link to this post

    Hi all,

    Well, my first Silverstripe site is now complete. Developed over 2 months in my spare time, with one fairly highly modified custom page type for managing and displaying and selling tours through South America.

    So the slated go-live was last night. Which was about the time I hit the snag I am still facing this morning.

    First, the site was developed in a WAMP environment. Pretty much a must have in terms of speed. When I uploaded my tables and code last night, I was met with nothing more than a

    Error

    The website server has not been able to respond to your request.


    Having a bit of a dig around, I found that the table names in my WAMP config were all lower case. I thought this was a little weird given SS's naming convention, so I installed a fresh copy of 2.2.2 on the live server. And yes, in a LAMP configuration, the table names are indeed TitleCased.

    I'm know that this must be a Windows-Linux thing, but I have never seen any open source software that has this sort of trouble (and I always develop in a WAMP-LAMP dev to live setup). This is surely something en-forcable by code?

    Cheers
    Aaron

  • dio5
    Avatar
    Community Member
    501 Posts

    Re: Table Names - Windows -> Linux Link to this post

    You need to put

    lower_case_table_names = 2

    in your my.ini file of yr mysql install on windows

    See http://doc.silverstripe.com/doku.php?id=installation-on-windows

  • Double-A-Ron
    Avatar
    Community Member
    603 Posts

    Re: Table Names - Windows -> Linux Link to this post

    Thanks Dio,

    It's a shame the forum doesn't support stickies, as I'm sure many newbs will get tripped up on that one.

    I never needed to check that doc, as SS ran just fine on WAMP the first time I tried.

    Question: Will that have any effect on my Dev version since all the table names are lowercase already?

  • dio5
    Avatar
    Community Member
    501 Posts

    Re: Table Names - Windows -> Linux Link to this post

    It will make new tables capitalized, but do nothing to the old ones afaik..

    I've added it a few weeks ago and havent noticed any issues so far...

  • Briohny
    Avatar
    Community Member
    199 Posts

    Re: Table Names - Windows -> Linux Link to this post

    So how would you go about changing the existing tables into capitalised names to coincide with the linux database format?

  • Blackdog
    Avatar
    Community Member
    156 Posts

    Re: Table Names - Windows -> Linux Link to this post

    by hand.

    I had to do a site which had all the content loaded locally. Took a while but better then reloading content.

    never made that mistake again.

  • Briohny
    Avatar
    Community Member
    199 Posts

    Re: Table Names - Windows -> Linux Link to this post

    Awww! That sux. ok, well here i go...

  • tobych
    Avatar
    Community Member
    97 Posts

    Re: Table Names - Windows -> Linux Link to this post

    The solution in this post worked for me:

    http://www.silverstripe.com/site-builders-forum/flat/77595#post128453

    Toby

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