Invalid date time format

Hi there,

I decoded the string “\xC4\x8Dilov” and it worked out to be ?ilov. We created an author using the same name, but we couldn’t reproduce this same error: https://d.pr/i/bNNv1u. Based on the ellipsis in the error message, it looks like this may be part of a longer name, so if that’s the case, please share the full name and we’ll try that as well.

It would also be helpful if you could share a screenshot of the server info from the Tools > Site Health > Info menu.

Thank you!

Hi There!

As I said – it’s probbly my own name: “Karolína Vysko?ilová”. I have a user like this:

Name: Karolína
Surname: Vysko?ilová
Display name: Karolína Vysko?ilová

I can’t see the author column at all: https://nimb.ws/fjMu5Hp

Here are the server Infos:

Server architecture	Linux 5.4.0-1129-gcp x86_64
Web server	nginx/1.25.5
PHP version	8.1.28 (Supports 64bit values)
PHP SAPI	fpm-fcgi
PHP max input variables	10000
PHP time limit	300
PHP memory limit	256M
Max input time	300
Upload max filesize	128M
PHP post max size	128M
cURL version	7.68.0 OpenSSL/1.1.1f
Is SUHOSIN installed?	No
Is the Imagick library available?	Yes
Are pretty permalinks supported?	Yes
.htaccess rules	Custom rules have been added to your .htaccess file.
Current time	2024-06-18T10:29:22+00:00
Current UTC time	Tuesday, 18-Jun-24 10:29:22 UTC
Current Server time	2024-06-18T10:29:21+00:00

• This reply was modified 5 months, 1 week ago by Karolina Vyskocilova.

The Author column isn’t visible by default, but you can display it by clicking the Toggle Columns button and then enabling it in the table.

When do you get this error message? Does it happen when you view the Pages report, or is it triggered when a new view is recorded?

To be honest, I don’t know – I get it when I loging into the website, but kinsta surpresses the same error messages for six hours :/ But I got it repeatedly. If it helps, I can give you access to the staging site (and I can copy the current state for you).

And as well it looks like the counting of the visitors is somehow underestimated, at least it looks like to me (no visit to the homepage etc.).

Is there any easy way to debug?

Thanks!

A staging site would be very helpful. Please reach out to us at [email protected], and we can discuss this further and look into the issue with the homepage visitor count as well.

@bensibley thanks! You have it there <3

Thank you! I just replied via email with a solution that should work ??

Seems to work! Thanks a lot once again.

Note: if anyone else experiences this error, the underlying issue was that the database was using a collation that didn’t include characters used in an author’s name. It was resolved by changing the collation of the tables to utf8mb4_unicode_520_ci.