Publications: Book chapter

Search
  1. “Test title”

    “Test title”

    2022-07-22 17:17:27 | Contributor(s): Graham Jensen | https://doi.org/10.80230/8ZJD-DT38

    testing, publications, test, unicorn

Debug Console

Close20 MBRequestSessionTimelineDatabase48Events18
$_GET
Array( sortby => title ) Array(
sortby => title
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( cookie => 43a25f71035b89b5, d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 24445... Array(
cookie => 43a25f71035b89b5,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B E A 350525D57 0 054 7 3 65359 156 F5E5E 756 451 751 45B C 254 F1B 3165952 2164044 C 016 A17 25056 31A51 25651 6555757 E 953 7 E E59 751505E C 551 3 7 354 55A57565D E44 B4358 6 A16164A515412 24A 256515C1A 3 0515650515256 F52 7 E F51515250 456 C525F5E53 75C585A5151 2 E16 94A,
81f30cf708470b974874c8a96a6bcdb2 => 72f34ec271c777ab26f87ffc7eab42d6,
8512ae7d57b1396273f76fe6ed341a23 => es
)
$_SERVER
Array( REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /en/publications/browse/17, REDIRECT_SC... Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/browse/17,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse/17,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /en/publications/browse/17,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse/17,
HTTP_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_ACCEPT => */*,
HTTP_ACCEPT_ENCODING => gzip, br, zstd, deflate,
HTTP_COOKIE => cookie=43a25f71035b89b5; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%20E%20A%20350525D57%200%20054%207%203%2065359%20156%20F5E5E%20756%20451%20751%2045B%20C%20254%20F1B%203165952%202164044%20C%20016%20A17%2025056%2031A51%2025651%206555757%20E%20953%207%20E%20E59%20751505E%20C%20551%203%207%20354%2055A57565D%20E44%20B4358%206%20A16164A515412%2024A%20256515C1A%203%200515650515256%20F52%207%20E%20F51515250%20456%20C525F5E53%2075C585A5151%202%20E16%2094A; 81f30cf708470b974874c8a96a6bcdb2=72f34ec271c777ab26f87ffc7eab42d6; 8512ae7d57b1396273f76fe6ed341a23=es,
HTTP_X_FORWARDED_FOR => 3.22.117.210,
HTTP_X_FORWARDED_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_X_FORWARDED_PORT => 443,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_SERVER => traefik-b8d8564f8-2whv9,
HTTP_X_REAL_IP => 3.22.117.210,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.62 (Debian),
SERVER_NAME => hsscommons.rs-dev.uvic.ca,
SERVER_ADDR => 10.233.98.122,
SERVER_PORT => 80,
REMOTE_ADDR => 10.233.94.22,
DOCUMENT_ROOT => /var/www/html,
REQUEST_SCHEME => http,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/html,
SERVER_ADMIN => webmaster@localhost,
SCRIPT_FILENAME => /var/www/html/index.php,
REMOTE_PORT => 43582,
REDIRECT_URL => /en/publications/browse/17,
REDIRECT_QUERY_STRING => sortby=title,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => sortby=title,
REQUEST_URI => /en/publications/browse/17?sortby=title,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745157587.9732,
REQUEST_TIME => 1745157587
)
session.client.forwarded 3.22.117.210
separator .
orderBy id
orderDir asc
always
0 registerDate
1 registerIP
2 access
renew
tracker.sid 72f34ec271c777ab26f87ffc7eab42d6
tracker.ssid 72f34ec271c777ab26f87ffc7eab42d6
tracker.rsid 72f34ec271c777ab26f87ffc7eab42d6
session.token 07e14d8d21da60655d44a9720c05f065
  • site 0.075 seconds (+0.075); 20.00 MB (+20.000) - afterInitialise
  • site 0.093 seconds (+0.017); 20.00 MB (0.000) - afterRoute
  • site 0.364 seconds (+0.272); 20.00 MB (0.000) - afterDispatch
  • site 0.405 seconds (+0.040); 20.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.419 seconds (+0.014); 20.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.419 seconds (+0.001); 20.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.420 seconds (+0.000); 20.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.420 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.420 seconds (+0.000); 20.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.420 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.420 seconds (+0.000); 20.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.420 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.421 seconds (+0.001); 20.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.421 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.421 seconds (+0.000); 20.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.422 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.446 seconds (+0.024); 20.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.446 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.446 seconds (+0.001); 20.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.447 seconds (+0.001); 20.00 MB (0.000) - onAfterRender
  • site 0.452 seconds (+0.005); 20.00 MB (0.000) - sessionStore
20 MB

48 Queries Logged: 0.33132362365723 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '72f34ec271c777ab26f87ffc7eab42d6'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  3. SELECT b.id, b.title
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  4. SELECT *
      FROM `jos_viewlevels`
  5. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= ''
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  6. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  7. SELECT *
      FROM `jos_languages`
      WHERE `published` = '1'
      ORDER BY `ordering` ASC
  8. SELECT language,id
      FROM `jos_menu`
      WHERE `home` = '1'
      AND `published` = '1'
      AND `client_id` = ''
  9. 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 `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > ''
      AND `m`.`client_id` = ''
      ORDER BY `m`.`lft` ASC
  10. SELECT con.`id`
      FROM `jos_content` AS con
      LEFT JOIN `jos_categories` AS cat
      ON con.catid = cat.id
      WHERE con.state=1
      AND con.`alias` = '17'
      AND cat.`path` = 'publications/browse'
  11. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  12. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = ''
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  15. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  16. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  17. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  18. SHOW FULL COLUMNS
      FROM `jos_publications`
  19. SHOW FULL COLUMNS
      FROM `jos_publication_master_types`
  20. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  21. SHOW FULL COLUMNS
      FROM `jos_publications`
  22. SELECT C.id
      FROM jos_publication_versions V
      LEFT JOIN jos_publications C
      ON V.publication_id = C.id
      LEFT JOIN jos_projects PP
      ON PP.id = C.project_id
      LEFT JOIN jos_publication_master_types MT
      ON MT.id = C.master_type
      LEFT JOIN jos_publication_categories AS t
      ON t.id = C.category
      WHERE 1
      AND V.version_number = (SELECT MAX(version_number)
      FROM jos_publication_versions
      WHERE publication_id=C.id
      AND state=1 )
      AND (V.state=1)
      AND C.category=17
      AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 13:59:48')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 13:59:48')
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id, V.id
  23. SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access, C.checked_out, C.checked_out_time, C.rating as master_rating, C.group_owner, C.master_type, C.master_doi, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.private as project_private, PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
      FROM `jos_publication_versions` as vv
      WHERE vv.publication_id=C.id
      AND vv.state=3
      ORDER BY ID DESC
      LIMIT 1) AS dev_version_label , (SELECT COUNT(*)
      FROM `jos_publication_versions`
      WHERE publication_id=C.id
      AND state!=3) AS versions
      FROM jos_publication_versions V
      LEFT JOIN jos_publications C
      ON V.publication_id = C.id
      LEFT JOIN jos_projects PP
      ON PP.id = C.project_id
      LEFT JOIN jos_publication_master_types MT
      ON MT.id = C.master_type
      LEFT JOIN jos_publication_categories AS t
      ON t.id = C.category
      WHERE 1
      AND V.version_number = (SELECT MAX(version_number)
      FROM jos_publication_versions
      WHERE publication_id=C.id
      AND state=1 )
      AND (V.state=1)
      AND C.category=17
      AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 13:59:48')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 13:59:48')
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id, V.id
      ORDER BY V.title ASC, V.version_number DESC
      LIMIT 0, 20
  24. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  25. SHOW FULL COLUMNS
      FROM `jos_publications`
  26. SELECT *
      FROM `jos_publication_categories`
      WHERE `id` = '17'
  27. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  28. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='64'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1017'
  30. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1017'
  31. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1017';
  32. SELECT t.tag, t.raw_tag, t.admin, tj.tagid, tj.objectid, COUNT(tj.tagid) AS tcount
      FROM jos_tags AS t JOIN jos_tags_object AS tj
      ON t.id=tj.tagid
      LEFT JOIN jos_publication_versions AS V
      ON V.id=tj.objectid
      AND tj.tbl='publications'
      WHERE t.id=tj.tagid
      AND t.admin=0
      AND tj.tbl='publications'
      AND V.state=1
      AND V.main=1
      AND V.access!=4
      AND V.published_up < '2025-04-20 13:59:48'
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down > '2025-04-20 13:59:48')
      GROUP BY tj.tagid
      ORDER BY tcount DESC
      LIMIT 20
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  36. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2025-04-20 13:59:48' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-20 13:59:48' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = ''
      AND (`mm`.`menuid` = '' OR `mm`.`menuid` <= '' )
      AND `m`.`language` IN ('en-GB','*')
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  38. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  48. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:60;s:19:\"session.timer.start\";i:1745157569;s:18:\"session.timer.last\";i:1745157587;s:17:\"session.timer.now\";i:1745157588;s:24:\"session.client.forwarded\";s:12:\"3.22.117.210\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:17:\"Hubzero\\User\\User\":1:{s:5:\"guest\";b:1;}s:11:\"tracker.sid\";s:32:\"72f34ec271c777ab26f87ffc7eab42d6\";s:12:\"tracker.ssid\";s:32:\"72f34ec271c777ab26f87ffc7eab42d6\";s:12:\"tracker.rsid\";s:32:\"72f34ec271c777ab26f87ffc7eab42d6\";s:13:\"session.token\";s:32:\"07e14d8d21da60655d44a9720c05f065\";}',`time` = '1745157588',`ip` = '10.233.94.22'
      WHERE `session_id` = '72f34ec271c777ab26f87ffc7eab42d6'
  • onAfterInitialise Method plgSystemLanguageFilter::onAfterInitialise /app/plugins/system/languagefilter/languagefilter.php:186
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /app/plugins/system/password/password.php:21
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch Method plgSystemLanguageFilter::onAfterDispatch /app/plugins/system/languagefilter/languagefilter.php:554
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21