Thanks very much for it. On Wednesday, 5 March 2014 08:53:42 UTC, Jàπ (Jasper N. Brouwer) wrote: > > Ahh, this problem arises when you already have a primary key in the table > and try to add an auto-incremented column. A workaround would be to drop > the existing primary key first. > > I suggest you take a look at Doctrine Migrations [1]. > > - Use the "migrations:diff" command which will generate a new > migration-version containing the sql that would be performed by > "orm:schema-tool:update". > - Change the SQL statements in that migration-version to fix your problem. > - Run the migration-version. > > Once the migration-version functions correctly, it can be safely used on > other databases (other developers, production, etc). > > [1]: http://www.doctrine-project.org/projects/migrations.html > > -- > Jasper N. Brouwer > (@jaspernbrouwer) > > > On 5 Mar 2014, at 01:59, janul <[email protected] <javascript:>> > wrote: > > > hi, > > Thanks for you reply: > > > > This what I get: > > -------------------- > > > > > > [Doctrine\DBAL\DBALException] > > > > An exception occurred while executing 'ALTER TABLE group_members ADD > id INT AUTO_INCREMENT NOT NULL, ADD joinstate INT NOT NULL, ADD isdisabled > TINYINT(1) NOT NULL, > > ADD isbanned TINYINT(1) NOT NULL': > > > > > > > > SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect > table definition; there can be only one auto column and it must be defined > as a key > > ------------------- > > I use mysql.. > > in entity definition I have also added: > > @Table(name="group_members", > uniqueConstraints={@UniqueConstraint(name="memberspair_idx", > columns={"user_id", "group_id"})}) > > > > Thanks in advance. > > -- > > Jnl > >
-- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
