Error in log and an error displayed on the site when trying to access course related info in two differnt views

Anonymous /course-catalogue PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'devopigno.tv.weight' which is not in SELECT list; this is incompatible with DISTINCT: SELECT DISTINCT td.* FROM {taxonomy_term_data} td INNER JOIN {taxonomy_vocabulary} tv ON td.vid = tv.vid LEFT OUTER JOIN {og_membership} ga ON ga.etid = td.tid AND ga.entity_type = :entity_type AND ga.field_name = :field_name WHERE (tv.machine_name = :db_condition_placeholder_0) AND( (ga.gid IS NULL ) ) ORDER BY tv.weight ASC, tv.name ASC, td.weight ASC, td.name ASC; Array ( [:db_condition_placeholder_0] => course_categories [:entity_type] => taxonomy_term [:field_name] => og_group_ref ) in views_handler_filter_term_node_tid->value_form() (line 147 of /var/www/html/devopigno.xxxxxx.org/profiles/opigno_lms/modules/contrib/views/modules/taxonomy/views_handler_filter_term_node_tid.inc). Authenticated /my-courses PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'devopigno.tv.weight' which is not in SELECT list; this is incompatible with DISTINCT: SELECT DISTINCT td.* FROM {taxonomy_term_data} td INNER JOIN {taxonomy_vocabulary} tv ON td.vid = tv.vid LEFT OUTER JOIN {og_membership} ga ON ga.etid = td.tid AND ga.entity_type = :entity_type AND ga.field_name = :field_name WHERE (tv.machine_name = :db_condition_placeholder_0) AND( (ga.gid IS NULL ) OR (ga.gid IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4)) ) ORDER BY tv.weight ASC, tv.name ASC, td.weight ASC, td.name ASC; Array ( [:db_condition_placeholder_0] => course_categories [:db_condition_placeholder_1] => 133 [:db_condition_placeholder_2] => 117 [:db_condition_placeholder_3] => 118 [:db_condition_placeholder_4] => 119 [:entity_type] => taxonomy_term [:field_name] => og_group_ref ) in views_handler_filter_term_node_tid->value_form() (line 147 of /var/www/html/devopigno.xxxxx.org/profiles/opigno_lms/modules/contrib/views/modules/taxonomy/views_handler_filter_term_node_tid.inc).

Anyone able to provide me with any support on this matter? I'm pretty sure I need to re-install a module, but I'm not sure which one. Please advise. Thank you, Roy Roy

No, it's pretty new. It was up for only a week as a sandbox and we had no problems when testing everything as administrators, but when we started to broaden our testing we saw this issue--so consider it a new install uncovering an issue. I have a feeling based upon other posts, that our install process may have been flawed and if not for having to demo the system today, I would do a complete fresh install and test, but I do not have that luxury and I am hoping a simple module reinstall would address the issue. Thanks for the response, please let me know. Thanks, Roy

James, Can we pick this conversation up again? I have approval to move forward to the next stage of work, and I'd like to have an idea of how difficult it will be to address these errors. Roy