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.