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

gyan guide45

The profile picture for gyan guide45

Choosing Between MERN and MEAN Stack: Deciphering the Full-Stack Dilemma

Entry #7814
0 comments
Introduction: The landscape of full-stack development is dotted with a myriad of technology stacks, each offering a unique set of tools and capabilities. Two prominent contenders in this arena are the MERN stack (MongoDB, Express.js, React.js, Node.js) and the MEAN stack (MongoDB, Express.js, Angular, Node.js). While both stacks share similarities, they differ in key components, leading developers to ponder the question: MERN or MEAN? 1. Frontend Frameworks: React.js vs Angular • React.js (MERN Stack): • React.js, developed by Facebook, follows a component-based architecture, allowing for the creation of reusable UI components. • Known for its virtual DOM, React enhances performance by minimizing direct manipulation of the actual DOM. • Offers flexibility and a thriving ecosystem of third-party libraries. • Angular (MEAN Stack): • Developed and maintained by Google, Angular is a comprehensive framework with a strong opinionated structure. • Follows a similar component-based architecture, providing modularity and reusability. • Includes features like two-way data binding and dependency injection out of the box. Verdict: The choice between React.js and Angular often boils down to personal preference and project requirements. React.js is favored for its flexibility and simplicity, while Angular is appreciated for its all-inclusive approach and out-of-the-box features. 2. Database: MongoDB • Both Stacks: • MongoDB is a common denominator in both the MERN and MEAN stacks, providing a flexible and scalable NoSQL database solution. • BSON (Binary JSON) format allows for the storage of diverse data types, making it suitable for dynamic applications. • Support for horizontal scaling ensures scalability as your application grows. Verdict: MongoDB's consistency in both stacks simplifies the choice, emphasizing the importance of a NoSQL database in handling the complexities of modern data. 3. Backend: Express.js and Node.js • MERN Stack: • Express.js, a minimalist web application framework, seamlessly integrates with Node.js to handle server-side logic and API requests. • Its simplicity allows for quick setup and customization, making it a preferred choice for developers. • MEAN Stack: • Express.js, being the web application framework, pairs with Node.js to form the backend in the MEAN stack. • Offers a robust and modular structure, aligning well with the opinionated nature of Angular on the frontend. Verdict: Express.js and Node.js are shared components in both stacks, offering a consistent and efficient backend development experience. 4. Learning Curve and Community Support • MERN Stack: • The MERN stack's components are considered more straightforward and have gained popularity for their ease of learning. • A vast and active community provides abundant resources and support for MERN stack developers. • MEAN Stack: • The MEAN stack, with Angular's comprehensive nature, may have a steeper learning curve. • Nevertheless, a robust community supports developers, providing resources and guidance. Verdict: The learning curve can vary based on individual preferences and prior experiences. The community support for both stacks is strong, ensuring assistance for developers at all levels. 1. MongoDB: The Database Layer A NoSQL database called MongoDB stores data in a versatile format called BSON (Binary JSON), which is akin to JSON. Its schema-less nature allows developers to easily adapt to changing data requirements without the need for complex migrations. MongoDB excels in handling large volumes of unstructured or semi-structured data, making it an ideal choice for scalable and dynamic applications. 2. Express.js: The Web Application Framework Express.js is a lightweight and flexible web application framework for Node.js, designed to simplify the process of building robust and scalable web applications. It provides a set of features for building RESTful APIs and handling HTTP requests, making it an essential component for the backend of MERN stack applications. Express.js is known for its minimalist design and extensibility, allowing developers to add middleware and modules as needed. 3. React.js: The Frontend Library React.js is a JavaScript library for building user interfaces, developed by Facebook. It follows a component-based architecture, allowing developers to create reusable UI components and efficiently manage the state of the application. React.js is renowned for its virtual DOM (Document Object Model), which enhances performance by minimizing the need for direct manipulation of the actual DOM. With its declarative syntax and efficient rendering, React.js facilitates the development of interactive and dynamic user interfaces, making it a cornerstone of the MERN stack. 4. Angular: The Frontend Framework Angular is a robust and feature-rich frontend framework developed and maintained by Google. It follows a component-based architecture, enabling developers to build modular and reusable user interface components. Angular provides a declarative approach to building dynamic web applications, simplifying the management of application state and user interactions. With features like two-way data binding, dependency injection, and a powerful templating system, Angular is a key player in the frontend development of MEAN stack applications. 5. Node.js: The JavaScript Runtime Node.js is a server-side JavaScript runtime that executes JavaScript code outside the browser. Its event-driven, non-blocking I/O model makes it well-suited for building scalable and high-performance server-side applications. Node.js, combined with Express.js, forms the backend of the MERN stack, handling server-side logic, API requests, and database interactions. Its ability to use JavaScript on both the client and server sides simplifies the development process and promotes code reuse, contributing to the overall efficiency of MERN stack applications. In the perennial debate of MERN vs MEAN, there is no one-size-fits-all answer. The choice ultimately hinges on your project's requirements, your team's expertise, and personal preferences. The MERN stack may appeal to those who favor simplicity, flexibility, and a thriving React.js ecosystem. On the other hand, the MEAN stack might be a preferred choice for those seeking a comprehensive, opinionated framework with Angular's out-of-the-box features. Get trained in MERN Stack technologies with industry-leading experts at Infocampus Training Institute. Our comprehensive course structure will help you master the fundamentals of MERN Stack development, enabling you to build modern web applications and deploy them to production. Enroll now! For more details Call: 8884166608 or 9740557058 Visit: https://infocampus.co.in/mern-stack-training-in-bangalore.html

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

Close15 MBRequestSessionTimelineDatabase93Events68
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-d... Array(
REDIRECT_SCRIPT_URL => /members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-deciphering-the-full-stack-dilemma,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-deciphering-the-full-stack-dilemma,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-deciphering-the-full-stack-dilemma,
SCRIPT_URI => https://itmig.curie.fr/members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-deciphering-the-full-stack-dilemma,
HTTPS => on,
SSL_TLS_SNI => itmig.curie.fr,
HTTP_ACCEPT => */*,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_HOST => itmig.curie.fr,
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 => 3.144.98.13,
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 => 48866,
REDIRECT_URL => /members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-deciphering-the-full-stack-dilemma,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/8396/blog/2024/01/choosing-between-mern-and-mean-stack-deciphering-the-full-stack-dilemma,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1714784067.884,
REQUEST_TIME => 1714784067
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 3383f16bf0c071c81a0b129c7cab15ae
tracker.ssid ⇒ 3383f16bf0c071c81a0b129c7cab15ae
tracker.rsid ⇒ 3383f16bf0c071c81a0b129c7cab15ae
session.token ⇒ 78e998578c735baa2bb05751e8f6c779
  • site 0.015 seconds (+0.015); 3.75 MB (+3.750) - afterInitialise
  • site 0.023 seconds (+0.008); 4.25 MB (+0.500) - afterRoute
  • site 0.117 seconds (+0.095); 14.50 MB (+10.250) - afterDispatch
  • site 0.122 seconds (+0.005); 14.50 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.124 seconds (+0.002); 14.75 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.124 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.126 seconds (+0.002); 14.75 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.126 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.131 seconds (+0.005); 14.75 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.131 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.132 seconds (+0.001); 15.00 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.132 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.137 seconds (+0.004); 15.00 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.140 seconds (+0.003); 15.00 MB (0.000) - onAfterRender
  • site 0.142 seconds (+0.002); 15.00 MB (0.000) - sessionStore
15 MB

93 Queries Logged: 0.018893003463745 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '31efe7f73f7cd9d6e490304ecda5f2ad'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '31efe7f73f7cd9d6e490304ecda5f2ad'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '3383f16bf0c071c81a0b129c7cab15ae'
  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` = '3383f16bf0c071c81a0b129c7cab15ae'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('3383f16bf0c071c81a0b129c7cab15ae','0','1714784067','3.144.98.13')
  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` = '8396'
  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 > '2024-05-04 00:54:27'
  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` = '8396'
      AND `jos_plugin_params`.`folder` = '0'
      AND `jos_plugin_params`.`element` = '0'
  28. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`alias` = 'choosing-between-mern-
      and-mean-stack-deciphering-the-full-stack-dilemma'
      AND `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '8396'
      AND `jos_blog_entries`.`state` IN ('0','1')
      ORDER BY `state` DESC
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '8396'
  30. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '7814'
      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` = '7814'
      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` = '8396'
      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` <= '2024-05-04 00:54:27' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-05-04 00:54:27' )
      ORDER BY `hits` DESC
      LIMIT 5
  33. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('8396')
  34. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('7665','7668','7676','7683','7687')
  35. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '8396'
  36. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '7814'
      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` = '7814'
      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` = '8396'
      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` <= '2024-05-04 00:54:27' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-05-04 00:54:27' )
  42. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('7665','7668','7676','7683','7687','7711','7728','7737','7744','7753','7754','7755','7757','7761','7765','7768','7771','7773','7774','7775','7778','7781','7785','7787','7788','7790','7791','7793','7795','7799','7800','7804','7805','7807','7808','7809','7810','7811','7812','7813','7814','7815','7816','7818','7819','7820','7821','7822','7823','7824','7825','7826','7827')
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  44. SHOW FULL COLUMNS
      FROM `jos_collections`
  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.object_id='8396'
      AND b.object_type='member'
  46. 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='8396'
      AND b.object_type='member'
  47. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  48. 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` = '8396'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  50. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '8396'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  51. 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 ('')
  52. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  53. SHOW FULL COLUMNS
      FROM `jos_courses`
  54. 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=8396
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  55. SHOW FULL COLUMNS
      FROM `jos_publications`
  56. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  57. 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` = '8396'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  58. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  59. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  60. 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)
  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=8396
      AND m.student=0
      AND r.alias='instructor'
  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 IN (1, 3)
      AND m.user_id=8396
      AND m.student=0
      AND r.alias='manager'
  63. 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=8396
      AND m.student=1
      AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2024-05-04 00:54:27')
      AND s.state=1
      AND o.state=1
  64. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'gyanguide45@gmail.com'
  65. ( 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=8396 ) 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=8396 ) 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=8396 ) 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=8396 )
  66. 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=8396
      WHERE `jos_xmessage_recipient`.`uid` = '8396'
      AND `jos_xmessage_recipient`.`state` = '0'
  67. 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` = '8396'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=8396)
  68. SHOW TABLES
  69. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '8396'
  70. SHOW FULL COLUMNS
      FROM `jos_projects`
  71. 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='8396'
      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='8396'
      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='8396')))
      AND p.provisioned = 0
  72. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  73. 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='gyanguide45@gmail.com'
  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 > '2024-05-04 00:54:27'
  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 > '2024-05-04 00:54:27'
  76. 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 > '2024-05-04 00:54:27'
  77. SHOW TABLES
  78. 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` = '8396'
      AND `jos_citations`.`published` IN ('1')
  79. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '8396'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  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=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 )
  81. ( 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=8396 ) 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=8396 ) 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=8396 ) 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=8396 )
  82. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '8396';
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  84. 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` <= '2024-05-04 00:54:28' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-05-04 00:54:28' )
      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
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  88. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  89. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  90. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  91. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  92. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  93. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714784067;s:18:\"session.timer.last\";i:1714784067;s:17:\"session.timer.now\";i:1714784067;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:\"3383f16bf0c071c81a0b129c7cab15ae\";s:12:\"tracker.ssid\";s:32:\"3383f16bf0c071c81a0b129c7cab15ae\";s:12:\"tracker.rsid\";s:32:\"3383f16bf0c071c81a0b129c7cab15ae\";s:13:\"session.token\";s:32:\"78e998578c735baa2bb05751e8f6c779\";}',`time` = '1714784068',`ip` = '3.144.98.13'
      WHERE `session_id` = '3383f16bf0c071c81a0b129c7cab15ae'
  • 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