List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:March 23 2009 8:09pm
Subject:RE: Error -1
View as plain text  

>-----Original Message-----
>From: Martin Gainty [mailto:mgainty@stripped]
>Sent: Monday, March 23, 2009 11:49 AM
>To: Jerry Schwartz; wagnerbianchi@stripped
>Cc: mysql@stripped
>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: 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>
>> 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
>>
>> ________________________________________
>>
>>
>>
>>
>> --
>> 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