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

Installing on myhosting.com


Reply


3 Posts   1780 Views

Avatar
dawnswebdesigns

Community Member, 2 Posts

11 May 2010 at 12:12pm

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.

Avatar
youngmug

Community Member, 19 Posts

11 May 2010 at 3:02pm

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.

Avatar
dawnswebdesigns

Community Member, 2 Posts

11 May 2010 at 4:45pm

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