Contrib.social

Sql error on admin/content

Open on Drupal.org →
Created on 17 June 2021, almost 4 years ago
Updated 24 November 2023, over 1 year ago

Hello!
I have an issue with the default admin content view;
After upgading to 8.9.16 i am receiving a mysql error:

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column '..' which is not in SELECT list;

This appears when some fields are sortable and the query setting dinstict is enabled.

This seems to be an issue only on our staging environment, not in our production although the Core version and the configuration of the view is the same.

The staging environment uses mysql while production mariabd and I;ve checked the sql_mode variable for both: neither of them has the option ONLY_FULL_GROUP_BY which i've found that could cause an issue like that. Any ideas/suggestions?

🐛 Bug report
Status

Closed: cannot reproduce

Version

9.5

Component
MySQL driver  →

Last updated 11 days ago

Created by

🇬🇷Greece Mirto

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment almost 2 years ago →
    🇳🇿New Zealand quietone

    @Mirto, Did you resolve the problem? Was it an MySQL version problem as stated in #3. If so, add a comment because it may help others. Otherwise, can you add complete steps to reproduce the issue → (starting from "Install Drupal core").

    Since we need more information to move forward with this issue, I am setting the status to Postponed (maintainer needs more info). If we don't receive additional information to help with the issue, it may be closed after three months.

    Changing tags per Issue tags field → and Issue tags -- special tags →

  • Status changed to Closed: cannot reproduce over 1 year ago
  • Comment over 1 year ago →
    🇳🇿New Zealand quietone

    The information needed to continue here hasn't been provided. Hopefully, this was resolved.

    I am closing this issue per #8.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024