Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

opt-in: wrong time shown in reports module for opt-in related dates #6487

Closed
lazka opened this issue Nov 12, 2018 · 0 comments
Closed

opt-in: wrong time shown in reports module for opt-in related dates #6487

lazka opened this issue Nov 12, 2018 · 0 comments
Labels
Priority:Critical Issues & PRs that are critical; broken core functionality, fatal errors - there are no workarounds Type:Bug Bugs within the core SuiteCRM codebase
Milestone

Comments

@lazka
Copy link
Contributor

lazka commented Nov 12, 2018

Issue

Creating a report which shows opt-in related date/time files for related email
addresses shows them all off by one/two hours.

Expected Behavior

The report should show the right date/times

Actual Behavior

It shows all times off by one/two hours (local vs GMT)

Possible Fix

PR: #6488

Steps to Reproduce

  1. Create a user and do a confirmed-opt-in
  2. Create a report showing the opt-in fields
  3. Compare the shown fields with the actual time when the actions took place

Context

We are trying to automate some things based on the opt-in state.
The wrong time and jumps on daylight saving transitions make this hard.

Your Environment

  • SuiteCRM Version used: 7.10.10
  • Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Firefox 63
  • Environment name and version (e.g. MySQL, PHP 7): PHP7.2
  • Operating System and version (e.g Ubuntu 16.04): Centos 7

Report Screenshot

bug

samus-aran added a commit that referenced this issue Dec 18, 2018
Fixed #6487 - opt-in: use the DB time for writing confirm_opt_in_*date
@samus-aran samus-aran added Type:Bug Bugs within the core SuiteCRM codebase Priority:Critical Issues & PRs that are critical; broken core functionality, fatal errors - there are no workarounds Priority:Important Issues & PRs that are important; broken functions, errors - there are workarounds labels Dec 18, 2018
@Dillon-Brown Dillon-Brown removed the Priority:Important Issues & PRs that are important; broken functions, errors - there are workarounds label Dec 31, 2018
@Dillon-Brown Dillon-Brown added this to the 7.10.12 milestone Dec 31, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Priority:Critical Issues & PRs that are critical; broken core functionality, fatal errors - there are no workarounds Type:Bug Bugs within the core SuiteCRM codebase
Projects
None yet
Development

No branches or pull requests

4 participants