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?
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
Line 286 in /home/sites/zwww.co.uk/public_html/sapphire/core/HTTP.php
Anyone have any pointers?
Thanks in advance.
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?
I'm not sure if I would want to manually rename 100 tablenames...
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?
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
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)
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.