Support

Support Options

Submit a Support Ticket

Wish List - Wish List

Search for Wishes
All (0 - 0 of 0)

There are currently no wishes on this list. Be the first to make a suggestion for improvement.

Debug Console

Close19 MBRequestSessionTimelineDatabase43
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /wishlist/, REDIRECT_SCRIPT_URI => http://chemistryhub.org/wish... Array(
REDIRECT_SCRIPT_URL => /wishlist/,
REDIRECT_SCRIPT_URI => http://chemistryhub.org/wishlist/,
REDIRECT_nokeepalive => ,
REDIRECT_STATUS => 200,
SCRIPT_URL => /wishlist/,
SCRIPT_URI => http://chemistryhub.org/wishlist/,
nokeepalive => ,
HTTP_HOST => chemistryhub.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 => Thu, 27 Jul 2017 18:53:14 GMT,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.2.15 (CentOS),
SERVER_NAME => chemistryhub.org,
SERVER_ADDR => 206.221.159.27,
SERVER_PORT => 80,
REMOTE_ADDR => 54.80.137.187,
DOCUMENT_ROOT => /var/www/chemistryhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/chemistryhub/index.php,
REMOTE_PORT => 33428,
REDIRECT_URL => /wishlist/,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /wishlist/,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1506093823.391,
REQUEST_TIME => 1506093823
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 6a4c9203afafcfaaf245882f10f2bc04
tracker.ssid 6a4c9203afafcfaaf245882f10f2bc04
tracker.rsid 6a4c9203afafcfaaf245882f10f2bc04
securiy_code0 3d9b2
session.token 610dbbbfe6426b8ffad6cb991aa1d07d
  • site 0.050 seconds (+0.050); 9.75 MB (+9.750) - afterInitialise
  • site 0.071 seconds (+0.021); 11.50 MB (+1.750) - afterRoute
  • site 0.118 seconds (+0.048); 16.50 MB (+5.000) - afterDispatch
  • site 0.128 seconds (+0.010); 16.50 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.130 seconds (+0.002); 16.75 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.130 seconds (+0.000); 16.75 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.132 seconds (+0.001); 17.00 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.132 seconds (+0.000); 17.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.136 seconds (+0.003); 17.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.136 seconds (+0.000); 17.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.167 seconds (+0.031); 17.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.167 seconds (+0.000); 17.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.169 seconds (+0.002); 17.75 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.169 seconds (+0.000); 17.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.184 seconds (+0.015); 18.75 MB (+1.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.187 seconds (+0.003); 18.75 MB (0.000) - onAfterRender
  • site 0.189 seconds (+0.002); 18.75 MB (0.000) - sessionStore
19 MB

43 Queries Logged: 0.020042657852173 seconds

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = 'c338da6bd1ff15ebd3d725aaff92b417'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'c338da6bd1ff15ebd3d725aaff92b417'
  3. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '6a4c9203afafcfaaf245882f10f2bc04'
  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` = '6a4c9203afafcfaaf245882f10f2bc04'
  6. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`, `ip`)
      VALUES ('6a4c9203afafcfaaf245882f10f2bc04', 0, '1506093823', '54.80.137.187')
  7. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  9. 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
  10. SELECT id, rules
      FROM `jos_viewlevels`
  11. 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
  12. 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 m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  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_wishlist'
  15. SHOW FULL COLUMNS
      FROM `jos_wishlist`
  16. SELECT *
      FROM jos_wishlist
      WHERE `referenceid` = '1'
      AND `category` = 'general'
  17. SELECT a.rules
      FROM jos_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
  18. 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_wishlist')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
  19. 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
  20. SHOW FULL COLUMNS
      FROM `jos_wishlist_item`
  21. SELECT ws.id
      FROM `jos_wishlist_item` AS ws
      WHERE 1=1
      AND ws.wishlist='2'
      AND ws.status!=2
      AND ws.private='0'
  22. SELECT ws.id
      FROM `jos_wishlist_item` AS ws
      WHERE 1=1
      AND ws.wishlist='2'
      AND ws.status=1
      AND ws.private='0'
  23. SELECT ws.*, v.helpful AS vote, m.importance AS myvote_imp, m.effort AS myvote_effort, xp.name AS authorname, NULL AS ranked, (SELECT COUNT(*)
      FROM jos_vote_log AS v
      WHERE v.helpful='yes'
      AND v.category='wish'
      AND v.referenceid=ws.id) AS positive, (SELECT COUNT(*)
      FROM jos_vote_log AS v
      WHERE v.helpful='no'
      AND v.category='wish'
      AND v.referenceid=ws.id) AS negative, (SELECT COUNT(*)
      FROM jos_wishlist_vote AS m
      WHERE m.wishid=ws.id) AS num_votes, (SELECT xp.name
      FROM jos_xprofiles AS xp
      WHERE xp.uidNumber=ws.granted_by) as grantedby, (SELECT xp.name
      FROM jos_xprofiles AS xp
      WHERE xp.uidNumber=ws.assigned) as assignedto, (SELECT count(*)
      FROM jos_item_comments AS CC
      WHERE CC.item_id=ws.id
      AND CC.state=1
      AND CC.item_type='wish') AS numreplies, '0' AS reports, (SELECT AVG(m.importance)
      FROM jos_wishlist_vote AS m
      WHERE m.wishid=ws.id) AS average_imp, (SELECT AVG(m.effort)
      FROM jos_wishlist_vote AS m
      WHERE m.wishid=ws.id
      AND m.effort!=6) AS average_effort, (SELECT SUM(amount)
      FROM jos_users_transactions
      WHERE category='wish'
      AND referenceid=ws.id
      AND type='hold') AS bonus, (SELECT COUNT(DISTINCT uid)
      FROM jos_users_transactions
      WHERE category='wish'
      AND referenceid=ws.id
      AND type='hold') AS bonusgivenby
      FROM jos_wishlist_item AS ws JOIN jos_xprofiles AS xp
      ON xp.uidNumber=ws.proposed_by
      LEFT JOIN jos_vote_log AS v
      ON v.referenceid=ws.id
      AND v.category='wish'
      AND v.voter='0'
      LEFT JOIN jos_wishlist_vote AS m
      ON m.wishid=ws.id
      AND m.userid='0'
      WHERE 1=1
      AND ws.wishlist='2'
      AND ws.status!=2
      AND ws.private='0'
      ORDER BY ws.status ASC, ws.proposed DESC
      LIMIT 0, 20
  24. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  25. SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'wishlist'
      GROUP BY jos_tags.id
      ORDER BY `objects` ASC
      LIMIT 10
  26. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  27. 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 <= '2017-09-22 15:23:43')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-22 15:23:43')
      AND m.access IN (1,1,4)
      AND m.client_id = 0
      AND (mm.menuid = 92 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  28. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  29. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  30. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  31. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  32. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  33. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  34. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  35. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  36. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_store'
  37. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  38. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  39. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  40. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  41. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  42. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  43. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506093823;s:18:\"session.timer.last\";i:1506093823;s:17:\"session.timer.now\";i:1506093823;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:\"6a4c9203afafcfaaf245882f10f2bc04\";s:12:\"tracker.ssid\";s:32:\"6a4c9203afafcfaaf245882f10f2bc04\";s:12:\"tracker.rsid\";s:32:\"6a4c9203afafcfaaf245882f10f2bc04\";s:13:\"securiy_code0\";s:5:\"3d9b2\";s:13:\"session.token\";s:32:\"610dbbbfe6426b8ffad6cb991aa1d07d\";}' , `time` = '1506093823' , `ip` = '54.80.137.187'
      WHERE `session_id` = '6a4c9203afafcfaaf245882f10f2bc04'