MySQL 5.1 lost its connection during query

Asked By Raymund Sebastian 0 points N/A Posted on - 10/30/2011

I'm using Solaris as my operating system and everytime  I execute my query in mysql server, it replies to me error. It says,  "Lost connection to MySQL server during query".  I'm using I am using mysql  5.1.  What can I do to get rid of this issue?

MY QUERY IS:

ELECT post_time, p.topic_id, t.topic_replies, post_id, u.user_id, username 
   FROM jforum_posts p, jforum_users u, jforum_topics t , jforum_forums f 
      WHERE t.forum_id = f.forum_id 
         AND t.topic_id = p.topic_id 
         AND f.forum_last_post_id = t.topic_last_post_id 
         AND t.topic_last_post_id = p.post_id 
         AND p.forum_id = 1 
         AND p.user_id = u.user_id 
         AND p.need_moderate = 0;
 

• Status: Open
• Question Views: 945
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Ramesh_89 0 points N/A #97634

MySQL 5.1 lost its connection during query

Hi,Raymund Sebastian

Doing a "gem install mysql" should do it, you may need to use the -include parameter though depending on how you installed MySQL (via Blastwave, source or the Sun freeware packages) as I can't remember off
the top of my head where each of these methods install MySQL. I've found upgrading to the native ones (you really should anyone for performance reasons) on solaris solved strange problems like this. Alternatively move to Postgresql if you can as I've found it to be less problematic.

About Ramesh_89

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/25/2011
• Question Category: MySQL Server