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