Date mismatch between Database and Log List

  • rsquared300

    (@rsquared300)


    1 week, 3 days ago

    Version 1.16.0
    Edge on Windows 11. PHP timezone UTC, database and WordPress America/Detroit (-4)

    The plugin stores the emails in local timezone ie timestamp = 2026-09-08 14:11:42, (2:11:42pm) but then shifts the displayed value on the log page by the WP timezone (-4 for me) and adds 4 hours, arriving at 6:11:24pm, 4 hours into the future. I resolved the issue by modifying the renderer function in wp-mail-logging\src\Renderer\Column\TimestampColumn.php

    public function render(array $mailArray, $format) {
    $rendered = parent::render($mailArray, $format);
    $dt = \DateTime::createFromFormat( 'Y-m-d H:i:s', $rendered, wp_timezone() );
    return wp_date(
    apply_filters( 'wpml_get_date_time_format', '' ),
    $dt->getTimestamp()
    );
    }

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Joao

    (@jplaudares)

    1 week, 2 days ago

    Hi @rsquared300 ,

    Thanks for the detailed write-up on this, the breakdown of your PHP vs. WordPress timezone setup and the exact timestamp math made this very easy to follow.

    You’ve pinpointed it correctly: the log entry is stored in local time, but the renderer treats it as UTC and applies the WordPress offset on top, which double-shifts the displayed value. With your America/Detroit setting that lands you four hours ahead, exactly as you described.

    I’m passing this along to our Product team as a note with your findings attached, including the renderer detail you identified. That’s the right group to weigh a proper fix into a future release.

    Best,

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

Tags