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

rpellicano
Forums
These are slightly different errors, but they appear to be caused by the same database error. Please advise on how to fix, or if you need additional information. [Got blocked by Mollom, so let's see if I can post at all and then post the error after the fact.] Thanks, Roy
rpellicano

errors

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).
rpellicano

Anyone able to provide me with any support on this matter?

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
James Aparicio

Hi rpllicano,

Hi rpllicano,

After you installed the distribution you got this error or you have been using it for some time?

Best regards

rpellicano

No, it's pretty new. It was

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
rpellicano

James,

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