Publications: All

Search
  1. Test publication for Zotero

    Test publication for Zotero

    2023-12-05 20:36:22 | Article | Contributor(s): Minh To, Graham Jensen

    Only provide a description but no abstract

  2. Testing doc preview

    Testing doc preview

    2023-10-11 21:51:10 | Article | Contributor(s): Graham Jensen

  3. Test publication with two authors

    Test publication with two authors

    2023-05-18 20:13:43 | Article | Contributor(s): Graham Jensen, Graham Jensen | https://doi.org/10.80230/2QYA-PW22

    english, DH

  4. test

    test

    2022-07-15 16:47:01 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/704F-NJ27

    test

  5. Test: can I publish a private publication via frontend (i.e., before publishing publicly)?
  6. another test

    another test

    2022-07-08 16:59:10 | Image | Contributor(s): Ansh Thayil | https://doi.org/10.80230/HQY0-BD20

    test

  7. test 3

    test 3

    2022-06-28 16:32:44 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/01EY-RF29

    I am normal

    I am red

    I am blue

    I am big

  8. another test

    another test

    2022-06-24 18:13:16 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/0YQN-2019

     

    I am normal

     

    I am red

     

     

    I am blue

     

     

    I am big

     

     

  9. Publication visibility test (still visible in repository when published without DOI?)
  10. test

    test

    2022-06-20 17:37:32 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/7EDZ-XR84

    I am normal

    I am red

    I am blue

    I am big

  11. ‘test’

    ‘test’

    2022-06-20 17:35:33 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/EDG4-W289

    test

     

     

    I am normal

    I am red

    I am blue

    I am big

  12. test2

    test2

    2022-06-20 17:15:53 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/J2DD-HJ87

    <p>I am normal</p>
    <p style="color:red;">I am red</p>
    <p style="color:blue;">I am blue</p>
    <p style="font-size:50px;">I am big</p>

     

  13. Test

    Test

    2022-06-20 16:28:28 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/8CSV-AH66

    Test

  14. Test 3

    Test 3

    2022-05-24 19:22:05 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/TDDZ-YW11

    This is a test.

  15. Test to see if DOI is published (and also in findable rather than draft state)

    Test to see if DOI is published (and also in findable rather than draft state)

    2022-05-18 21:29:44 | Article | Contributor(s): Graham Jensen | https://doi.org/10.80230/QK8Z-XS11

    Test

  16. HTML Tag test

    HTML Tag test

    2022-05-03 18:52:38 | Dataset | Contributor(s): Ansh Thayil | https://doi.org/10.80230/V335-SA38

    This is a test

    By ansh thayil

    By ansh thayil

    By ansh thayil

  17. Test Publication (License)

    Test Publication (License)

    2022-04-27 22:50:55 | Dataset | Contributor(s): John Doe | https://doi.org/10.80230/212A-CX57

    test

  18. Test publication

    Test publication

    2022-04-27 21:33:14 | Article | Contributor(s): John Doe | https://doi.org/10.80230/5HT6-ZA61

    test

Debug Console

Close18 MBRequestSessionTimelineDatabase115Events18
$_GET
Array( tag => test ) Array(
tag => test
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( 81f30cf708470b974874c8a96a6bcdb2 => 2cb4331e1d53737b7374e6aeededb5e7, d482552ea4a74f85... Array(
81f30cf708470b974874c8a96a6bcdb2 => 2cb4331e1d53737b7374e6aeededb5e7,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B B5B 75755 B 557 6 151 7 657 F 153 A F5255 6 3575550 05D5A 555 E1B 3165952 2164044 C 016 A17 25056 31A54535256 1 3 5 0 85C 5 3 E A F 75455 F 057 1 4 15155 15C 1515C F44 B4358 6 A16164A515412 24A 256515C1A 651555157 7 0 1 9 751 A F55 75255 1 7 0 0 F5955555D5C5C 756 3 F16 94A,
8512ae7d57b1396273f76fe6ed341a23 => en-GB,
cookie => 43a25f71035b89b5
)
$_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 => 81f30cf708470b974874c8a96a6bcdb2=2cb4331e1d53737b7374e6aeededb5e7; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%20B5B%2075755%20B%20557%206%20151%207%20657%20F%20153%20A%20F5255%206%203575550%2005D5A%20555%20E1B%203165952%202164044%20C%20016%20A17%2025056%2031A54535256%201%203%205%200%2085C%205%203%20E%20A%20F%2075455%20F%20057%201%204%2015155%2015C%201515C%20F44%20B4358%206%20A16164A515412%2024A%20256515C1A%20651555157%207%200%201%209%20751%20A%20F55%2075255%201%207%200%200%20F5955555D5C5C%20756%203%20F16%2094A; 8512ae7d57b1396273f76fe6ed341a23=en-GB; cookie=43a25f71035b89b5,
HTTP_X_FORWARDED_FOR => 3.144.108.246,
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.144.108.246,
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 => 57104,
REDIRECT_URL => /en/publications/browse,
REDIRECT_QUERY_STRING => tag=test,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => tag=test,
REQUEST_URI => /en/publications/browse?tag=test,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745100918.8357,
REQUEST_TIME => 1745100918
)
session.client.forwarded 3.144.108.246
separator .
orderBy id
orderDir asc
always
0 registerDate
1 registerIP
2 access
renew
tracker.sid 2cb4331e1d53737b7374e6aeededb5e7
tracker.ssid 2cb4331e1d53737b7374e6aeededb5e7
tracker.rsid 2cb4331e1d53737b7374e6aeededb5e7
  • site 0.091 seconds (+0.091); 18.00 MB (+18.000) - afterInitialise
  • site 0.137 seconds (+0.046); 18.00 MB (0.000) - afterRoute
  • site 0.448 seconds (+0.311); 18.00 MB (0.000) - afterDispatch
  • site 0.458 seconds (+0.010); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.465 seconds (+0.007); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.465 seconds (+0.001); 18.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.466 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.466 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.466 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.466 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.466 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.466 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.467 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.467 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.468 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.468 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.485 seconds (+0.018); 18.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.485 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.486 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.487 seconds (+0.001); 18.00 MB (0.000) - onAfterRender
  • site 0.490 seconds (+0.003); 18.00 MB (0.000) - sessionStore
18 MB

115 Queries Logged: 0.2635064125061 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '2cb4331e1d53737b7374e6aeededb5e7'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  3. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  4. 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'
  5. SELECT *
      FROM `jos_viewlevels`
  6. 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
  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:15:19')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-19 22:15:19')
      AND V.state != 2
      AND (V.access != 2)
      AND RTA.tbl='publications'
      AND TA.tag IN ('test')
      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:15:19')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-19 22:15:19')
      AND V.state != 2
      AND (V.access != 2)
      AND RTA.tbl='publications'
      AND TA.tag IN ('test')
      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_versions`
  29. SHOW FULL COLUMNS
      FROM `jos_publications`
  30. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  31. SHOW FULL COLUMNS
      FROM `jos_publications`
  32. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  33. SHOW FULL COLUMNS
      FROM `jos_publications`
  34. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  35. SHOW FULL COLUMNS
      FROM `jos_publications`
  36. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  37. SHOW FULL COLUMNS
      FROM `jos_publications`
  38. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  39. SHOW FULL COLUMNS
      FROM `jos_publications`
  40. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  41. SHOW FULL COLUMNS
      FROM `jos_publications`
  42. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  43. SHOW FULL COLUMNS
      FROM `jos_publications`
  44. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  45. SHOW FULL COLUMNS
      FROM `jos_publications`
  46. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  47. SHOW FULL COLUMNS
      FROM `jos_publications`
  48. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  49. SHOW FULL COLUMNS
      FROM `jos_publications`
  50. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  51. SHOW FULL COLUMNS
      FROM `jos_publications`
  52. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  53. SHOW FULL COLUMNS
      FROM `jos_publications`
  54. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  55. SHOW FULL COLUMNS
      FROM `jos_publications`
  56. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  57. SHOW FULL COLUMNS
      FROM `jos_publications`
  58. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  59. SHOW FULL COLUMNS
      FROM `jos_publications`
  60. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  61. 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='2881'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  62. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1044'
  63. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1044'
  64. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1044';
  65. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1086'
  66. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1086'
  67. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1086';
  68. 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='2620'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  69. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1019'
  70. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1019'
  71. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1019';
  72. 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='1322'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  73. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1017'
  74. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1017'
  75. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1017';
  76. 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='57'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  77. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1021'
  78. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1021'
  79. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1021';
  80. 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='60'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  81. 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='56'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  82. 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='53'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  83. 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='49'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  84. 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='51'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  85. 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='45'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  86. 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='39'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  87. 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='43'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  88. 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='42'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  89. 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='30'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  90. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = ''
  91. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  92. 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='13'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  93. 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='26'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  94. 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='23'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  95. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1023'
  96. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1023'
  97. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1023';
  98. 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='20'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  99. 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:15:19'
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down > '2025-04-19 22:15:19')
      GROUP BY tj.tagid
      ORDER BY tcount DESC
      LIMIT 20
  100. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  101. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  102. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  103. 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:15:19' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-19 22:15:19' )
      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
  104. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  105. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  106. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  107. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  108. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  109. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  110. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  111. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  112. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  113. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  114. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  115. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1745100912;s:18:\"session.timer.last\";i:1745100918;s:17:\"session.timer.now\";i:1745100918;s:24:\"session.client.forwarded\";s:13:\"3.144.108.246\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:8:\"Question\";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:\"2cb4331e1d53737b7374e6aeededb5e7\";s:12:\"tracker.ssid\";s:32:\"2cb4331e1d53737b7374e6aeededb5e7\";s:12:\"tracker.rsid\";s:32:\"2cb4331e1d53737b7374e6aeededb5e7\";}',`time` = '1745100919',`ip` = '10.233.94.22'
      WHERE `session_id` = '2cb4331e1d53737b7374e6aeededb5e7'
  • 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