Incorrect Date and Time

  • Resolved Gagan Deep Singh

    (@gagan0123)


    4 years, 9 months ago

    Hi,

    I’m having an issue with the plugin, that the date and time for all records is being set as
    10 years ago
    -0001/11/30
    12:00:00 AM

    Its a default WordPress install with a few necessary plugins. One thing I guess could be causing this is MySQL 8. Sites that had this plugin installed before MySQL 8 update, are still working fine, but on the sites, where I installed it after updating to MySQL 8, are having issue.

    Here’s some more info that might help you debug the issue:

    
### wp-core ###

version: 5.4.1
site_language: en_US
user_language: en_US
timezone: +00:00
permalink: /%year%/%monthnum%/%day%/%postname%/
https_status: true
user_registration: 0
default_comment_status: open
multisite: false
user_count: 1
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: {redacted}/htdocs
wordpress_size: 39.49 MB (41408511 bytes)
uploads_path: {redacted}/htdocs/wp-content/uploads
uploads_size: 0.00 B (0 bytes)
themes_path: {redacted}/htdocs/wp-content/themes
themes_size: 3.79 MB (3975557 bytes)
plugins_path: {redacted}/htdocs/wp-content/plugins
plugins_size: 3.32 MB (3484525 bytes)
database_size: 2.33 MB (2441216 bytes)
total_size: 48.93 MB (51309809 bytes)

### wp-dropins (1) ###

object-cache.php: true

### wp-active-theme ###

name: Twenty Twenty (twentytwenty)
version: 1.2 (latest version: 1.3)
author: the WordPress team
author_website: https://www.ads-software.com/
parent_theme: none
theme_features: automatic-feed-links, custom-background, post-thumbnails, custom-logo, title-tag, html5, align-wide, responsive-embeds, customize-selective-refresh-widgets, editor-color-palette, editor-font-sizes, widgets, menus, editor-style
theme_path: {redacted}/htdocs/wp-content/themes/twentytwenty

### wp-themes-inactive (2) ###

Twenty Nineteen: version: 1.5, author: the WordPress team
Twenty Seventeen: version: 2.3, author: the WordPress team

### wp-plugins-active (5) ###

Nginx Helper: version: 2.2.1, author: rtCamp (latest version: 2.2.2)
Redis Object Cache: version: 1.5.7, author: Till Krüss (latest version: 1.5.9)
Stream: version: 3.4.3, author: XWP

### wp-plugins-inactive (2) ###

Akismet Anti-Spam: version: 4.1.5, author: Automattic
Hello Dolly: version: 1.7.2, author: Matt Mullenweg

### wp-media ###

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1687
imagemagick_version: ImageMagick 6.9.7-4 Q16 x86_64 20170114 https://www.imagemagick.org
imagick_limits: 
	imagick::RESOURCETYPE_AREA: 122 MB
	imagick::RESOURCETYPE_DISK: 1073741824
	imagick::RESOURCETYPE_FILE: 768
	imagick::RESOURCETYPE_MAP: 512 MB
	imagick::RESOURCETYPE_MEMORY: 256 MB
	imagick::RESOURCETYPE_THREAD: 1
gd_version: 2.3.0
ghostscript_version: 9.26

### wp-server ###

server_architecture: Linux 4.15.0-96-generic x86_64
httpd_software: nginx/1.16.1
php_version: 7.4.6 64bit
php_sapi: fpm-fcgi
max_input_variables: 1000
time_limit: 30
memory_limit: 256M
max_input_time: 60
upload_max_size: 100M
php_post_max_size: 100M
curl_version: 7.58.0 OpenSSL/1.1.1g
suhosin: false
imagick_availability: true

### wp-database ###

extension: mysqli
server_version: 8.0.20
client_version: mysqlnd 7.4.6

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: {redacted}/htdocs/wp-content
WP_PLUGIN_DIR: {redacted}/htdocs/wp-content/plugins
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_LOCAL_DEV: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable

    Similar issue had already been reported by @tringstad , but not with this much debug info:
    https://www.ads-software.com/support/topic/time-and-date-all-wrong/

    Let me know if anything else is needed for rectifying this issue, would be happy to help.

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

  • @gagan0123 I’ve recently been experiencing this issue as well, but had no idea what was causing it. Your insights on when the error begin to occur, actually gives me a really good idea of where this issue is in the code. I’ll determine if my hunch is correct, and begin patching process as soon as I can.

    There is also an open issue on GitHub to track the progress of this.

    This has been fixed in the latest version of Stream 3.5.0.

    This date issue still exists for me and I’m on 3.5. It’s a local Windows server in my office.

    Thread Starter Gagan Deep Singh

    (@gagan0123)

    Yep, the issue is still there. Will add a screencast for the same shortly. Let me know if anything is needed from my part like MySQL configuration or PHP configuration or any debug log.

    Thank you for confirming! We’ve reopened the issue on GitHub so you can follow the progress there.

    Thread Starter Gagan Deep Singh

    (@gagan0123)

    Hi Guys,

    As I replied on the Github issue, the last patch by @kidunot89 fixed this. Just awaiting release of the plugin here on www.ads-software.com with that patch so that we can mark this topic as resolved.

    Thread Starter Gagan Deep Singh

    (@gagan0123)

    Thanks Stream team for fixing the issue, I can verify that current solution, as implemented in 3.5.1 resolves this issue.

    Thanks again for your support guys ??

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Incorrect Date and Time’ is closed to new replies.