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 => Wy1F7YAuE9gAC5nEa30AAAAH, REDIRECT_SCRIPT_URL => /whatsnew, REDIRECT_SCRIPT_URI => https://vhub.org/whatsnew, REDIRECT_nokeepalive => REDIRECT_HTTPS => on, REDIRECT_SSL_TLS_SNI => vhub.org, REDIRECT_STATUS => 200, UNIQUE_ID => Wy1F7YAuE9gAC5nEa30AAAAH, SCRIPT_URL => /whatsnew, SCRIPT_URI => https://vhub.org/whatsnew, 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 => Sun, 18 Feb 2018 09:05:21 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.80.198.173, 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 => 55542, REDIRECT_URL => /whatsnew, GATEWAY_INTERFACE => CGI/1.1, SERVER_PROTOCOL => HTTP/1.1, REQUEST_METHOD => GET, QUERY_STRING => REQUEST_URI => /whatsnew, SCRIPT_NAME => /index.php, PHP_SELF => /index.php, REQUEST_TIME_FLOAT => 1529693677.66, REQUEST_TIME => 1529693677, argv => Array(
)
, argc => 0separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 637745e7510cc8bff5766be1e892368d
tracker.ssid ⇒ 637745e7510cc8bff5766be1e892368d
tracker.rsid ⇒ 637745e7510cc8bff5766be1e892368d
securiy_code0 ⇒ eefe5
session.token ⇒ 119f75093381521aa15db8c21569e874
site 0.024 seconds (+0.024); 3.50 MB (+3.500) - afterInitialisesite 0.038 seconds (+0.015); 4.00 MB (+0.500) - afterRoutesite 0.187 seconds (+0.149); 8.25 MB (+4.250) - afterDispatchsite 1.220 seconds (+1.033); 28.75 MB (+20.500) - beforeRenderModule mod_search (Search Module)site 1.223 seconds (+0.003); 29.00 MB (+0.250) - afterRenderModule mod_search (Search Module)site 1.223 seconds (+0.000); 29.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)site 1.235 seconds (+0.012); 29.50 MB (+0.500) - afterRenderModule mod_reportproblems (Trouble Report)site 1.235 seconds (+0.000); 29.50 MB (0.000) - beforeRenderModule mod_custom (V template footer)site 1.236 seconds (+0.001); 29.50 MB (0.000) - afterRenderModule mod_custom (V template footer)site 1.237 seconds (+0.000); 29.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)site 1.240 seconds (+0.003); 29.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)site 1.240 seconds (+0.000); 29.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)site 1.250 seconds (+0.010); 29.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)site 1.255 seconds (+0.005); 29.75 MB (0.000) - onAfterRendersite 1.258 seconds (+0.003); 29.75 MB (0.000) - sessionStoreSELECT data
FROM `jos_session`
WHERE `session_id` = '26b5b820f9abb72d1ff27e23d12bc629'DELETE
FROM`jos_session`
WHERE `session_id` = '26b5b820f9abb72d1ff27e23d12bc629'SELECT data
FROM `jos_session`
WHERE `session_id` = '637745e7510cc8bff5766be1e892368d'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` = '637745e7510cc8bff5766be1e892368d'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('637745e7510cc8bff5766be1e892368d','0','1529693677','54.80.198.173')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 con.`id`, cat.`alias`, cat.`path`
FROM `jos_content` AS con
LEFT JOIN `jos_categories` AS cat
ON con.catid = cat.id
WHERE con.state=1
AND con.`alias` = 'whatsnew'SELECT *
FROM `jos_redirect_links`
WHERE `published`=1
AND (`old_url`='https://vhub.org/whatsnew'
OR `old_url`='/whatsnew')
LIMIT 1SELECT 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_whatsnew'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'SELECT 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_publications'SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASC 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 > '2018-05-22 18:54:37'
AND c.publish_up < '2018-06-22 18:54:37'
AND c.state='1'SELECT count(DISTINCT e.id)
FROM jos_events AS e
WHERE e.created > '2018-05-22 18:54:37'
AND e.created < '2018-06-22 18:54:37'
AND scope='events'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 < '2018-06-22 18:54:37'
AND f.access IN (1,1,4)( 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 )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')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '62'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '64'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '10'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '9'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '1'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '3'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '7'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '67'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54: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` = '2'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54:37'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wiki'SELECT *
FROM `jos_wiki_pages`
WHERE `jos_wiki_pages`.`state` = '1'
AND `jos_wiki_pages`.`created` >= '2018-05-22 18:54:37'
AND `jos_wiki_pages`.`created` < '2018-06-22 18:54:37'
ORDER BY `created` DESCSHOW FULL COLUMNS
FROM `jos_publications`SELECT C.id
FROM jos_publication_versions as V, jos_projects as PP,
jos_publication_master_types AS MT, jos_publications AS C
LEFT JOIN jos_publication_categories AS t
ON t.id=C.category
WHERE V.publication_id=C.id
AND MT.id=C.master_type
AND PP.id = C.project_id
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 = '0000-00-00 00:00:00' OR V.published_up <= '2018-06-22 18:54:37')
AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2018-06-22 18:54:37')
AND V.published_up > '2018-05-22 18:54:37'
AND V.published_up < '2018-06-22 18:54:37'
AND V.state != 2
AND (V.access != 2)
GROUP BY C.id SELECT c.id, c.title, c.alias, c.created, b.path, CONCAT(c.introtext, c.fulltext) AS text, CONCAT('index.php?option=com_content&task=view&id=', c.id) AS href, NULL AS fsection, b.alias AS category, 'content' AS section, NULL AS subsection
FROM jos_content AS c
INNER JOIN jos_categories AS b
ON b.id=c.catid
WHERE c.publish_up > '2018-05-22 18:54:37'
AND c.publish_up < '2018-06-22 18:54:37'
AND c.state='1'
ORDER BY publish_up DESC, title
LIMIT 0,5SELECT e.id, e.title, NULL AS alias, e.content AS itext, NULL AS ftext, e.state, e.created, e.modified, e.publish_up, NULL AS params,
CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, NULL AS area, NULL AS category, NULL AS rating, NULL AS times_rated, NULL AS ranking
FROM jos_events AS e
WHERE e.created > '2018-05-22 18:54:37'
AND e.created < '2018-06-22 18:54:37'
AND scope='events'
ORDER BY publish_up DESC, title
LIMIT 0,5SELECT
f.id,
f.title,
f.fulltxt AS `text`,
concat('index.php?option=com_kb§ion=', 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 < '2018-06-22 18:54:37'
AND f.access IN (1,1,4)
ORDER BY f.created DESC, f.title
LIMIT 0,5SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'( 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 )SELECT *
FROM `jos_resources`
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` = '1'
AND (`jos_resources`.`access` IN ('0','3')
OR `jos_resources`.`group_owner` IN ('www-data')
)
AND `jos_resources`.`publish_up` > '2018-05-22 18:54:37'
AND `jos_resources`.`publish_up` < '2018-06-22 18:54:37'
ORDER BY `created` DESC
LIMIT 5SELECT *
FROM `jos_wiki_pages`
WHERE `jos_wiki_pages`.`state` = '1'
AND `jos_wiki_pages`.`created` >= '2018-05-22 18:54:37'
AND `jos_wiki_pages`.`created` < '2018-06-22 18:54:37'
ORDER BY `created` DESC
LIMIT 5SELECT *
FROM `jos_xgroups`
WHERE gidNumber = '3356';(select uidNumber, 'invitees' AS role
from jos_xgroups_invitees
where gidNumber='3356')
UNION
(select uidNumber, 'applicants' AS role
from jos_xgroups_applicants
where gidNumber='3356')
UNION
(select uidNumber, 'members' AS role
from jos_xgroups_members
where gidNumber='3356')
UNION
(select uidNumber, 'managers' AS role
from jos_xgroups_managers
where gidNumber='3356')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'SELECT *
FROM `jos_wiki_versions`
WHERE `jos_wiki_versions`.`id` = '4390'SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access,
C.checked_out, C.checked_out_time, C.rating as master_rating,
C.group_owner, C.master_type, C.master_doi,
C.ranking as master_ranking, C.times_rated as master_times_rated,
C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias,
t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title,
PP.state as project_status, PP.private as project_private,
PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
FROM `jos_publication_versions` as vv
WHERE vv.publication_id=C.id
AND vv.state=3
ORDER BY ID DESC
LIMIT 1) AS dev_version_label , (SELECT COUNT(*)
FROM `jos_publication_versions`
WHERE publication_id=C.id
AND state!=3) AS versions
FROM jos_publication_versions as V, jos_projects as PP,
jos_publication_master_types AS MT, jos_publications AS C
LEFT JOIN jos_publication_categories AS t
ON t.id=C.category
WHERE V.publication_id=C.id
AND MT.id=C.master_type
AND PP.id = C.project_id
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 = '0000-00-00 00:00:00' OR V.published_up <= '2018-06-22 18:54:37')
AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2018-06-22 18:54:37')
AND V.published_up > '2018-05-22 18:54:37'
AND V.published_up < '2018-06-22 18:54:37'
AND V.state != 2
AND (V.access != 2)
GROUP BY C.id
ORDER BY V.published_up DESC
LIMIT 0, 5SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`id` = '62'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tools'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4411'
AND `jos_author_assoc`.`subtable` = 'resources'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4411'
AND `jos_author_assoc`.`subtable` = 'resources'
ORDER BY `ordering` ASCSELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`id` = '3'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4398'
AND `jos_author_assoc`.`subtable` = 'resources'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4398'
AND `jos_author_assoc`.`subtable` = 'resources'
ORDER BY `ordering` ASCSELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4395'
AND `jos_author_assoc`.`subtable` = 'resources'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4395'
AND `jos_author_assoc`.`subtable` = 'resources'
ORDER BY `ordering` ASCSELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4394'
AND `jos_author_assoc`.`subtable` = 'resources'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4394'
AND `jos_author_assoc`.`subtable` = 'resources'
ORDER BY `ordering` ASCSELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4392'
AND `jos_author_assoc`.`subtable` = 'resources'SELECT *
FROM `jos_author_assoc`
WHERE `jos_author_assoc`.`subid` = '4392'
AND `jos_author_assoc`.`subtable` = 'resources'
ORDER BY `ordering` ASCSELECT 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-22 18:54:38'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2018-06-22 18:54:38'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '0'
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_answers'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wishlist'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:1529693677;s:18:\"session.timer.last\";i:1529693677;s:17:\"session.timer.now\";i:1529693677;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:\"637745e7510cc8bff5766be1e892368d\";s:12:\"tracker.ssid\";s:32:\"637745e7510cc8bff5766be1e892368d\";s:12:\"tracker.rsid\";s:32:\"637745e7510cc8bff5766be1e892368d\";s:13:\"securiy_code0\";s:5:\"eefe5\";s:13:\"session.token\";s:32:\"119f75093381521aa15db8c21569e874\";}',`time` = '1529693678',`ip` = '54.80.198.173'
WHERE `session_id` = '637745e7510cc8bff5766be1e892368d'17 × SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`10 × SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`10 × SELECT *
FROM `jos_author_assoc`3 × SELECT *
FROM `jos_resource_types`2 × SELECT *
FROM `jos_wiki_pages`2 × SELECT data
FROM `jos_session`1 × SELECT C.id
FROM jos_publication_versions as V, jos_projects as PP, jos_publication_master_types AS MT, jos_publications AS C
LEFT JOIN jos_publication_categories AS t
ON t.id=C.category1 × SELECT e.id, e.title, NULL AS alias, e.content AS itext, NULL AS ftext, e.state, e.created, e.modified, e.publish_up, NULL AS params, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, NULL AS area, NULL AS category, NULL AS rating, NULL AS times_rated, NULL AS ranking
FROM jos_events AS e1 × SELECT *
FROM `jos_xgroups`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_id1 × SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access, C.checked_out, C.checked_out_time, C.rating as master_rating, C.group_owner, C.master_type, C.master_doi, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.private as project_private, PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
FROM `jos_publication_versions` as vv1 × SELECT *
FROM `jos_wiki_versions`1 × SELECT *
FROM `jos_resources`1 × SELECT f.id, f.title, f.fulltxt AS `text`, concat('index.php?option=com_kb§ion=', 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.category1 × SELECT count(DISTINCT e.id)
FROM jos_events AS e1 × SELECT *
FROM `jos_viewlevels1 × 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 session_id
FROM `jos_session`1 × SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`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 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.template1 × SELECT *
FROM `jos_redirect_links`1 × SELECT con.`id`, cat.`alias`, cat.`path`
FROM `jos_content` AS con
LEFT JOIN `jos_categories` AS cat
ON con.catid = cat.id1 × SELECT COUNT(*)
FROM `jos_kb_articles` AS f
LEFT JOIN `jos_categories` AS c
ON c.id = f.category2 × ( 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 m1 × (select uidNumber, 'invitees' AS role
from jos_xgroups_invitees1 × UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1529693677;s:18:\"session.timer.last\";i:1529693677;s:17:\"session.timer.now\";i:1529693677;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:\"637745e7510cc8bff5766be1e892368d\";s:12:\"tracker.ssid\";s:32:\"637745e7510cc8bff5766be1e892368d\";s:12:\"tracker.rsid\";s:32:\"637745e7510cc8bff5766be1e892368d\";s:13:\"securiy_code0\";s:5:\"eefe5\";s:13:\"session.token\";s:32:\"119f75093381521aa15db8c21569e874\";}',`time` = '1529693678',`ip` = '54.80.198.173'1 × SELECT c.id, c.title, c.alias, c.created, b.path, CONCAT(c.introtext, c.fulltext) AS text, CONCAT('index.php?option=com_content&task=view&id=', c.id) AS href, NULL AS fsection, b.alias AS category, 'content' AS section, NULL AS subsection
FROM jos_content AS c
INNER JOIN jos_categories AS b
ON b.id=c.catid1 × SHOW FULL COLUMNS
FROM `jos_publications1 × SELECT count(DISTINCT c.id)
FROM jos_content AS c
INNER JOIN jos_categories AS b
ON b.id=c.catid1 × DELETE
FROM`jos_session`1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
VALUES ('637745e7510cc8bff5766be1e892368d','0','1529693677','54.80.198.173'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:46onWhatsnewAreas — Method — plgWhatsnewContent::onWhatsnewAreas → /core/plugins/whatsnew/content/content.php:53onWhatsnewAreas — Method — plgWhatsnewEvents::onWhatsnewAreas → /core/plugins/whatsnew/events/events.php:53onWhatsnewAreas — Method — plgWhatsnewKb::onWhatsnewAreas → /core/plugins/whatsnew/kb/kb.php:53onWhatsnewAreas — Method — plgWhatsnewResources::onWhatsnewAreas → /core/plugins/whatsnew/resources/resources.php:88onWhatsnewAreas — Method — plgWhatsnewWiki::onWhatsnewAreas → /core/plugins/whatsnew/wiki/wiki.php:53onWhatsnewAreas — Method — plgWhatsnewPublications::onWhatsnewAreas → /core/plugins/whatsnew/publications/publications.php:90onWhatsnew — Method — plgWhatsnewContent::onWhatsnew → /core/plugins/whatsnew/content/content.php:70onWhatsnew — Method — plgWhatsnewEvents::onWhatsnew → /core/plugins/whatsnew/events/events.php:70onWhatsnew — Method — plgWhatsnewKb::onWhatsnew → /core/plugins/whatsnew/kb/kb.php:70onWhatsnew — Method — plgWhatsnewResources::onWhatsnew → /core/plugins/whatsnew/resources/resources.php:127onWhatsnew — Method — plgWhatsnewWiki::onWhatsnew → /core/plugins/whatsnew/wiki/wiki.php:70onWhatsnew — Method — plgWhatsnewPublications::onWhatsnew → /core/plugins/whatsnew/publications/publications.php:107onAfterDispatch — 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