MySQL Forums
Forum List  »  PHP

Re: Lost connection to MySQL server during query
Posted by: neil craig
Date: June 06, 2006 02:54AM

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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.