Bug #52430

Cannot convert from UUID to auto-increment ID

Added by Vladimir B about 8 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2013-10-01
Due date:
% Done:

0%

Estimated time:
PHP Version:
Has patch:
No
Complexity:

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

No data to display

Also available in: Atom PDF