Invalid date time format

  • Resolved Karolina Vyskocilova

    (@vyskoczilova)


    1 year, 10 months ago

    Hi guys, do you have an idea what’s going on here? The value looks like my surname HTML encoded (“Vyskočilová”).

    Let me know, if you need more. details!

    024/06/17 08:13:34 [error] 10861#10861: *42012 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC4\x8Dilov...' for column kybernaut.wp_independent_analytics_resources.cached_author at row 1 in /www/kybernaut_715/public/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php:446
Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Ben Sibley

    (@bensibley)

    1 year, 10 months ago

    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!

    Thread Starter Karolina Vyskocilova

    (@vyskoczilova)

    1 year, 10 months ago

    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
    Plugin Author Ben Sibley

    (@bensibley)

    1 year, 10 months ago

    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?

    Thread Starter Karolina Vyskocilova

    (@vyskoczilova)

    1 year, 10 months ago

    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!

    Plugin Author Ben Sibley

    (@bensibley)

    1 year, 10 months ago

    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.

    Thread Starter Karolina Vyskocilova

    (@vyskoczilova)

    1 year, 10 months ago

    @bensibley thanks! You have it there <3

    Plugin Author Ben Sibley

    (@bensibley)

    1 year, 10 months ago

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

    Thread Starter Karolina Vyskocilova

    (@vyskoczilova)

    1 year, 10 months ago

    Seems to work! Thanks a lot once again.

    Plugin Author Ben Sibley

    (@bensibley)

    1 year, 10 months ago

    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.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Invalid date time format’ is closed to new replies.