<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to Discussion</title><link href="https://sourceforge.net/p/mychem/discussion/" rel="alternate"/><link href="https://sourceforge.net/p/mychem/discussion/feed.atom" rel="self"/><id>https://sourceforge.net/p/mychem/discussion/</id><updated>2016-10-18T19:01:08.022000Z</updated><subtitle>Recent posts to Discussion</subtitle><entry><title>Tanimoto ordering of substructure search</title><link href="https://sourceforge.net/p/mychem/discussion/690593/thread/29d9dca0/" rel="alternate"/><published>2016-10-18T19:01:08.022000Z</published><updated>2016-10-18T19:01:08.022000Z</updated><author><name>Martin Morissette</name><uri>https://sourceforge.net/u/studur01/</uri></author><id>https://sourceforge.netcb8f5c64acfc23fa42f03b18197dff39a3ae941b</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi, I would need some help to create a SQL query that returns hits ordered on the tanimoto coefficient of the queried smiles and the fingerprints stored in the database. So far, I was able to set the sql variable as follow :&lt;/p&gt;
&lt;p&gt;SET @fp = (SELECT FINGERPRINT2(SMILES_TO_MOLECULE(‘smiles'))); &lt;/p&gt;
&lt;p&gt;Where the smiles is inserted with php from a JSME input&lt;/p&gt;
&lt;p&gt;Then I want to modify the current substructure search query :&lt;/p&gt;
&lt;p&gt;$query = "SELECT compounds.name AS No, pdt.fullname as Name FROM pdt,compounds,bin_structures WHERE pdt.name=compounds.name AND compounds.id=bin_structures.compound_id AND MATCH_SUBSTRUCT('".$_POST&lt;span&gt;['smiles']&lt;/span&gt;."',obserialized)";&lt;/p&gt;
&lt;p&gt;to compute the tanimoto of @fp and bin_structures.fp2&lt;/p&gt;
&lt;p&gt;Whenever I try to compute TANIMOTO(@fp, fp2) from bin_structures I get a NULL value.&lt;/p&gt;
&lt;p&gt;If I use two variables @fp1 and @fp2 and set these values with 2 different smiles fingerprints, I can compute the TANIMOTO(@fp1, @fp2).&lt;/p&gt;
&lt;p&gt;I use a LAMP stack on Ubuntu 14.04 64 bits. &lt;/p&gt;
&lt;p&gt;Any help is welcome&lt;/p&gt;
&lt;p&gt;Thank you&lt;/p&gt;
&lt;p&gt;Martin&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>mychem osx 10.10.5</title><link href="https://sourceforge.net/p/mychem/discussion/690593/thread/8bc13252/" rel="alternate"/><published>2016-04-01T12:25:29.740000Z</published><updated>2016-04-01T12:25:29.740000Z</updated><author><name>homa mohammadi</name><uri>https://sourceforge.net/u/hmpelta/</uri></author><id>https://sourceforge.net64d7d2fc2d9e4472f2921090808d682c1ccc10c1</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I have followed instructions to install mychem on my mac (OS X yosemite 10.10.5) but I was not successful .&lt;/p&gt;
&lt;p&gt;after typing this: mysql -u root -p &amp;lt; src/mychemdb_macosx.sql&lt;/p&gt;
&lt;p&gt;I get this error :ERROR 1126 (HY000) at line 10: Can't open shared library 'libmychem.dylib' (errno: 2 dlopen(/usr/local/Cellar/mysql56/5.6.29/lib/plugin/libmychem.dylib, 2): Symbol not found: __ZN9OpenBabel12OBDescriptor14GetStrin).&lt;/p&gt;
&lt;p&gt;i have tried with different version of mysql from 5.5 until 5.7.&lt;/p&gt;
&lt;p&gt;it is several days i am trying to solve problem …&lt;/p&gt;
&lt;p&gt;"make" command run successfully of course with one warning:&lt;/p&gt;
&lt;p&gt;&lt;span&gt;[  6%]&lt;/span&gt; Building CXX object src/CMakeFiles/mychem-lib.dir/conversion_wrapper.cpp.o&lt;/p&gt;
&lt;p&gt;In file included from /usr/local/src/mychem-code-master/src/conversion_wrapper.cpp:41:&lt;/p&gt;
&lt;p&gt;/usr/local/src/mychem-code-master/src/fingerprints/finger3.cpp:220:34: warning: &lt;/p&gt;
&lt;div class="codehilite"&gt;&lt;pre&gt;  unsequenced modification and access to 'div' [-Wunsequenced]

    ngrp = (num + div -1)/div--; //rounds up

                  ~~~        ^
&lt;/pre&gt;&lt;/div&gt;


&lt;p&gt;1 warning generated.&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>