>-----Original Message----- >From: Martin Gainty [mailto:mgai...@hotmail.com] >Sent: Monday, March 23, 2009 11:49 AM >To: Jerry Schwartz; wagnerbian...@yahoo.com.br >Cc: mysql@lists.mysql.com >Subject: RE: Error -1 > > > >SELECT bunch_of_columns FROM bunch_of_tables > WHERE MATCH (memos.note_text) > AGAINST ('frog' IN NATURAL LANGUAGE MODE); > [JS] That didn't make any difference, I still get Error -1. > >You may want to consider implementing lucene for search engine >capability >http://lucene.apache.org/java/docs/ > [JS] I have enough troubles right now :<( >? >Martin >______________________________________________ >Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality >note >Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene >Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede >unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. >Diese Nachricht dient lediglich dem Austausch von Informationen und >entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten >Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt >uebernehmen. >This message is confidential and may be privileged. If you are not the >intended recipient, we kindly ask you to please inform the sender. Any >unauthorised 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, we can not accept any liability for the content provided. > > > > > > >> From: jschwa...@the-infoshop.com >> To: wagnerbian...@yahoo.com.br >> CC: mysql@lists.mysql.com >> Subject: RE: Error -1 >> Date: Mon, 23 Mar 2009 10:26:36 -0400 >> >> >> >> From: Wagner Bianchi [mailto:wagnerbian...@yahoo.com.br] >> Sent: Monday, March 23, 2009 7:57 AM >> To: Jerry Schwartz >> Subject: Res: Error -1 >> >> Hi friend, >> >> You can use this, but, the -1 Error you got on the situation in you >use InnoDB >> and it's crash. >> >> [JS] I'm not using InnoDB for this table, it needs a full-text index >so it has >> to be MyISAM: >> >> Create Table: CREATE TABLE `memos` ( >> `note_id` int(11) NOT NULL AUTO_INCREMENT, >> `customer_id` int(11) DEFAULT NULL, >> `note_timestamp` datetime DEFAULT NULL, >> `note_text` text, >> PRIMARY KEY (`note_id`), >> KEY `customer_id` (`customer_id`), >> FULLTEXT KEY `note_text` (`note_text`) >> ) ENGINE=MyISAM AUTO_INCREMENT=102353 DEFAULT CHARSET=utf8 >> >> >> Curious, somebody know more about this question? >> >> Wagner Bianchi >> Diretor de Tecnologia - INFODBA C&T >> wagnerbian...@infodba.com.br - (31) 3272 - 0226 / 9114 - 7695 >> >> >> >> ________________________________________ >> De: Jerry Schwartz <jschwa...@the-infoshop.com> >> Para: MySql <mysql@lists.mysql.com> >> Enviadas: Sábado, 21 de Março de 2009 22:56:30 >> Assunto: Error -1 >> >> I'm running 5.1.31-community on WinXP. >> >> I'm getting >> >> ERROR 1030 (HY000): Got error -1 from storage engine >> >> from the following query: >> >> >> SELECT SQL_CALC_FOUND_ROWS customers.*, account.account_name, >> account.real_name AS `Sales Rep`, stage.stage_name, memos.note_text AS >> m_note_text >> FROM customers INNER JOIN account ON account.account_id = >> customers.account_id >> INNER JOIN stage ON customers.stage_id = stage.stage_id >> LEFT JOIN memos ON customers.customer_id = memos.customer_id AND >> (memos.note_id = (SELECT note_id FROM memos WHERE >> memos.customer_id=customers.customer_id >> >> AND (MATCH(memos.note_text) AGAINST ("frog")) >> >> ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT >0,25; >> >> If I take out the MATCH term, the query works just fine. >> >> SELECT SQL_CALC_FOUND_ROWS customers.*, account.account_name, >> account.real_name AS `Sales Rep`, stage.stage_name, memos.note_text AS >> m_note_text >> FROM customers INNER JOIN account ON account.account_id = >> customers.account_id >> INNER JOIN stage ON customers.stage_id = stage.stage_id >> LEFT JOIN memos ON customers.customer_id = memos.customer_id AND >> (memos.note_id = (SELECT note_id FROM memos WHERE >> memos.customer_id=customers.customer_id >> ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT >0,25; >> >> The error -1 isn't very helpful, does anyone have a clue? Perhaps I >can't >> use MATCH in a JOIN condition? >> >> >> Regards, >> >> Jerry Schwartz >> The Infoshop by Global Information Incorporated >> 195 Farmington Ave. >> Farmington, CT 06032 >> >> 860.674.8796 / FAX: 860.674.8341 >> >> www.the-infoshop.com >> www.giiexpress.com >> www.etudes-marche.com >> >> >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=wagnerbian...@yahoo.com.br >> >> ________________________________________ >> Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - >> Celebridades - Música - Esportes >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com >> > >_________________________________________________________________ >Get quick access to your favorite MSN content with Internet Explorer 8. >http://ie8.msn.com/microsoft/internet-explorer-8/en- >us/ie8.aspx?ocid=B037MSN55C0701A
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
