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, biapar, Willr, Ingo, swaiba, simon_w

Impossibile Install SilverStripe 5_development


Reply


4 Posts   528 Views

Avatar
maga

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

Source

392    }
393    
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       }
400       
401       user_error($msg, $errorLevel);
402    }
403 }
404
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.
greetings
MG

Avatar
camfindlay

Forum Moderator, 181 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 http://doc.silverstripe.org/framework/en/tutorials

Avatar
maga

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
MG

Avatar
Devlin

Community Member, 217 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".

Edit:
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.