Title: Invalid date time format Last modified: June 17, 2024 --- # Invalid date time format * Resolved [Karolina Vyskocilova](https://wordpress.org/support/users/vyskoczilova/) * (@vyskoczilova) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/) * 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! * ```wp-block-code 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](https://wordpress.org/support/users/bensibley/) * (@bensibley) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17831349) * 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](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](https://wordpress.org/support/users/vyskoczilova/) * (@vyskoczilova) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17832604) * Hi There! * As I said – it’s probbly my own name: “Karolína Vyskočilová”. I have a user like this: * ```wp-block-code Name: KarolínaSurname: VyskočilováDisplay name: Karolína Vyskočilová ``` * I can’t see the author column at all: [https://nimb.ws/fjMu5Hp](https://nimb.ws/fjMu5Hp) * Here are the server Infos: * ```wp-block-code Server architecture Linux 5.4.0-1129-gcp x86_64Web server nginx/1.25.5PHP version 8.1.28 (Supports 64bit values)PHP SAPI fpm-fcgiPHP max input variables 10000PHP time limit 300PHP memory limit 256MMax input time 300Upload max filesize 128MPHP post max size 128McURL version 7.68.0 OpenSSL/1.1.1fIs SUHOSIN installed? NoIs the Imagick library available? YesAre pretty permalinks supported? Yes.htaccess rules Custom rules have been added to your .htaccess file.Current time 2024-06-18T10:29:22+00:00Current UTC time Tuesday, 18-Jun-24 10:29:22 UTCCurrent Server time 2024-06-18T10:29:21+00:00 ``` - This reply was modified 1 year, 11 months ago by [Karolina Vyskocilova](https://wordpress.org/support/users/vyskoczilova/). * Plugin Author [Ben Sibley](https://wordpress.org/support/users/bensibley/) * (@bensibley) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17833021) * 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](https://wordpress.org/support/users/vyskoczilova/) * (@vyskoczilova) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17833282) * 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](https://wordpress.org/support/users/bensibley/) * (@bensibley) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17833678) * A staging site would be very helpful. Please reach out to us at [support@independentwp.com](https://wordpress.org/support/topic/invalid-date-time-format/support@independentwp.com?output_format=md), and we can discuss this further and look into the issue with the homepage visitor count as well. * Thread Starter [Karolina Vyskocilova](https://wordpress.org/support/users/vyskoczilova/) * (@vyskoczilova) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17836706) * [@bensibley](https://wordpress.org/support/users/bensibley/) thanks! You have it there <3 * Plugin Author [Ben Sibley](https://wordpress.org/support/users/bensibley/) * (@bensibley) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17836776) * Thank you! I just replied via email with a solution that should work 🙂 * Thread Starter [Karolina Vyskocilova](https://wordpress.org/support/users/vyskoczilova/) * (@vyskoczilova) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17838160) * Seems to work! Thanks a lot once again. * Plugin Author [Ben Sibley](https://wordpress.org/support/users/bensibley/) * (@bensibley) * [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17838743) * **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. * ![](https://ps.w.org/independent-analytics/assets/icon.svg?rev=3504049) * [Independent Analytics - WordPress Analytics Plugin](https://wordpress.org/plugins/independent-analytics/) * [Frequently Asked Questions](https://wordpress.org/plugins/independent-analytics/#faq) * [Support Threads](https://wordpress.org/support/plugin/independent-analytics/) * [Active Topics](https://wordpress.org/support/plugin/independent-analytics/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/independent-analytics/unresolved/) * [Reviews](https://wordpress.org/support/plugin/independent-analytics/reviews/) * 9 replies * 2 participants * Last reply from: [Ben Sibley](https://wordpress.org/support/users/bensibley/) * Last activity: [1 year, 11 months ago](https://wordpress.org/support/topic/invalid-date-time-format/#post-17838743) * Status: resolved