Jump to:

4945 Posts in 17872 Topics by 1494 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Impossibile Install SilverStripe 5_development

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

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

Page: 1
Go to End
Author Topic: 449 Views
  • maga
    Avatar
    Community Member
    11 Posts

    Impossibile Install SilverStripe 5_development Link to this post

    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

  • camfindlay
    Avatar
    Forum Moderator
    148 Posts

    Re: Impossibile Install SilverStripe 5_development Link to this post

    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

  • maga
    Avatar
    Community Member
    11 Posts

    Re: Impossibile Install SilverStripe 5_development Link to this post

    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

  • Devlin
    Avatar
    Community Member
    215 Posts

    Re: Impossibile Install SilverStripe 5_development Link to this post

    "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.

    449 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.