I had the same problems when executing queries with an HAVING clause and
TEXT fields SELECTed, at least using InnoDB tables.
If you are in the same position you can use substring(text_field, 128) to
solve your problem, at least partially.
Hope it helps
Nico
On Fri, 13 Jul 2001, Lance Lovette wrote:
> I recently upgraded from MySQL 3.23.36 to 3.23.39 and now the following
> query fails.
>
> > SELECT DISTINCT Ring.*, Question.DefaultRingID, COUNT(RingMember.UserID)
> AS MemberCount FROM Ring, Question, QuestionXQuestionCategory,
> BrandXQuestionCategory LEFT JOIN RingMember ON (Ring.RingID =
> RingMember.RingID) WHERE (Ring.QuestionID = Question.QuestionID) AND
> (Question.QuestionID = QuestionXQuestionCategory.QuestionID) AND
> (QuestionXQuestionCategory.CategoryID = BrandXQuestionCategory.CategoryID)
> AND Ring.DirectoryListing = 1 AND BrandXQuestionCategory.BrandID = 1 GROUP
> BY Ring.RingID, QuestionXQuestionCategory.CategoryID HAVING (Ring.RingID !=
> Question.DefaultRingID) ORDER BY MemberCount DESC LIMIT 5
>
> ERROR 1032: Can't find record in '#sql45e7_7123_1'
>
> I ran 'myisamchk --medium-check --silent /var/lib/mysql/*/*.MYI' and nothing
> was reported.
>
> What might be causing the error?
>
> Thanks!
> Lance
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread79451@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-nico=officinedigitali.it@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
