Bug #6624 #1030 - Got error -1 from storage engine

Description:
hi!

the query:
SELECT * 
FROM foren_threads
WHERE id
IN (
SELECT DISTINCT thread_id id
FROM foren_postings
WHERE MATCH (
posting
)
AGAINST (
'toll'
)
)
LIMIT 0 , 30 

produces the following error message:
#1030 - Got error -1 from storage engine 

both statements on their own work without any problems.

in the .err file, the following is written:
041115  8:49:01 [ERROR] Got error -1 when reading table './oc2004/foren_postings'

table structures:
CREATE TABLE `foren_postings` (
  `forum` text collate latin1_german1_ci NOT NULL,
  `thread_id` int(11) unsigned NOT NULL default '0',
  `posting_id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL default '0',
  `posting` text collate latin1_german1_ci NOT NULL,
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`posting_id`),
  KEY `thread_id` (`thread_id`),
  FULLTEXT KEY `posting` (`posting`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='Tabelle zum Forum rumtesten' AUTO_INCREMENT=14 ;
        
CREATE TABLE `foren_threads` (
  `forum` text collate latin1_german1_ci NOT NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  `thema` text collate latin1_german1_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL default '0',
  `postings` int(10) unsigned NOT NULL default '0',
  `last_post_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `last_poster_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='Threads des Testforums' AUTO_INCREMENT=6 ;
        
regards,
corin

How to repeat:
create tables and insert some random records. execute the query.

Suggested fix:
none

Duplicate for #6523