{"action":"created","issue":{"url":"https://api.github.com/repos/statonlab/hardwoods_site/issues/289","repository_url":"https://api.github.com/repos/statonlab/hardwoods_site","labels_url":"https://api.github.com/repos/statonlab/hardwoods_site/issues/289/labels{/name}","comments_url":"https://api.github.com/repos/statonlab/hardwoods_site/issues/289/comments","events_url":"https://api.github.com/repos/statonlab/hardwoods_site/issues/289/events","html_url":"https://github.com/statonlab/hardwoods_site/issues/289","id":328145171,"node_id":"MDU6SXNzdWUzMjgxNDUxNzE=","number":289,"title":"publications linking sql error","user":{"login":"bradfordcondon","id":7063154,"node_id":"MDQ6VXNlcjcwNjMxNTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/7063154?v=4","gravatar_id":"","url":"https://api.github.com/users/bradfordcondon","html_url":"https://github.com/bradfordcondon","followers_url":"https://api.github.com/users/bradfordcondon/followers","following_url":"https://api.github.com/users/bradfordcondon/following{/other_user}","gists_url":"https://api.github.com/users/bradfordcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/bradfordcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradfordcondon/subscriptions","organizations_url":"https://api.github.com/users/bradfordcondon/orgs","repos_url":"https://api.github.com/users/bradfordcondon/repos","events_url":"https://api.github.com/users/bradfordcondon/events{/privacy}","received_events_url":"https://api.github.com/users/bradfordcondon/received_events","type":"User","site_admin":false},"labels":[{"id":457040284,"node_id":"MDU6TGFiZWw0NTcwNDAyODQ=","url":"https://api.github.com/repos/statonlab/hardwoods_site/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":{"login":"bradfordcondon","id":7063154,"node_id":"MDQ6VXNlcjcwNjMxNTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/7063154?v=4","gravatar_id":"","url":"https://api.github.com/users/bradfordcondon","html_url":"https://github.com/bradfordcondon","followers_url":"https://api.github.com/users/bradfordcondon/followers","following_url":"https://api.github.com/users/bradfordcondon/following{/other_user}","gists_url":"https://api.github.com/users/bradfordcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/bradfordcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradfordcondon/subscriptions","organizations_url":"https://api.github.com/users/bradfordcondon/orgs","repos_url":"https://api.github.com/users/bradfordcondon/repos","events_url":"https://api.github.com/users/bradfordcondon/events{/privacy}","received_events_url":"https://api.github.com/users/bradfordcondon/received_events","type":"User","site_admin":false},"assignees":[{"login":"bradfordcondon","id":7063154,"node_id":"MDQ6VXNlcjcwNjMxNTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/7063154?v=4","gravatar_id":"","url":"https://api.github.com/users/bradfordcondon","html_url":"https://github.com/bradfordcondon","followers_url":"https://api.github.com/users/bradfordcondon/followers","following_url":"https://api.github.com/users/bradfordcondon/following{/other_user}","gists_url":"https://api.github.com/users/bradfordcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/bradfordcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradfordcondon/subscriptions","organizations_url":"https://api.github.com/users/bradfordcondon/orgs","repos_url":"https://api.github.com/users/bradfordcondon/repos","events_url":"https://api.github.com/users/bradfordcondon/events{/privacy}","received_events_url":"https://api.github.com/users/bradfordcondon/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-05-31T13:45:50Z","updated_at":"2018-06-05T14:37:28Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"<!--\r\nPlease include a direct link to the page on HWG (dev or live is fine)\r\nwhere your feature request or bug report is found.\r\n-->\r\n\r\nWhen attemping to link publications to maps:\r\n\r\n```\r\nCould not save the entity: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block\r\nCannot save entity\r\n```\r\n\r\ni dont think we have this dev, so updating tripal might be enough."},"comment":{"url":"https://api.github.com/repos/statonlab/hardwoods_site/issues/comments/394734057","html_url":"https://github.com/statonlab/hardwoods_site/issues/289#issuecomment-394734057","issue_url":"https://api.github.com/repos/statonlab/hardwoods_site/issues/289","id":394734057,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NDczNDA1Nw==","user":{"login":"bradfordcondon","id":7063154,"node_id":"MDQ6VXNlcjcwNjMxNTQ=","avatar_url":"https://avatars2.githubusercontent.com/u/7063154?v=4","gravatar_id":"","url":"https://api.github.com/users/bradfordcondon","html_url":"https://github.com/bradfordcondon","followers_url":"https://api.github.com/users/bradfordcondon/followers","following_url":"https://api.github.com/users/bradfordcondon/following{/other_user}","gists_url":"https://api.github.com/users/bradfordcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/bradfordcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradfordcondon/subscriptions","organizations_url":"https://api.github.com/users/bradfordcondon/orgs","repos_url":"https://api.github.com/users/bradfordcondon/repos","events_url":"https://api.github.com/users/bradfordcondon/events{/privacy}","received_events_url":"https://api.github.com/users/bradfordcondon/received_events","type":"User","site_admin":false},"created_at":"2018-06-05T14:37:28Z","updated_at":"2018-06-05T14:37:28Z","author_association":"CONTRIBUTOR","body":"no real error message and not happening on other sites, so i dont know whats going on here.\r\n\r\n```\r\nhardwoods_06012018=> select featuremap_id, name  from chado.featuremap;\r\n1\tChinese Chestnut genetic map\r\n2\tChinese Chestnut physical map\r\nhardwoods_06012018=>\r\n```\r\n```\r\nselect pub_id, title from chado.pub;\r\n1\r\n3\tA transcriptome-based genetic map of Chinese chestnut (Castanea mollissima) and identification of regions of segmental homology with peach (Prunus persica)\r\n4\tA physical map of the Chinese chestnut (Castanea mollissima) genome and its integration with the genetic map\r\n```\r\n\r\n`INSERT into chado.featuremap_pub (featuremap_id, pub_id) VALUES (2, 3);`\r\n\r\nridiculous workaround, need to resolve this...\r\n"}}
{"actor":{"display_login":"bradfordcondon"}}