Hi
I am trying to install SilverStripe on a host provider but am striking problems with the database (see attached screenshot). When I create the database the install programme says it can't see it so I deleted it but then the installer says I don't have the permission to create a database even though that user had just been used to create one via the hosting interface. I am confused, I have logged a ticket with the host provider but I am wondering if I am missing something on the SS side

Can you help?
MM

That error as it says in the bottom corner - You have not got a database called 'SS_mysite' and your user can't create the database. So you will have to a) Use a different user which has CREATE rights b) Give your user CREATE rights so that SilverStripe can create the database for you or c) Use an existing database or create the database.

Hi Willr

Thanks for the quick response.

I am trying to get the host provider to hep me sort the permissions, for some reason I don't have access to this. I am using the database administrator shouldn't tis work?

In the meantime I am wondering if I can get around the problem. The database has a prefix newzealandboutiq_-_ which the install script seems to change to newzealandboutiq__ (see attached ss)when I click Recheck Requirements which I am guessing is why it says the database doesn't exist when it actually does. Is there anyway to stop this?

Thaks

Catherine

I am having exactly the same problem with the '_-_' being turned into '___'. My hosting is with FreeParking.

The host has come back to me and said they don't think there is anything wrong with the permissions and the problem is being caused by the missing dash. Can I log tis as a bug and how do I do that?

Cheers

Catherine

Snap on the Freeparking thing. Have asked if the dash can be removed from the prefix as a work around.

Catherine

I've just fixed it. If you edit your install.php file and change the name of your database there it recognises the '_-_'. You can even put your username and password in there to to make it quicker!

Apparently you can't change the prefix, which is a bit of a bugger!

Hey LoZza

Thank you very much you have made my Friday morning

MM