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

  6. Frequently Asked Questions

    What are tags? How do I create a new tag? How can I delete a tag? How can I remove a tag from a resource/group/my profile/etc? Is there a limit on the number of tags I can add to an item? Can I...

    https://datacenterhub.org/kb/tags/faq

  7. Frequently Asked Questions

    What are resources?How do I upload a new resource?How can I delete a resource?Is there a limit on the number of resources I can submit?What are resources?Think of a hub as an empty library....

    https://datacenterhub.org/kb/resources/faq

  8. Customize your dashboard page

    To change your dashboard page, simply click the Personalize button located in the upper-right corner of that page. The page will enter a customization mode where you may move modules around by...

    https://datacenterhub.org/kb/tips/personalize

  9. Frequently Asked Questions

    What is Group Discoverability? What is Group Membership Access? How to Customize a Group? What are Group Plugin Access Levels? How are groups managed? How do I leave a group? How do I delete a...

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

  10. Help! I'm getting a Java error!

    Users may experience a Java error on Mac OS X if they are using Java version 1.3 and below. Please ensure your Java install is up to date.NOTE! For gecko browsers (Mozilla, Firefox, Camino), the...

    https://datacenterhub.org/kb/tools/javaerr

  11. How do I change my password?

    We have multiple methods available to help you change your password. If you can't remember your password, go to the forgot password page to reset it. If you're already logged in, and simply wish to...

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

  12. How do I change my username?

    Sorry, but login names cannot be changed. If this is poses a serious problem for you, please contact our support team.

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

  13. How to Enable Cookies

    In order to log in to this site, you must enable cookies in your browser. Instructions for enabling cookies in common browsers are listed below. If your browser is not listed, please check its...

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

  14. How to enable pop-ups?

    Web pages can use the JavaScript language to automatically force the your web browser to open new windows. This capability has often been abused by advertising sites and many browsers disable the...

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

  15. How to use WebDAV to access your hub storage

    WebDAV is the Distributed Authoring and Versioning extension to the standard HTTP/HTTPS web protocol. It allows a client to browse a remote filesystem, usually with a graphical browser that makes...

    https://datacenterhub.org/kb/tips/webdav

  16. How to View/Download Video Content?

    This hub relies on two formats of video files, MP4 (MPEG-4) mostly used for podcasts but also can be viewed directly on your computer, and Windows Media Player which is used by older lectures and...

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

  17. I registered but cannot log in!

    If this is a new account, you won't be able to log in until you've confirmed your e-mail address. Right after you registered, you should have received an e-mail at the address that you registered...

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

  18. I registered in the past but cannot log in anymore!

    You may have entered an incorrect username or password. If you've forgotten either one, you can recover your username or recover your password. Just fill out the form, and we'll send your account...

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

  19. I've lost my password!

    Don't panic! We can reset your password and send instructions to the e-mail address that you have on file with us. Then, you can follow the instructions, log in to the site, and change your...

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

  20. Rate a Resource

    Rating a resource is quick and easy.Every resource has two sets of stars: the average rating and your rating. If you haven't rated a resource, you're rating will show up as a set of slightly grayed...

    https://datacenterhub.org/kb/tips/rate

Debug Console

Close20 MBRequestSessionTimelineDatabase54Events27
$_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 => /whatsnew/kb:month,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/whatsnew/kb:month,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /whatsnew/kb:month,
SCRIPT_URI => https://datacenterhub.org/whatsnew/kb:month,
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 => Sun, 05 Apr 2020 16:59:17 UTC,
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 => 18.206.194.134,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 38850,
REDIRECT_URL => /whatsnew/kb:month,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /whatsnew/kb:month,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1594262555.1519,
REQUEST_TIME => 1594262555,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid b4345bb4aea616b1a6f76a1c9846b214
tracker.ssid b4345bb4aea616b1a6f76a1c9846b214
tracker.rsid b4345bb4aea616b1a6f76a1c9846b214
  • site 0.045 seconds (+0.045); 12.25 MB (+12.250) - afterInitialise
  • site 0.064 seconds (+0.019); 13.50 MB (+1.250) - afterRoute
  • site 0.234 seconds (+0.171); 19.50 MB (+6.000) - afterDispatch
  • site 0.243 seconds (+0.008); 19.75 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.244 seconds (+0.001); 19.75 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.244 seconds (+0.000); 19.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.259 seconds (+0.015); 20.25 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.264 seconds (+0.005); 20.50 MB (+0.250) - onAfterRender
  • site 0.266 seconds (+0.002); 20.50 MB (0.000) - sessionStore
20 MB

54 Queries Logged: 0.10412979125977 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '36cdaca211845e109c3e1a87f85a39aa'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '36cdaca211845e109c3e1a87f85a39aa'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'b4345bb4aea616b1a6f76a1c9846b214'
  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` = 'b4345bb4aea616b1a6f76a1c9846b214'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('b4345bb4aea616b1a6f76a1c9846b214','0','1594262555','18.206.194.134')
  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_whatsnew'
  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_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-06-09 02:42:35'
      AND c.publish_up < '2020-07-09 02:42:35'
      AND c.state='1'
  19. SELECT count(DISTINCT e.id)
      FROM jos_events AS e
      WHERE e.created > '2020-06-09 02:42:35'
      AND e.created < '2020-07-09 02:42: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-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_resources`.`publish_up` < '2020-07-09 02:42: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-06-09 02:42:35'
      AND `jos_wiki_pages`.`created` < '2020-07-09 02:42: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-07-09 02:42:35')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2020-07-09 02:42:35')
      AND V.published_up > '2020-06-09 02:42:35'
      AND V.published_up < '2020-07-09 02:42:35'
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id
  43. 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-07-09 02:42:35'
      AND f.access IN (1,1,4)
      ORDER BY f.created DESC, f.title
      LIMIT 0,20
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  46. 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-07-09 02:42:35' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-07-09 02:42:35' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '94' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  50. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  52. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  53. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  54. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594262555;s:18:\"session.timer.last\";i:1594262555;s:17:\"session.timer.now\";i:1594262555;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:\"b4345bb4aea616b1a6f76a1c9846b214\";s:12:\"tracker.ssid\";s:32:\"b4345bb4aea616b1a6f76a1c9846b214\";s:12:\"tracker.rsid\";s:32:\"b4345bb4aea616b1a6f76a1c9846b214\";}',`time` = '1594262555',`ip` = '18.206.194.134'
      WHERE `session_id` = 'b4345bb4aea616b1a6f76a1c9846b214'

22 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. 2 × SELECT data
      FROM `jos_session`
  4. 1 × SELECT COUNT(*)
      FROM `jos_kb_articles` AS f
      LEFT JOIN `jos_categories` AS c
      ON c.id = f.category
  5. 1 × SELECT *
      FROM `jos_wiki_pages`
  6. 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
  7. 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
  8. 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
  9. 1 × SELECT count(DISTINCT e.id)
      FROM jos_events AS e
  10. 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
  11. 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
  12. 1 × SELECT session_id
      FROM `jos_session`
  13. 1 × SELECT *
      FROM `jos_viewlevels
  14. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  15. 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
  16. 1 × SELECT *
      FROM `jos_resource_types`
OTHER Tables:
  1. 1 × SHOW FULL COLUMNS
      FROM `jos_publications
  2. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594262555;s:18:\"session.timer.last\";i:1594262555;s:17:\"session.timer.now\";i:1594262555;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:\"b4345bb4aea616b1a6f76a1c9846b214\";s:12:\"tracker.ssid\";s:32:\"b4345bb4aea616b1a6f76a1c9846b214\";s:12:\"tracker.rsid\";s:32:\"b4345bb4aea616b1a6f76a1c9846b214\";}',`time` = '1594262555',`ip` = '18.206.194.134'
  3. 1 × ( 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
  4. 1 × SELECT count(DISTINCT c.id)
      FROM jos_content AS c
      INNER JOIN jos_categories AS b
      ON b.id=c.catid
  5. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('b4345bb4aea616b1a6f76a1c9846b214','0','1594262555','18.206.194.134'
  6. 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
  • 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