Support

Support Options

Report a problem

About you
This is a randomly generated image of letters and numbers. Letters not clear? Click to renew CAPTCHA.
About the problem

Jennifer Jenny

How to recover your CoinSpot Account?

CoinSpot is a platform that allows you to access everything it has to offer as soon as you create an account. To do this, you simply need to remember your username (which can be your email address or mobile number) and password so you can log in whenever you want. However, if for some reason you can't get to your profile page, don't worry! There are several methods. All you have to do is follow the steps to recover your account and you'll be back on track in no time.

 

Recover with the Phone number or Email

  1. Open the login page in your CoinSpot mobile app or on the official website. 
  2. Click on the button “need help”. A forgot password link appears after clicking on it. 
  3. Enter the email address or phone number associated with your account on the "Forgot Password" page.
  4. Click Continue and Enter the OTP arrived via email or SMS and click Continue. 
  5. Enter your new password twice. Click Save changes and sign in. 

You have successfully recovered your CoinSpot Login

Note- In some cases, if you're logged in from an unknown location or device, CoinSpot may decide to verify your identity.

 

Recover without password

This process does not require a password to login into your device. Follow the step-by-step process given below. 

  1. Visit the CoinSpot website and click on the "Forgot Password" link. 
  2. You will receive the “Via Email” or “Via SMS” option.  
  3. Click on the "Via SMS" option. 
  4. Enter the phone number you registered the account with, and an SMS will be sent to that number. 
  5. Once you have entered the code that is sent to you, you will get access to your account. 

You have successfully logged in to your CoinSpot account!

 

Reset CoinSpot password without phone number or email

You can report your password issue and send a request to give you access to reset your CoinSpot login details. 

  1. Go to "Report a problem" in the website’s settings and privacy. 
  2. When you will see the "Feedback and help" option, Scroll down further and click on "Account and Profile." 
  3. After this, under "Select a Topic," then select "Login."
  4. Finally, select "Other" from the list. Under the Other list, click on "Still have a problem?". 
  5. Type your problem in that and continue by clicking on the "Report" icon.

 

Read more - Exodus Wallet is a cryptocurrency wallet with an incorporated, decentralized cryptocurrency exchange. It offers 138 cryptocurrencies for crypto-to-crypto, peer-to-peer swaps. Users have total control over their assets. In comparison, Coinbase is a centralized cryptocurrency brokerage.

 

Conclusion

Try these methods to recover your CoinSpot login details. If all these methods failed to work. Contact CoinSpot directly. There are several ways to contact the company such as Facebook, Twitter, Email, or chatbot to contact the company.

  1. Guide
  2. Tips

Comments on this entry

There are no comments at this time.

Add a comment

Please keep comments relevant to this entry.

Line breaks and paragraphs are automatically converted. URLs (starting with http://) or email addresses will automatically be linked.

Debug Console

Close14 MBRequestSessionTimelineDatabase92Events68
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /members/3715/blog/2022/08/how-to-recover-your-coinspot-account, ... Array(
REDIRECT_SCRIPT_URL => /members/3715/blog/2022/08/how-to-recover-your-coinspot-account,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/members/3715/blog/2022/08/how-to-recover-your-coinspot-account,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/3715/blog/2022/08/how-to-recover-your-coinspot-account,
SCRIPT_URI => https://itmig.curie.fr/members/3715/blog/2022/08/how-to-recover-your-coinspot-account,
HTTPS => on,
SSL_TLS_SNI => itmig.curie.fr,
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 => itmig.curie.fr,
HTTP_CONNECTION => Keep-Alive,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.10 (Debian),
SERVER_NAME => itmig.curie.fr,
SERVER_ADDR => 192.168.25.26,
SERVER_PORT => 443,
REMOTE_ADDR => 44.192.52.167,
DOCUMENT_ROOT => /var/www/itmig,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/itmig,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/itmig/index.php,
REMOTE_PORT => 59386,
REDIRECT_URL => /members/3715/blog/2022/08/how-to-recover-your-coinspot-account,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/3715/blog/2022/08/how-to-recover-your-coinspot-account,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1670529791.161,
REQUEST_TIME => 1670529791
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 96784d7f81b8f5a7e516df0d7a1e7558
tracker.ssid 96784d7f81b8f5a7e516df0d7a1e7558
tracker.rsid 96784d7f81b8f5a7e516df0d7a1e7558
session.token 449aa58fa6a030aa29b5b45b47acff5b
  • site 0.014 seconds (+0.014); 3.75 MB (+3.750) - afterInitialise
  • site 0.022 seconds (+0.008); 4.25 MB (+0.500) - afterRoute
  • site 0.118 seconds (+0.096); 13.25 MB (+9.000) - afterDispatch
  • site 0.124 seconds (+0.006); 13.25 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.125 seconds (+0.001); 13.50 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.125 seconds (+0.000); 13.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.128 seconds (+0.003); 13.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.128 seconds (+0.000); 13.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.134 seconds (+0.006); 13.50 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.135 seconds (+0.000); 13.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.136 seconds (+0.001); 13.75 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.136 seconds (+0.000); 13.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.141 seconds (+0.005); 13.75 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.145 seconds (+0.004); 13.75 MB (0.000) - onAfterRender
  • site 0.147 seconds (+0.002); 13.75 MB (0.000) - sessionStore
14 MB

92 Queries Logged: 0.019488334655762 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '8f0b254547aaf295c4a299c6c8723cc7'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '8f0b254547aaf295c4a299c6c8723cc7'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '96784d7f81b8f5a7e516df0d7a1e7558'
  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` = '96784d7f81b8f5a7e516df0d7a1e7558'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('96784d7f81b8f5a7e516df0d7a1e7558','0','1670529791','44.192.52.167')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '3715'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  20. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  21. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  22. 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_members.component'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  23. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  24. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  25. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2022-12-08 20:03:11'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  27. SELECT *
      FROM `jos_plugin_params`
      WHERE `jos_plugin_params`.`object_id` = '3715'
      AND `jos_plugin_params`.`folder` = '0'
      AND `jos_plugin_params`.`element` = '0'
  28. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`alias` = 'how-to-recover-your-coinspot-account'
      AND `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '3715'
      AND `jos_blog_entries`.`state` IN ('0','1')
      ORDER BY `state` DESC
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '3715'
  30. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '6767'
      AND `jos_blog_comments`.`state` IN ('1','3')
  31. 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` = 'blog'
      AND `jos_tags_object`.`objectid` = '6767'
      AND `jos_tags`.`admin` = '0'
      GROUP BY jos_tags_object.label,jos_tags.id
  32. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '3715'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2022-12-08 20:03:11' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2022-12-08 20:03:11' )
      ORDER BY `hits` DESC
      LIMIT 5
  33. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('3715')
  34. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('6688','6767')
  35. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '3715'
  36. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '6767'
      AND `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`parent` = '0'
      ORDER BY `created` ASC
  37. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '0'
  38. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  39. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '6767'
      AND `jos_blog_comments`.`id` = '0'
      AND `jos_blog_comments`.`state` IN ('1','3')
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  41. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '3715'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2022-12-08 20:03:11' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2022-12-08 20:03:11' )
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  43. SHOW FULL COLUMNS
      FROM `jos_collections`
  44. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.object_id='3715'
      AND b.object_type='member'
  45. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='3715'
      AND b.object_type='member'
  46. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  47. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      LEFT JOIN jos_author_assoc
      ON jos_author_assoc.subid = jos_resources.id
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` IN ('1')
      AND `jos_author_assoc`.`subtable` = 'resources'
      AND `jos_author_assoc`.`authorid` = '3715'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  49. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '3715'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  50. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`scope` = 'site'
      AND `jos_wiki_pages`.`id` IN ('')
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  52. SHOW FULL COLUMNS
      FROM `jos_courses`
  53. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE m.user_id=3715
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  54. SHOW FULL COLUMNS
      FROM `jos_publications`
  55. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  56. SELECT COUNT(jos_publication_versions.id) AS count
      FROM `jos_publication_versions`
      INNER JOIN jos_publications
      ON jos_publications.id = jos_publication_versions.publication_id
      LEFT JOIN jos_publication_authors
      ON jos_publication_authors.publication_version_id = jos_publication_versions.id
      WHERE `jos_publication_versions`.`state` IN ('1')
      AND `jos_publication_authors`.`user_id` = '3715'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  57. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  58. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  59. SELECT r.*, (SELECT COUNT(m.user_id)
      FROM jos_courses_members AS m
      WHERE m.role_id=r.id
      AND m.`offering_id` IN (0,0)) AS total
      FROM jos_courses_roles AS r
      WHERE r.`offering_id` IN (0,0)
  60. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=3715
      AND m.student=0
      AND r.alias='instructor'
  61. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=3715
      AND m.student=0
      AND r.alias='manager'
  62. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state=1
      AND m.user_id=3715
      AND m.student=1
      AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2022-12-08 20:03:11')
      AND s.state=1
      AND o.state=1
  63. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'xivare7467@zfobo.com'
  64. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 )
  65. SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=3715
      WHERE `jos_xmessage_recipient`.`uid` = '3715'
      AND `jos_xmessage_recipient`.`state` = '0'
  66. SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      WHERE `jos_xmessage_recipient`.`uid` = '3715'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=3715)
  67. SHOW TABLES
  68. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '3715'
  69. SHOW FULL COLUMNS
      FROM `jos_projects`
  70. SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='3715'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='3715'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='3715')))
      AND p.provisioned = 0
  71. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  72. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='xivare7467@zfobo.com'
  73. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2022-12-08 20:03:11'
  74. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2022-12-08 20:03:11'
  75. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2022-12-08 20:03:11'
  76. SHOW TABLES
  77. SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
      FROM `jos_citations`
      LEFT JOIN jos_users AS u
      ON jos_citations.uid = u.id
      LEFT JOIN jos_citations_secondary AS CS
      ON jos_citations.id = CS.cid
      LEFT JOIN jos_citations_format AS F
      ON jos_citations.format = F.style
      WHERE `jos_citations`.`scope` = 'member'
      AND `jos_citations`.`scope_id` = '3715'
      AND `jos_citations`.`published` IN ('1')
  78. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '3715'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  79. ( 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 (g.type='1' OR g.type='3')
      AND 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 (g.type='1' OR g.type='3')
      AND 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 (g.type='1' OR g.type='3')
      AND 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  80. ( 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 ) 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 ) 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 ) 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=3715 )
  81. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '3715';
  82. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  83. 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` <= '2022-12-08 20:03:11' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2022-12-08 20:03:11' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  88. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  89. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  90. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  91. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  92. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1670529791;s:18:\"session.timer.last\";i:1670529791;s:17:\"session.timer.now\";i:1670529791;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\":2:{s:4:\"Blog\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Comment\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:3:\"asc\";}}}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:\"96784d7f81b8f5a7e516df0d7a1e7558\";s:12:\"tracker.ssid\";s:32:\"96784d7f81b8f5a7e516df0d7a1e7558\";s:12:\"tracker.rsid\";s:32:\"96784d7f81b8f5a7e516df0d7a1e7558\";s:13:\"session.token\";s:32:\"449aa58fa6a030aa29b5b45b47acff5b\";}',`time` = '1670529791',`ip` = '44.192.52.167'
      WHERE `session_id` = '96784d7f81b8f5a7e516df0d7a1e7558'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onMembersAreas Method plgMembersDashboard::onMembersAreas /core/plugins/members/dashboard/dashboard.php:87
  • onMembersAreas Method plgMembersProfile::onMembersAreas /core/plugins/members/profile/profile.php:55
  • onMembersAreas Method plgMembersAccount::onMembersAreas /core/plugins/members/account/account.php:59
  • onMembersAreas Method plgMembersBlog::onMembersAreas /core/plugins/members/blog/blog.php:55
  • onMembersAreas Method plgMembersCollections::onMembersAreas /core/plugins/members/collections/collections.php:55
  • onMembersAreas Method plgMembersContributions::onMembersAreas /core/plugins/members/contributions/contributions.php:55
  • onMembersAreas Method plgMembersCourses::onMembersAreas /core/plugins/members/courses/courses.php:55
  • onMembersAreas Method plgMembersGroups::onMembersAreas /core/plugins/members/groups/groups.php:55
  • onMembersAreas Method plgMembersImpact::onMembersAreas /core/plugins/members/impact/impact.php:105
  • onMembersAreas Method plgMembersMessages::onMembersAreas /core/plugins/members/messages/messages.php:55
  • onMembersAreas Method plgMembersPoints::onMembersAreas /core/plugins/members/points/points.php:55
  • onMembersAreas Method plgMembersProjects::onMembersAreas /core/plugins/members/projects/projects.php:71
  • onMembersAreas Method plgMembersResume::onMembersAreas /core/plugins/members/resume/resume.php:85
  • onMembersAreas Method plgMembersUsage::onMembersAreas /core/plugins/members/usage/usage.php:55
  • onMembersAreas Method plgMembersCitations::onMembersAreas /core/plugins/members/citations/citations.php:72
  • onMembersAreas Method plgMembersActivity::onMembersAreas /core/plugins/members/activity/activity.php:54
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:60
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:49
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:59
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:50
  • onContentPrepare Method plgContentFormatwiki::onContentPrepare /core/plugins/content/formatwiki/formatwiki.php:88
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:130
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:65
  • onBlogView Method plgBlogOpengraph::onBlogView /core/plugins/blog/opengraph/opengraph.php:44
  • onBlogView Method plgBlogTwitter::onBlogView /core/plugins/blog/twitter/twitter.php:44
  • onMembersContributionsAreas Method plgMembersResources::onMembersContributionsAreas /core/plugins/members/resources/resources.php:88
  • onMembersContributionsAreas Method plgMembersWiki::onMembersContributionsAreas /core/plugins/members/wiki/wiki.php:53
  • onMembersContributionsAreas Method plgMembersCourses::onMembersContributionsAreas /core/plugins/members/courses/courses.php:379
  • onMembersContributionsAreas Method plgMembersImpact::onMembersContributionsAreas /core/plugins/members/impact/impact.php:221
  • onMembersContributionsAreas Method plgMembersPublications::onMembersContributionsAreas /core/plugins/members/publications/publications.php:90
  • onMembersContributions Method plgMembersResources::onMembersContributions /core/plugins/members/resources/resources.php:142
  • onMembersContributions Method plgMembersWiki::onMembersContributions /core/plugins/members/wiki/wiki.php:90
  • onMembersContributions Method plgMembersCourses::onMembersContributions /core/plugins/members/courses/courses.php:417
  • onMembersContributions Method plgMembersImpact::onMembersContributions /core/plugins/members/impact/impact.php:266
  • onMembersContributions Method plgMembersPublications::onMembersContributions /core/plugins/members/publications/publications.php:127
  • onMembers Method plgMembersDashboard::onMembers /core/plugins/members/dashboard/dashboard.php:113
  • onMembers Method plgMembersProfile::onMembers /core/plugins/members/profile/profile.php:75
  • onMembers Method plgMembersAccount::onMembers /core/plugins/members/account/account.php:85
  • onMembers Method plgMembersBlog::onMembers /core/plugins/members/blog/blog.php:75
  • onMembers Method plgMembersCollections::onMembers /core/plugins/members/collections/collections.php:75
  • onMembers Method plgMembersContributions::onMembers /core/plugins/members/contributions/contributions.php:75
  • onMembers Method plgMembersCourses::onMembers /core/plugins/members/courses/courses.php:78
  • onMembers Method plgMembersGroups::onMembers /core/plugins/members/groups/groups.php:81
  • onMembers Method plgMembersImpact::onMembers /core/plugins/members/impact/impact.php:138
  • onMembers Method plgMembersMessages::onMembers /core/plugins/members/messages/messages.php:81
  • onMembers Method plgMembersPoints::onMembers /core/plugins/members/points/points.php:81
  • onMembers Method plgMembersProjects::onMembers /core/plugins/members/projects/projects.php:96
  • onMembers Method plgMembersResume::onMembers /core/plugins/members/resume/resume.php:185
  • onMembers Method plgMembersUsage::onMembers /core/plugins/members/usage/usage.php:75
  • onMembers Method plgMembersCitations::onMembers /core/plugins/members/citations/citations.php:92
  • onMembers Method plgMembersActivity::onMembers /core/plugins/members/activity/activity.php:78
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:47
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:85
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:49
  • onDisplay Method plgCaptchaImage::onDisplay /core/plugins/captcha/image/image.php:80
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45