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, 1
Lance Lovette writes:
> 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 RingMem
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.R
