Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

quartz_chem/add_split_weights: Integrity constraint violation #7

Closed
zploskey opened this issue Mar 11, 2017 · 1 comment
Closed

quartz_chem/add_split_weights: Integrity constraint violation #7

zploskey opened this issue Mar 11, 2017 · 1 comment
Assignees
@zploskey
Labels
bug
Milestone
v1.2

Comments

@zploskey
Copy link
Owner

An uncaught Exception was encountered

Type: Doctrine_Connection_Mysql_Exception

Message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (chemdb.split, CONSTRAINT split_split_bkr_id_split_bkr_id FOREIGN KEY (split_bkr_id) REFERENCES split_bkr (id))

Filename: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection.php

Line Number: 1090

Backtrace:

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection/Statement.php
Line: 284
Function: rethrowException

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection.php
Line: 1050
Function: execute

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection.php
Line: 695
Function: exec

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection/UnitOfWork.php
Line: 647
Function: insert

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection/UnitOfWork.php
Line: 571
Function: processSingleInsert

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection/UnitOfWork.php
Line: 81
Function: insert

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Record.php
Line: 1718
Function: saveGraph

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Collection.php
Line: 922
Function: save

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection/UnitOfWork.php
Line: 136
Function: save

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Record.php
Line: 1718
Function: saveGraph

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Collection.php
Line: 922
Function: save

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Connection/UnitOfWork.php
Line: 136
Function: save

File: /home/zach/public_html/chemdb/vendor/lexpress/doctrine1/lib/Doctrine/Record.php
Line: 1718
Function: saveGraph

File: /home/zach/public_html/chemdb/app/controllers/Quartz_chem.php
Line: 522
Function: save

File: /home/zach/public_html/chemdb/index.php
Line: 294
Function: require_once
@zploskey zploskey added the bug label Mar 11, 2017
@zploskey zploskey added this to the v1.2 milestone Mar 11, 2017
@zploskey zploskey self-assigned this Mar 11, 2017
@zploskey
Copy link
Owner Author

This was probably not encountered before because existing installs were set up using MyISAM tables which do not support foreign key constraints.

zploskey added a commit that referenced this issue Sep 1, 2017
@zploskey
Allow split.split_bkr_id to be null, migr. 32
a9c9916 
Not allowing split_bkr_id to be null resulted in an integrity
constraint violation in quartz_chem/add_split_weights.

Fixes #7.

Introduces migration number 32.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zploskey zploskey

Labels
bug
Projects
None yet
Milestone
v1.2
Development

No branches or pull requests
1 participant
@zploskey