I've been trying to install SilverStripe to investigate it and compare it to the three usual suspects. This was instigated by reading that you're the first open source project to be M$ certified. But I've given up, it's all become to painful and time consuming! Well, ok, not quite or I wouldn't be posting here.
Step 1) Download - yes, did that!
Step 2) Install - yeah, right
So I'm here <http://doc.silverstripe.org/installation-on-webserver>
"Visit your Sites Domain or IP Address in your webbrowser" - NO!! visit your_site/install.php
So I work through the not too obvious errors about file permissions, except that in half the cases the files weren't there to have their permissions set. Wouldn't be more helpful to actually say a file is not there. Anyway, a few touch and chmods seem to sort it out but you're never 100% sure.
Then is says everything is set to install, so I select Install.
Next I get some banal message about Database Error and in classic style nothing more except some equally crap message that the web server was unable to perform the request. I doubt it! The web server had done just fine I suspect!
I trawl the forums but no suggestions work. The best one was advice to add a debug entry to mysite/_config.php - brilliant! You can't install the site with this file present and you can't get debug output without it!!
Next, hmmmm! I think. I'll re-install but now I won't use the BlackCandy theme, the Tutorials are the way to go right, no; wrong again. This time I'm told the installation has worked! Yipee! And to follow the links to the CMS. So I do. Bugger! 404! I look at the file system, there's no admin directory nor file. I look in the database, no references to admin any where ** sigh **
Next, I register an account so I can <s>rant</s> report issues.
Next I re-run the install using Black Candy so I can accurately report on the error message reported above. I'm quite used to it now, I have a console window open so I can just use the cursor keys and <Return>.
Blimey, the install now works! There's nothing like consistency, it this is nothing like... you get the point. Well is says it's worked but it hasn't really. I'm just thinking about deleting this post when bam!
[User Error] Couldn't run query: SELECT COUNT(*) FROM "PageComment" WHERE "PageComment"."ParentID" = '1' Table 'SilverStripe.PageComment' doesn't exist
GET /
Line 526 in /opt/lampp/htdocs/SilverStripe/sapphire/core/model/MySQLDatabase.php
Source
517 }
518
519 function databaseError($msg, $errorLevel = E_USER_ERROR) {
520 // try to extract and format query
521 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
522 $formatter = new SQLFormatter();
523 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
524 }
525
526 user_error($msg, $errorLevel);
527 }
528
529 /**
530 * Return a boolean type-formatted string
531 *
532 * @param array $values Contains a tokenised list of info about this data type
Trace
Couldn't run query: SELECT COUNT(*) FROM "PageComment" WHERE "PageComment"."ParentID" = '1' Table 'SilverStripe.PageComment' doesn't exist
Line 526 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: SELECT COUNT(*) FROM "PageComment" WHERE "PageComment"."ParentID" = '1' | Table 'SilverStripe.PageComment' doesn't exist,256)
Line 124 of MySQLDatabase.php
MySQLDatabase->query(SELECT COUNT(*) FROM "PageComment" WHERE "PageComment"."ParentID" = '1',256)
Line 129 of DB.php
DB::query(SELECT COUNT(*) FROM "PageComment" WHERE "PageComment"."ParentID" = '1')
Line 392 of ContentController.php
ContentController->PageComments()
Line 369 of ViewableData.php
ViewableData->obj(PageComments,,,1)
Line 446 of ViewableData.php
ViewableData->XML_val(PageComments,,1)
Line 207 of .cache.themes.blackcandy.templates.Layout.Page.ss
include(/opt/lampp/htdocs/SilverStripe/silverstripe-cache/.cache.themes.blackcandy.templates.Layout.Page.ss)
Line 420 of SSViewer.php
SSViewer->process(Page_Controller,Zend_Cache_Frontend_Output)
Line 411 of SSViewer.php
SSViewer->process(Page_Controller)
Line 202 of Controller.php
Controller->handleAction(SS_HTTPRequest)
Line 137 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
Line 147 of Controller.php
Controller->handleRequest(SS_HTTPRequest)
Line 199 of ContentController.php
ContentController->handleRequest(SS_HTTPRequest)
Line 67 of ModelAsController.php
ModelAsController->handleRequest(SS_HTTPRequest)
Line 111 of RootURLController.php
RootURLController->handleRequest(SS_HTTPRequest)
Line 281 of Director.php
Director::handleRequest(SS_HTTPRequest,Session)
Line 124 of Director.php
Director::direct(/)
Line 127 of main.php
A quick exam of the database reveals that indeed it is now trying to interrogate a database table that doesn't exists. Ah, I know, it's confused, it's already got a bunch of tables - I'll delete the database and start again. Once again the install works, why?!?! it failed time after time before, but lets not worry too much about that right now. And yes, the same error again, no database table called PageComment.
I have no hair left and my tears have turned to manic laughter. I'm sorry guys, it's great that M$ have certified you, I certainly need certifying after trying to use SliverStripe, but I fear I'll have to stick to the usual three CMSs that not only install but work the way they describe.
I'm using 2.4.3, I suspect I would have had more success using the 2.4.2 Windows installer (I'm using Linux before anyone says "yes"!).