search

schmittjoh / JMSJobQueueBundle

Run and Schedule Symfony Console Commands as Background Jobs
http://jmsyst.com/bundles/JMSJobQueueBundle
334 stars 254 forks source link

doctrine/dbal v2.7.0 doctrine:schema:update issue #204

Closed gam6itko closed 3 years ago

gam6itko commented 6 years ago

After updating doctrine/dbal to version 2.7.0 execution of doctrine:schema:update failed with errors below

  [Doctrine\DBAL\Exception\DriverException]
  An exception occurred while executing 'ALTER TABLE jms_job_related_entities ADD CONSTRAINT FK_E956F4E2BE04EA9 FOREIGN KEY (job_id) REFERENCES  jms_jobs (id)':

  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

  [Doctrine\DBAL\Driver\PDOException]
  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

  [PDOException]
  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

Downgrade to v2.6.3 solves this problem.

Server: Localhost via UNIX socket Server type: MySQL Server version: 5.7.21 - MySQL Community Server (GPL) Protocol version: 10

Ydalb commented 6 years ago

Same problem here. Thanks for the tip.

dkorsak commented 6 years ago

+1

stephanvierkant commented 6 years ago

@dkorsak Don't place a comment like '+1' but use reactions instead, preferably on the referenced PR.