StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJUser::_load: Unable to load user although the user exists in all 3 main joomla tables
text
Body
copied!<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 <= 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->msgSendInfo[0]; $subject = $this->msgSendInfo[1]; $message = $this->msgSendInfo[2]; $document =& JFactory::getDocument(); $document->addScriptDeclaration($this->script); $document->addScriptDeclaration($this->users); ?>  <div class="fsl_h3title"><b><?php echo JText::_('JBJOBS_NEWMESSAGE'); ?></b></div>   <form action="index.php" method="post" name="adminForm" id="adminForm" > <div class="col100"> <table class="admintable jbj_tblborder" width="100%"> <tr> <td width="100" align="right" class="key"> <label for="to"> <?php echo JText::_( 'JBJOBS_TO' ); ?>: </label> </td> <td> <input class="text_area" type="text" name="to" id="to" size="32" maxlength="100" value="<?php echo $to; ?>" onkeyup="return getUser()" readonly />  </td> </tr> <tr> <td width="100" align="right" class="key"> <label for="subject"> <?php echo JText::_( 'JBJOBS_SUBJECT' ); ?>: </label> </td> <td> <input class="text_area" type="text" name="subject" id="subject" size="48" maxlength="100" value="<?php echo $subject; ?>" /> </td> </tr> <tr> <td width="100" align="right" class="key"> <label for="message"> <?php echo JText::_( 'JBJOBS_MESSAGE' ); ?>: </label> </td> <td> <?php $editor =& JFactory::getEditor(); echo $editor->display('message', $message, '500', '300', '60', '10', true); ?> </td>  <input type='hidden' id='temp' /> <input type='hidden' id='temp2' /> </tr> <tr> <td width="100" align="right" class="key"> <label for="submit"> </label> </td> <td> <input class="button" type="submit" name="submit" id="submit" size="32" maxlength="100" value="<?php echo JText::_( 'JBJOBS_SEND' ); ?>" /> </td> </tr> </table> </div> <div class="clr"></div>   <input type="hidden" name="option" value="com_jbjobs" /> <input type="hidden" name="task" value="savemessage" /> <input type="hidden" name="controller" value="jbmessaging" /> <input type="hidden" name="Itemid" id="Itemid" value="<?php echo $Itemid; ?>" /> <?php jimport('joomla.utilities.date'); $now = new JDate(); $date = $now->toMySQL(); $user =& JFactory::getUser(); ?> <input type="hidden" name="date" value="<?php echo $date; ?>" /> <input type="hidden" name="idFrom" value="<?php echo $user->id; ?>" /> <input type="hidden" name="<?php echo JUtility::getToken(); ?>" value="1" /> </form> <script type='text/javascript'>  </script> </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>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload