Summary

Loading a Section Layout when you have lots of articles, ends up in an error page with MySQL running out of memory because of the way the SQL query is made.

Detailed info and query tracing here:

http://forum.joomla.org/viewtopic.php?f=431&t=603477
http://forum.joomla.org/viewtopic.php?f=431&t=722989



JDatabaseMySQL::query: 2008 - MySQL client ran out of memory SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email as author_email FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.access <= 0 AND s.id = 11 AND s.access <= 0 AND cc.access <= 0 AND s.published = 1 AND cc.published = 1 AND a.state = 1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-06-06 22:06:01' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-06-06 22:06:01' ) ORDER BY a.created DESC

Call stack
# Function Location
1 JSite->dispatch() /home/x/public_html/portales/index.php:68
2 JComponentHelper->renderComponent() /home/x/public_html/portales/includes/application.php:124
3 require_once() /home/x/public_html/portales/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/x/public_html/portales/components/com_content/content.php:35
5 ContentController->display() /home/x/public_html/portales/libraries/joomla/application/component/controller.php:236
6 JController->display() /home/x/public_html/portales/components/com_content/controller.php:55
7 JCacheView->get() /home/x/public_html/portales/libraries/joomla/application/component/controller.php:308
8 ContentViewSection->display() /home/x/public_html/portales/libraries/joomla/cache/handler/view.php:98
9 JView->get() /home/x/public_html/portales/components/com_content/views/section/view.html.php:55
10 ContentModelSection->getTotal() /home/x/public_html/portales/libraries/joomla/application/component/view.php:364
11 JModel->_getListCount() /home/x/public_html/portales/components/com_content/models/section.php:137
12 JFDatabase->query() /home/x/public_html/portales/libraries/joomla/application/component/model.php:300
13 JDatabaseMySQLi->query() /home/x/public_html/portales/plugins/system/jfdatabase/jfdatabase_inherit.php:640
14 JError->raiseError() /home/x/public_html/portales/libraries/joomla/database/database/mysqli.php:247
15 JError->raise() /home/x/public_html/portales/libraries/joomla/error/error.php:171
16 JException->__construct() /home/x/public_html/portales/libraries/joomla/error/error.php:136
Opened On:
7 Jun 2012, 9:20 by Himeko Tokyo
Closed On:
10 Aug 2013, 10:42
Status:
Closed

Filed Under

  • Administrator
  • Apache 2.2.x
  • MySQL 5.2.x
  • PHP 5.3.x

Responses

Posted on 10 Aug 2013, 10:13 by Jonny Roger
Some suggestions have been added to http://forum.joomla.org/viewtopic.php?f=431&t=722989, but no guarantees.
Posted on 10 Aug 2013, 10:42 by Brian Teeman
Support for Joomla 1.5 ended in April of 2012 and we continued to support it unofficially until the end of 2012 for medium to high priority security issues.