Processwire Not Saving User Data

[Fuzzy]

Hi,

Today I noticed that I cannot save/edit the password, email address or assigned role of existing or new users. I can create a new user but the email address and assigned role will not be saved. In the DB the entry for the user has been created, but the entry for the emails address and passsword is empty (see screenshot below).

The thing is that saving/editing other pages works fine. The problem is only with the user management.

Can someone help me, please?!?

Thanks!

Edited May 27, 2022 by Fuzzy

[Gideon So]

Hi @Fuzzy

No screenshot found and is there any error message you can find from the log?

Gideon

[flydev]

An idea just in case. If you are using a password manager, disable it and try again to save infos.

[Fuzzy]

1 hour ago, Gideon So said:

Hi @Fuzzy

No screenshot found and is there any error message you can find from the log?

Gideon

Hi @Gideon So,

Thanks for your reply. I've added the screenshots to my original post. Page ID 22307 is representing the user, I'm trying to create...

I couldn't find an error message related to this problem. But I noticed that since a while there is an error with the following error message: "SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value".

Thanks for your help!

 

[Fuzzy]

26 minutes ago, flydev ?? said:

An idea just in case. If you are using a password manager, disable it and try again to save infos.

Hi @flydev ??,

unfortunately, that didn't solve the problem...

Thanks for your help!
Deborah

[flydev]

Yes just saw the screenshots. Did you upgraded the MySql engine or ProcessWire ? Can you give us the version of mySql and PW please ?

[Fuzzy]

10 minutes ago, flydev ?? said:

Yes just saw the screenshots. Did you upgraded the MySql engine or ProcessWire ? Can you give us the version of mySql and PW please ?

Processwire has definitely not been updated. We are running on ProcessWire 3.0.123.

Server-Version: 8.0.25-0ubuntu0.20.10.1 - (Ubuntu); PHP 8

[flydev]

8 minutes ago, Fuzzy said:

Processwire has definitely not been updated. We are running on ProcessWire 3.0.123.

Server-Version: 8.0.25-0ubuntu0.20.10.1 - (Ubuntu); PHP 8

Did you upgraded the database server recently ? This could explain your DATETIME issue

 

make a backup of everything (files and database), upgrade ProcessWire to the latest version and try again.

⚠️ ? Do not forget to replace the .htaccess which require an update as you are running a Processwire version < 3.0.135

 

[Fuzzy]

1 hour ago, flydev ?? said:

Did you upgraded the database server recently ? This could explain your DATETIME issue

 

make a backup of everything (files and database), upgrade ProcessWire to the latest version and try again.

⚠️ ? Do not forget to replace the .htaccess which require an update as you are running a Processwire version < 3.0.135

 

The database has not been updated. At least to my knowledge...

Processwire has been updtaed to 3.0.200. Unfortunately, new users cannot be created and existing cannot be modified...

[flydev]

You also should look at what are saying logs => mysql.err log, errors/exceptions.log (pw), webserver errors log. You should be able to find the reason somewhere for sure.

I bet that you cannot add or modify an user due a db issue related to the error you already shown (DATETIME), quite confirmed by looking at the screenshot. If you want me to take a look at your setup, just send me an ssh access by private message, or upload a db backup that I can test.

[Fuzzy]

Ok, thanks @flydev ??. I'll try to figure out more on Monday. If I do not succeed, I will come back to your generous offer ?

Thank you very much for your help!

[Gideon So]

Look like it is related to MySQL 8.0.17