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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

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

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

installation problems


Go to End


2 Posts   2199 Views

Avatar
t-dog

Community Member, 1 Post

3 June 2010 at 8:01pm

Hi all,
I stumbled across Silverstripe whilst trying to find a straightforward CMS to use for creating simple CMS websites, i've tried Drupal, Joomla but i just can't get my head around those so hoping Silverstripe is the answer.

However i'm having problems with the installation, i get the following error but don't know how to correct, i hope someone can help

* Setting up 'mysite/_config.php'...
* Setting up /Applications/MAMP/htdocs/works/mysite/_config.php
* Setting up '.htaccess' file...
* Setting up /Applications/MAMP/htdocs/works/.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 /works/install.php

Line 536 in /Applications/MAMP/htdocs/works/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,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

Regards

Tony

Avatar
Sean

Forum Moderator, 922 Posts

3 June 2010 at 10:50pm

Hmm, I've never seen that happen before and I notice you're using MAMP. I've used MAMP plenty of times with SilverStripe with no problems.

Which version of MAMP are you using?

Have you tried installing before, and are you installing onto a database that already exists? This may be why MySQL complains.

Sean