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
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