Getting this error when users try to log in, running 1.8 7ca

[samoy2002]

Unhandled Exception
Message:
SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'mbbizca_bugs207.USR.id' which is not in SELECT list; this is incompatible with DISTINCT

SQL: SELECT DISTINCT 0 AS project, 0 AS attached, 0 AS tages, USR.email, USR.firstname AS first, USR.lastname as last, CONCAT(USR.firstname, ' ', USR.lastname) AS user, USR.language, 'Robot of BUGS system' AS name, 'A user just connected to BUGS' AS title FROM users AS USR WHERE USR.role_id = 4 ORDER BY USR.id ASC LIMIT 0, 1

Bindings: array (
)
Location:
/home/mbbizca/public_html/bugs/app/laravel/database/connection.php on line 238
Stack Trace:
#0 /home/mbbizca/public_html/bugs/app/laravel/database/connection.php(171): Laravel\Database\Connection->execute('SELECT DISTINCT...', Array)
#1 [internal function]: Laravel\Database\Connection->query('SELECT DISTINCT...')
#2 /home/mbbizca/public_html/bugs/app/laravel/database.php(179): call_user_func_array(Array, Array)
#3 /home/mbbizca/public_html/bugs/app/application/libraries/mail.php(119): Laravel\Database::__callStatic('query', Array)
#4 /home/mbbizca/public_html/bugs/app/application/controllers/login.php(49): Mail::letMailIt(Array, 10, 'en')
#5 [internal function]: Login_Controller->post_index()
#6 /home/mbbizca/public_html/bugs/app/laravel/routing/controller.php(303): call_user_func_array(Array, Array)
#7 /home/mbbizca/public_html/bugs/app/laravel/routing/controller.php(266): Laravel\Routing\Controller->response('index', Array)
#8 /home/mbbizca/public_html/bugs/app/laravel/routing/controller.php(157): Laravel\Routing\Controller->execute('index', Array)
#9 /home/mbbizca/public_html/bugs/app/laravel/routing/route.php(153): Laravel\Routing\Controller::call('login@index', Array)
#10 /home/mbbizca/public_html/bugs/app/laravel/routing/route.php(124): Laravel\Routing\Route->response()
#11 /home/mbbizca/public_html/bugs/app/laravel/laravel.php(158): Laravel\Routing\Route->call()
#12 /home/mbbizca/public_html/bugs/index.php(18): require('/home/mbbizca/p...')
#13 {main}

[Patriboom]

Is there any circumstance when it happens ?
Is that for all users ?
How many users in this BUGS system ?
Did it happen right away after install ?
.... after an update ? If so (after update) did it work good before ?
Is the blocked user have special rights ( is he admin, or observer ... ) ?

I'll try - first - to replicate the problem.

Thanks for this message and for more informations.

[samoy2002]

It is for all users other than myself it seems. There are about 10 users in the bugs install. I am not sure when it happened, as I was just informed of it a few days ago. However, I did update a week ago or so. The blocked user that I am testing with is an admin. He is an admin on all projects. When I go to the admin page I see the following. However, clicking the items does not seem to run the Java script. Also, I went in and manually ran each of the sql statements in MySQL admin and all of them either completed or errored out because it was already done.

…

Sent from my iPhone

On Mar 14, 2022, at 6:27 PM, Patriboom ***@***.***> wrote:  Is there any circumstance when it happens ? Is that for all users ? How many users in this BUGS system ? Did it happen right away after install ? .... after an update ? If so (after update) did it work good before ? Is the blocked user have special rights ( is he admin, or observer ... ) ? I'll try - first - to replicate the problem. Thanks for this message and for more informations. — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you authored the thread.

[Patriboom]

Ok, thanks for your feedback.
You wrote When I go to the admin page I see the following. but provided no screenshot nor description.

My test will go like this:
in existing DB, I'll create a new user with admin permissions on all projects. Then, I'll logoff from my personnal admin and try to login as the newly created admin user. Hopefully, I'll encounter the problem you describ.

[samoy2002]

I guess because I replied to the email it didn’t provide the screenshots onto the forum. I could send them direct if you provide an email.

…

Sent from my iPhone

On Mar 14, 2022, at 7:32 PM, Patriboom ***@***.***> wrote:  Ok, thanks for your feedback. You wrote When I go to the admin page I see the following. but provided no screenshot nor description. My test will go like this: in existing DB, I'll create a new user with admin permissions on all projects. Then, I'll logoff from my personnal admin and try to login as the newly created admin user. Hopefully, I'll encounter the problem you describ. — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you authored the thread.

[Patriboom]

On github, you can drag & drop your file into reply square, it will attached the dropped images.

[Patriboom]

Ok, I think I've figured out.
For now, you'll be able to give them access following these steps:

1. Login yourself as admin
2. Go to the Users admin page
3. Edit a user
4. Define a new password to the user
5. Apply the changes
6. Repeat 3-5 for each user.

I'll fix that later this week.

[Patriboom]

The patch is available, but will not alter the existing users. I'll release a new pre-release ... give you the like after its creation.

The pre-release 18. rev 7cl is available and fixes this giving you the opportunity to define the new user's password.

[samoy2002]

I have installed the patch, 1.8 rev 7ck and then tried what you suggested with changing the password of the user. However, that user is still not able to log in. I believe that reading through your thread, you will be putting out a patch to fix it, I hope I understood that correctly From: Patriboom ***@***.***> Sent: Tuesday, March 15, 2022 7:01 AM To: pixeline/bugs ***@***.***> Cc: samoy2002 ***@***.***>; Author ***@***.***> Subject: Re: [pixeline/bugs] Getting this error when users try to log in, running 1.8 7ca (Issue #778) The patch is available, but will not alter the existing users. I'll release a new pre-release ... give you the like after its creation. - Reply to this email directly, view it on GitHub <#778 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATER5RILOMZTZ4TL34OKX5DVA B3TFANCNFSM5QVWQPXQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&m t=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=u tm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Patriboom]

Hello samoy2002, please make sure your user knows that password is case sensitive v.g: « Pass » is not the same as « pass » which is not the same as « pAss » ... On Wed, 16 Mar 2022 07:59:03 -0700 samoy2002 ***@***.***> écrivites:

…

I have installed the patch, 1.8 rev 7ck and then tried what you suggested with changing the password of the user. However, that user is still not able to log in. I believe that reading through your thread, you will be putting out a patch to fix it, I hope I understood that correctly From: Patriboom ***@***.***> Sent: Tuesday, March 15, 2022 7:01 AM To: pixeline/bugs ***@***.***> Cc: samoy2002 ***@***.***>; Author ***@***.***> Subject: Re: [pixeline/bugs] Getting this error when users try to log in, running 1.8 7ca (Issue #778) The patch is available, but will not alter the existing users. I'll release a new pre-release ... give you the like after its creation. - Reply to this email directly, view it on GitHub <#778 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATER5RILOMZTZ4TL34OKX5DVA [...] Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&m [...] <https://play.google.com/store/apps/details?id=com.github.android&referrer=u tm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> . You are receiving this because you authored the thread.Message ID: [...]

--- Soyez artisans de paix. Patrick Allaire, ptre