CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Mailing event time stamp
Pages: [1]

Author Topic: Mailing event time stamp  (Read 252 times)

timfluhr

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
Mailing event time stamp
August 01, 2014, 08:35:06 am
Hi everyone.

I have a strange problem.  For many of my civicrm mailings the civicrm_mailing_event_delivered_time_stamp value is set to NULL.  I noticed this when building a drupal view to search for mailings and sort them by delivered date.  I'm not sure of a couple things:

1.  Why/how this became the case.
2.  Where in the database I can go to manually change the value from NULL to something else so it shows up in the views I am creating.

This is 4.2.14 instance of civi running on D6.  Does anyone have any insight?

Thanks!

-tim

timfluhr

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
Re: Mailing event time stamp
August 07, 2014, 08:51:33 am
Hey all.

I'm still kind of stuck on this.  I basically have a bunch of mailings will null values for event_delivered_time stamp.

I would like to fix these manually (at the very least) so they will show up correctly in views I've created, but I can't figure out where in the database to change the value from NULL to some real date.

-tim
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Mailing event time stamp

This forum was archived on 2017-11-26.