<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to bugs</title><link href="https://sourceforge.net/p/mychem/bugs/" rel="alternate"/><link href="https://sourceforge.net/p/mychem/bugs/feed.atom" rel="self"/><id>https://sourceforge.net/p/mychem/bugs/</id><updated>2015-01-25T21:31:37.313000Z</updated><subtitle>Recent changes to bugs</subtitle><entry><title>#15 null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/?limit=25#7294" rel="alternate"/><published>2015-01-25T21:31:37.313000Z</published><updated>2015-01-25T21:31:37.313000Z</updated><author><name>Jerome Pansanel</name><uri>https://sourceforge.net/u/pansanel/</uri></author><id>https://sourceforge.net99f06b29effaa95aa7c0d612324701591278cc62</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;: accepted --&amp;gt; closed-fixed&lt;/li&gt;
&lt;/ul&gt;&lt;/div&gt;</summary></entry><entry><title>#15 null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/?limit=25#3319" rel="alternate"/><published>2015-01-25T21:31:10.526000Z</published><updated>2015-01-25T21:31:10.526000Z</updated><author><name>Jerome Pansanel</name><uri>https://sourceforge.net/u/pansanel/</uri></author><id>https://sourceforge.net253e1af3e907667b789121915473c9308d4ecf17</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;The fix has been released in Mychem v0.9.2&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#15 null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/?limit=25#fa54" rel="alternate"/><published>2014-09-13T06:08:51.995000Z</published><updated>2014-09-13T06:08:51.995000Z</updated><author><name>Jerome Pansanel</name><uri>https://sourceforge.net/u/pansanel/</uri></author><id>https://sourceforge.net64829a6d6ddaa9cda34b47574d5843f464447ead</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;Can you replace your current molmatch.c file with this replacement and tell me if it works better (it shoud, it test this fix). If it works are requested, I will release a new version of Mychem within the next week.&lt;/p&gt;
&lt;p&gt;Cheers,&lt;/p&gt;
&lt;p&gt;Jerome&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#15 null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/?limit=25#9ad6/02e3" rel="alternate"/><published>2014-07-09T11:26:35.257000Z</published><updated>2014-07-09T11:26:35.257000Z</updated><author><name>sigsm</name><uri>https://sourceforge.net/u/ssmarason/</uri></author><id>https://sourceforge.netfc0050c8430bf5c76946eaa400b6b28399ad32f7</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;br /&gt;
The table structures and the query were taken verbatim from the examples in the handbook. The 3D_structure table had entries of an empty string that resulted in a NULL entry into the bin_structure for obserialized when populated.&lt;br /&gt;
But in case it helps the exported structures from my database and the query that crashed  are pasted in below.&lt;br /&gt;
best,&lt;br /&gt;
Siggi&lt;/p&gt;
&lt;p&gt;--&lt;br /&gt;
-- Table structure for table &lt;code&gt;compounds&lt;/code&gt;&lt;br /&gt;
--&lt;/p&gt;
&lt;p&gt;CREATE TABLE IF NOT EXISTS &lt;code&gt;compounds&lt;/code&gt; (&lt;br /&gt;
&lt;code&gt;id&lt;/code&gt; int(11) unsigned NOT NULL AUTO_INCREMENT,&lt;br /&gt;
&lt;code&gt;name&lt;/code&gt; varchar(255) COLLATE utf8_bin NOT NULL,&lt;br /&gt;
&lt;code&gt;created&lt;/code&gt; timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,&lt;br /&gt;
&lt;code&gt;modified&lt;/code&gt; timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',&lt;br /&gt;
  PRIMARY KEY (&lt;code&gt;id&lt;/code&gt;),&lt;br /&gt;
  UNIQUE KEY &lt;code&gt;name&lt;/code&gt; (&lt;code&gt;name&lt;/code&gt;)&lt;br /&gt;
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Compound Library' AUTO_INCREMENT=40445 ;&lt;/p&gt;
&lt;p&gt;--&lt;br /&gt;
-- Table structure for table &lt;code&gt;3D_structures&lt;/code&gt;&lt;br /&gt;
--&lt;/p&gt;
&lt;p&gt;CREATE TABLE IF NOT EXISTS &lt;code&gt;3D_structures&lt;/code&gt; (&lt;br /&gt;
&lt;code&gt;compound_id&lt;/code&gt; int(11) unsigned NOT NULL,&lt;br /&gt;
&lt;code&gt;molfile&lt;/code&gt; text COLLATE utf8_bin NOT NULL,&lt;br /&gt;
  PRIMARY KEY (&lt;code&gt;compound_id&lt;/code&gt;)&lt;br /&gt;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Compound 3D Structures';&lt;/p&gt;
&lt;p&gt;--&lt;br /&gt;
-- Table structure for table &lt;code&gt;bin_structures&lt;/code&gt;&lt;br /&gt;
--&lt;/p&gt;
&lt;p&gt;CREATE TABLE IF NOT EXISTS &lt;code&gt;bin_structures&lt;/code&gt; (&lt;br /&gt;
&lt;code&gt;compound_id&lt;/code&gt; int(11) unsigned NOT NULL,&lt;br /&gt;
&lt;code&gt;fp2&lt;/code&gt; blob,&lt;br /&gt;
&lt;code&gt;obserialized&lt;/code&gt; blob,&lt;br /&gt;
  PRIMARY KEY (&lt;code&gt;compound_id&lt;/code&gt;),&lt;br /&gt;
  UNIQUE KEY &lt;code&gt;compound_id&lt;/code&gt; (&lt;code&gt;compound_id&lt;/code&gt;)&lt;br /&gt;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Compound Binary Structures';&lt;/p&gt;
&lt;p&gt;--&lt;br /&gt;
-- Insertion of data into the &lt;code&gt;bin_structures&lt;/code&gt; table&lt;br /&gt;
-- &lt;br /&gt;
--&lt;br /&gt;
INSERT INTO &lt;code&gt;bin_structures&lt;/code&gt; (&lt;code&gt;compound_id&lt;/code&gt;,&lt;code&gt;fp2&lt;/code&gt;,&lt;code&gt;obserialized&lt;/code&gt;)&lt;br /&gt;
SELECT &lt;code&gt;compound_id&lt;/code&gt;, FINGERPRINT2(&lt;code&gt;molfile&lt;/code&gt;),&lt;br /&gt;
MOLECULE_TO_SERIALIZEDOBMOL(&lt;code&gt;molfile&lt;/code&gt;) FROM &lt;code&gt;3D_structures&lt;/code&gt;;&lt;/p&gt;
&lt;p&gt;--&lt;br /&gt;
-- Query that crashes if there are NULL values in bin_structures&lt;br /&gt;
--&lt;br /&gt;
SELECT &lt;code&gt;compounds&lt;/code&gt;.&lt;code&gt;name&lt;/code&gt;&lt;br /&gt;
FROM &lt;code&gt;compounds&lt;/code&gt;,&lt;code&gt;bin_structures&lt;/code&gt;&lt;br /&gt;
WHERE &lt;code&gt;compounds&lt;/code&gt;.&lt;code&gt;id&lt;/code&gt;=&lt;code&gt;bin_structures&lt;/code&gt;.&lt;code&gt;compound_id&lt;/code&gt;&lt;br /&gt;
AND MATCH_SUBSTRUCT('&lt;span&gt;[OH]&lt;/span&gt;c1ccccc1',&lt;code&gt;obserialized&lt;/code&gt;);&lt;br /&gt;
LIMIT 10;&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#15 null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/?limit=25#86bd" rel="alternate"/><published>2014-07-09T08:01:33.425000Z</published><updated>2014-07-09T08:01:33.425000Z</updated><author><name>Jerome Pansanel</name><uri>https://sourceforge.net/u/pansanel/</uri></author><id>https://sourceforge.netcacd44d2447872f361ed1fdedb032259efad9953</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;: unread --&amp;gt; accepted&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;assigned_to&lt;/strong&gt;: Jerome Pansanel&lt;/li&gt;
&lt;/ul&gt;&lt;/div&gt;</summary></entry><entry><title>#15 null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/?limit=25#9ad6" rel="alternate"/><published>2014-07-09T08:01:16.270000Z</published><updated>2014-07-09T08:01:16.270000Z</updated><author><name>Jerome Pansanel</name><uri>https://sourceforge.net/u/pansanel/</uri></author><id>https://sourceforge.netecb58abde14dc51aa0b2045140ab71f519e9d134</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;Yes, it may be a bug. I should add a check on the data type before to do any match substruct test. Can you send be the table structures (I don't need any data) of your database and the query you did?&lt;/p&gt;
&lt;p&gt;Cheers,&lt;/p&gt;
&lt;p&gt;Jerome&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/" rel="alternate"/><published>2014-06-17T12:56:44.681000Z</published><updated>2014-06-17T12:56:44.681000Z</updated><author><name>sigsm</name><uri>https://sourceforge.net/u/ssmarason/</uri></author><id>https://sourceforge.net19bc4806bf86ec864ef63f492868d71b584af05e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;This happened to me, but I don't know if this is repeatable. I had some 40K+ entries in a database and did a substructure search via MATCH_SUBSTRUCT. The search kept crashing the database although it recovered (in effect resetting the connection). Tried a few things but in the end if I excluded (via sql) the entries with Null value in the column used for the reference_obmol blob it stopped crashing. Can someone verify this or is this is already known perhaps?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/" rel="alternate"/><published>2014-06-17T12:56:44.681000Z</published><updated>2014-06-17T12:56:44.681000Z</updated><author><name>sigsm</name><uri>https://sourceforge.net/u/ssmarason/</uri></author><id>https://sourceforge.net917beaba79d35114541fc3ca180c4ef42cce21c5</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Ticket 15 has been modified: null value passed to MATCH_SUBSTRUCT crashes the database&lt;br /&gt;
Edited By: Jerome Pansanel (pansanel)&lt;br /&gt;
Status updated: u'unread' =&amp;gt; u'accepted'&lt;br /&gt;
Owner updated: None =&amp;gt; u'pansanel'&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>null value passed to MATCH_SUBSTRUCT crashes the database</title><link href="https://sourceforge.net/p/mychem/bugs/15/" rel="alternate"/><published>2014-06-17T12:56:44.681000Z</published><updated>2014-06-17T12:56:44.681000Z</updated><author><name>sigsm</name><uri>https://sourceforge.net/u/ssmarason/</uri></author><id>https://sourceforge.netbcb5e587c51b7c7bb0d119e80144ee153879efcd</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Ticket 15 has been modified: null value passed to MATCH_SUBSTRUCT crashes the database&lt;br /&gt;
Edited By: Jerome Pansanel (pansanel)&lt;br /&gt;
Status updated: u'accepted' =&amp;gt; u'closed-fixed'&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>all functions return null</title><link href="https://sourceforge.net/p/mychem/bugs/14/" rel="alternate"/><published>2012-04-13T01:24:34Z</published><updated>2012-04-13T01:24:34Z</updated><author><name>jiohua</name><uri>https://sourceforge.net/u/jiohua/</uri></author><id>https://sourceforge.net6743f2a40de4575197a47559b783013944148f8f</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;br /&gt;
I got this problem with the new version. I tried to stop apparmor but still do not work.&lt;/p&gt;
&lt;p&gt;mysql&amp;gt; select version(), mychem_version(), openbabel_version();&lt;br /&gt;
+-----------------+------------------+---------------------+&lt;br /&gt;
| version()       | mychem_version() | openbabel_version() |&lt;br /&gt;
+-----------------+------------------+---------------------+&lt;br /&gt;
| 5.1.58-1ubuntu1 | 0.9.1            | 2.3.1               |&lt;br /&gt;
+-----------------+------------------+---------------------+&lt;br /&gt;
1 row in set (0.00 sec)&lt;/p&gt;
&lt;p&gt;mysql&amp;gt; select smiles_to_molecule('c1ccccc1');&lt;br /&gt;
+--------------------------------+&lt;br /&gt;
| smiles_to_molecule('c1ccccc1') |&lt;br /&gt;
+--------------------------------+&lt;br /&gt;
| NULL                           |&lt;br /&gt;
+--------------------------------+&lt;br /&gt;
1 row in set (0.01 sec)&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>