21493 Posts in 5784 Topics by 2622 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1148 Views |
-
[solved] server error when trying to copy database
30 March 2011 at 11:10pm
hi,
when i try to copy my db from localhost to my hosted site, i get this server error:
Server error
Sorry, there was a problem with handling your request.
i checked the _config and the dbhost, pw/login, db name etc. were all changed to match the ones on the new db.
any help?
-
Re: [solved] server error when trying to copy database
31 March 2011 at 5:27am
could read the faq for some debugging methods and that may shed some light on it...
http://www.silverstripe.org/general-questions/show/16055 -
Re: [solved] server error when trying to copy database
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...
-
Re: [solved] server error when trying to copy database
31 March 2011 at 9:17am
Running dev/build does rename tables to the right case.
-
Re: [solved] server error when trying to copy database
31 March 2011 at 9:44pm
not with me.
of course, after copying the db dev/build was the first thing i did... even before trying to view the site...
btw: how would ss know how to rename the tables?? from lowercase to CamelCase?
-
Re: [solved] server error when trying to copy database
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?
-
Re: [solved] server error when trying to copy database
31 March 2011 at 10:06pm
yeah, i found it as well after searching the forum (after i identified the problem).
and after changing it, it had no effect.now, after a second thought - of course - it can only work when you create the db after the change... stupid me...
| 1148 Views | ||
|
Page:
1
|
Go to Top |
