4571 Posts in 1382 Topics by 1376 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1298 Views |
-
Installing on myhosting.com

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.phpWith 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.
-
Re: Installing on myhosting.com

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.
-
Re: Installing on myhosting.com

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.
| 1298 Views | ||
|
Page:
1
|
Go to Top |

