Upgraders

You are here: Home

Using Extensions

Content Component

Article Category List

Upgraders

Notice

Error

The template for this display is not available. Please contact a Site administrator.

Upgraders

Details: Category: Joomla!; Published on Saturday, 01 January 2011 01:00; Written by Super User; Hits: 358

If you are an experienced Joomla! 1.5 user, 1.6 will seem very familiar. There are new templates and improved user interfaces, but most functionality is the same. The biggest changes are improved access control (ACL) and nested categories.

The new user manager which will let you manage who has access to what in your site. You can leave access groups exactly the way you had them in Joomla 1.5 or make them as complicated as you want. You can learn more about how access control works in on the Joomla! Documentation site

In Joomla 1.5 and 1.0 content was organized into sections and categories. In 1.6 sections are gone, and you can create categories within categories, going as deep as you want. The sample data provides many examples of the use of nested categories.

All layouts have been redesigned to improve accessibility and flexibility. If you would like to keep the 1.5 layouts, you can find them in the html folder of the MilkyWay template. Simply copy the layouts you want to the html folder of your template.

Updating your site and extensions when needed is easier than ever thanks to installer improvements.

Errors

The template for this display is not available. Please contact a Site administrator.

Information

Backtrace

Call stack
#	Function	Location
1	JSite->dispatch()	/www/www.dobbelsteijn.net/data/villalorena/index.php:43
2	JComponentHelper::renderComponent()	/www/www.dobbelsteijn.net/data/villalorena/includes/application.php:188
3	JSite->getTemplate()	/www/www.dobbelsteijn.net/data/villalorena/libraries/joomla/application/component/helper.php:102
4	JError::raiseWarning()	/www/www.dobbelsteijn.net/data/villalorena/includes/application.php:466
5	JError::raise()	/www/www.dobbelsteijn.net/data/villalorena/libraries/joomla/error/error.php:194

Profile Information

Application 0.001 seconds (+0.001); 0.95 MB (+0.95) - afterLoad

Application 0.069 seconds (+0.069); 5.03 MB (+4.07) - afterInitialise

Application 0.130 seconds (+0.061); 7.91 MB (+2.89) - afterRoute

Application 0.244 seconds (+0.114); 11.98 MB (+4.07) - afterDispatch

Application 0.350 seconds (+0.105); 12.67 MB (+0.69) - afterRender

Memory Usage

12.69 MB (13,307,872 Bytes)

18 Queries Logged

SELECT `data`
FROM `lor2_session`
WHERE `session_id` = '689fc12f115dcd0026aa10703296ef16'
SELECT folder AS type, element AS name, params
  FROM lor2_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM lor2_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
  FROM lor2_menu AS m
  LEFT JOIN lor2_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  AND m.access IN (1,1)
  ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM lor2_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM lor2_categories as c
  LEFT JOIN lor2_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM lor2_categories AS cat JOIN lor2_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=50
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft
SELECT alias, catid
FROM lor2_content
WHERE id = 50
SELECT *
  FROM lor2_languages
  WHERE published=1
  ORDER BY lang_id ASC
SELECT id, home, template, params
FROM lor2_template_styles
WHERE client_id = 0
SELECT b.rules
  FROM lor2_assets AS a
  LEFT JOIN lor2_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.name = 'com_content'
  ORDER BY b.lft
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM lor2_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
  FROM lor2_content AS a
  LEFT JOIN lor2_categories AS c
  on c.id = a.catid
  LEFT JOIN lor2_users AS u
  on u.id = a.created_by
  LEFT JOIN lor2_contact_details AS contact
  on contact.user_id = a.created_by
  LEFT JOIN lor2_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN lor2_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM lor2_categories AS cat JOIN lor2_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published <= 0
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE a.id = 50
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 08:39:12')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 08:39:12')
  AND (a.state = 1 OR a.state =2)
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM lor2_categories as c
  LEFT JOIN lor2_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM lor2_categories AS cat JOIN lor2_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=19
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft
SELECT b.rules
  FROM lor2_assets AS a
  LEFT JOIN lor2_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.name = 'com_content.article.50'
  ORDER BY b.lft
SELECT a.id, 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
  FROM lor2_content AS a
  LEFT JOIN lor2_categories AS cc
  ON cc.id = a.catid
  WHERE a.catid = 19
  AND a.state = 1
  AND a.access = 1
  AND (a.state = 1 OR a.state = -1)
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 08:39:12')
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 08:39:12')
  ORDER BY a.title
UPDATE lor2_content
SET hits = hits + 1
WHERE id = 50
SELECT id, title, module, position, content, showtitle, params, mm.menuid
  FROM lor2_modules AS m
  LEFT JOIN lor2_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.published = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-02-23 08:39:12')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-02-23 08:39:12')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 260 OR mm.menuid <= 0)
  ORDER BY position, ordering
UPDATE `lor2_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1329986023;s:18:\"session.timer.last\";i:1329986329;s:17:\"session.timer.now\";i:1329986352;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"15381c57d8057dbcb73cf47fc761fb44\";s:16:\"com_mailto.links\";a:9:{s:40:\"697ff310f2c80fb70dcf2eca93ae5f2201ea52a5\";O:8:\"stdClass\":2:{s:4:\"link\";s:44:\"http://www.villalorena.eu/index.php/site-map\";s:6:\"expiry\";i:1329986046;}s:40:\"bef73fd0e3f0e8b63f04ddcb62b62649d2131c2f\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.villalorena.eu/index.php/using-joomla\";s:6:\"expiry\";i:1329986067;}s:40:\"4a729674be9ee09e9ab922f4fc0180d524c92052\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.villalorena.eu/index.php/sample-sites\";s:6:\"expiry\";i:1329986094;}s:40:\"804f9c65ee6af24e9aeb696b3a8e66125c05fb6e\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.villalorena.eu/index.php/getting-started\";s:6:\"expiry\";i:1329986115;}s:40:\"22455108e1d60022dc951eac3bd9753665871702\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.villalorena.eu/index.php/the-joomla-project\";s:6:\"expiry\";i:1329986140;}s:40:\"24caa330df57e3f1f7bfddb314969adddc151206\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://www.villalorena.eu/index.php/the-joomla-community\";s:6:\"expiry\";i:1329986196;}s:40:\"6dac595135c9e6281c3f7d695189ac3588679093\";O:8:\"stdClass\":2:{s:4:\"link\";s:120:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component/article-category-list/24-joomla\";s:6:\"expiry\";i:1329986307;}s:40:\"78451a54118ac735e981826a0c0c8ad1ea138eae\";O:8:\"stdClass\":2:{s:4:\"link\";s:122:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component/article-category-list/8-beginners\";s:6:\"expiry\";i:1329986329;}s:40:\"ebf82da1c6931b0ffdcacfd421252d55b34ca770\";O:8:\"stdClass\":2:{s:4:\"link\";s:123:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component/article-category-list/50-upgraders\";s:6:\"expiry\";i:1329986352;}}}', `time` = 1329986353
WHERE `session_id` = '689fc12f115dcd0026aa10703296ef16'

14 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM lor2_extensions
2 × SELECT b.rules FROM lor2_assets AS a LEFT JOIN lor2_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM lor2_categories as c LEFT JOIN lor2_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM lor2_categories AS cat JOIN lor2_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM lor2_content AS a LEFT JOIN lor2_categories AS c on c.id = a.catid LEFT JOIN lor2_users AS u on u.id = a.created_by LEFT JOIN lor2_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN lor2_categories as parent ON parent.id = c.parent_id LEFT JOIN lor2_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM lor2_categories AS cat JOIN lor2_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT a.id, 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 FROM lor2_content AS a LEFT JOIN lor2_categories AS cc ON cc.id = a.catid
1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM lor2_modules AS m LEFT JOIN lor2_modules_menu AS mm ON mm.moduleid = m.id
1 × SELECT id, home, template, params FROM lor2_template_styles
1 × SELECT alias, catid FROM lor2_content
1 × SELECT folder AS type, element AS name, params FROM lor2_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM lor2_menu AS m LEFT JOIN lor2_extensions AS e ON m.component_id = e.extension_id
1 × SELECT `data` FROM `lor2_session`
1 × SELECT * FROM lor2_languages

OTHER Tables:

1 × UPDATE `lor2_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1329986023;s:18:\"session.timer.last\";i:1329986329;s:17:\"session.timer.now\";i:1329986352;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"15381c57d8057dbcb73cf47fc761fb44\";s:16:\"com_mailto.links\";a:9:{s:40:\"697ff310f2c80fb70dcf2eca93ae5f2201ea52a5\";O:8:\"stdClass\":2:{s:4:\"link\";s:44:\"http://www.villalorena.eu/index.php/site-map\";s:6:\"expiry\";i:1329986046;}s:40:\"bef73fd0e3f0e8b63f04ddcb62b62649d2131c2f\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.villalorena.eu/index.php/using-joomla\";s:6:\"expiry\";i:1329986067;}s:40:\"4a729674be9ee09e9ab922f4fc0180d524c92052\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.villalorena.eu/index.php/sample-sites\";s:6:\"expiry\";i:1329986094;}s:40:\"804f9c65ee6af24e9aeb696b3a8e66125c05fb6e\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.villalorena.eu/index.php/getting-started\";s:6:\"expiry\";i:1329986115;}s:40:\"22455108e1d60022dc951eac3bd9753665871702\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.villalorena.eu/index.php/the-joomla-project\";s:6:\"expiry\";i:1329986140;}s:40:\"24caa330df57e3f1f7bfddb314969adddc151206\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://www.villalorena.eu/index.php/the-joomla-community\";s:6:\"expiry\";i:1329986196;}s:40:\"6dac595135c9e6281c3f7d695189ac3588679093\";O:8:\"stdClass\":2:{s:4:\"link\";s:120:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component/article-category-list/24-joomla\";s:6:\"expiry\";i:1329986307;}s:40:\"78451a54118ac735e981826a0c0c8ad1ea138eae\";O:8:\"stdClass\":2:{s:4:\"link\";s:122:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component/article-category-list/8-beginners\";s:6:\"expiry\";i:1329986329;}s:40:\"ebf82da1c6931b0ffdcacfd421252d55b34ca770\";O:8:\"stdClass\":2:{s:4:\"link\";s:123:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component/article-category-list/50-upgraders\";s:6:\"expiry\";i:1329986352;}}}', `time` = 1329986353
1 × UPDATE lor2_content SET hits = hits + 1