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

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

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?

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

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

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.

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

The solution in this post worked for me:

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

Toby