search

statonlab / tripal_hq

provides a user and administrative dashboard for Chado content creation
GNU General Public License v3.0
2 stars 0 forks source link

user site unable to submit organisms for content modified by Drupal Features module #109

Open bradfordcondon opened 5 years ago

bradfordcondon commented 5 years ago 
```PDOException: SQLSTATE[23503]: Foreign key violation: 7 ERROR: insert or update on table "organism" violates foreign key constraint "organism_type_id_fkey" DETAIL: Key (type_id)=(0) is not present in table "cvterm".: INSERT INTO chado.organism (species, genus, common_name, abbreviation, type_id, infraspecific_name, comment) VALUES (:species, :genus, :common_name, :abbreviation, :type_id, :infraspecific_name, NULL); Array ( [:species] => balteatus [:genus] => Bombus [:common_name] => bee [:abbreviation] => B. stuff [:type_id] => 0 [:infraspecific_name] => ) in chado_query() (line 1720 of /app/tripal3/drupal7/sites/all/modules/contrib/tripal/tripal_chado/api/tripal_chado.query.api.inc).```

user is reporting this error. the type_id is set to 0 instead of null for some reason. I examined the serialized record and it appears to be null, not 0.

bradfordcondon commented 5 years ago

i confirmed this was due to something with the features module exporting content configuration. Beyond that I can't put my finger on it. For now ,be warned: using hte drupal features module to export configurations might break compatibility with this module.