From: Martin Gainty Date: March 23 2009 3:49pm Subject: RE: Error -1 List-Archive: http://lists.mysql.com/mysql/216847 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_87cef319-8d3c-49dd-8e83-d600e9a1867d_" --_87cef319-8d3c-49dd-8e83-d600e9a1867d_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable SELECT bunch_of_columns FROM bunch_of_tables WHERE MATCH (memos.note_text) AGAINST ('frog' IN NATURAL LANGUAGE MODE)=3B You may want to consider implementing lucene for search engine capability http://lucene.apache.org/java/docs/ ? Martin=20 ______________________________________________=20 Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality note= =20 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. This message is confidential and may be privileged. If you are not the inte= nded recipient=2C we kindly ask you to please inform the sender. Any unaut= horised dissemination or copying hereof is prohibited. This message serves = for information purposes only and shall not have any legally binding effect= . Given that e-mails can easily be subject to manipulation=2C we can not ac= cept any liability for the content provided. > From: jschwartz@stripped > To: wagnerbianchi@stripped > CC: mysql@stripped > Subject: RE: Error -1 > Date: Mon=2C 23 Mar 2009 10:26:36 -0400 >=20 >=20 >=20 > From: Wagner Bianchi [mailto:wagnerbianchi@stripped] > Sent: Monday=2C March 23=2C 2009 7:57 AM > To: Jerry Schwartz > Subject: Res: Error -1 >=20 > Hi friend=2C >=20 > You can use this=2C but=2C the -1 Error you got on the situation in you u= se InnoDB=20 > and it's crash. >=20 > [JS] I'm not using InnoDB for this table=2C it needs a full-text index so= it has=20 > to be MyISAM: >=20 > Create Table: CREATE TABLE `memos` ( > `note_id` int(11) NOT NULL AUTO_INCREMENT=2C > `customer_id` int(11) DEFAULT NULL=2C > `note_timestamp` datetime DEFAULT NULL=2C > `note_text` text=2C > PRIMARY KEY (`note_id`)=2C > KEY `customer_id` (`customer_id`)=2C > FULLTEXT KEY `note_text` (`note_text`) > ) ENGINE=3DMyISAM AUTO_INCREMENT=3D102353 DEFAULT CHARSET=3Dutf8 >=20 >=20 > Curious=2C somebody know more about this question? >=20 > Wagner Bianchi > Diretor de Tecnologia - INFODBA C&T > wagnerbianchi@stripped - (31) 3272 - 0226 / 9114 - 7695 >=20 >=20 >=20 > ________________________________________ > De: Jerry Schwartz > Para: MySql > Enviadas: S=E1bado=2C 21 de Mar=E7o de 2009 22:56:30 > Assunto: Error -1 >=20 > I'm running 5.1.31-community on WinXP. >=20 > I'm getting >=20 > ERROR 1030 (HY000): Got error -1 from storage engine >=20 > from the following query: >=20 >=20 > SELECT SQL_CALC_FOUND_ROWS customers.*=2C account.account_name=2C > account.real_name AS `Sales Rep`=2C stage.stage_name=2C memos.note_text A= S > m_note_text > FROM customers INNER JOIN account ON account.account_id =3D > customers.account_id > INNER JOIN stage ON customers.stage_id =3D stage.stage_id > LEFT JOIN memos ON customers.customer_id =3D memos.customer_id AND > (memos.note_id =3D (SELECT note_id FROM memos WHERE > memos.customer_id=3Dcustomers.customer_id >=20 > AND (MATCH(memos.note_text) AGAINST ("frog")) >=20 > ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT 0= =2C25=3B >=20 > If I take out the MATCH term=2C the query works just fine. >=20 > SELECT SQL_CALC_FOUND_ROWS customers.*=2C account.account_name=2C > account.real_name AS `Sales Rep`=2C stage.stage_name=2C memos.note_text A= S > m_note_text > FROM customers INNER JOIN account ON account.account_id =3D > customers.account_id > INNER JOIN stage ON customers.stage_id =3D stage.stage_id > LEFT JOIN memos ON customers.customer_id =3D memos.customer_id AND > (memos.note_id =3D (SELECT note_id FROM memos WHERE > memos.customer_id=3Dcustomers.customer_id > ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT 0= =2C25=3B >=20 > The error -1 isn't very helpful=2C does anyone have a clue? Perhaps I can= 't > use MATCH in a JOIN condition? >=20 >=20 > Regards=2C >=20 > Jerry Schwartz > The Infoshop by Global Information Incorporated > 195 Farmington Ave. > Farmington=2C CT 06032 >=20 > 860.674.8796 / FAX: 860.674.8341 >=20 > www.the-infoshop.com > www.giiexpress.com > www.etudes-marche.com >=20 >=20 >=20 >=20 >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:=20 > http://lists.mysql.com/mysql?unsub=3Dwagnerbianchi@stripped >=20 > ________________________________________ > Veja quais s=E3o os assuntos do momento no Yahoo! + Buscados: Top 10 -=20 > Celebridades - M=FAsica - Esportes >=20 >=20 >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 _________________________________________________________________ Get quick access to your favorite MSN content with Internet Explorer 8.=20 http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=3DB037= MSN55C0701A= --_87cef319-8d3c-49dd-8e83-d600e9a1867d_--