Re: Lost connection to MySQL server during query

[neil craig]

Right! Solved it...

It's been a very unhelpful error message, or perhaps one I mis-interpreted?

There are 2 queries which make up a navigation panel on this chat system, one shows public chatrooms, the other private. The query which made up the private chatrooms was:

select distinct chatroom_label as label, chatroom_id as id
from chatroom where chatroom_date_deleted_timestamp is null
and chatroom_is_permanent_chatroom=1
order by chatroom_label desc, chatroom.chatroom_label asc

which is obviously wrong since it's ordering by the same column twice. This didn't produce an error but instead crashed the MySQL connection.

It was one of those situations where an unhelpful error message made it difficult to find the source of the problem. It doesn't help also that this site is into 6 figures in terms of lines of code...

Many thanks to Peter for all your help...