Publications: All

Search
  1. Test publication

    Test publication

    2023-10-27 16:27:30 | Article | Contributor(s): Minh To

    This publication will be deleted later

  2. Test pub

    Test pub

    2023-07-12 18:44:32 | Article | Contributor(s): Minh To

Debug Console

Close18 MBRequestSessionTimelineDatabase50Events18
$_GET
Array( tag => testtag1 ) Array(
tag => testtag1
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( cookie => 43a25f71035b89b5, 8512ae7d57b1396273f76fe6ed341a23 => es, d482552ea4a74f85... Array(
cookie => 43a25f71035b89b5,
8512ae7d57b1396273f76fe6ed341a23 => es,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B A A 35A53 9 057 F 15755 953 D50 25A E52 852505052 C52 A C 3 35C1B 3165952 2164044 C 016 A17 25056 31A55 2565B 7 1 0 0 15C 351 1 E D56 5 5 E 0 A5557 656 953 B5757 A5D44 B4358 6 A16164A515412 24A 256515C1A 7 0515C51 5 5 1 0 75758 051 5 3 451 6 05D5B A5252 1 E B5150555D16 94A,
81f30cf708470b974874c8a96a6bcdb2 => 32f9514e8d3a8753fc648b2bb873433e
)
$_SERVER
Array( REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /en/publications/browse, REDIRECT_SCRIP... Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/browse,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /en/publications/browse,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse,
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; 8512ae7d57b1396273f76fe6ed341a23=es; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%20A%20A%2035A53%209%20057%20F%2015755%20953%20D50%2025A%20E52%20852505052%20C52%20A%20C%203%2035C1B%203165952%202164044%20C%20016%20A17%2025056%2031A55%202565B%207%201%200%200%2015C%20351%201%20E%20D56%205%205%20E%200%20A5557%20656%20953%20B5757%20A5D44%20B4358%206%20A16164A515412%2024A%20256515C1A%207%200515C51%205%205%201%200%2075758%20051%205%203%20451%206%2005D5B%20A5252%201%20E%20B5150555D16%2094A; 81f30cf708470b974874c8a96a6bcdb2=32f9514e8d3a8753fc648b2bb873433e,
HTTP_X_FORWARDED_FOR => 18.219.165.19,
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 => 18.219.165.19,
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 => 43162,
REDIRECT_URL => /en/publications/browse,
REDIRECT_QUERY_STRING => tag=testtag1,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => tag=testtag1,
REQUEST_URI => /en/publications/browse?tag=testtag1,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745101168.4655,
REQUEST_TIME => 1745101168
)
session.client.forwarded 18.219.165.19
separator .
orderBy id
orderDir asc
always
0 registerDate
1 registerIP
2 access
renew
tracker.sid 32f9514e8d3a8753fc648b2bb873433e
tracker.ssid 32f9514e8d3a8753fc648b2bb873433e
tracker.rsid 32f9514e8d3a8753fc648b2bb873433e
  • site 0.081 seconds (+0.081); 16.00 MB (+16.000) - afterInitialise
  • site 0.119 seconds (+0.038); 16.00 MB (0.000) - afterRoute
  • site 0.524 seconds (+0.405); 16.00 MB (0.000) - afterDispatch
  • site 0.562 seconds (+0.038); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.581 seconds (+0.019); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.582 seconds (+0.002); 18.00 MB (+2.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.583 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.583 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.583 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.583 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.583 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.583 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.584 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.584 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.585 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.585 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.629 seconds (+0.044); 18.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.629 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.630 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.631 seconds (+0.001); 18.00 MB (0.000) - onAfterRender
  • site 0.643 seconds (+0.013); 18.00 MB (0.000) - sessionStore
18 MB

50 Queries Logged: 0.49292635917664 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '32f9514e8d3a8753fc648b2bb873433e'
  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` = 'browse'
      AND cat.`path` = 'publications'
  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 , TA.tag, COUNT(DISTINCT TA.tag) AS uniques
      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
      LEFT JOIN jos_tags_object RTA
      ON RTA.objectid = V.id
      LEFT JOIN jos_tags TA
      ON RTA.tagid = TA.id
      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 (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-19 22:19:28')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-19 22:19:28')
      AND V.state != 2
      AND (V.access != 2)
      AND RTA.tbl='publications'
      AND TA.tag IN ('testtag1')
      GROUP BY C.id
      HAVING uniques=1
  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 , TA.tag, COUNT(DISTINCT TA.tag) AS uniques
      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
      LEFT JOIN jos_tags_object RTA
      ON RTA.objectid = V.id
      LEFT JOIN jos_tags TA
      ON RTA.tagid = TA.id
      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 (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-19 22:19:28')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-19 22:19:28')
      AND V.state != 2
      AND (V.access != 2)
      AND RTA.tbl='publications'
      AND TA.tag IN ('testtag1')
      GROUP BY C.id
      HAVING uniques=1
      ORDER BY V.published_up DESC
      LIMIT 0, 20
  24. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  25. SHOW FULL COLUMNS
      FROM `jos_publications`
  26. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  27. SHOW FULL COLUMNS
      FROM `jos_publications`
  28. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  29. 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='2817'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  30. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1044'
  31. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1044'
  32. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1044';
  33. 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='1586'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  34. 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-19 22:19:28'
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down > '2025-04-19 22:19:28')
      GROUP BY tj.tagid
      ORDER BY tcount DESC
      LIMIT 20
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  36. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  38. 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-19 22:19:29' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-19 22:19:29' )
      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
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  50. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1745101158;s:18:\"session.timer.last\";i:1745101168;s:17:\"session.timer.now\";i:1745101168;s:24:\"session.client.forwarded\";s:13:\"18.219.165.19\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:4:\"Post\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
      limit\";i:20;}}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:\"32f9514e8d3a8753fc648b2bb873433e\";s:12:\"tracker.ssid\";s:32:\"32f9514e8d3a8753fc648b2bb873433e\";s:12:\"tracker.rsid\";s:32:\"32f9514e8d3a8753fc648b2bb873433e\";}',`time` = '1745101169',`ip` = '10.233.94.22'
      WHERE `session_id` = '32f9514e8d3a8753fc648b2bb873433e'
  • 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