{"action":"created","issue":{"url":"https://api.github.com/repos/biocore/qiita/issues/1122","labels_url":"https://api.github.com/repos/biocore/qiita/issues/1122/labels{/name}","comments_url":"https://api.github.com/repos/biocore/qiita/issues/1122/comments","events_url":"https://api.github.com/repos/biocore/qiita/issues/1122/events","html_url":"https://github.com/biocore/qiita/pull/1122","id":71781396,"number":1122,"title":"Merge relax-md-req into master","user":{"login":"ElDeveloper","id":375307,"avatar_url":"https://avatars.githubusercontent.com/u/375307?v=3","gravatar_id":"","url":"https://api.github.com/users/ElDeveloper","html_url":"https://github.com/ElDeveloper","followers_url":"https://api.github.com/users/ElDeveloper/followers","following_url":"https://api.github.com/users/ElDeveloper/following{/other_user}","gists_url":"https://api.github.com/users/ElDeveloper/gists{/gist_id}","starred_url":"https://api.github.com/users/ElDeveloper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ElDeveloper/subscriptions","organizations_url":"https://api.github.com/users/ElDeveloper/orgs","repos_url":"https://api.github.com/users/ElDeveloper/repos","events_url":"https://api.github.com/users/ElDeveloper/events{/privacy}","received_events_url":"https://api.github.com/users/ElDeveloper/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-29T05:21:17Z","updated_at":"2015-04-29T14:49:35Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/biocore/qiita/pulls/1122","html_url":"https://github.com/biocore/qiita/pull/1122","diff_url":"https://github.com/biocore/qiita/pull/1122.diff","patch_url":"https://github.com/biocore/qiita/pull/1122.patch"},"body":""},"comment":{"url":"https://api.github.com/repos/biocore/qiita/issues/comments/97454320","html_url":"https://github.com/biocore/qiita/pull/1122#issuecomment-97454320","issue_url":"https://api.github.com/repos/biocore/qiita/issues/1122","id":97454320,"user":{"login":"antgonza","id":2014559,"avatar_url":"https://avatars.githubusercontent.com/u/2014559?v=3","gravatar_id":"","url":"https://api.github.com/users/antgonza","html_url":"https://github.com/antgonza","followers_url":"https://api.github.com/users/antgonza/followers","following_url":"https://api.github.com/users/antgonza/following{/other_user}","gists_url":"https://api.github.com/users/antgonza/gists{/gist_id}","starred_url":"https://api.github.com/users/antgonza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/antgonza/subscriptions","organizations_url":"https://api.github.com/users/antgonza/orgs","repos_url":"https://api.github.com/users/antgonza/repos","events_url":"https://api.github.com/users/antgonza/events{/privacy}","received_events_url":"https://api.github.com/users/antgonza/received_events","type":"User","site_admin":false},"created_at":"2015-04-29T14:49:35Z","updated_at":"2015-04-29T14:49:35Z","body":"The last reported errors are due to inconsistencies in my local DB due to tests while writing the delete functions.\r\n\r\nAnyway, now I'm getting this and I'm almost certain that is an actual bug.\r\n```\r\nTraceback (most recent call last):\r\n  File \"qiita_db/support_files/patches/python_patches/23.py\", line 14, in <module>\r\n    SampleTemplate(s_id).generate_files()\r\n  File \"/Users/antoniog/svn_programs/qiita/qiita_db/metadata_template/sample_template.py\", line 201, in generate_files\r\n    self.to_file(fp)\r\n  File \"/Users/antoniog/svn_programs/qiita/qiita_db/metadata_template/base_metadata_template.py\", line 994, in to_file\r\n    df = self.to_dataframe()\r\n  File \"/Users/antoniog/svn_programs/qiita/qiita_db/metadata_template/base_metadata_template.py\", line 1024, in to_dataframe\r\n    meta = conn_handler.execute_fetchall(sql, (self._id,))\r\n  File \"/Users/antoniog/svn_programs/qiita/qiita_db/sql_connection.py\", line 454, in execute_fetchall\r\n    with self._sql_executor(sql, sql_args) as pgcursor:\r\n  File \"/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/contextlib.py\", line 17, in __enter__\r\n    return self.gen.next()\r\n  File \"/Users/antoniog/svn_programs/qiita/qiita_db/sql_connection.py\", line 303, in _sql_executor\r\n    (sql, str(sql_args), e)))\r\nqiita_db.exceptions.QiitaDBExecutionError: \r\nError running SQL query: SELECT abx_past_6_mos, age, age_in_years, age_unit, altitude, anatomical_sample_site, anonymized_name, assigned_from_geo, atherosclerosis, barcode_read_group_tag, barcodesequence, bmi_185_249, bmi_25_299, bmi_30_349, bmi_35_399, bmi_greater_40, bmi_less_184, body_habitat, body_mass_index, body_product, body_site, chronic_condition, clinical_condition, collectday, collection_date, collection_timestamp, common_name, common_sample_site, contaminated, country, delivery_method, depth, description, description_duplicate, dna_extracted, elevation, env_biome, env_feature, env_matter, experiment_alias, experiment_center, experiment_design_description, family_relationship, flxdata_published, gender, hiv, hmpbodysubsite, hmpbodysupersite, host_common_name, host_individual, host_subject_id, host_taxid, hypertension, includes_timeseries, intph, investigation_type, key_seq, lab_person, lab_person_contact, latitude, library_construction_protocol, linkerprimersequence, longitude, miens_compliant, mislabeled, months_without_antibiotics, myocardinfarct, newilluminadatagenerated, nucl_acid_amp, nucl_acid_ext, obesity, original_sample_site, pcr_cond, pcr_primers, pfph, physical_specimen_location, physical_specimen_remaining, platform, pmid, pool_member_accession, pool_member_name, pool_proportion, primer_read_group_tag, principal_investigator, project_name, psn, region, required_sample_info_status, reverseprimer, run, run_alias, run_center, run_date, run_lane, run_prefix, samp_collect_device, samp_size, sample_center, sample_id, sample_type, sequencing_meth, sex, smoker, specific_body_site, srs, study_abstract, study_id, study_ref, url, visitno\r\n                 FROM qiita.study_sample\r\n                 JOIN qiita.sample_850 USING (sample_id)\r\n                 WHERE study_id = %s\r\nARGS: (850L,)\r\nError: column reference \"study_id\" is ambiguous\r\nLINE 1: ... smoker, specific_body_site, srs, study_abstract, study_id, ...\r\n                                                             ^\r\n```"}}