What's New: Past Month

Knowledge Base feed

  1. Where do I go for documentation?

    Documentation can be found in HUBzero’s documentation page.

    https://datacenterhub.org/kb/misc/testarticle

  2. Why is Hispanic / Latino not a racial background choice?

    According to U.S. government guidelines, ethnic heritage and racial background are to be separate, distinct questions and responses. "Ethnic Heritage" defines membership in cultural groups such as...

    https://datacenterhub.org/kb/registration/hispanic

  3. Group Guidelines & Tips

    Ultimately it is the Admins that decide what the rules are for their group, but if you have been made a manager of a group, here are some suggestions for keeping your group happy:Manager...

    https://datacenterhub.org/kb/groups/guide

  4. What are groups?

    Work together with your colleaguesCreate a group to organize your interactions. Group members can:Post content that only other group members are allowed to seeExport their content to other web...

    https://datacenterhub.org/kb/groups/general

  5. Earning points in the Questions & Answers forum

    Each question in the forum has its own "market" value, which reflects the level of community interest the question has generated. This is calculated by summing up the weighted number of answers,...

    https://datacenterhub.org/kb/points/earning_points_in_the_answers_forum

Top 5 shown

Wiki Pages feed

  1. Main Page

    What are wiki pages? Wiki pages are user-written articles on a range of subjects. Any contributor or a group of contributors can create (and own) new articles, and there can be multiple articles...

    https://datacenterhub.org/groups/htirc_growth_modeling/wiki/MainPage

  2. Main Page

    What are wiki pages? Wiki pages are user-written articles on a range of subjects. Any contributor or a group of contributors can create (and own) new articles, and there can be multiple articles...

    https://datacenterhub.org/groups/instylejacketsuk/wiki/MainPage

  3. Main Page

    What are wiki pages? Wiki pages are user-written articles on a range of subjects. Any contributor or a group of contributors can create (and own) new articles, and there can be multiple articles...

    https://datacenterhub.org/groups/needassignment/wiki/MainPage

  4. Main Page

    What are wiki pages? Wiki pages are user-written articles on a range of subjects. Any contributor or a group of contributors can create (and own) new articles, and there can be multiple articles...

    https://datacenterhub.org/groups/buyassignment/wiki/MainPage

  5. Main Page

    What are wiki pages? Wiki pages are user-written articles on a range of subjects. Any contributor or a group of contributors can create (and own) new articles, and there can be multiple articles...

    https://datacenterhub.org/groups/instylejackets/wiki/MainPage

Top 5 shown

Debug Console

Close21 MBRequestSessionTimelineDatabase74Events27
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( MANPATH => /opt/remi/php56/root/usr/share/man:/opt/puppetlabs/puppet/share/man, HOSTNA... Array(
MANPATH => /opt/remi/php56/root/usr/share/man:/opt/puppetlabs/puppet/share/man,
HOSTNAME => hz01-p-web01.hz01.internal,
SHELL => /bin/bash,
TERM => xterm-256color,
HISTSIZE => 1000,
SSH_TTY => /dev/pts/0,
NO_PROXY => .s2.internal,
http_proxy => http://10.8.63.5:3128,
USER => apache,
LD_LIBRARY_PATH => /opt/remi/php56/root/usr/lib64,
LS_COLORS => rs=0:di=38;5;27:ln=38;5;51:mh=44;38;5;15:pi=40;38;5;11:so=38;5;13:do=38;5;5:bd=48;5;232;38;5;11:cd=48;5;232;38;5;3:or=48;5;232;38;5;9:mi=05;48;5;232;38;5;15:su=48;5;196;38;5;15:sg=48;5;11;38;5;16:ca=48;5;196;38;5;226:tw=48;5;10;38;5;16:ow=48;5;10;38;5;21:st=48;5;21;38;5;15:ex=38;5;34:*.tar=38;5;9:*.tgz=38;5;9:*.arj=38;5;9:*.taz=38;5;9:*.lzh=38;5;9:*.lzma=38;5;9:*.tlz=38;5;9:*.txz=38;5;9:*.zip=38;5;9:*.z=38;5;9:*.Z=38;5;9:*.dz=38;5;9:*.gz=38;5;9:*.lz=38;5;9:*.xz=38;5;9:*.bz2=38;5;9:*.tbz=38;5;9:*.tbz2=38;5;9:*.bz=38;5;9:*.tz=38;5;9:*.deb=38;5;9:*.rpm=38;5;9:*.jar=38;5;9:*.rar=38;5;9:*.ace=38;5;9:*.zoo=38;5;9:*.cpio=38;5;9:*.7z=38;5;9:*.rz=38;5;9:*.jpg=38;5;13:*.jpeg=38;5;13:*.gif=38;5;13:*.bmp=38;5;13:*.pbm=38;5;13:*.pgm=38;5;13:*.ppm=38;5;13:*.tga=38;5;13:*.xbm=38;5;13:*.xpm=38;5;13:*.tif=38;5;13:*.tiff=38;5;13:*.png=38;5;13:*.svg=38;5;13:*.svgz=38;5;13:*.mng=38;5;13:*.pcx=38;5;13:*.mov=38;5;13:*.mpg=38;5;13:*.mpeg=38;5;13:*.m2v=38;5;13:*.mkv=38;5;13:*.ogm=38;5;13:*.mp4=38;5;13:*.m4v=38;5;13:*.mp4v=38;5;13:*.vob=38;5;13:*.qt=38;5;13:*.nuv=38;5;13:*.wmv=38;5;13:*.asf=38;5;13:*.rm=38;5;13:*.rmvb=38;5;13:*.flc=38;5;13:*.avi=38;5;13:*.fli=38;5;13:*.flv=38;5;13:*.gl=38;5;13:*.dl=38;5;13:*.xcf=38;5;13:*.xwd=38;5;13:*.yuv=38;5;13:*.cgm=38;5;13:*.emf=38;5;13:*.axv=38;5;13:*.anx=38;5;13:*.ogv=38;5;13:*.ogx=38;5;13:*.aac=38;5;45:*.au=38;5;45:*.flac=38;5;45:*.mid=38;5;45:*.midi=38;5;45:*.mka=38;5;45:*.mp3=38;5;45:*.mpc=38;5;45:*.ogg=38;5;45:*.ra=38;5;45:*.wav=38;5;45:*.axa=38;5;45:*.oga=38;5;45:*.spx=38;5;45:*.xspf=38;5;45:,
SUDO_USER => su-ehuebner,
SUDO_UID => 602,
USERNAME => root,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
MAIL => /var/spool/mail/su-ehuebner,
PWD => /home/ehuebner,
LANG => en_US.UTF-8,
MODULEPATH => /usr/share/Modules/modulefiles:/etc/modulefiles,
LOADEDMODULES => ,
https_proxy => http://10.8.63.5:3128,
ENVIRON_CONFIG_DIRS => /etc/environ.d ,
SHLVL => 3,
SUDO_COMMAND => /bin/su,
HOME => /var/www,
LOGNAME => root,
CVS_RSH => ssh,
MODULESHOME => /usr/share/Modules,
LESSOPEN => ||/usr/bin/lesspipe.sh %s,
SUDO_GID => 800,
G_BROKEN_FILENAMES => 1,
BASH_FUNC_module() => () { eval `/usr/bin/modulecmd bash $*`
}
,
_ => /opt/remi/php56/root/usr/sbin/php-fpm,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /community/resources/whatsnew,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/community/resources/whatsnew,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /community/resources/whatsnew,
SCRIPT_URI => https://datacenterhub.org/community/resources/whatsnew,
HTTPS => on,
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 => Sun, 05 Apr 2020 09:12:56 PDT,
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 => 10.111.11.10,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 17800,
REDIRECT_URL => /community/resources/whatsnew,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /community/resources/whatsnew,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590474695.6549,
REQUEST_TIME => 1590474695,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid d106e884008fb99475cfc24300b4166b
tracker.ssid d106e884008fb99475cfc24300b4166b
tracker.rsid d106e884008fb99475cfc24300b4166b
  • site 0.045 seconds (+0.045); 12.25 MB (+12.250) - afterInitialise
  • site 0.063 seconds (+0.018); 13.50 MB (+1.250) - afterRoute
  • site 0.340 seconds (+0.277); 20.00 MB (+6.500) - afterDispatch
  • site 0.349 seconds (+0.009); 20.25 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.351 seconds (+0.002); 20.50 MB (+0.250) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.351 seconds (+0.000); 20.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.365 seconds (+0.015); 20.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.370 seconds (+0.004); 21.00 MB (+0.250) - onAfterRender
  • site 0.372 seconds (+0.003); 21.00 MB (0.000) - sessionStore
21 MB

74 Queries Logged: 0.16283440589905 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '81f7714061c71548cd39f6029bb77024'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '81f7714061c71548cd39f6029bb77024'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'd106e884008fb99475cfc24300b4166b'
  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` = 'd106e884008fb99475cfc24300b4166b'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('d106e884008fb99475cfc24300b4166b','0','1590474695','10.111.11.10')
  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 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
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_whatsnew'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  18. SELECT count(DISTINCT c.id)
      FROM jos_content AS c
      INNER JOIN jos_categories AS b
      ON b.id=c.catid
      WHERE c.publish_up > '2020-04-26 06:31:35'
      AND c.publish_up < '2020-05-26 06:31:35'
      AND c.state='1'
  19. SELECT count(DISTINCT e.id)
      FROM jos_events AS e
      WHERE e.created > '2020-04-26 06:31:35'
      AND e.created < '2020-05-26 06:31:35'
      AND scope='events'
  20. SELECT COUNT(*)
      FROM `jos_kb_articles` AS f
      LEFT JOIN `jos_categories` AS c
      ON c.id = f.category
      WHERE f.state=1
      AND c.published = 1
      AND f.created > ''
      AND f.created < '2020-05-26 06:31:35'
      AND f.access IN (1,1,4)
  21. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  22. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '68'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  23. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '76'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  24. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '73'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  25. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '6'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  26. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '72'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  27. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '9'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  28. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '69'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  29. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '66'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  30. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '67'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  31. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '10'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  32. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '3'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  33. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '1'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  34. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '31'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  35. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '39'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  36. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '7'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  37. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '77'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  38. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`type` = '2'
      AND `jos_resources`.`access` IN ('0','3')
      AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
      AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  40. SELECT *
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`created` >= '2020-04-26 06:31:35'
      AND `jos_wiki_pages`.`created` < '2020-05-26 06:31:35'
      ORDER BY `created` DESC
  41. SHOW FULL COLUMNS
      FROM `jos_publications`
  42. 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 (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2020-05-26 06:31:35')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2020-05-26 06:31:35')
      AND V.published_up > '2020-04-26 06:31:35'
      AND V.published_up < '2020-05-26 06:31:35'
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id
  43. SELECT c.id, c.title, c.alias, c.created, b.path, CONCAT(c.introtext, c.fulltext) AS text, CONCAT('index.php?option=com_content&task=view&id=', c.id) AS href, NULL AS fsection, b.alias AS category, 'content' AS section, NULL AS subsection
      FROM jos_content AS c
      INNER JOIN jos_categories AS b
      ON b.id=c.catid
      WHERE c.publish_up > '2020-04-26 06:31:35'
      AND c.publish_up < '2020-05-26 06:31:35'
      AND c.state='1'
      ORDER BY publish_up DESC, title
      LIMIT 0,5
  44. SELECT e.id, e.title, NULL AS alias, e.content AS itext, NULL AS ftext, e.state, e.created, e.modified, e.publish_up, NULL AS params, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, NULL AS area, NULL AS category, NULL AS rating, NULL AS times_rated, NULL AS ranking
      FROM jos_events AS e
      WHERE e.created > '2020-04-26 06:31:35'
      AND e.created < '2020-05-26 06:31:35'
      AND scope='events'
      ORDER BY publish_up DESC, title
      LIMIT 0,5
  45. SELECT f.id, f.title, f.fulltxt AS `text`, concat('index.php?option=com_kb&section=', coalesce(concat(c.path, '/'), ''), f.alias) AS href, 'kb' AS section, c.alias AS subsection
      FROM `jos_kb_articles` AS f
      LEFT JOIN `jos_categories` AS c
      ON c.id = f.category
      WHERE f.state=1
      AND c.published = 1
      AND f.created > ''
      AND f.created < '2020-05-26 06:31:35'
      AND f.access IN (1,1,4)
      ORDER BY f.created DESC, f.title
      LIMIT 0,5
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  47. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  48. SELECT *
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`created` >= '2020-04-26 06:31:35'
      AND `jos_wiki_pages`.`created` < '2020-05-26 06:31:35'
      ORDER BY `created` DESC
      LIMIT 5
  49. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '1539';
  50. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1539') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1539') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1539') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1539')
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  52. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`id` = '385'
  53. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '1538';
  54. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1538') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1538') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1538') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1538')
  55. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`id` = '384'
  56. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '1537';
  57. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1537') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1537') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1537') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1537')
  58. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`id` = '383'
  59. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '1536';
  60. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1536') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1536') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1536') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1536')
  61. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`id` = '382'
  62. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '1535';
  63. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1535') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1535') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1535') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1535')
  64. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`id` = '381'
  65. 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 (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2020-05-26 06:31:36')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2020-05-26 06:31:36')
      AND V.published_up > '2020-04-26 06:31:35'
      AND V.published_up < '2020-05-26 06:31:35'
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id
      ORDER BY V.published_up DESC
      LIMIT 0, 5
  66. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  67. 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-05-26 06:31:36' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-26 06:31:36' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '20' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  68. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  69. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  70. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  71. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  72. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  73. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  74. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590474695;s:18:\"session.timer.last\";i:1590474695;s:17:\"session.timer.now\";i:1590474695;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\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.ssid\";s:32:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.rsid\";s:32:\"d106e884008fb99475cfc24300b4166b\";}',`time` = '1590474696',`ip` = '10.111.11.10'
      WHERE `session_id` = 'd106e884008fb99475cfc24300b4166b'

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 17 × SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
  2. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  3. 5 × SELECT *
      FROM `jos_wiki_versions`
  4. 5 × SELECT *
      FROM `jos_xgroups`
  5. 2 × SELECT data
      FROM `jos_session`
  6. 2 × SELECT *
      FROM `jos_wiki_pages`
  7. 1 × 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
  8. 1 × SELECT e.id, e.title, NULL AS alias, e.content AS itext, NULL AS ftext, e.state, e.created, e.modified, e.publish_up, NULL AS params, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, NULL AS area, NULL AS category, NULL AS rating, NULL AS times_rated, NULL AS ranking
      FROM jos_events AS e
  9. 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
  10. 1 × SELECT f.id, f.title, f.fulltxt AS `text`, concat('index.php?option=com_kb&section=', coalesce(concat(c.path, '/'), ''), f.alias) AS href, 'kb' AS section, c.alias AS subsection
      FROM `jos_kb_articles` AS f
      LEFT JOIN `jos_categories` AS c
      ON c.id = f.category
  11. 1 × 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
  12. 1 × SELECT count(DISTINCT e.id)
      FROM jos_events AS e
  13. 1 × SELECT *
      FROM `jos_viewlevels
  14. 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
  15. 1 × SELECT session_id
      FROM `jos_session`
  16. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  17. 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
  18. 1 × SELECT *
      FROM `jos_resource_types`
  19. 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
  20. 1 × SELECT COUNT(*)
      FROM `jos_kb_articles` AS f
      LEFT JOIN `jos_categories` AS c
      ON c.id = f.category
OTHER Tables:
  1. 5 × (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
  2. 2 × ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
  3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('d106e884008fb99475cfc24300b4166b','0','1590474695','10.111.11.10'
  4. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590474695;s:18:\"session.timer.last\";i:1590474695;s:17:\"session.timer.now\";i:1590474695;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\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.ssid\";s:32:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.rsid\";s:32:\"d106e884008fb99475cfc24300b4166b\";}',`time` = '1590474696',`ip` = '10.111.11.10'
  5. 1 × SELECT c.id, c.title, c.alias, c.created, b.path, CONCAT(c.introtext, c.fulltext) AS text, CONCAT('index.php?option=com_content&task=view&id=', c.id) AS href, NULL AS fsection, b.alias AS category, 'content' AS section, NULL AS subsection
      FROM jos_content AS c
      INNER JOIN jos_categories AS b
      ON b.id=c.catid
  6. 1 × SHOW FULL COLUMNS
      FROM `jos_publications
  7. 1 × DELETE
      FROM `jos_session`
  8. 1 × SELECT count(DISTINCT c.id)
      FROM jos_content AS c
      INNER JOIN jos_categories AS b
      ON b.id=c.catid
  • 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
  • onWhatsnewAreas Method plgWhatsnewContent::onWhatsnewAreas /core/plugins/whatsnew/content/content.php:28
  • onWhatsnewAreas Method plgWhatsnewEvents::onWhatsnewAreas /core/plugins/whatsnew/events/events.php:28
  • onWhatsnewAreas Method plgWhatsnewKb::onWhatsnewAreas /core/plugins/whatsnew/kb/kb.php:28
  • onWhatsnewAreas Method plgWhatsnewResources::onWhatsnewAreas /core/plugins/whatsnew/resources/resources.php:63
  • onWhatsnewAreas Method plgWhatsnewWiki::onWhatsnewAreas /core/plugins/whatsnew/wiki/wiki.php:28
  • onWhatsnewAreas Method plgWhatsnewPublications::onWhatsnewAreas /core/plugins/whatsnew/publications/publications.php:65
  • onWhatsnew Method plgWhatsnewContent::onWhatsnew /core/plugins/whatsnew/content/content.php:45
  • onWhatsnew Method plgWhatsnewEvents::onWhatsnew /core/plugins/whatsnew/events/events.php:45
  • onWhatsnew Method plgWhatsnewKb::onWhatsnew /core/plugins/whatsnew/kb/kb.php:45
  • onWhatsnew Method plgWhatsnewResources::onWhatsnew /core/plugins/whatsnew/resources/resources.php:102
  • onWhatsnew Method plgWhatsnewWiki::onWhatsnew /core/plugins/whatsnew/wiki/wiki.php:45
  • onWhatsnew Method plgWhatsnewPublications::onWhatsnew /core/plugins/whatsnew/publications/publications.php:82
  • 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