General error: 3065 Expression #1 of ORDER BY

[hrohwer]

Hi Guys,

I get the following error when logging a second user in.

I've traced it down to "->orderBy('created_at')" line 87 in WebsiteNotification.php

By removing it I can continue.

"SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'freescout.threads.created_at' which is not in SELECT list; this is incompatible with DISTINCT (SQL: select distinct id, conversation_id, body from threads where conversation_id in (2) and type in (1, 2, 3) order by created_at asc) (View: C:\laragon\www\FREESCOUT\freescout\resources\views\layouts\app.blade.php) (View: C:\laragon\www\FREESCOUT\freescout\resources\views\layouts\app.blade.php) ◀"

[freescout-helpdesk]

Hi. What version of MySQL/MariaDB are you using?

Try to change line 84 in WebsiteNotification.php to:

->select(['id', 'conversation_id', 'body', 'created_at'])

and line 87 in BroadcastNotification.php:

->select(['body', 'created_at'])

[hrohwer]

MySQL 5.7.19
Changed those lines and seems to work perfectly :)

By the way, great work on this project 👍

[freescout-helpdesk]

Great. Thanks.