MySQL 5.1 lost its connection during query

Asked By 0 points N/A Posted on -
qa-featured

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;
 

SHARE
Answered By 0 points N/A #97634

MySQL 5.1 lost its connection during query

qa-featured

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.

Related Questions