search

lotusbase / lotus.au.dk

Lotus Base website
https://lotus.au.dk
MIT License
2 stars 1 forks source link

MySQL syntax error when querying for expression data #93

Closed terrymun closed 5 years ago

terrymun commented 5 years ago

Submitter: Samantha Connolly Email: stconnol@uvm.edu Tried to search in Lotus Expression Atlas using a gene ID. Received the following error:

"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS RowID, GROUP_CONCAT(t2.ProbeID) AS MappedToID, t3.ProbeID AS MappedID, Mean_W' at line 2"

Thank you!!

terrymun commented 5 years ago

Issue fixed in #92, it was a simple typo when referencing the IDType key in returned results.