Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Impossibile Install SilverStripe 5_development

Go to End

4 Posts   1012 Views


Community Member, 11 Posts

21 February 2014 at 4:42am

Problem during the installation of SilverStripe (2.3) 5_development :
I am a novice, I'm reading the guidelines SilverStripe The Complete Guide to CMS Development, within the book refers to the installation of SilverStripe folder 5_development
Silverstripe says I have all the prerequisites I start the installation and when creating the database returns the error at line 401

Creating C:\wamp\www\5_development\.htaccess
Building database schema...

[User Error] Couldn't run query: CREATE TABLE `TrackBackPing` ( `ID` int(11) not null auto_increment, `ClassName` enum('TrackBackPing') character set utf8 collate utf8_general_ci default 'TrackBackPing', `Created` datetime, `LastEdited` datetime, `Title` varchar(50) character set utf8 collate utf8_general_ci, `Excerpt` mediumtext character set utf8 collate utf8_general_ci, `Url` varchar(50) character set utf8 collate utf8_general_ci, `BlogName` varchar(50) character set utf8 collate utf8_general_ci, `PageID` int(11) not null default '0', index `PageID` (PageID), index `ClassName` (ClassName), primary key (ID) ) TYPE=MyISAM You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 16
POST /5_development/install.php

Line 401 in C:\wamp\www\5_development\sapphire\core\model\MySQLDatabase.php


392 }
394 function databaseError($msg, $errorLevel = E_USER_ERROR) {
395 // try to extract and format query
396 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397 $formatter = new SQLFormatter();
398 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399 }
401 user_error($msg, $errorLevel);
402 }
403 }
405 /**
406 * A result-set from a MySQL database.
407 * @package sapphire

Information PC (windows 7 64 bit) + WAMP 2.2

*** I enclose folder SilverStripe that returns the error ****


Thank you all in advance that I will succeed in giving aid.


Forum Moderator, 267 Posts

21 February 2014 at 9:06am

Hi MG,

Those books are a bit old now but still have some good information (just some of the API's and syntax had changed).

You might want to try using the newer version of SilverStripe 3.1 and go through our tutorials at


Community Member, 11 Posts

21 February 2014 at 10:14pm

Thanks Camfindlay for the info.

The tutorials I've already looked though the book is interesting because it goes more in depth and above all it creates a site already running, while the tutorial sketch the site.

I'd really like to be able to install the version of SilverStripe book but what is the problem?
the new version of mysql too?
the new version of WAMP too?
Have you tried to install the attachment also gives you the same error?

I'd like to install the old version of silverstripe to follow step by step the book.

Does anyone have any idea to solve?
Thanks to all of the aid


Community Member, 334 Posts

22 February 2014 at 1:10am

Edited: 22/02/2014 1:17am

"what is the problem? the new version of mysql too?"

Yes. 'TYPE=MyISAM' is depreciated since MySQL 5.0. Use 'ENGINE=MyISAM' instead.

"the new version of WAMP too?"

A new version of WAMP uses PHP 5.4. So there will be a lot of errors since in PHP 5.4 "E_STRICT became part of E_ALL".

If you really want to use the book. Please try to use SS 2.4.13 instead. It should be sufficiently compatible to your book... I think.