Advertisement:

Author Topic: Database Error!  (Read 275 times)

Offline Palmgren

  • Newbie
  • *
  • Posts: 1
Database Error!
« on: September 16, 2020, 09:42:05 AM »
Hello!

Right after logging in and pressing the button: "Show new replies to your posts." I'll get this error:

Expression #1 of ORDER BY clause is not in SELECT list, references column 'XXXX_XXXX_smf1.t.id_last_msg' which is not in SELECT list; this is incompatible with DISTINCT
File: /home/XXXXXX/public_html/Sources/Recent.php
Line: 1107

My current SMF version is 2.0.17 I have updated everything to the latest version.

Not sure what to look for. Any recommendation is appreciated.

Thanks // T

Offline Dzonny

  • Localizer
  • SMF Super Hero
  • *
  • Posts: 12,275
  • Gender: Male
  • No sleep...
    • dzontra.nikola on Facebook
    • Dzonny on GitHub
    • dzontranikola on LinkedIn
    • @opusteniforum on Twitter
    • Samo opusteno
Re: Database Error!
« Reply #1 on: September 16, 2020, 09:44:57 AM »
Hello there and welcome to SMF community!

Looks like your problem is related to this:
https://www.simplemachines.org/community/index.php?topic=554500.msg3930639#msg3930639

Can you try what's suggested in that topic and let us know if that helped?