title: JUser::_load: Unable to load user although the user exists in all 3 main joomla tables
body: <p>I have this user already..alive and kicking in the 3 main tables i.e jos_user, and other 2 acro_ and acro_map...of the joomla i get this error when i use the contact button from a component...</p>
  
  <p>Below is the error:</p>
  
  <pre><code>JUser::_load: Unable to load user with id: 160529
  Error loading Modules:MySQL server has gone away SQL=SELECT m.*, am.params as adv_params FROM jos_modules as m LEFT JOIN jos_advancedmodules as am ON am.moduleid = m.id WHERE m.published = 1 AND m.access &lt;= 1 AND m.client_id = 0 ORDER BY m.ordering, m.id  
  </code></pre>
  
  <p>Please do not worry about the other Error (since i m trying to find a solution for that frm hosting provider)  but at the moment i am seriously clueless about unable to load user in this joomla component when i use the Contact us button  </p>
  
  <p>Code for the 'View' of the component ::</p>
  
  <pre><code>defined('_JEXEC') or die('Restricted access'); 
  
  $to = "";
  $subject = "";
  $message = "";
  $Itemid = JRequest::getInt('Itemid');
  
  $to = $this-&gt;msgSendInfo[0];
  $subject = $this-&gt;msgSendInfo[1];
  $message = $this-&gt;msgSendInfo[2];
  
  $document =&amp; JFactory::getDocument();
  $document-&gt;addScriptDeclaration($this-&gt;script);
  $document-&gt;addScriptDeclaration($this-&gt;users);
  ?&gt;
  
  &lt;!-- Title --&gt;
  &lt;div class="fsl_h3title"&gt;&lt;b&gt;&lt;?php echo JText::_('JBJOBS_NEWMESSAGE'); ?&gt;&lt;/b&gt;&lt;/div&gt;
  &lt;!--&lt;div runat="server" ID="divContent" class="border" contenteditable="true"&gt; 
      &lt;?php echo $message; ?&gt;
  &lt;/div&gt;--&gt;
  &lt;!-- Begin Form for message --&gt;
  &lt;form action="index.php" method="post" name="adminForm" id="adminForm" &gt;
  &lt;div class="col100"&gt;
      &lt;table class="admintable jbj_tblborder" width="100%"&gt;
          &lt;tr&gt;
              &lt;td width="100" align="right" class="key"&gt;
                  &lt;label for="to"&gt;
                      &lt;?php echo JText::_( 'JBJOBS_TO' ); ?&gt;:
                  &lt;/label&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;input class="text_area" type="text" name="to" id="to" size="32" maxlength="100" value="&lt;?php echo $to; ?&gt;" onkeyup="return getUser()"  readonly /&gt;
                  &lt;!--&lt;select id="toList" style="width: 200px; float: left; margin-left: 8px; vertical-align: middle;" onchange="return setUser()" size="2"&gt;
                      &lt;option&gt;&lt;?php echo JText::_( 'JBJOBS_NOSUGGESTIONS' ); ?&gt;&lt;/option&gt;
                  &lt;/select&gt;--&gt;
              &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td width="100" align="right" class="key"&gt;
                  &lt;label for="subject"&gt;
                      &lt;?php echo JText::_( 'JBJOBS_SUBJECT' ); ?&gt;:
                  &lt;/label&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;input class="text_area" type="text" name="subject" id="subject" size="48" maxlength="100" value="&lt;?php echo $subject; ?&gt;" /&gt;
              &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td width="100" align="right" class="key"&gt;
                  &lt;label for="message"&gt;
                      &lt;?php echo JText::_( 'JBJOBS_MESSAGE' ); ?&gt;:
                  &lt;/label&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;?php 
                      $editor =&amp; JFactory::getEditor();
                      echo $editor-&gt;display('message', $message, '500', '300', '60', '10', true);
                  ?&gt;
              &lt;/td&gt;
  
          &lt;!-- Do NOT remove these two input boxes --&gt;
          &lt;input type='hidden' id='temp' /&gt;
          &lt;input type='hidden' id='temp2' /&gt;
  
          &lt;/tr&gt;
  
          &lt;tr&gt;
              &lt;td width="100" align="right" class="key"&gt;
                  &lt;label for="submit"&gt;
  
                  &lt;/label&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;input class="button" type="submit" name="submit" id="submit" size="32" maxlength="100" value="&lt;?php echo JText::_( 'JBJOBS_SEND' ); ?&gt;" /&gt;
              &lt;/td&gt;
          &lt;/tr&gt;
      &lt;/table&gt;
  &lt;/div&gt;
  &lt;div class="clr"&gt;&lt;/div&gt; &lt;!-- Clears the float --&gt;
  
      &lt;!-- Do not edit after this point, it does not change the visual style --&gt;
      &lt;input type="hidden" name="option" value="com_jbjobs" /&gt;
      &lt;input type="hidden" name="task" value="savemessage" /&gt;
      &lt;input type="hidden" name="controller" value="jbmessaging" /&gt;
      &lt;input type="hidden" name="Itemid" id="Itemid" value="&lt;?php echo $Itemid; ?&gt;" /&gt;
      &lt;?php
      jimport('joomla.utilities.date');
      $now = new JDate();
      $date = $now-&gt;toMySQL();
      $user =&amp; JFactory::getUser();
      ?&gt;
      &lt;input type="hidden" name="date" value="&lt;?php echo $date; ?&gt;" /&gt;
      &lt;input type="hidden" name="idFrom" value="&lt;?php echo $user-&gt;id; ?&gt;" /&gt;
      &lt;input type="hidden" name="&lt;?php echo JUtility::getToken(); ?&gt;" value="1" /&gt;
  &lt;/form&gt;
  &lt;script type='text/javascript'&gt;
      &lt;!--
      getUser();
      //--&gt;
  &lt;/script&gt;
  </code></pre>
  
  <p>Edit : A note from my host provide ( final blow to the hard-work past 6 months )</p>
  
  <p>Thank you for contacting. The problem it seems to be with a huge joomla user table:</p>
  
  <pre><code># 1267920 users in jos users"
  ls -laSh /var/lib/mysql/_final1
  total 868M
  -rw-rw---- 1 mysql mysql 452M May 2 04:51 jos_jbjobs_jobseeker.MYD
  -rw-rw---- 1 mysql mysql 155M May 2 16:47 jos_users.MYD
  -rw-rw---- 1 mysql mysql 120M May 2 16:47 jos_users.MYI
  -rw-rw---- 1 mysql mysql 45M May 2 04:51 jos_core_acl_aro.MYD
  -rw-rw---- 1 mysql mysql 36M May 2 08:30 jos_core_acl_aro.MYI
  -rw-rw---- 1 mysql mysql 25M May 2 04:51 jos_core_acl_groups_aro_map.MYD
  -rw-rw---- 1 mysql mysql 13M May 2 08:30 jos_jbjobs_jobseeker.MYI
  </code></pre>
  
  <p>joomla is limit itself per 64M memory limit</p>
  
  <p>when you clicking this form below:</p>
  
  <p>Components ? Contacts ? new Contacts </p>
  
  <p>due to a huge amount of user:</p>
  
  <p>Linked User. The username this contact is linked to (if applicable).</p>
  
  <p>throwing the below error of 64M limitation</p>
  
  <pre><code>Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 76 bytes) in /home/ink/public_html/libraries/joomla/database/database/mysql.php on line 462
  </code></pre>
  
  <p>the actual consumption of memory in this case is a lot more than 1G. So it's not like a server issue is more like a joomla issue itself and apparently joomla is not design for so many users. Let us know if you have any other questions or concerns.</p>
  
  <p>So i  guess joomla perhaps cannot handle  1 million or  5 million users? </p>