You must login before you can run this tool.
Workspace
Workspace
Workspace
You must login before you can run this tool.
Version 1.1 - published on 28 Aug 2012
Find information on common issues.
Ask questions and find answers from other users.
Suggest a new site feature or improvement.
Check on status of your tickets.
REDIRECT_UNIQUE_ID => Wy@st4AuE9gAD7dWSrMAAAAN, REDIRECT_SCRIPT_URL => /resources/workspace, REDIRECT_SCRIPT_URI => https://vhub.org/resources/workspace, REDIRECT_nokeepalive => REDIRECT_HTTPS => on, REDIRECT_SSL_TLS_SNI => vhub.org, REDIRECT_STATUS => 200, UNIQUE_ID => Wy@st4AuE9gAD7dWSrMAAAAN, SCRIPT_URL => /resources/workspace, SCRIPT_URI => https://vhub.org/resources/workspace, nokeepalive => HTTPS => on, SSL_TLS_SNI => vhub.org, HTTP_HOST => vhub.org, HTTP_ACCEPT_ENCODING => x-gzip, gzip, deflate, HTTP_USER_AGENT => CCBot/2.0 (http://commoncrawl.org/faq/), HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8, HTTP_IF_MODIFIED_SINCE => Sat, 24 Feb 2018 04:19:40 GMT, HTTP_CONNECTION => close, PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin, SERVER_SIGNATURE => SERVER_SOFTWARE => Apache, SERVER_NAME => vhub.org, SERVER_ADDR => 128.46.19.216, SERVER_PORT => 443, REMOTE_ADDR => 54.145.103.69, DOCUMENT_ROOT => /www/vhub, REQUEST_SCHEME => https, CONTEXT_PREFIX => CONTEXT_DOCUMENT_ROOT => /www/vhub, SERVER_ADMIN => nkissebe@purdue.edu, SCRIPT_FILENAME => /www/vhub/index.php, REMOTE_PORT => 51266, REDIRECT_URL => /resources/workspace, GATEWAY_INTERFACE => CGI/1.1, SERVER_PROTOCOL => HTTP/1.1, REQUEST_METHOD => GET, QUERY_STRING => REQUEST_URI => /resources/workspace, SCRIPT_NAME => /index.php, PHP_SELF => /index.php, REQUEST_TIME_FLOAT => 1529851063.06, REQUEST_TIME => 1529851063, argv => Array(
)
, argc => 0separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ bd6d7a11f51b89ecabc098ad6c74a702
tracker.ssid ⇒ bd6d7a11f51b89ecabc098ad6c74a702
tracker.rsid ⇒ bd6d7a11f51b89ecabc098ad6c74a702
securiy_code0 ⇒ 5121c
session.token ⇒ 05d82bc3c2432ac258cebd04bc70cb65
site 0.025 seconds (+0.025); 3.50 MB (+3.500) - afterInitialisesite 0.041 seconds (+0.016); 4.25 MB (+0.750) - afterRoutesite 0.180 seconds (+0.138); 10.25 MB (+6.000) - afterDispatchsite 1.211 seconds (+1.031); 30.75 MB (+20.500) - beforeRenderModule mod_search (Search Module)site 1.214 seconds (+0.003); 31.00 MB (+0.250) - afterRenderModule mod_search (Search Module)site 1.214 seconds (+0.000); 31.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)site 1.228 seconds (+0.013); 31.75 MB (+0.750) - afterRenderModule mod_reportproblems (Trouble Report)site 1.228 seconds (+0.000); 31.75 MB (0.000) - beforeRenderModule mod_custom (V template footer)site 1.229 seconds (+0.001); 31.75 MB (0.000) - afterRenderModule mod_custom (V template footer)site 1.229 seconds (+0.000); 31.75 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)site 1.233 seconds (+0.003); 31.75 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)site 1.233 seconds (+0.000); 31.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)site 1.243 seconds (+0.010); 31.75 MB (0.000) - afterRenderModule mod_menu (Main Menu)site 1.248 seconds (+0.005); 31.75 MB (0.000) - onAfterRendersite 1.252 seconds (+0.004); 31.75 MB (0.000) - sessionStoreSELECT data
FROM `jos_session`
WHERE `session_id` = '653e5a9c7bd0f970832eb61a1ac14651'DELETE
FROM`jos_session`
WHERE `session_id` = '653e5a9c7bd0f970832eb61a1ac14651'SELECT data
FROM `jos_session`
WHERE `session_id` = 'bd6d7a11f51b89ecabc098ad6c74a702'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT session_id
FROM `jos_session`
WHERE `session_id` = 'bd6d7a11f51b89ecabc098ad6c74a702'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('bd6d7a11f51b89ecabc098ad6c74a702','0','1529851063','54.145.103.69')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'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'SELECT *
FROM `jos_viewlevels`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` ASCSELECT 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` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASCSELECT 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` DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tools'SELECT *
FROM `jos_resources`
WHERE `jos_resources`.`alias` = 'workspace'SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`id` = '7'SHOW FULL COLUMNS
FROM `jos_tool_version`SHOW FULL COLUMNS
FROM `jos_tool_authors`SELECT v.*, d.*
FROM `jos_tool_version` as v
LEFT JOIN `jos_doi_mapping` as d
ON d.alias = v.toolname
AND d.local_revision=v.revision
WHERE v.toolname = 'workspace'
ORDER BY v.state DESC, v.revision DESCSELECT r.id
FROM `jos_tool` as t
LEFT JOIN `jos_resources` as r
ON r.alias = t.toolname
WHERE t.id='1' ;SELECT authorid as uidNumber
FROM `jos_author_assoc`
WHERE subid= '1'
AND subtable='resources'
ORDER BY orderingSELECT jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags.id = jos_tags_object.tagid
WHERE `jos_tags_object`.`label` != 'badge'
AND `jos_tags_object`.`tbl` = 'resources'
AND `jos_tags_object`.`objectid` = '1'
AND `jos_tags`.`admin` = '0'SELECT *
FROM `jos_screenshots`
WHERE `jos_screenshots`.`resourceid` = '1'
AND `jos_screenshots`.`versionid` = NULL
ORDER BY `ordering` ASCSELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
FROM `jos_tool_authors` AS t
LEFT JOIN `jos_users` AS n
ON n.id=t.uid JOIN `jos_tool_version` AS v
ON v.id=t.version_id
LEFT JOIN `jos_author_assoc` AS a
ON a.authorid=t.uid
AND a.subtable='resources'
AND a.subid='1'
WHERE t.toolname='workspace'
AND v.state<>3
AND t.revision='7'
ORDER BY t.orderingSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_citations'SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
FROM `jos_tool_authors` AS t
LEFT JOIN `jos_users` AS n
ON n.id=t.uid JOIN `jos_tool_version` AS v
ON v.id=t.version_id
LEFT JOIN `jos_author_assoc` AS a
ON a.authorid=t.uid
AND a.subtable='resources'
AND a.subid='1'
WHERE t.toolname='workspace'
AND v.state<>3
AND t.revision='7'
ORDER BY t.orderingSELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '1'
AND `jos_author_assoc`.`subtable` = 'resources'
ORDER BY `ordering` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'SELECT jos_answers_questions.*
FROM `jos_answers_questions`
INNER JOIN jos_tags_object
ON jos_tags_object.objectid = jos_answers_questions.id
INNER JOIN jos_tags
ON jos_tags.id = jos_tags_object.tagid
WHERE `jos_tags_object`.`tbl` = 'answers'
AND `jos_tags`.`tag` IN ('toolworkspace')
AND `jos_answers_questions`.`state` < '2'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'SELECT *
FROM `jos_citations`
INNER JOIN jos_citations_assoc
ON jos_citations_assoc.cid = jos_citations.id
WHERE `jos_citations`.`published` = '1'
AND `jos_citations_assoc`.`tbl` = 'resource'
AND `jos_citations_assoc`.`oid` = '1'
ORDER BY `jos_citations`.`affiliated` ASC,`jos_citations`.`year` DESCSELECT *
FROM `jos_resource_ratings`
WHERE `jos_resource_ratings`.`resource_id` = '1'
AND `jos_resource_ratings`.`state` IN ('1','3')
ORDER BY `created` DESCSHOW TABLESSELECT *
FROM `jos_resource_stats_tools`
WHERE `jos_resource_stats_tools`.`resid` = '1'
AND `jos_resource_stats_tools`.`period` = '14'
AND `jos_resource_stats_tools`.`datetime` LIKE '%2018-06-%%'SELECT *
FROM `jos_resource_stats_clusters`
WHERE `jos_resource_stats_clusters`.`resid` = '1'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wishlist'SELECT *
FROM `jos_wishlist`
WHERE `jos_wishlist`.`referenceid` = '1'
AND `jos_wishlist`.`category` = 'resource'SELECT *
FROM `jos_xgroups`
WHERE gidNumber = '1';SHOW FULL COLUMNS
FROM `jos_publications`SELECT V.*, C.id as id, C.category, C.master_type,
C.project_id, C.access as master_access, C.master_doi,
C.checked_out, C.checked_out_time, C.rating as master_rating,
C.ranking as master_ranking, C.times_rated as master_times_rated,
C.alias, V.id as version_id, C.group_owner,
t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url,
MT.alias as base, MT.curatorgroup, PP.alias as project_alias,
PP.title as project_title, PP.state as project_status,
PP.provisioned as project_provisioned,
PP.private as project_private,
PP.owned_by_group as project_group ,(SELECT vv.version_label
FROM jos_publication_versions as vv
WHERE vv.publication_id=C.id
AND (vv.state = 3 OR vv.state = 5)
LIMIT 1) AS dev_version_label ,(SELECT vv.state
FROM jos_publication_versions as vv
WHERE vv.publication_id=C.id
AND vv.main=1
ORDER BY vv.created DESC
LIMIT 1)
AS default_version_status ,(SELECT COUNT(*)
FROM jos_publication_versions
WHERE publication_id=C.id
AND state!=3 ) AS versions
FROM jos_publication_versions as V, jos_projects AS PP, jos_publication_master_types AS MT, jos_publications AS C JOIN jos_publication_categories AS t
ON C.category=t.id
WHERE V.publication_id=C.id
AND MT.id=C.master_type
AND PP.id=C.project_id
AND V.main=1
AND C.id='1'
LIMIT 1SELECT *
FROM `jos_resources`
WHERE `jos_resources`.`id` = '1'SELECT g.cn
FROM `jos_tool_groups` AS g
INNER JOIN `jos_xgroups` AS xg
ON g.cn=xg.cn
INNER JOIN `jos_tool` AS t
ON g.toolid=t.id
INNER JOIN `jos_resources` as r
ON r.alias = t.toolname
WHERE r.id = '1'
AND g.role=1SELECT *
FROM `jos_wishlist_ownergroups`
WHERE `jos_wishlist_ownergroups`.`wishlist` = '2'SELECT *
FROM `jos_xgroups`
WHERE cn = 'app-workspace';(select uidNumber, 'invitees' AS role
from jos_xgroups_invitees
where gidNumber='3001')
UNION
(select uidNumber, 'applicants' AS role
from jos_xgroups_applicants
where gidNumber='3001')
UNION
(select uidNumber, 'members' AS role
from jos_xgroups_members
where gidNumber='3001')
UNION
(select uidNumber, 'managers' AS role
from jos_xgroups_managers
where gidNumber='3001')SELECT *
FROM `jos_wishlist_owners`
WHERE `jos_wishlist_owners`.`wishlist` = '2'
AND `jos_wishlist_owners`.`type` != '2'SELECT COUNT(jos_wishlist_item.id) AS count
FROM `jos_wishlist_item`
WHERE `jos_wishlist_item`.`wishlist` = '2'
AND `jos_wishlist_item`.`status` != '2'
AND `jos_wishlist_item`.`private` = '0'SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
FROM `jos_tool_authors` AS t
LEFT JOIN `jos_users` AS n
ON n.id=t.uid JOIN `jos_tool_version` AS v
ON v.id=t.version_id
LEFT JOIN `jos_author_assoc` AS a
ON a.authorid=t.uid
AND a.subtable='resources'
AND a.subid='1'
WHERE t.toolname='workspace'
AND v.state<>3
AND t.revision='7'
ORDER BY t.orderingSHOW FULL COLUMNS
FROM `jos_resource_assoc`SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
FROM `jos_resources`
INNER JOIN jos_resource_assoc
ON jos_resources.id = child_id
WHERE `jos_resource_assoc`.`parent_id` = '1'
AND `jos_resources`.`published` = '1'
AND `jos_resources`.`standalone` = '0'
ORDER BY `ordering` ASCSELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lftSELECT 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_tools.1'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASCSELECT *
FROM `jos_assets`
WHERE `jos_assets`.`parent_id` = '0'SELECT *
FROM `jos_assets`
WHERE `jos_assets`.`id` = '1'SHOW TABLESSELECT *
FROM jos_tool_version
WHERE instance='workspace_r7';SELECT alias
FROM jos_tool_version_alias AS aux
WHERE aux.tool_version_id='99'
ORDER BY alias ASC;SELECT middleware
FROM jos_tool_version_middleware AS aux
WHERE aux.tool_version_id='99'
ORDER BY middleware ASC;SELECT hostreq
FROM jos_tool_version_hostreq AS aux
WHERE aux.tool_version_id='99'
ORDER BY hostreq ASC;SELECT uid
FROM jos_tool_authors
WHERE version_id='99'
ORDER BY ordering ASC;SELECT cn
FROM jos_tool_groups
WHERE role='0'
AND toolid='1'
ORDER BY cn ASC;SELECT cn
FROM jos_tool_groups
WHERE (role='1' OR role='2')
AND toolid='1'
ORDER BY cn ASC;SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
FROM jos_tool
WHERE id='1';SELECT instance
FROM jos_tool_version AS aux
WHERE aux.toolid='1'
ORDER BY version ASC;SELECT tv.toolname, tg.cn
FROM `jos_tool_groups` AS tg, `jos_tool_version` AS tv
WHERE tg.toolid = tv.toolid
AND tg.toolid='1'
AND role=0
AND tv.instance='workspace_r7'
AND tv.toolaccess='@
GROUP'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
ORDER BY description, cnSELECT k.*
FROM ((SELECT v.id, v.page_id AS pageid, MAX(v.version) AS version, w.title, w.pagename AS alias, v.pagetext AS introtext,
NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
FROM `jos_wiki_pages` AS w
JOIN `jos_wiki_versions` AS v
ON w.id=v.page_id
JOIN `jos_wiki_links` AS wl
ON wl.page_id=w.id
WHERE v.approved=1
AND wl.scope='resource'
AND wl.scope_id='1'
AND w.access!=1
GROUP BY pageid
ORDER BY ranking DESC, title
LIMIT 10) UNION (SELECT DISTINCT r.id, NULL AS pageid, NULL AS version, r.title, r.alias, r.introtext, r.type, r.published, r.publish_up,
NULL AS scope, r.rating, r.times_rated, r.ranking, rt.type AS section
FROM `jos_resource_types` AS rt, `jos_resources` AS r
JOIN `jos_resource_assoc` AS a
ON r.id=a.parent_id
LEFT JOIN `jos_resource_types` AS t
ON r.logical_type=t.id
WHERE r.published=1
AND a.child_id='1'
AND r.type=rt.id
AND r.type!=8
AND r.access=0
ORDER BY r.ranking
LIMIT 10)) AS k
ORDER BY ranking DESC
LIMIT 10SELECT *
FROM `jos_resource_sponsors`
WHERE `jos_resource_sponsors`.`state` = '1'SELECT jos_tags_object.label,jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags_object.tagid = jos_tags.id
WHERE `jos_tags_object`.`tbl` = 'resources'
AND `jos_tags_object`.`objectid` = '1'
GROUP BY jos_tags.idSELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`id` = '7'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-06-24 14:37:43'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2018-06-24 14:37:43'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '4'
OR `mm`.`menuid` <= '0'
)
ORDER BY `m`.`position` ASC,`m`.`ordering` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_support'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_usage'UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1529851063;s:18:\"session.timer.last\";i:1529851063;s:17:\"session.timer.now\";i:1529851063;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\":2:{s:6:\"Models\";O:8:\"stdClass\":3:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:10:\"Screenshot\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}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:\"bd6d7a11f51b89ecabc098ad6c74a702\";s:12:\"tracker.ssid\";s:32:\"bd6d7a11f51b89ecabc098ad6c74a702\";s:12:\"tracker.rsid\";s:32:\"bd6d7a11f51b89ecabc098ad6c74a702\";s:13:\"securiy_code0\";s:5:\"5121c\";s:13:\"session.token\";s:32:\"05d82bc3c2432ac258cebd04bc70cb65\";}',`time` = '1529851064',`ip` = '54.145.103.69'
WHERE `session_id` = 'bd6d7a11f51b89ecabc098ad6c74a702'15 × SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`3 × SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
FROM `jos_tool_authors` AS t
LEFT JOIN `jos_users` AS n
ON n.id=t.uid JOIN `jos_tool_version` AS v
ON v.id=t.version_id
LEFT JOIN `jos_author_assoc` AS a
ON a.authorid=t.uid
AND a.subtable='resources'
AND a.subid='1'3 × SELECT *
FROM `jos_resource_types`2 × SELECT *
FROM `jos_resources`2 × SELECT *
FROM `jos_assets`2 × SELECT cn
FROM jos_tool_groups2 × SELECT data
FROM `jos_session`2 × SELECT *
FROM `jos_xgroups`1 × SELECT alias
FROM jos_tool_version_alias AS aux1 × SELECT middleware
FROM jos_tool_version_middleware AS aux1 × SELECT hostreq
FROM jos_tool_version_hostreq AS aux1 × SELECT *
FROM jos_tool_version1 × SELECT b.id
FROM `jos_usergroups` AS `a`
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
FROM `jos_resources`
INNER JOIN jos_resource_assoc
ON jos_resources.id = child_id1 × SELECT a.rules
FROM `jos_assets` AS `a`1 × SELECT b.rules
FROM `jos_assets` AS `a`
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT uid
FROM jos_tool_authors1 × SELECT session_id
FROM `jos_session`1 × SELECT *
FROM `jos_resource_sponsors`1 × SELECT jos_tags_object.label,jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags_object.tagid = jos_tags.id1 × 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_id1 × SELECT k.*
FROM ((SELECT v.id, v.page_id AS pageid, MAX(v.version) AS version, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
FROM `jos_wiki_pages` AS w JOIN `jos_wiki_versions` AS v
ON w.id=v.page_id JOIN `jos_wiki_links` AS wl
ON wl.page_id=w.id1 × 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 m1 × SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
FROM jos_tool1 × SELECT instance
FROM jos_tool_version AS aux1 × SELECT tv.toolname, tg.cn
FROM `jos_tool_groups` AS tg, `jos_tool_version` AS tv1 × SELECT COUNT(jos_wishlist_item.id) AS count
FROM `jos_wishlist_item`1 × SELECT *
FROM `jos_wishlist_owners`1 × SELECT *
FROM `jos_screenshots`1 × SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`1 × SELECT *
FROM `jos_author_assoc`1 × SELECT jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags.id = jos_tags_object.tagid1 × SELECT authorid as uidNumber
FROM `jos_author_assoc`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_id1 × SELECT v.*, d.*
FROM `jos_tool_version` as v
LEFT JOIN `jos_doi_mapping` as d
ON d.alias = v.toolname
AND d.local_revision=v.revision1 × SELECT r.id
FROM `jos_tool` as t
LEFT JOIN `jos_resources` as r
ON r.alias = t.toolname1 × SELECT jos_answers_questions.*
FROM `jos_answers_questions`
INNER JOIN jos_tags_object
ON jos_tags_object.objectid = jos_answers_questions.id
INNER JOIN jos_tags
ON jos_tags.id = jos_tags_object.tagid1 × SELECT *
FROM `jos_citations`
INNER JOIN jos_citations_assoc
ON jos_citations_assoc.cid = jos_citations.id1 × SELECT V.*, C.id as id, C.category, C.master_type, C.project_id, C.access as master_access, C.master_doi, C.checked_out, C.checked_out_time, C.rating as master_rating, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, C.group_owner, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, MT.alias as base, MT.curatorgroup, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.provisioned as project_provisioned, PP.private as project_private, PP.owned_by_group as project_group ,(SELECT vv.version_label
FROM jos_publication_versions as vv1 × SELECT g.cn
FROM `jos_tool_groups` AS g
INNER JOIN `jos_xgroups` AS xg
ON g.cn=xg.cn
INNER JOIN `jos_tool` AS t
ON g.toolid=t.id
INNER JOIN `jos_resources` as r
ON r.alias = t.toolname1 × SELECT *
FROM `jos_wishlist_ownergroups`1 × SELECT *
FROM `jos_viewlevels1 × SELECT *
FROM `jos_wishlist`1 × SELECT *
FROM `jos_resource_ratings`1 × SELECT *
FROM `jos_resource_stats_tools`1 × SELECT *
FROM `jos_resource_stats_clusters`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.template2 × SHOW TABLE1 × (select uidNumber, 'invitees' AS role
from jos_xgroups_invitees1 × SHOW FULL COLUMNS
FROM `jos_resource_assoc1 × UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1529851063;s:18:\"session.timer.last\";i:1529851063;s:17:\"session.timer.now\";i:1529851063;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\":2:{s:6:\"Models\";O:8:\"stdClass\":3:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:10:\"Screenshot\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}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:\"bd6d7a11f51b89ecabc098ad6c74a702\";s:12:\"tracker.ssid\";s:32:\"bd6d7a11f51b89ecabc098ad6c74a702\";s:12:\"tracker.rsid\";s:32:\"bd6d7a11f51b89ecabc098ad6c74a702\";s:13:\"securiy_code0\";s:5:\"5121c\";s:13:\"session.token\";s:32:\"05d82bc3c2432ac258cebd04bc70cb65\";}',`time` = '1529851064',`ip` = '54.145.103.69'1 × SHOW FULL COLUMNS
FROM `jos_publications1 × DELETE
FROM`jos_session`1 × SHOW FULL COLUMNS
FROM `jos_tool_version1 × SHOW FULL COLUMNS
FROM `jos_tool_authors1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
VALUES ('bd6d7a11f51b89ecabc098ad6c74a702','0','1529851063','54.145.103.69'onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:46onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:45onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:44onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:46onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:138onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:46onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:46onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:46onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:46onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:46onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:46onResourcesAreas — Method — plgResourcesAbout::onResourcesAreas → /core/plugins/resources/about/about.php:57onResourcesAreas — Method — plgResourcesQuestions::onResourcesAreas → /core/plugins/resources/questions/questions.php:54onResourcesAreas — Method — plgResourcesCitations::onResourcesAreas → /core/plugins/resources/citations/citations.php:54onResourcesAreas — Method — plgResourcesReviews::onResourcesAreas → /core/plugins/resources/reviews/reviews.php:68onResourcesAreas — Method — plgResourcesUsage::onResourcesAreas → /core/plugins/resources/usage/usage.php:52onResourcesAreas — Method — plgResourcesVersions::onResourcesAreas → /core/plugins/resources/versions/versions.php:54onResourcesAreas — Method — plgResourcesShare::onResourcesAreas → /core/plugins/resources/share/share.php:54onResourcesAreas — Method — plgResourcesWishlist::onResourcesAreas → /core/plugins/resources/wishlist/wishlist.php:54onResourcesAreas — Method — plgResourcesSupportingDocs::onResourcesAreas → /core/plugins/resources/supportingdocs/supportingdocs.php:55onResourcesAreas — Method — plgResourcesFindThisText::onResourcesAreas → /core/plugins/resources/findthistext/findthistext.php:54onResourcesAreas — Method — plgResourcesWindowstools::onResourcesAreas → /core/plugins/resources/windowstools/windowstools.php:236onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:49onContentPrepare — Method — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:60onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:50onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:59onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:88onContentPrepare — Method — plgContentFormathtml::onContentPrepare → /core/plugins/content/formathtml/formathtml.php:130onResources — Method — plgResourcesAbout::onResources → /core/plugins/resources/about/about.php:79onResources — Method — plgResourcesQuestions::onResources → /core/plugins/resources/questions/questions.php:85onResources — Method — plgResourcesCitations::onResources → /core/plugins/resources/citations/citations.php:76onResources — Method — plgResourcesReviews::onResources → /core/plugins/resources/reviews/reviews.php:116onResources — Method — plgResourcesUsage::onResources → /core/plugins/resources/usage/usage.php:74onResources — Method — plgResourcesVersions::onResources → /core/plugins/resources/versions/versions.php:75onResources — Method — plgResourcesShare::onResources → /core/plugins/resources/share/share.php:75onResources — Method — plgResourcesWishlist::onResources → /core/plugins/resources/wishlist/wishlist.php:75onResources — Method — plgResourcesSupportingDocs::onResources → /core/plugins/resources/supportingdocs/supportingdocs.php:77onResources — Method — plgResourcesFindThisText::onResources → /core/plugins/resources/findthistext/findthistext.php:76onResources — Method — plgResourcesWindowstools::onResources → /core/plugins/resources/windowstools/windowstools.php:257onResources — Method — plgResourcesGooglescholar::onResources → /core/plugins/resources/googlescholar/googlescholar.php:47onResources — Method — plgResourcesOpengraph::onResources → /core/plugins/resources/opengraph/opengraph.php:47onResources — Method — plgResourcesDublincore::onResources → /core/plugins/resources/dublincore/dublincore.php:47onResourcesSub — Method — plgResourcesRelated::onResourcesSub → /core/plugins/resources/related/related.php:70onResourcesSub — Method — plgResourcesSponsors::onResourcesSub → /core/plugins/resources/sponsors/sponsors.php:70onResourcesSub — Method — plgResourcesWatch::onResourcesSub → /core/plugins/resources/watch/watch.php:70onResourcesSub — Method — plgResourcesGroups::onResourcesSub → /core/plugins/resources/groups/groups.php:70onResourcesSub — Method — plgResourcesCollections::onResourcesSub → /core/plugins/resources/collections/collections.php:56onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:87onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:49onGetModuleCaptcha — Method — plgSupportCaptcha::onGetModuleCaptcha → /core/plugins/support/captcha/captcha.php:217onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:45