I try to install Silverstripe 2.2.2 on ovh hosting (a big french hosting).
(php 5.2.6 , mysql 5.0.44)
on the install.php, all requirements are green (good) but when I press install button I have an error :
I am now running through the installation steps (this should take about 30 seconds)
If you receive a fatal error, refresh this page to continue the installation
# Creating 'mysite/_config.php'...
# Creating /home.10.23/nutrifiz/www/mysite/_config.php
# Creating '.htaccess' file...
# Creating /home.10.23/nutrifiz/www/.htaccess
# Building database schema...
Fatal error: DATABASE ERROR: Couldn't run query: SHOW FULL FIELDS IN `Newsletter` | Table 'nutrifiz.Newsletter' doesn't exist in /home.10.23/nutrifiz/www/sapphire/core/model/Database.php on line 431
What's wrong ? is somebody successfully install silverstripe on ovh ?
Can we specify to not take care of case in mysql ?
I think this could be a mysql config option rather then an SS one. To get pass the installer you could try dulicating the newsletter table to Newsletter - its a bit of a hack but if your not going to use the newsletter system then you should be sweet
It's a problem of casing. I tried to develop in local on a windows machine and transfered on ovh hosting. as it doesn't work I reinstall SS directly on ovh but without deleting the db.
with a clean install all is ok.
UNIX is case sensitive for tables names where as windows is not - or the other way round :P so it works when you clean install but if you try and copy the db across you of course have an issue. See the mysql docs - http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html for how to disable it.