Joomla! Debug Console
Errors

    JDatabaseMySQL::query: 1054 - Unknown column 'parent' in 'field list' SQL=select parent, menutype, ordering from lo2i8_menu where id = 594 limit 1
    Call stack
    #	Function	Location
    1	JSite->render()	JROOT/index.php:48
    2	JDocumentHTML->parse()	JROOT/includes/application.php:260
    3	JDocumentHTML->_fetchTemplate()	JROOT/libraries/joomla/document/html/html.php:414
    4	JDocumentHTML->_loadTemplate()	JROOT/libraries/joomla/document/html/html.php:591
    5	require()	JROOT/libraries/joomla/document/html/html.php:531
    6	include_once()	JROOT/templates/bluewater_learning_template/index.php:5
    7	SJ_Tools->getCurrentMenuIndex()	JROOT/templates/bluewater_learning_template/sj_vars.php:14
    8	JDatabase->loadObject()	JROOT/templates/bluewater_learning_template/sj_templatetools.php:113
    9	JDatabaseMySQL->query()	JROOT/libraries/joomla/database/database.php:1033
    10	JError::raiseError()	JROOT/libraries/joomla/database/database/mysql.php:542
    11	JError::raise()	JROOT/libraries/joomla/error/error.php:251

Session
__default
Profile Information
Application 0.000 seconds (+0.000); 0.53 MB (+0.527) - afterLoad
Application 0.276 seconds (+0.276); 9.37 MB (+8.838) - afterInitialise
Application 0.322 seconds (+0.046); 10.21 MB (+0.844) - afterRoute
Application 0.922 seconds (+0.599); 25.62 MB (+15.412) - afterDispatch
Memory Usage
25.53 MB (26,765,944 Bytes)
Database Queries
45 Queries Logged

    SELECT `data`
      FROM `lo2i8_session`
      WHERE `session_id` = '0a0cf1d4dd10b925810db75f66cca3e8'
    DELETE
      FROM `lo2i8_session`
      WHERE `time` < '1339056463'
    SELECT folder AS type, element AS name, params
      FROM lo2i8_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3)
      ORDER BY ordering
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM lo2i8_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM lo2i8_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kunena'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM lo2i8_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_k2'
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM lo2i8_menu AS m
      LEFT JOIN lo2i8_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    SELECT id, home, template, s.params
      FROM lo2i8_template_styles as s
      LEFT JOIN lo2i8_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM lo2i8_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_comprofiler'
    SELECT *
      FROM lo2i8_languages
      WHERE published=1
      ORDER BY ordering ASC
    SELECT c.*, u.*
      FROM lo2i8_users AS u
      LEFT JOIN lo2i8_comprofiler AS c
      ON c.id = u.id
      WHERE u.id = 70
    SELECT a.id
      FROM lo2i8_user_usergroup_map AS map
      LEFT JOIN lo2i8_usergroups AS a
      ON a.id = map.group_id
      WHERE map.user_id = 70
    SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM lo2i8_comprofiler_plugin
      WHERE published = 1
      AND access IN (0,1,2)
      AND type = 'user'
      ORDER BY ordering
    SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM lo2i8_comprofiler_plugin
      WHERE published = 1
      AND access IN (0,1,2)
      AND type = 'user/plug_cbgroupjive/plugins'
      ORDER BY ordering
    SELECT *
      FROM `lo2i8_groupjive_plugin_auto`
      WHERE ( `published` = 1 )
      ORDER BY `ordering` ASC
    SELECT *
      FROM `lo2i8_comprofiler_plugin`
      WHERE `element` = 'cbgroupjive'
    SELECT *
      FROM `lo2i8_comprofiler_tabs`
      WHERE `pluginid` = 500
    SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM lo2i8_comprofiler_plugin
      WHERE published = 1
      AND access IN (0,1,2)
      AND type = 'templates'
      ORDER BY ordering
    SELECT *
      FROM `lo2i8_usergroups`
      ORDER BY `lft`
    SELECT b.id
      FROM lo2i8_user_usergroup_map AS map
      LEFT JOIN lo2i8_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN lo2i8_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE map.user_id = 70
    SELECT *
      FROM `lo2i8_usergroups`
      ORDER BY `lft`
    SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
      FROM `lo2i8_usergroups` AS a
      LEFT JOIN `lo2i8_usergroups` AS b
      ON a.`lft` > b.`lft`
      AND a.`rgt` < b.`rgt`
      GROUP BY a.`id`
      ORDER BY a.`lft` ASC
    SELECT *
      FROM lo2i8_comprofiler_tabs t
      WHERE t.enabled=1
      AND t.viewaccesslevel IN (1,2,3)
      AND t.useraccessgroupid IN (-2,-1,1,16,6,7,2,13,3,15,4,5,12,18,17,14,8)
      ORDER BY t.position, t.ordering
    SELECT id
      FROM lo2i8_menu
      WHERE link = 'index.php?option=com_comprofiler'
      AND published = 1
      AND access IN (1,2,3)
      AND `language` IN ( 'en-GB', '*', '' )
    SELECT g.id AS gid
      FROM (lo2i8_users AS u
      INNER JOIN lo2i8_user_usergroup_map AS um
      ON u.id=um.user_id)
      INNER JOIN lo2i8_usergroups AS g
      ON um.group_id=g.id
      WHERE u.id=70
    SELECT g.id AS gid
      FROM (lo2i8_users AS u
      INNER JOIN lo2i8_user_usergroup_map AS um
      ON u.id=um.user_id)
      INNER JOIN lo2i8_usergroups AS g
      ON um.group_id=g.id
      WHERE u.id=70
    SELECT g.id AS gid
      FROM (lo2i8_users AS u
      INNER JOIN lo2i8_user_usergroup_map AS um
      ON u.id=um.user_id)
      INNER JOIN lo2i8_usergroups AS g
      ON um.group_id=g.id
      WHERE u.id=70
    SELECT g.id AS gid
      FROM (lo2i8_users AS u
      INNER JOIN lo2i8_user_usergroup_map AS um
      ON u.id=um.user_id)
      INNER JOIN lo2i8_usergroups AS g
      ON um.group_id=g.id
      WHERE u.id=70
    SELECT g.id AS gid
      FROM (lo2i8_users AS u
      INNER JOIN lo2i8_user_usergroup_map AS um
      ON u.id=um.user_id)
      INNER JOIN lo2i8_usergroups AS g
      ON um.group_id=g.id
      WHERE u.id=70
    SELECT a.*
      FROM `lo2i8_groupjive_categories` AS a
      WHERE ( a.`user_id` = 70 )
      ORDER BY a.`ordering` ASC
    SELECT a.*
      FROM `lo2i8_groupjive_groups` AS a
      WHERE ( a.`user_id` = 70 )
      ORDER BY a.`ordering` ASC
    SELECT a.*
      FROM `lo2i8_groupjive_groups` AS a
      LEFT JOIN `lo2i8_groupjive_users` AS e
      ON e.`
      group` = a.`id`
      WHERE ( ( e.`user_id` = 70 )
      AND ( e.`status` NOT IN ( '-1', '0', '4' ) ) )
      ORDER BY a.`ordering` ASC
    SELECT a.*
      FROM `lo2i8_groupjive_invites` AS a
      WHERE ( a.`user_id` = 70 )
      ORDER BY a.`accepted` ASC
    SELECT a.*
      FROM `lo2i8_groupjive_groups` AS a
      LEFT JOIN `lo2i8_groupjive_invites` AS f
      ON f.`
      group` = a.`id`
      WHERE ( ( f.`user` = 70 ) OR ( f.`email` = 'system@bluewaterlearning.com' ) )
      AND ( f.`accepted` IN ( '0000-00-00', '0000-00-00 00:00:00', '', NULL ) )
      ORDER BY a.`ordering` ASC
    SELECT id
      FROM lo2i8_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access<=2
      AND language IN ('en-GB','*')
      LIMIT 1
    SELECT id
      FROM lo2i8_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access<=2
      AND language IN ('en-GB','*')
      LIMIT 1
    SELECT a.*, b.name AS fromname
      FROM lo2i8_uddeim AS a
      LEFT JOIN lo2i8_users AS b
      ON a.fromid=b.id
      WHERE a.toid=70
      AND a.totrash=0
      AND archived=0
      ORDER BY datum DESC
      LIMIT 0,10
    SELECT f.*
      FROM lo2i8_comprofiler_fields f
      INNER JOIN lo2i8_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
      WHERE f.published = 1
      AND f.profile != 0
      AND t.enabled = 1
      AND t.viewaccesslevel IN (1,2,3)
      AND t.useraccessgroupid IN (-2,-1,1,16,6,7,2,13,3,15,4,5,12,18,17,14,8)
      ORDER BY t.position, t.ordering, f.ordering
    SELECT MAX(time)
      FROM lo2i8_session
      WHERE userid = 70
      AND guest = 0
    SELECT `id`
      FROM `lo2i8_menu`
      WHERE `link` LIKE '%com_kunena%'
    SELECT *
      FROM lo2i8_kunena_config
    SELECT `version`
      FROM `lo2i8_kunena_version`
      ORDER BY `id` DESC
      LIMIT 0, 1
    SELECT f.*, `rank`
      FROM `lo2i8_kunena_users`AS f, `lo2i8_users`AS u
      WHERE f.`userid` = u.`id`
      AND f.`userid` = 70
      LIMIT 0, 1
    select parent, menutype, ordering
      from lo2i8_menu
      where id = 594
      limit 1
    UPDATE `lo2i8_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1339086867;s:18:\"session.timer.last\";i:1339092453;s:17:\"session.timer.now\";i:1339092463;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"70\";s:4:\"name\";s:10:\"Temp Admin\";s:8:\"username\";s:9:\"tempadmin\";s:5:\"email\";s:28:\"system@bluewaterlearning.com\";s:8:\"password\";s:65:\"be3c20943348763e5ced8c962c276fad:nm8XFPPYVzTGkrUX8KteAQ7E0BBLXO3X\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2012-06-01 16:22:58\";s:13:\"lastvisitDate\";s:19:\"0000-00-00 00:00:00\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:3:{i:2;s:1:\"2\";i:7;s:1:\"7\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:5:{i:0;i:1;i:1;i:2;i:3;i:6;i:4;i:7;i:6;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:\"8df92c8b1ecd401e7f7c98fd357009a8\";}' , `time` = '1339092464'
      WHERE `session_id` = '0a0cf1d4dd10b925810db75f66cca3e8'

33 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

    5 × SELECT g.id AS gid
      FROM (lo2i8_users AS u
      INNER JOIN lo2i8_user_usergroup_map AS um
      ON u.id=um.user_id)
      INNER JOIN lo2i8_usergroups AS g
      ON um.group_id=g.id
    4 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM lo2i8_extensions
    3 × SELECT id
      FROM lo2i8_menu
    3 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
      FROM lo2i8_comprofiler_plugin
    2 × SELECT *
      FROM `lo2i8_usergroups`
    1 × SELECT a.*
      FROM `lo2i8_groupjive_invites` AS a
    1 × SELECT a.*
      FROM `lo2i8_groupjive_groups` AS a
      LEFT JOIN `lo2i8_groupjive_users` AS e
      ON e.`
      group` = a.`id`
    1 × SELECT a.*
      FROM `lo2i8_groupjive_groups` AS a
    1 × select parent, menutype, ordering
      from lo2i8_menu
    1 × SELECT f.*, `rank`
      FROM `lo2i8_kunena_users`AS f, `lo2i8_users`AS u
    1 × SELECT a.*
      FROM `lo2i8_groupjive_groups` AS a
      LEFT JOIN `lo2i8_groupjive_invites` AS f
      ON f.`
      group` = a.`id`
    1 × SELECT a.*, b.name AS fromname
      FROM lo2i8_uddeim AS a
      LEFT JOIN lo2i8_users AS b
      ON a.fromid=b.id
    1 × SELECT `id`
      FROM `lo2i8_menu`
    1 × SELECT *
      FROM lo2i8_kunena_confi
    1 × SELECT MAX(time)
      FROM lo2i8_session
    1 × SELECT a.*
      FROM `lo2i8_groupjive_categories` AS a
    1 × SELECT f.*
      FROM lo2i8_comprofiler_fields f
      INNER JOIN lo2i8_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
    1 × SELECT `version`
      FROM `lo2i8_kunena_version`
    1 × SELECT *
      FROM lo2i8_comprofiler_tabs t
    1 × SELECT *
      FROM lo2i8_languages
    1 × SELECT c.*, u.*
      FROM lo2i8_users AS u
      LEFT JOIN lo2i8_comprofiler AS c
      ON c.id = u.id
    1 × SELECT id, home, template, s.params
      FROM lo2i8_template_styles as s
      LEFT JOIN lo2i8_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
    1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM lo2i8_menu AS m
      LEFT JOIN lo2i8_extensions AS e
      ON m.component_id = e.extension_id
    1 × SELECT folder AS type, element AS name, params
      FROM lo2i8_extensions
    1 × SELECT a.id
      FROM lo2i8_user_usergroup_map AS map
      LEFT JOIN lo2i8_usergroups AS a
      ON a.id = map.group_id
    1 × SELECT *
      FROM `lo2i8_groupjive_plugin_auto`
    1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
      FROM `lo2i8_usergroups` AS a
      LEFT JOIN `lo2i8_usergroups` AS b
      ON a.`lft` > b.`lft`
      AND a.`rgt` < b.`rgt`
      GROUP BY a.`id`
    1 × SELECT b.id
      FROM lo2i8_user_usergroup_map AS map
      LEFT JOIN lo2i8_usergroups AS a
      ON a.id = map.group_id
      LEFT JOIN lo2i8_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
    1 × SELECT *
      FROM `lo2i8_comprofiler_tabs`
    1 × SELECT *
      FROM `lo2i8_comprofiler_plugin`
    1 × SELECT `data`
      FROM `lo2i8_session`

OTHER Tables:

    1 × UPDATE `lo2i8_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1339086867;s:18:\"session.timer.last\";i:1339092453;s:17:\"session.timer.now\";i:1339092463;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20100101 Firefox/12.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"70\";s:4:\"name\";s:10:\"Temp Admin\";s:8:\"username\";s:9:\"tempadmin\";s:5:\"email\";s:28:\"system@bluewaterlearning.com\";s:8:\"password\";s:65:\"be3c20943348763e5ced8c962c276fad:nm8XFPPYVzTGkrUX8KteAQ7E0BBLXO3X\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:11:\"Super Users\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2012-06-01 16:22:58\";s:13:\"lastvisitDate\";s:19:\"0000-00-00 00:00:00\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:3:{i:2;s:1:\"2\";i:7;s:1:\"7\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:5:{i:0;i:1;i:1;i:2;i:3;i:6;i:4;i:7;i:6;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:\"8df92c8b1ecd401e7f7c98fd357009a8\";}' , `time` = '1339092464'
    1 × DELETE
      FROM `lo2i8_session`