• Discoverability Visible
  • Join Policy Invite Only
  • Created 22 Jan 2015

About the Group

Public Description

Building a Modular Cyber-Platform for Systematic Collection, Curation, and Preservation of Large Engineering and Science Data, NSF CIF21 DIBBs, $1,500,000, 2014-2017

 

This project focuses upon the preservation and re-use of scientific and engineering data. A computational platform is being developed to allow researchers to organize, preserve, and share their data in more consistent and reliable ways, to facilitate broader use by the research community and society as a whole. The team plans to create a Modular Cyber-Platform (MCP) that would be simple and reliable enough to minimize the costs associated with maintenance, yet flexible enough to facilitate use in a large number of domains or disciplines. The modular cyber-platform would allow communities to readily publish systematically classified datasets, permit automatic long-term curation of data, and create a cyberinfrastructure for dataset dissemination, validation (crowd vetting) and collaboration. While the products of this project would be relevant to a range of science and engineering communities, the emphasis of the project will initially be on data related to civil infrastructure (bridges, highways, buildings, pipelines, power distribution networks).

 


Debug Console

Close37 MBRequestSessionTimelineDatabase66Events49
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /groups/dibbs,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/groups/dibbs,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /groups/dibbs,
SCRIPT_URI => https://datacenterhub.org/groups/dibbs,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Fri, 29 May 2020 20:46:54 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 3.228.220.31,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 41530,
REDIRECT_URL => /groups/dibbs,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /groups/dibbs,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1597321900.4773,
REQUEST_TIME => 1597321900,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 80cad3525fe70db977bb38b76e3652bc
tracker.ssid 80cad3525fe70db977bb38b76e3652bc
tracker.rsid 80cad3525fe70db977bb38b76e3652bc
  • site 0.092 seconds (+0.092); 12.25 MB (+12.250) - afterInitialise
  • site 0.122 seconds (+0.031); 13.50 MB (+1.250) - afterRoute
  • site 0.405 seconds (+0.282); 36.25 MB (+22.750) - afterDispatch
  • site 0.413 seconds (+0.009); 36.75 MB (+0.500) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.416 seconds (+0.003); 36.75 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.417 seconds (+0.000); 36.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.436 seconds (+0.020); 37.00 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.441 seconds (+0.005); 37.00 MB (0.000) - onAfterRender
  • site 0.445 seconds (+0.004); 37.00 MB (0.000) - sessionStore
37 MB

66 Queries Logged: 0.051175594329834 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'e81e7a016c040d065b4a3b3fc938971c'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'e81e7a016c040d065b4a3b3fc938971c'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '80cad3525fe70db977bb38b76e3652bc'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '80cad3525fe70db977bb38b76e3652bc'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('80cad3525fe70db977bb38b76e3652bc','0','1597321900','3.228.220.31')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      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'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. 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` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  13. 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` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. DELETE
      FROM `jos_xgroups_pages_checkout`
      WHERE `userid`='0'
  16. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'dibbs';
  17. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1009') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1009') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1009') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1009')
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  20. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages`
  21. SELECT *
      FROM jos_xgroups_pages
      WHERE gidNumber='1009'
      AND state IN (0,1)
      ORDER BY lft ASC
  22. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_versions`
  23. SELECT *
      FROM jos_xgroups_pages_versions
      WHERE pageid='3'
      ORDER BY version DESC
  24. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_hits`
  25. INSERT INTO `jos_xgroups_pages_hits` (`gidNumber`,`pageid`,`userid`,`date`,`ip`)
      VALUES ('1009','3','0','2020-08-13 12:31:40','3.228.220.31')
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  28. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_categories`
  29. SELECT *
      FROM `jos_xgroups_description_fields`
      ORDER BY `ordering` ASC
  30. SELECT *
      FROM `jos_xgroups_description_answers`
      WHERE `jos_xgroups_description_answers`.`group_id` = '1009'
      AND `jos_xgroups_description_answers`.`field_id` IN ('116','117')
      ORDER BY `ordering` ASC
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  32. SHOW FULL COLUMNS
      FROM `jos_collections`
  33. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      LEFT JOIN `jos_xgroups` AS g
      ON g.gidNumber=b.object_id
      AND b.object_type='
      group'
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1009'
      AND b.object_type='
      group'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  35. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`scope` = '
      group'
      AND `jos_wiki_pages`.`scope_id` = '1009'
      AND `jos_wiki_pages`.`state` = '1'
  36. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  37. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`published` IN ('1')
      AND `jos_resources`.`group_owner` = 'dibbs'
      AND `jos_resources`.`access` IN ('0','1','2','3','4')
      AND (`jos_resources`.`publish_up` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_up` <= '2020-08-13 12:31:40' )
      AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_down` >= '2020-08-13 12:31:40' )
  38. SELECT jos_resources.*
      FROM `jos_resources`
      WHERE `jos_resources`.`published` IN ('1')
      AND `jos_resources`.`group_owner` = 'dibbs'
      AND `jos_resources`.`access` IN ('0','1','2','3','4')
      AND (`jos_resources`.`publish_up` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_up` IS NULL OR `jos_resources`.`publish_up` <= '2020-08-13 12:31:40' )
      AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_down` IS NULL OR `jos_resources`.`publish_down` >= '2020-08-13 12:31:40' )
      GROUP BY jos_resources.id
      ORDER BY `rating` ASC
      LIMIT 15
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  40. SELECT COUNT(jos_forum_posts.id) AS count
      FROM `jos_forum_posts`
      WHERE `jos_forum_posts`.`scope` = '
      group'
      AND `jos_forum_posts`.`scope_id` = '1009'
      AND `jos_forum_posts`.`state` = '1'
      AND `jos_forum_posts`.`parent` = '0'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  42. SELECT COUNT(jos_blog_entries.id) AS count
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = '
      group'
      AND `jos_blog_entries`.`scope_id` = '1009'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2020-08-13 12:31:40' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2020-08-13 12:31:40' )
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  44. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`referenceid` = '1009'
      AND `jos_wishlist`.`category` = '
      group'
  45. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '4'
  46. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '4'
      AND `jos_wishlist_owners`.`type` != '2'
  47. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  48. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'manage'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  49. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  50. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  51. SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`wishlist` = '4'
      AND `jos_wishlist_item`.`status` != '2'
      AND `jos_wishlist_item`.`private` = '0'
  52. SHOW FULL COLUMNS
      FROM `jos_projects`
  53. SELECT DISTINCT p.id
      FROM jos_project_owners as po, jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.created_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE p.id=po.projectid
      AND p.state NOT IN (2, 3)
      AND po.status=1
      AND po.groupid=1009
  54. SELECT *
      FROM `jos_xgroups_memberoption`
      WHERE `jos_xgroups_memberoption`.`gidNumber` = '1009'
      AND `jos_xgroups_memberoption`.`userid` = '0'
      AND `jos_xgroups_memberoption`.`optionname` = 'receive-forum-email'
  55. SELECT COUNT(jos_announcements.id) AS count
      FROM `jos_announcements`
      WHERE `jos_announcements`.`scope` = '
      group'
      AND `jos_announcements`.`scope_id` = '1009'
      AND `jos_announcements`.`state` = '1'
      AND (`jos_announcements`.`publish_up` IS NULL OR `jos_announcements`.`publish_up` <= '2020-08-13 12:31:40' )
      AND (`jos_announcements`.`publish_down` IS NULL OR `jos_announcements`.`publish_down` >= '2020-08-13 12:31:40' )
  56. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = '
      group'
      AND `jos_activity_recipients`.`scope_id` = '1009'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  57. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  58. SELECT *
      FROM jos_xgroups_pages
      WHERE gidNumber='1009'
      AND state IN (1)
      ORDER BY lft ASC
  59. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'groups'
      AND `jos_tags_object`.`objectid` = '1009'
      GROUP BY jos_tags_object.label,jos_tags.id
  60. 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` <= '2020-08-13 12:31:40' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-08-13 12:31:40' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '81' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  61. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  62. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  63. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  64. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  65. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  66. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597321900;s:18:\"session.timer.last\";i:1597321900;s:17:\"session.timer.now\";i:1597321900;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\":2:{s:6:\"Groups\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:3:\"Orm\";O:8:\"stdClass\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Answer\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}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\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"80cad3525fe70db977bb38b76e3652bc\";s:12:\"tracker.ssid\";s:32:\"80cad3525fe70db977bb38b76e3652bc\";s:12:\"tracker.rsid\";s:32:\"80cad3525fe70db977bb38b76e3652bc\";}',`time` = '1597321900',`ip` = '3.228.220.31'
      WHERE `session_id` = '80cad3525fe70db977bb38b76e3652bc'

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 19 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 2 × SELECT *
      FROM `jos_assets`
  3. 2 × SELECT data
      FROM `jos_session`
  4. 2 × SELECT *
      FROM jos_xgroups_pages
  5. 1 × SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  6. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  7. 1 × SELECT *
      FROM `jos_wishlist`
  8. 1 × SELECT COUNT(jos_blog_entries.id) AS count
      FROM `jos_blog_entries`
  9. 1 × SELECT *
      FROM `jos_wishlist_ownergroups`
  10. 1 × SELECT *
      FROM `jos_wishlist_owners`
  11. 1 × SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
  12. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  13. 1 × 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
  14. 1 × SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
  15. 1 × SELECT COUNT(jos_announcements.id) AS count
      FROM `jos_announcements`
  16. 1 × SELECT DISTINCT p.id
      FROM jos_project_owners as po, jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.created_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
  17. 1 × SELECT *
      FROM `jos_xgroups_memberoption`
  18. 1 × SELECT COUNT(jos_forum_posts.id) AS count
      FROM `jos_forum_posts`
  19. 1 × SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
  20. 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 `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
  21. 1 × 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
  22. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  23. 1 × SELECT *
      FROM `jos_viewlevels
  24. 1 × SELECT session_id
      FROM `jos_session`
  25. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  26. 1 × SELECT *
      FROM `jos_xgroups`
  27. 1 × SELECT *
      FROM jos_xgroups_pages_versions
  28. 1 × SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
  29. 1 × SELECT *
      FROM `jos_resource_types`
  30. 1 × SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      LEFT JOIN `jos_xgroups` AS g
      ON g.gidNumber=b.object_id
      AND b.object_type='
      group'
  31. 1 × SELECT *
      FROM `jos_xgroups_description_answers`
  32. 1 × SELECT *
      FROM `jos_xgroups_description_fields`
  33. 1 × SELECT jos_resources.*
      FROM `jos_resources`
OTHER Tables:
  1. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_categories
  2. 1 × INSERT INTO `jos_xgroups_pages_hits` (`gidNumber`,`pageid`,`userid`,`date`,`ip`)
      VALUES ('1009','3','0','2020-08-13 12:31:40','3.228.220.31'
  3. 1 × SHOW FULL COLUMNS
      FROM `jos_collections
  4. 1 × SHOW FULL COLUMNS
      FROM `jos_projects
  5. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597321900;s:18:\"session.timer.last\";i:1597321900;s:17:\"session.timer.now\";i:1597321900;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\":2:{s:6:\"Groups\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:3:\"Orm\";O:8:\"stdClass\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Answer\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}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\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"80cad3525fe70db977bb38b76e3652bc\";s:12:\"tracker.ssid\";s:32:\"80cad3525fe70db977bb38b76e3652bc\";s:12:\"tracker.rsid\";s:32:\"80cad3525fe70db977bb38b76e3652bc\";}',`time` = '1597321900',`ip` = '3.228.220.31'
  6. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_hits
  7. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_versions
  8. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('80cad3525fe70db977bb38b76e3652bc','0','1597321900','3.228.220.31'
  9. 1 × DELETE
      FROM `jos_xgroups_pages_checkout`
  10. 1 × (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
  11. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages
  12. 1 × DELETE
      FROM `jos_session`
  • 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 plgSystemPassword::onAfterRoute /core/plugins/system/password/password.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
  • onGroupAreas Method plgGroupsCollections::onGroupAreas /core/plugins/groups/collections/collections.php:127
  • onGroupAreas Method plgGroupsMembers::onGroupAreas /core/plugins/groups/members/members.php:59
  • onGroupAreas Method plgGroupsWiki::onGroupAreas /core/plugins/groups/wiki/wiki.php:55
  • onGroupAreas Method plgGroupsMessages::onGroupAreas /core/plugins/groups/messages/messages.php:55
  • onGroupAreas Method plgGroupsResources::onGroupAreas /core/plugins/groups/resources/resources.php:78
  • onGroupAreas Method plgGroupsForum::onGroupAreas /core/plugins/groups/forum/forum.php:61
  • onGroupAreas Method plgGroupsBlog::onGroupAreas /core/plugins/groups/blog/blog.php:55
  • onGroupAreas Method plgGroupsWishlist::onGroupAreas /core/plugins/groups/wishlist/wishlist.php:55
  • onGroupAreas Method plgGroupsProjects::onGroupAreas /core/plugins/groups/projects/projects.php:68
  • onGroupAreas Method plgGroupsMemberOptions::onGroupAreas /core/plugins/groups/memberoptions/memberoptions.php:28
  • onGroupAreas Method plgGroupsAnnouncements::onGroupAreas /core/plugins/groups/announcements/announcements.php:55
  • onGroupAreas Method plgGroupsFiles::onGroupAreas /core/plugins/groups/files/files.php:55
  • onGroupAreas Method plgGroupsActivity::onGroupAreas /core/plugins/groups/activity/activity.php:28
  • onContentSave Method plgSystemContent::onContentSave /core/plugins/system/content/content.php:23
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onGroup Method plgGroupsCollections::onGroup /core/plugins/groups/collections/collections.php:152
  • onGroup Method plgGroupsMembers::onGroup /core/plugins/groups/members/members.php:84
  • onGroup Method plgGroupsWiki::onGroup /core/plugins/groups/wiki/wiki.php:80
  • onGroup Method plgGroupsMessages::onGroup /core/plugins/groups/messages/messages.php:80
  • onGroup Method plgGroupsResources::onGroup /core/plugins/groups/resources/resources.php:103
  • onGroup Method plgGroupsForum::onGroup /core/plugins/groups/forum/forum.php:86
  • onGroup Method plgGroupsBlog::onGroup /core/plugins/groups/blog/blog.php:80
  • onGroup Method plgGroupsWishlist::onGroup /core/plugins/groups/wishlist/wishlist.php:81
  • onGroup Method plgGroupsProjects::onGroup /core/plugins/groups/projects/projects.php:93
  • onGroup Method plgGroupsMemberOptions::onGroup /core/plugins/groups/memberoptions/memberoptions.php:54
  • onGroup Method plgGroupsAnnouncements::onGroup /core/plugins/groups/announcements/announcements.php:131
  • onGroup Method plgGroupsFiles::onGroup /core/plugins/groups/files/files.php:80
  • onGroup Method plgGroupsActivity::onGroup /core/plugins/groups/activity/activity.php:53
  • onBeforeGroup Method plgGroupsAnnouncements::onBeforeGroup /core/plugins/groups/announcements/announcements.php:74
  • 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