GNQA Search

ERROR

This error is not what we wanted to see. Unfortunately errors are part of all software systems and we need to resolve this together.

It is important to report this ERROR so we can fix it for everyone.

Report to the GeneNetwork team by recording the steps you take to reproduce this ERROR. Next to those steps, copy-paste below stack trace, either as a new issue or E-mail this full page to one of the developers directly.

(GeneNetwork error: (1054, "Unknown column 'CaseAttribute.CaseAttributeId' in 'field list'"))

    GeneNetwork 2.11-rc2 
    (1054, "Unknown column 'CaseAttribute.CaseAttributeId' in 'field list'") (error)
    
    
  

To check if this already a known issue, search the issue tracker.

Toggle full stack trace
      GeneNetwork 2.11-rc2  http://gn2-zach.genenetwork.org/show_trait?trait_id=rsm10000006649&dataset=BXDGeno (10:43AM UTC Apr 24, 2024) 
Traceback (most recent call last):
  File "/home/zas1024/opt/gn-latest-20240112/lib/python3.10/site-packages/flask/app.py", line 1523, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/zas1024/opt/gn-latest-20240112/lib/python3.10/site-packages/flask/app.py", line 1509, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
  File "/home/zas1024/gn2-zach/gene/gn2/wqflask/views.py", line 618, in show_trait_page
    }).either(with_flash_error(render_template("show_trait_error.html")),
  File "/home/zas1024/opt/gn-latest-20240112/lib/python3.10/site-packages/pymonad/either.py", line 89, in either
    return right_function(self.value)
  File "/home/zas1024/gn2-zach/gene/gn2/wqflask/views.py", line 597, in __show_trait__
    template_vars = show_trait.ShowTrait(cursor,
  File "/home/zas1024/gn2-zach/gene/gn2/wqflask/show_trait/show_trait.py", line 172, in __init__
    self.make_sample_lists()
  File "/home/zas1024/gn2-zach/gene/gn2/wqflask/show_trait/show_trait.py", line 520, in make_sample_lists
    primary_samples = SampleList(dataset=self.dataset,
  File "/home/zas1024/gn2-zach/gene/gn2/wqflask/show_trait/SampleList.py", line 28, in __init__
    self.get_attributes()
  File "/home/zas1024/gn2-zach/gene/gn2/wqflask/show_trait/SampleList.py", line 127, in get_attributes
    cursor.execute(
  File "/home/zas1024/opt/gn-latest-20240112/lib/python3.10/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/home/zas1024/opt/gn-latest-20240112/lib/python3.10/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/home/zas1024/opt/gn-latest-20240112/lib/python3.10/site-packages/MySQLdb/connections.py", line 259, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'CaseAttribute.CaseAttributeId' in 'field list'")