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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
