Bug #52430

Cannot convert from UUID to auto-increment ID

Added by Vladimir B almost 2 years ago.

Status:New Start date:2013-10-01
Priority:Should have Due date:
Assigned To:- % Done:

0%
Category:-
Target version:-
PHP Version: Complexity:
Has patch:No Affected Flow version:Flow 2.0.0

Description

Hi all

I think I found a bug - when I tried to convert a model to use an auto-increment ID instead of the UUID, the doctrine:update failed with message:

Uncaught Exception
An exception occurred while executing 'ALTER TABLE
mytable DROP persistence_object_identifier, CHANGE
id id INT AUTO_INCREMENT 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

More Information
Exception code #0
File /flow/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 47

Also available in: Atom PDF