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

MERN vs. MEAN: Choosing the Right Stack for Your Web Development Needs

Entry #7810
0 comments
Introduction: Web development has evolved significantly in recent years, and developers now have a plethora of choices when it comes to selecting a technology stack for building robust and scalable applications. Two popular choices in the world of full-stack development are MERN (MongoDB, Express.js, React, Node.js) and MEAN (MongoDB, Express.js, Angular, Node.js). In this article, we will delve into the strengths and weaknesses of both stacks to help you make an informed decision based on your project requirements. MERN Stack Overview: 1. MongoDB: MERN stack's database is MongoDB, a NoSQL database that is known for its flexibility and scalability. It stores data in JSON-like BSON format, making it suitable for handling large amounts of unstructured data. 2. Express.js: Express.js is a minimal and flexible Node.js web application framework that provides a robust set of features for web and mobile applications. It simplifies the process of building web applications and APIs with Node.js. 3. React: Facebook created the JavaScript package React, which is used to create user interfaces. It enables developers to create reusable UI components and build single-page applications that offer a seamless and dynamic user experience. 4. Node.js: Node.js is a server-side JavaScript runtime that executes JavaScript code outside of a web browser. It allows developers to build scalable network applications and is an essential component of the MERN stack. ReactJS: 1. Library vs. Framework: React is often referred to as a library rather than a framework. It focuses primarily on the view layer of the application, allowing developers to integrate it into existing projects without imposing a rigid structure. 2. Component-Based Architecture: React is built around a component-based architecture, where the UI is divided into independent and reusable components. This promotes code reusability, maintainability, and a modular approach to development. 3. JSX: React uses JSX, a syntax extension that allows developers to write HTML elements and components in a syntax that closely resembles XML or HTML. This enables a more declarative and readable code structure. 4. Flexibility: React is often praised for its flexibility. Developers can choose their preferred tools and libraries for state management (e.g., Redux) or routing, allowing for a more customized development experience. MEAN Stack Overview: 1. MongoDB: Like in the MERN stack, MongoDB is the database of choice in the MEAN stack. Its NoSQL nature allows for flexible data storage, making it suitable for dynamic and evolving applications. 2. Express.js: Express.js serves as the backend web application framework in the MEAN stack, just as it does in the MERN stack. It simplifies the process of building APIs and handling requests and responses. 3. Angular: Angular is a TypeScript-based web application framework developed and maintained by Google. It is known for its robust features and is ideal for building dynamic and interactive single-page applications. 4. Node.js: Similar to the MERN stack, Node.js is the runtime environment that executes server-side JavaScript in the MEAN stack. AngularJS: 1. Full-Fledged Framework: AngularJS is a comprehensive front-end framework developed and maintained by Google. It provides a more opinionated structure, covering not just the view layer but also routing, dependency injection, and more. 2. Two-Way Data Binding: AngularJS employs two-way data binding, a feature that automatically synchronizes the model and the view. This simplifies the code and reduces the need for boilerplate code to keep the UI and data in sync. 3. TypeScript: AngularJS is built with TypeScript, a superset of JavaScript that introduces static typing. TypeScript can catch errors during development, providing a more robust and maintainable codebase. 4. Dependency Injection: AngularJS includes a powerful dependency injection system, making it easier to manage and test components by injecting dependencies at runtime. Comparison: 1. Frontend Frameworks: • MERN uses React, which is known for its component-based architecture and virtual DOM, offering a highly efficient and responsive user interface. • MEAN uses Angular, a full-fledged framework that provides a more opinionated structure and a set of tools for building large-scale applications. 2. Learning Curve: • React's learning curve is generally considered more gradual, making it accessible to developers with varying levels of experience. • Angular, on the other hand, has a steeper learning curve due to its comprehensive framework and the use of TypeScript. 3. Flexibility and Opinionating: • MERN stack is often praised for its flexibility, allowing developers to choose libraries and tools based on project requirements. • MEAN stack, with Angular, is more opinionated and provides a structured approach to development, which can be beneficial for large teams and projects. 4. Community and Ecosystem: • Both MERN and MEAN have large and active communities, with a rich ecosystem of libraries, tools, and resources available for developers. • React has gained widespread adoption, while Angular is known for its enterprise-level support and robustness. Conclusion: Choosing between MERN and MEAN ultimately depends on the specific needs and goals of your project, as well as the expertise of your development team. If flexibility and a gentle learning curve are essential, MERN might be the better choice. On the other hand, if you prefer a more opinionated structure and need a comprehensive framework for building large-scale applications, MEAN with Angular could be the right fit. Both stacks have their strengths, and successful implementation depends on understanding the nuances of each and aligning them with your project requirements. Become a master of MERN stack development with our comprehensive training program in Bangalore. Infocampus offers hands-on training, real-world projects, and expert guidance to help you excel in this high-demand field. Enroll now and kickstart your career as a MERN stack developer with confidence. For more details Call: 8884166608 or 9740557058 Visit: https://infocampus.co.in/mern-stack-training-in-bangalore.html
  1. Angular JS
  2. MERN Stack
  3. React Js
  4. Web Design
  5. Web Development

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/2023/12/mern-vs-mean-choosing-the-right-stack-... Array(
REDIRECT_SCRIPT_URL => /members/8396/blog/2023/12/mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/members/8396/blog/2023/12/mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/8396/blog/2023/12/mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs,
SCRIPT_URI => https://itmig.curie.fr/members/8396/blog/2023/12/mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs,
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 => 18.226.251.68,
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 => 1215,
REDIRECT_URL => /members/8396/blog/2023/12/mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/8396/blog/2023/12/mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1714320515.268,
REQUEST_TIME => 1714320515
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 940d6c581077e1ca58ce7450da3540fd
tracker.ssid ⇒ 940d6c581077e1ca58ce7450da3540fd
tracker.rsid ⇒ 940d6c581077e1ca58ce7450da3540fd
session.token ⇒ f754ac4efb788f54abe034582e22097e
  • 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.111 seconds (+0.089); 14.50 MB (+10.250) - afterDispatch
  • site 0.116 seconds (+0.005); 14.50 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.117 seconds (+0.001); 14.75 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.118 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.121 seconds (+0.003); 14.75 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.121 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.126 seconds (+0.005); 14.75 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.126 seconds (+0.000); 14.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.127 seconds (+0.001); 15.00 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.127 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.132 seconds (+0.004); 15.00 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.134 seconds (+0.003); 15.00 MB (0.000) - onAfterRender
  • site 0.136 seconds (+0.002); 15.00 MB (0.000) - sessionStore
15 MB

93 Queries Logged: 0.015600919723511 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'db7c6eedee68f1c549eca4a5f49be242'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = 'db7c6eedee68f1c549eca4a5f49be242'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '940d6c581077e1ca58ce7450da3540fd'
  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` = '940d6c581077e1ca58ce7450da3540fd'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('940d6c581077e1ca58ce7450da3540fd','0','1714320515','18.226.251.68')
  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-04-28 16:08:35'
  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` = 'mern-vs-mean-choosing-the-right-stack-for-your-web-development-needs'
      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` = '7810'
      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` = '7810'
      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-04-28 16:08:35' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-04-28 16:08:35' )
      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` = '7810'
      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` = '7810'
      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-04-28 16:08:35' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-04-28 16:08:35' )
  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-04-28 16:08:35')
      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-04-28 16:08:35'
  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-04-28 16:08:35'
  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-04-28 16:08:35'
  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-04-28 16:08:35' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-04-28 16:08:35' )
      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:1714320515;s:18:\"session.timer.last\";i:1714320515;s:17:\"session.timer.now\";i:1714320515;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:\"940d6c581077e1ca58ce7450da3540fd\";s:12:\"tracker.ssid\";s:32:\"940d6c581077e1ca58ce7450da3540fd\";s:12:\"tracker.rsid\";s:32:\"940d6c581077e1ca58ce7450da3540fd\";s:13:\"session.token\";s:32:\"f754ac4efb788f54abe034582e22097e\";}',`time` = '1714320515',`ip` = '18.226.251.68'
      WHERE `session_id` = '940d6c581077e1ca58ce7450da3540fd'
  • 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