Nichols Data browser

[sandyl27]

When I clicked the radio button Correlations among strains and searched ygeQ

I got

Database error
A database query error has occurred. This may indicate a bug in the software.

SELECT * FROM chemgen.strain_cc WHERE (strain IN ('ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'')) ORDER BY correlation_coefficient desc

Function: EcoliSpecialpage::doRequest
Error: 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 'ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','ECK2858-YGEQ'','' at line 1 (localhost)

[dsiegele]

I didn't get this error when I selected the radio button 'Correlations among strains' and searched for either ygeQ or ECK2859. 10:15 pm CDT.

[sandyl27]

Jim was working on it yesterday and may have fixed it.
Also, this is on OMP and when I did it again this morning, it is still getting an error.
@jimhu-tamu

[jimhu-tamu]

Fixed by escaping the single quotes for primes. Not ideal, but couldn't figure out how to get a mysqli connection object from within the MW code.

[dsiegele]

For most, if not all of the the gene names that have a single quote, such as ypjC', I don't know any reason for the quote to be there. I will double check the list and maybe we can eliminate all of them.