17488 Posts in 4473 Topics by 1978 members
| Go to End | Next > | |
| Author | Topic: | 13650 Views |
-
Unable to install on hosted server - No Create DB rights
22 October 2006 at 3:52pm
Not sure if this is a feature request or bug...
I'm on Webdrive (www.webdrive.co.nz) and I can create databases through the web admin panel. The problem is that Silverstripe wants to create the database for me but I don't have the ability to do that. Othe CMS installs have the option of either getting the installer to create the DB or simply pointing the installer to an existing DB.
Any chance of getting this put in or is there a workaround?
Thanks,
Glen -
Re: Unable to install on hosted server - No Create DB rights
22 October 2006 at 5:29pm
Hi Glen,
You can choose the database to use in '_config.php', in the <projectroot> directory. This is where you define what one it's using, and the username and password etc. After that (hopefully), you can then do a <projectroot>/db/build and it should create the first tables in your database.
Cheers,
Sean HarveyDeveloper / SilverStripe
-
Re: Unable to install on hosted server - No Create DB rights
24 October 2006 at 11:55am
Sean's right: SilverStripe will only attempt to create the database for you if it doesn't already exist. This isn't included as an explicit step in the installer, however - that's probably a good thing to add.
-
Re: Unable to install on hosted server - No Create DB rights
24 October 2006 at 1:50pm
If for some reason <projectroot><projectname>_config.php does not exist,
The contents of the file should contain something like:
<?phpglobal $project;
$project = "<projectnname>";$databaseConfig = array(
"type" => "MySQLDatabase",
"server" => "localhost",
//windows "server" => "localhost:3307",
"username" => "<username>",
"password" => "<password>",
"database" => "<dbname>",
);Debug::sendLiveErrorsTo("<your email address>");
Security::setDefaultAdmin('<admin login>','<admin password>');?>
The file should be created automatically by the installer.
-
Re: Unable to install on hosted server - No Create DB rights
24 October 2006 at 3:26pm
OK, getting there...I'vemanaged to install on my local machine with admin rights but now if gives me an error when I go to http://localhost/ss/Security/login adn then enter some login details. I checked the mysql DB and it looks as though there is no users table.
FATAL ERROR: DataObject::buildSQL: Can't find data classes (classes linked to tables) for Member
At line 753 in C:\wamp\www\ss\sapphire\core\model\DataObject.phpuser_error(DataObject::buildSQL: Can't find data classes (classes linked to tables) for Member,256)
user_error at line 753 of DataObject.phpDataObject->buildSQL(Email = 'admin' And Password = 'password',)
buildSQL at line 929 of DataObject.php
.
.
. -
Re: Unable to install on hosted server - No Create DB rights
24 October 2006 at 4:58pm
Is this happening even after you do '<projectpath>/db/build' in your browser (to create the initial fields for the database) ?
Cheers,
Sean HarveyDeveloper / SilverStripe
-
Re: Unable to install on hosted server - No Create DB rights
24 October 2006 at 5:03pm
You probably want to visit /db/build?flush=1 or /Security/login?flush=1. SilverStripe keeps a cache of the database tables that exist and it sounds like this isn't been updated properly.
The default account, admin/password, is created when you first try and log in.
-
Re: Unable to install on hosted server - No Create DB rights
25 October 2006 at 11:52am
Um, have you run the DB build first ?
(You might need to comment that line before you can run the db build) - It allows you administration access before the db / admin membership is setup.
| 13650 Views | ||
| Go to Top | Next > |
