Jump to:

4945 Posts in 17703 Topics by 1494 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Installing on myhosting.com

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: 1677 Views
  • dawnswebdesigns
    Avatar
    Community Member
    2 Posts

    Installing on myhosting.com Link to this post

    I just tried to install your latest version & it won't get past the installation:

    Installing SilverStripe...
    I am now running through the installation steps (this should take about 30 seconds)
    If you receive a fatal error, refresh this page to continue the installation
    •   Setting up 'mysite/_config.php'...
    •   Setting up /var/www/domains/dawnswebdesigns.com/docs/family/mysite/_config.php
    •   Setting up '.htaccess' file...
    •   Setting up /var/www/domains/dawnswebdesigns.com/docs/family/.htaccess
    •   Building database schema...

    [User Error] Couldn't run query: ALTER TABLE "Permission" ADD "ID" int(11) not null auto_increment, ADD "ClassName" enum('Permission') character set utf8 collate utf8_general_ci default 'Permission', ADD "Created" datetime, ADD "LastEdited" datetime, ADD "Code" varchar(50) character set utf8 collate utf8_general_ci, ADD "Arg" int(11) not null default 0, ADD "Type" int(11) not null default 1, ADD "GroupID" int(11) not null default 0, ADD index "GroupID" (GroupID), ADD index "Code" (Code), ADD index "ClassName" (ClassName) Incorrect table definition; there can be only one auto column and it must be defined as a key
    POST /family/install.php
    Line 536 in /var/www/domains/dawnswebdesigns.com/docs/family/sapphire/core/model/MySQLDatabase.php
    Source
    527    }
    528    
    529    function databaseError($msg, $errorLevel = E_USER_ERROR) {
    530       // try to extract and format query
    531       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
    532          $formatter = new SQLFormatter();
    533          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
    534       }
    535       
    536       user_error($msg, $errorLevel);
    537    }
    538    
    539    /**
    540     * Return a boolean type-formatted string
    541     *
    542     * @param array $values Contains a tokenised list of info about this data type
    Trace
    o   Couldn't run query: ALTER TABLE "Permission" ADD "ID" int(11) not null auto_increment, ADD "ClassName" enum('Permission') character set utf8 collate utf8_general_ci default 'Permission', ADD "Created" datetime, ADD "LastEdited" datetime, ADD "Code" varchar(50) character set utf8 collate utf8_general_ci, ADD "Arg" int(11) not null default 0, ADD "Type" int(11) not null default 1, ADD "GroupID" int(11) not null default 0, ADD index "GroupID" (GroupID), ADD index "Code" (Code), ADD index "ClassName" (ClassName) Incorrect table definition; there can be only one auto column and it must be defined as a key
    Line 536 of MySQLDatabase.php
    o   MySQLDatabase->databaseError(Couldn't run query: ALTER TABLE "Permission" ADD "ID" int(11) not null auto_increment, ADD "ClassName" enum('Permission') character set utf8 collate utf8_general_ci default 'Permission', ADD "Created" datetime, ADD "LastEdited" datetime, ADD "Code" varchar(50) character set utf8 collate utf8_general_ci, ADD "Arg" int(11) not null default 0, ADD "Type" int(11) not null default 1, ADD "GroupID" int(11) not null default 0, ADD index "GroupID" (GroupID), ADD index "Code" (Code), ADD index "ClassName" (ClassName) | Incorrect table definition; there can be only one auto column and it must be defined as a key,256)
    Line 134 of MySQLDatabase.php
    o   MySQLDatabase->query(ALTER TABLE "Permission" ADD "ID" int(11) not null auto_increment, ADD "ClassName" enum('Permission') character set utf8 collate utf8_general_ci default 'Permission', ADD "Created" datetime, ADD "LastEdited" datetime, ADD "Code" varchar(50) character set utf8 collate utf8_general_ci, ADD "Arg" int(11) not null default 0, ADD "Type" int(11) not null default 1, ADD "GroupID" int(11) not null default 0, ADD index "GroupID" (GroupID), ADD index "Code" (Code), ADD index "ClassName" (ClassName))
    Line 261 of MySQLDatabase.php
    o   MySQLDatabase->alterTable(Permission,Array,Array,Array,Array,,)
    Line 186 of Database.php
    o   SS_Database->endSchemaUpdate()
    Line 199 of DatabaseAdmin.php
    o   DatabaseAdmin->doBuild(1)
    Line 1028 of install.php
    o   Installer->install(Array)
    Line 193 of install.php

    With my hosting, at least on my plan & platform, there's no subdomain names, only subdirectories. Also all softwares must share the same database. SMF adds an extension like SMF_ so you can tell what in your database belongs to SMF. Drupal does no such thing. If you do no such thing...I think that's the problem.

    What could I add to where so it'll add an extension onto this & install it into the database with that extension?

    Thanks for any help.

  • youngmug
    Avatar
    Community Member
    19 Posts

    Re: Installing on myhosting.com Link to this post

    Is this a new install or an upgrade? If it's an upgrade, did you previously move the database/site from a different host?

    SilverStripe doesn't use a prefix by default, I believe. If Drupal has a table of the same name, there could be conflicts. It would probably be best for management to run separate databases for each application; most hosting plans allow more than one database to be created.

  • dawnswebdesigns
    Avatar
    Community Member
    2 Posts

    Re: Installing on myhosting.com Link to this post

    It's a new install. I got the cheapest plan possible & no there's no subdomain names or 2nd database. Yes I am looking to move. Anyway...thanks for trying.

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