search

MatsDahlberg / clinicalDB

0 stars 0 forks source link

Other Families (8084) #42

Closed robinandeer closed 10 years ago

robinandeer commented 10 years ago

http://localhost:8083/api/v1/other_families?variant_id=40906100

Ger error:

Traceback (most recent call last):  File "/home/scout/scoutApp/lib/python2.7/site-packages/tornado/web.py", line 1220, in _when_complete    callback()  File "/home/scout/scoutApp/lib/python2.7/site-packages/tornado/web.py", line 1241, in _execute_method    self._when_complete(method(*self.path_args, **self.path_kwargs),  File "/home/scout/scoutApp/clinicalDB_dev/clinic.py", line 211, in get    tLoc = db.query(sSql, variant)  File "/home/scout/scoutApp/lib/python2.7/site-packages/torndb.py", line 132, in query    self._execute(cursor, query, parameters, kwparameters)  File "/home/scout/scoutApp/lib/python2.7/site-packages/torndb.py", line 226, in _execute    return cursor.execute(query, kwparameters or parameters)  File "/home/scout/scoutApp/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute    self.errorhandler(self, exc, value)  File "/home/scout/scoutApp/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler    raise errorclass, errorvalueOperationalError: (1052, "Column 'pk' in field list is ambiguous")
MatsDahlberg commented 10 years ago

Ska vara fixat nu.

robinandeer commented 10 years ago

Det verkar stämma! Tack.

robinandeer commented 10 years ago

Förresten upptäckte jag ett liknande problem för

variants/40912391

Traceback (most recent call last): File "/home/scout/scoutApp/lib/python2.7/site-packages/tornado/web.py", line 1220, in _when_complete callback() File "/home/scout/scoutApp/lib/python2.7/site-packages/tornado/web.py", line 1241, in _execute_method self._when_complete(method(*self.path_args, **self.path_kwargs), File "/home/scout/scoutApp/clinicalDB_dev/clinic.py", line 300, in get tOtherVariants = db.query(sSql) File "/home/scout/scoutApp/lib/python2.7/site-packages/torndb.py", line 132, in query self._execute(cursor, query, parameters, kwparameters) File "/home/scout/scoutApp/lib/python2.7/site-packages/torndb.py", line 226, in _execute return cursor.execute(query, kwparameters or parameters) File "/home/scout/scoutApp/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/scout/scoutApp/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalueOperationalError: (1052, "Column 'pk' in field list is ambiguous")

MatsDahlberg commented 10 years ago

Ska oxå vara fixat nu.

robinandeer commented 10 years ago

Perfect