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 academic proof-of-concept testing phase. All email addresses that end in .edu will be automatically approved. All others will be approved on a case by case basis. We desire to hear as much feedback as possible. Please send us feedback/questions/comments through the ticketing system found here or within SMILE. Thank you.

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

Debug Console

Close14 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_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 => 35.175.182.106,
DOCUMENT_ROOT => /var/www/smm,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/smm/index.php,
REMOTE_PORT => 35588,
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 => 1544816690.12,
REQUEST_TIME => 1544816690
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid eebc9a96544682f29bdc408c5ebb9f55
tracker.ssid eebc9a96544682f29bdc408c5ebb9f55
tracker.rsid eebc9a96544682f29bdc408c5ebb9f55
session.token cd1f4e363ac70b52237632631036cff0
  • site 0.046 seconds (+0.046); 9.00 MB (+9.000) - afterInitialise
  • site 0.062 seconds (+0.016); 10.25 MB (+1.250) - afterRoute
  • site 0.099 seconds (+0.036); 13.00 MB (+2.750) - beforeRenderModule mod_toptags (Browse Content by Tags)
  • site 0.105 seconds (+0.006); 13.75 MB (+0.750) - afterRenderModule mod_toptags (Browse Content by Tags)
  • site 0.108 seconds (+0.003); 13.75 MB (0.000) - afterDispatch
  • site 0.115 seconds (+0.007); 14.00 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.116 seconds (+0.001); 14.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.116 seconds (+0.000); 14.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.117 seconds (+0.001); 14.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.117 seconds (+0.000); 14.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.118 seconds (+0.001); 14.25 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.118 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_custom (Welcome)
  • site 0.119 seconds (+0.000); 14.25 MB (0.000) - afterRenderModule mod_custom (Welcome)
  • site 0.119 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.122 seconds (+0.003); 14.25 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.122 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.124 seconds (+0.001); 14.25 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.124 seconds (+0.000); 14.25 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.132 seconds (+0.008); 14.50 MB (+0.250) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.134 seconds (+0.002); 14.50 MB (0.000) - onAfterRender
  • site 0.136 seconds (+0.002); 14.50 MB (0.000) - sessionStore
14 MB

28 Queries Logged: 0.011267185211182 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1ebf75dd384c0cf81dce0e48d9699603'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '1ebf75dd384c0cf81dce0e48d9699603'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'eebc9a96544682f29bdc408c5ebb9f55'
  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` = 'eebc9a96544682f29bdc408c5ebb9f55'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('eebc9a96544682f29bdc408c5ebb9f55','0','1544816690','35.175.182.106')
  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 *
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
  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.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,(0) as contactid,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 <= '2018-12-14 19:44:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-14 19:44:50')
      AND (a.state = 1 OR a.state =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
  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` <= '2018-12-14 19:44:50' )
      AND (`m`.`publish_down` = '0000-00-00 00:00:00' OR `m`.`publish_down` >= '2018-12-14 19:44:50' )
      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:1544816690;s:18:\"session.timer.last\";i:1544816690;s:17:\"session.timer.now\";i:1544816690;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:\"eebc9a96544682f29bdc408c5ebb9f55\";s:12:\"tracker.ssid\";s:32:\"eebc9a96544682f29bdc408c5ebb9f55\";s:12:\"tracker.rsid\";s:32:\"eebc9a96544682f29bdc408c5ebb9f55\";s:13:\"session.token\";s:32:\"cd1f4e363ac70b52237632631036cff0\";}',`time` = '1544816690',`ip` = '35.175.182.106'
      WHERE `session_id` = 'eebc9a96544682f29bdc408c5ebb9f55'
  • 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