As I'm migrating Silverstripe databases on a regular basis I've encountered the same issue. I created a little helper Excel sheet, that converts tables to the correct Camel case until the issue is resolved in version 2.4.0.

My host provider has installed the SilverStripe for me on a new server already. Whatever changes I make, I can see it on the internet immediately by going to www.mysite.com/silverstripe/.

After I finish the rewrite, I want the url remains to www.mysite.com. If I am right in following the instructions, seems I just need to change the .htaccess file to "Rewritebase /". Correct?

Thanks!

Grrr... looks like my post timed out. I'll try again.
Live server 'A', test server 'B'.

a) export DB from 'A'
b) copy all public_html recursively from 'A'
c) create db on 'B'
d) import db previously exported from 'A' to 'B'
e) fixup _config.php to point to the db on 'B' with the right credentials
f) fixup .htaccess to allow php5 for files with .php extension on 'B'

Now since this is my first run with SilverStripe (I have done lots of Joomla) I cannot easliy see what might be wrong.
In IE and Chrome the site 'B' basically works but is missing the main masthead area completely as well as footer links.
In FF there is a failure (which must be suppressed by the other browsers).

[Warning] HTTP::add_cache_headers() must be passed an HTTPResponse object
GET /

Line 286 in /home/sites/zwww.co.uk/public_html/sapphire/core/HTTP.php

Anyone have any pointers?
Thanks in advance.
Lee

Ok ignore the FF errors (they went away on the next reboot), so FF, IE7 and Chrome all have the same issue in a copy of a site, ie the masthead section and footer are both missing.

I just tried that patch for renaming the tables, but it doesn't work for me. It doesn't seem to do anything.

AFAICS it doesn't really do any uppercase renaming or am I missing something obvious?

http://open.silverstripe.org/attachment/ticket/2476/MySQLDatabase.diff

I'm not sure if I would want to manually rename 100 tablenames...

Hi,

I'm migrating a SS 3.1.6 site from my local Windows 7 machine into a Linux server.
I checked and all the table names are lower case.

All the links posted for reference tickets or post seem to be broken. Are there any updated news on this?

Thank you

I have just taken over managing a SilverStripe site (new job) and I am attempting to setup a dev server on my laptop.

I created the database and imported the .sql file, installed the SilverStripe framework and copied what I think are all the parts of the site over. However I get this page. What am I missing?

----------------------------------------------------------------
Welcome to SilverStripe
Getting Started
To get started with the SilverStripe framework:

Create a Controller subclass (doc.silverstripe.org/framework/en/topics/controller)
Setup the routes.yml to your Controller (doc.silverstripe.org/framework/en/reference/director#routing).
Create a template for your Controller (doc.silverstripe.org/framework/en/reference/templates)

Community resources
silverstripe.org/forum Discussion forums for the development community.
silverstripe.org/irc IRC channel for realtime support and discussions.
doc.silverstripe.org Searchable developer documentation, how-tos, tutorials, and reference.
api.silverstripe.org API documentation for PHP classes, methods and properties.

Thanks in advance.

For people looking for help on the table name case using Xamp on Windows: update the following setting on my.ini (MySQL>Config): lower_case_table_names=0

valpd: make sure you visit yoursite.com/dev/build and yoursite.com/?flush=all after migrating.