Support

Support Options

Report a problem

About you
About the problem

Help!

The open source platform for scientific and educational collaboration

Social Media Macroscope

The Social Media Macroscope is a project by University of Illinois Technology Services and the National Center for Supercomputing Applications (NCSA) with the goal of making social media data, analytics, and visualization tools accessible to researchers and students of all levels of expertise. More information about this project can be found at: https://doi.org/10.6084/m9.figshare.6855269.v2

Login/Register View Available Tools

This tool is now in an open proof-of-concept testing phase. We desire to hear as much feedback as possible. Please send us feedback/questions/comments through the ticketing system found here or within the tools. Thank you.

  • Copyright © 2018 Social Media Macroscope
  • Powered by HUBzero®

Debug Console

Close15 MBRequestSessionTimelineDatabase28Events22
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /var/www, FCGI_ROLE => RESPONDER, SCRIPT_URL => /, SCRIP... Array(
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
SCRIPT_URL => /,
SCRIPT_URI => https://socialmediamacroscope.org/,
HTTPS => on,
SSL_TLS_SNI => socialmediamacroscope.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_IF_MODIFIED_SINCE => Wed, 23 Jan 2019 20:19:13 GMT,
HTTP_HOST => socialmediamacroscope.org,
HTTP_CONNECTION => Keep-Alive,
HTTP_ACCEPT_ENCODING => gzip,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.2.15 (Red Hat),
SERVER_NAME => socialmediamacroscope.org,
SERVER_ADDR => 10.65.128.100,
SERVER_PORT => 443,
REMOTE_ADDR => 18.206.175.155,
DOCUMENT_ROOT => /var/www/smm,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/smm/index.php,
REMOTE_PORT => 43918,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1550405158.8064,
REQUEST_TIME => 1550405158
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid d5677697276650d16e7bc031d209b73b
tracker.ssid d5677697276650d16e7bc031d209b73b
tracker.rsid d5677697276650d16e7bc031d209b73b
session.token f421bf7696e0b498b773233c51ad5ca5
  • site 0.045 seconds (+0.045); 9.25 MB (+9.250) - afterInitialise
  • site 0.061 seconds (+0.016); 10.75 MB (+1.500) - afterRoute
  • site 0.095 seconds (+0.034); 13.25 MB (+2.500) - beforeRenderModule mod_toptags (Browse Content by Tags)
  • site 0.101 seconds (+0.006); 13.75 MB (+0.500) - afterRenderModule mod_toptags (Browse Content by Tags)
  • site 0.104 seconds (+0.003); 14.00 MB (+0.250) - afterDispatch
  • site 0.111 seconds (+0.007); 14.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.112 seconds (+0.001); 14.25 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.112 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.113 seconds (+0.001); 14.25 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.114 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.115 seconds (+0.001); 14.25 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.115 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_custom (Welcome)
  • site 0.115 seconds (+0.000); 14.25 MB (0.000) - afterRenderModule mod_custom (Welcome)
  • site 0.115 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.119 seconds (+0.003); 14.25 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.119 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.120 seconds (+0.001); 14.50 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.120 seconds (+0.000); 14.50 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.128 seconds (+0.008); 14.75 MB (+0.250) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.130 seconds (+0.002); 14.75 MB (0.000) - onAfterRender
  • site 0.131 seconds (+0.002); 14.75 MB (0.000) - sessionStore
15 MB

28 Queries Logged: 0.010911703109741 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '945e6234ffdf93eabecc06b197627e41'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '945e6234ffdf93eabecc06b197627e41'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'd5677697276650d16e7bc031d209b73b'
  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` = 'd5677697276650d16e7bc031d209b73b'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('d5677697276650d16e7bc031d209b73b','0','1550405158','18.206.175.155')
  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_content'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  15. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  16. 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` = 'com_content'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  17. SELECT a.*,a.id,a.asset_id,a.title,a.alias,a.title_alias,a.introtext,a.fulltext,
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state,a.mask,a.catid,a.created,a.created_by,a.created_by_alias,
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END AS modified,a.modified_by,a.checked_out,a.checked_out_time,a.publish_up,a.publish_down,a.images,a.urls,a.attribs,a.version,a.parentid,a.ordering,a.metakey,a.metadesc,a.access,a.hits,a.metadata,a.featured,a.language,a.xreference,c.title AS category_title,c.alias AS category_alias,c.access AS category_access,u.name AS author,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating,v.rating_count AS rating_count
      FROM `jos_content` AS `a`
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE `a`.`id` = '1'
      AND (`a`.`publish_up` = '0000-00-00 00:00:00' OR `a`.`publish_up` <= '2019-02-17 12:05:58' )
      AND (`a`.`publish_down` = '0000-00-00 00:00:00' OR `a`.`publish_down` >= '2019-02-17 12:05:58' )
      AND `a`.`state` IN ('1','2')
  18. SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (`c`.`extension` = 'com_content' OR `c`.`extension` = 'system' )
      AND `c`.`access` IN ('1','1','4')
      AND `c`.`published` = '1'
      AND `s`.`id` = '2'
      AND badcats.id is null
      GROUP BY c.id,c.asset_id,c.access,c.alias,c.checked_out,c.checked_out_time,c.created_time,c.created_user_id,c.description,c.extension,c.hits,c.language,c.level,c.lft,c.metadata,c.metadesc,c.metakey,c.modified_time,c.note,c.params,c.parent_id,c.path,c.published,c.rgt,c.title,c.modified_user_id
      ORDER BY `c`.`lft` ASC
  19. 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` = '0000-00-00 00:00:00' OR `m`.`publish_up` <= '2019-02-17 12:05:58' )
      AND (`m`.`publish_down` = '0000-00-00 00:00:00' OR `m`.`publish_down` >= '2019-02-17 12:05:58' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '100' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  21. SELECT *
      FROM `jos_tags`
      WHERE `jos_tags`.`admin` = '0'
      ORDER BY `objects` DESC
      LIMIT 25
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  28. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550405158;s:18:\"session.timer.last\";i:1550405158;s:17:\"session.timer.now\";i:1550405158;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}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:\"d5677697276650d16e7bc031d209b73b\";s:12:\"tracker.ssid\";s:32:\"d5677697276650d16e7bc031d209b73b\";s:12:\"tracker.rsid\";s:32:\"d5677697276650d16e7bc031d209b73b\";s:13:\"session.token\";s:32:\"f421bf7696e0b498b773233c51ad5ca5\";}',`time` = '1550405158',`ip` = '18.206.175.155'
      WHERE `session_id` = 'd5677697276650d16e7bc031d209b73b'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:49
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:59
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:50
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:130
  • onContentBeforeDisplay Method plgContentPagenavigation::onContentBeforeDisplay /core/plugins/content/pagenavigation/pagenavigation.php:49
  • onContentBeforeDisplay Method plgContentVote::onContentBeforeDisplay /core/plugins/content/vote/vote.php:57
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:47
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:87
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:49
  • onDisplay Method plgCaptchaRecaptcha::onDisplay /core/plugins/captcha/recaptcha/recaptcha.php:98
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45