31 March 2011 at 7:29am
(Last edited: 31 March 2011 7:30am),
so it was the infamous mysql table names: CamelCase vs. lowercase...
just to reiterate again:
on windows, mysql's tablenames are all lowercase. when copying the database to a ss installation on a linux server, where the table names are CamelCase, very bad things happen. :)
i think this should be at least addressed more broadly by the ss team. i spend hours to debug...
31 March 2011 at 9:57pm
well it does have this hidden away in the docs... http://doc.silverstripe.org/sapphire/en/installation/windows-wamp... that mentions...
"Left-click the gauge, then select MySQL -> my.ini. At the very bottom of the file, and add the following to a new line (without the quotes): "lower_case_table_names = 2". Save the file, close Notepad and left-click the gauge, and selected 'Restart all services'. This is used to ease the transition between a Windows-based install and a Linux-based install where case-sensitivity is important."
maybe it could detect windows and make this a requirement during install?