List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:March 23 2009 3:49pm
Subject:RE: Error -1
View as plain text  

SELECT bunch_of_columns FROM bunch_of_tables
     WHERE MATCH (memos.note_text)
    AGAINST ('frog' IN NATURAL LANGUAGE MODE);


You may want to consider implementing lucene for search engine capability
http://lucene.apache.org/java/docs/

?
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: jschwartz@stripped
> To: wagnerbianchi@stripped
> CC: mysql@stripped
> Subject: RE: Error -1
> Date: Mon, 23 Mar 2009 10:26:36 -0400
> 
> 
> 
> From: Wagner Bianchi [mailto:wagnerbianchi@stripped]
> 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
> wagnerbianchi@stripped - (31) 3272 - 0226 / 9114 - 7695
> 
> 
> 
> ________________________________________
> De: Jerry Schwartz <jschwartz@stripped>
> Para: MySql <mysql@stripped>
> 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=1
> 
> ________________________________________
> 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=1
> 

_________________________________________________________________
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
Thread
Error -1Jerry Schwartz22 Mar
  • RE: Error -1Jerry Schwartz23 Mar
RE: Error -1Jerry Schwartz23 Mar
  • RE: Error -1Martin Gainty23 Mar
    • RE: Error -1Jerry Schwartz23 Mar