Solar PV Diagnosis

By Xingshu sun1, Muhammed Tahir Patel1, Reza Asadpour1, Muhammad A. Alam1

1. Purdue University

Category

Databases

Published on

Abstract

The uncertainties associated with technology‐specific and geography‐specific degradation rates make it difficult to calculate the levelized cost of energy, and thus the economic viability of solar energy. In this regard, millions of fielded photovoltaic modules may serve as a global testbed, where we can interpret the routinely collected time series maximum power point (MPP) data to assess the time‐dependent “health” of solar modules. The existing characterization methods, however, cannot effectively mine/decode these datasets to identify various degradation pathways. In this paper, we propose a new methodology called the Suns‐Vmp method, which offers a simple yet powerful approach to monitoring and diagnosing time‐dependent degradation of solar modules by using the MPP data. The algorithm reconstructs “IV” curves by using the natural illumination‐dependent and temperature‐dependent daily MPP characteristics as constraints to fit physics‐based circuit models. These synthetic IV characteristics are then used to determine the time‐dependent evolution of circuit parameters (e.g. series resistance), which in turn allows one to deduce the dominant degradation modes (e.g. solder bond failure) of solar modules. The proposed method has been applied to a test facility at the National Renewable Energy Laboratory. Our analysis indicates that the solar modules degraded at a rate of ~0.7%/year because of discoloration and weakened solder bonds. These conclusions are validated by independent outdoor IV measurements and on‐site imaging characterization. Integrated with physics‐based degradation models or machine learning algorithms, the method can also serve to predict the lifetime of photovoltaic systems.

Publication
X. Sun, R. Vamsi K. Chavali, and M. A. Alam, “Real ‐ time monitoring and diagnosis of photovoltaic system degradation only using maximum power point — the Suns ‐ Vmp method,” Prog. Ph, no. March, pp. 1–12, 2018. (https://doi.org/10.1002/pip.3043 )

View and Download
Click the blue View Data button above to view, explore, and download the Solar PV simulation code, example input and output files, presentations, and reports.




image
Figure 1. A schematic illustration to explain the working principles of the Suns‐Vmp methods


image
Figure 2. The flow chart of the Suns‐Vmp method. Degradation mechanisms that affect the performance
of solar modules are reflected in the time‐dependent changes of these circuit parameters.


image
Figure 3. (a) Three‐day maximum power point (MPP) and environmental data (circles) from November 09, 2002 to November 11, 2002 of the test facility. The fitting results of the MPP data (solid lines) using the Suns‐Vmp method is also present. (b) An illustration of reconstructing “IV” from the MPP data in (a)


image
Figure 4. Temporal degradation deconvolution with respect to circuit parameters for the negative monopole.



Key findings from the Suns‐Vmp method that analyzes the PV degradation


  1. The Suns‐Vmp method enables monitoring and diagnosis of PV reliability in real time by systemically and physically mining the time series MPP data. The method can extract physically defined circuit parameters by fitting IVs consisting of the varying MPP data over a measurement window. The extracted circuit parameters can be used to estimate the STC efficiency, quantitatively deconvolve PV degradation pathways, and identify the dominant degradation pathways.

  2. We have demonstrated the Suns‐Vmp method by analyzing MPP data from an NREL test facility, where physics‐based circuit parameters and efficiencies of the solar modules have been extracted as a function of time. Independent outdoor IV measurements have systemically validated our results. Our analysis suggests that the PV system degrades at a rate of 0.7%/year, primarily because of reduced short‐circuit current and increased series resistance most likely caused by discoloration and weakened solder bond, respectively. The on‐site optical photograph and IR image indeed substantiate our interpretation of the physical degradation pathways, ie, discoloration and solder bond failure.

  3. The analysis of deconvolving the underlying degradation pathways by the Suns‐Vmp method can deepen the current understanding of technology‐dependent and geographic‐dependent degradation, and inspire more robust environment‐specific designs for the next‐generation reliability‐aware solar modules. The Suns‐Vmp method can be used to calibrate physics‐based degradation models as well as train machine learning algorithms, both of which can then predict power degradation of PV and improve the evaluation of “bankability.”




image

The Solar PV Diagnosis dataset stores all the files (input, output and simulation code) and provides an easy access to users for their perusal. A pre-processing tool has been added to System 50 files to show how the raw field data and weather data are converted into appropriately formatted input files.

The source of the data is NREL (Golden, Colorado, USA) – System 50 and System 51 are included as two example cases.

Alam CEED Group website
Funding - National Science Foundation under Grant #1724728


[1] X. Sun, R. Vamsi K. Chavali, and M. A. Alam, “Real ‐ time monitoring and diagnosis of photovoltaic system degradation only using maximum power point — the Suns ‐ Vmp method,” Prog. Ph, no. March, pp. 1–12, 2018.

Cite this work

Researchers should cite this work as follows:

  • Xingshu sun; Muhammed Tahir Patel; Reza Asadpour; Muhammad A. Alam (2018), "Solar PV Diagnosis," https://datacenterhub.org/resources/14754.

    BibTex | EndNote

Debug Console

Close26 MBRequestSessionTimelineDatabase49Events52
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /resources/14754,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/resources/14754,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /resources/14754,
SCRIPT_URI => https://datacenterhub.org/resources/14754,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 3.235.239.156,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 42528,
REDIRECT_URL => /resources/14754,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/14754,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1593878290.6294,
REQUEST_TIME => 1593878290,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 76f1d33ce8e63cfcc40c767a764034fc
tracker.ssid 76f1d33ce8e63cfcc40c767a764034fc
tracker.rsid 76f1d33ce8e63cfcc40c767a764034fc
  • site 0.047 seconds (+0.047); 12.25 MB (+12.250) - afterInitialise
  • site 0.066 seconds (+0.019); 13.50 MB (+1.250) - afterRoute
  • site 0.598 seconds (+0.532); 25.00 MB (+11.500) - afterDispatch
  • site 0.602 seconds (+0.005); 25.25 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.604 seconds (+0.002); 25.25 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.605 seconds (+0.000); 25.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.621 seconds (+0.016); 25.75 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.626 seconds (+0.005); 25.75 MB (0.000) - onAfterRender
  • site 0.629 seconds (+0.003); 25.75 MB (0.000) - sessionStore
26 MB

49 Queries Logged: 0.060564517974854 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '2fb9ab4a596c21bb7aad5960dce0841b'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '2fb9ab4a596c21bb7aad5960dce0841b'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '76f1d33ce8e63cfcc40c767a764034fc'
  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` = '76f1d33ce8e63cfcc40c767a764034fc'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('76f1d33ce8e63cfcc40c767a764034fc','0','1593878290','3.235.239.156')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  16. SELECT *
      FROM `jos_resources`
      WHERE `jos_resources`.`id` = '14754'
  17. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  18. SELECT 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` = '14754'
      AND `jos_tags`.`admin` = '0'
  19. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14754'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  21. SELECT *
      FROM `jos_resource_ratings`
      WHERE `jos_resource_ratings`.`resource_id` = '14754'
      AND `jos_resource_ratings`.`state` IN ('1','3')
      ORDER BY `created` DESC
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  23. 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` = '14754'
      ORDER BY `jos_citations`.`affiliated` ASC,`jos_citations`.`year` DESC
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  25. 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 ('resource14754')
      AND `jos_answers_questions`.`state` < '2'
  26. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1474'
  27. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2060'
  28. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2058'
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-1535484909'
  30. SHOW FULL COLUMNS
      FROM `jos_resource_assoc`
  31. 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` = '14754'
      AND `jos_resources`.`standalone` = '0'
      AND `jos_resources`.`published` = '1'
      ORDER BY `ordering` ASC
  32. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '0'
  33. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '12'
  34. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '13'
  35. SELECT *
      FROM `jos_resource_licenses`
      WHERE `jos_resource_licenses`.`name` = 'cc40-by-nc-sa'
      LIMIT 1
  36. SELECT k.*
      FROM ((SELECT DISTINCT w.id, 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
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
      WHERE v.approved=1
      AND wl.scope='resource'
      AND wl.scope_id='14754'
      AND w.access!=1
      GROUP BY w.id, v.pagetext
      ORDER BY ranking DESC, title
      LIMIT 10) UNION (SELECT DISTINCT r.id, 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='14754'
      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 10
  37. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  38. 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` = '14754'
      GROUP BY jos_tags_object.label,jos_tags.id
  39. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  40. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2020-07-04 15:58:11' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-07-04 15:58:11' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '88' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  49. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1593878290;s:18:\"session.timer.last\";i:1593878290;s:17:\"session.timer.now\";i:1593878290;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\":1:{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:\"76f1d33ce8e63cfcc40c767a764034fc\";s:12:\"tracker.ssid\";s:32:\"76f1d33ce8e63cfcc40c767a764034fc\";s:12:\"tracker.rsid\";s:32:\"76f1d33ce8e63cfcc40c767a764034fc\";}',`time` = '1593878291',`ip` = '3.235.239.156'
      WHERE `session_id` = '76f1d33ce8e63cfcc40c767a764034fc'

26 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 5 × SELECT *
      FROM `jos_resource_types`
  3. 4 × SELECT *
      FROM `jos_users`
  4. 2 × SELECT data
      FROM `jos_session`
  5. 1 × 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
  6. 1 × 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
  7. 1 × SELECT k.*
      FROM ((SELECT DISTINCT w.id, 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
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
  8. 1 × SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  9. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  10. 1 × SELECT *
      FROM `jos_resource_sponsors`
  11. 1 × SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
  12. 1 × SELECT *
      FROM `jos_resource_licenses`
  13. 1 × SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
  14. 1 × SELECT *
      FROM `jos_viewlevels
  15. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  16. 1 × SELECT session_id
      FROM `jos_session`
  17. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  18. 1 × SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
  19. 1 × SELECT *
      FROM `jos_author_assoc`
  20. 1 × SELECT *
      FROM `jos_resources`
  21. 1 × SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
  22. 1 × SELECT *
      FROM `jos_resource_ratings`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1593878290;s:18:\"session.timer.last\";i:1593878290;s:17:\"session.timer.now\";i:1593878290;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\":1:{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:\"76f1d33ce8e63cfcc40c767a764034fc\";s:12:\"tracker.ssid\";s:32:\"76f1d33ce8e63cfcc40c767a764034fc\";s:12:\"tracker.rsid\";s:32:\"76f1d33ce8e63cfcc40c767a764034fc\";}',`time` = '1593878291',`ip` = '3.235.239.156'
  2. 1 × SHOW FULL COLUMNS
      FROM `jos_resource_assoc
  3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('76f1d33ce8e63cfcc40c767a764034fc','0','1593878290','3.235.239.156'
  4. 1 × DELETE
      FROM `jos_session`
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onResourcesAreas Method plgResourcesAbout::onResourcesAreas /core/plugins/resources/about/about.php:32
  • onResourcesAreas Method plgResourcesReviews::onResourcesAreas /core/plugins/resources/reviews/reviews.php:43
  • onResourcesAreas Method plgResourcesUsage::onResourcesAreas /core/plugins/resources/usage/usage.php:29
  • onResourcesAreas Method plgResourcesVersions::onResourcesAreas /core/plugins/resources/versions/versions.php:29
  • onResourcesAreas Method plgResourcesShare::onResourcesAreas /core/plugins/resources/share/share.php:29
  • onResourcesAreas Method plgResourcesCitations::onResourcesAreas /core/plugins/resources/citations/citations.php:29
  • onResourcesAreas Method plgResourcesQuestions::onResourcesAreas /core/plugins/resources/questions/questions.php:29
  • onResourcesAreas Method plgResourcesSupportingDocs::onResourcesAreas /core/plugins/resources/supportingdocs/supportingdocs.php:30
  • onResourcesAreas Method plgResourcesWishlist::onResourcesAreas /core/plugins/resources/wishlist/wishlist.php:29
  • onResourcesAreas Method plgResourcesFindThisText::onResourcesAreas /core/plugins/resources/findthistext/findthistext.php:29
  • onResourcesAreas Method plgResourcesWindowstools::onResourcesAreas /core/plugins/resources/windowstools/windowstools.php:214
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onResources Method plgResourcesAbout::onResources /core/plugins/resources/about/about.php:54
  • onResources Method plgResourcesReviews::onResources /core/plugins/resources/reviews/reviews.php:91
  • onResources Method plgResourcesUsage::onResources /core/plugins/resources/usage/usage.php:51
  • onResources Method plgResourcesVersions::onResources /core/plugins/resources/versions/versions.php:50
  • onResources Method plgResourcesShare::onResources /core/plugins/resources/share/share.php:50
  • onResources Method plgResourcesCitations::onResources /core/plugins/resources/citations/citations.php:51
  • onResources Method plgResourcesQuestions::onResources /core/plugins/resources/questions/questions.php:60
  • onResources Method plgResourcesSupportingDocs::onResources /core/plugins/resources/supportingdocs/supportingdocs.php:52
  • onResources Method plgResourcesWishlist::onResources /core/plugins/resources/wishlist/wishlist.php:50
  • onResources Method plgResourcesFindThisText::onResources /core/plugins/resources/findthistext/findthistext.php:51
  • onResources Method plgResourcesWindowstools::onResources /core/plugins/resources/windowstools/windowstools.php:235
  • onResources Method plgResourcesGooglescholar::onResources /core/plugins/resources/googlescholar/googlescholar.php:25
  • onResources Method plgResourcesOpengraph::onResources /core/plugins/resources/opengraph/opengraph.php:25
  • onResources Method plgResourcesDublincore::onResources /core/plugins/resources/dublincore/dublincore.php:25
  • onResources Method plgResourcesCoins::onResources /core/plugins/resources/coins/coins.php:25
  • onResourcesSub Method plgResourcesGroups::onResourcesSub /core/plugins/resources/groups/groups.php:45
  • onResourcesSub Method plgResourcesRelated::onResourcesSub /core/plugins/resources/related/related.php:45
  • onResourcesSub Method plgResourcesSponsors::onResourcesSub /core/plugins/resources/sponsors/sponsors.php:45
  • onResourcesSub Method plgResourcesWatch::onResourcesSub /core/plugins/resources/watch/watch.php:46
  • onResourcesSub Method plgResourcesCollections::onResourcesSub /core/plugins/resources/collections/collections.php:31
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21