CiviCRM Community Forums (archive)

Hey!

With Views, when im requesting the field "Event Startdate" to be viewed two times, i get the following error:

warning: DateTime::__construct() [datetime.--construct]: Failed to parse time string (1248265800) at position 7 (: Unexpected character in /var/www/orbizznet/sites/all/modules/civicrm/drupal/modules/views/civicrm/civicrm_handler_field_datetime.inc on line 23.

I want the field to be viewed twice, because the first view displays the full date and the second field displays the day of the event.

Are you familiar with this problem?

thnx in advance!
greets, Frank

Yep, when i display it once, the error is gone 

I am getting the same (I think) error:
warning: DateTime::__construct() [datetime.--construct]: Failed to parse time string (1199941200) at position 8 (0):
Unexpected character in /ebs/home/scethics/public_html/sites/all/modules/civicrm/drupal/modules/views/civicrm/civicrm_handler_field_datetime.inc on line 23.
I am setting an argument on an Start_date, granularity: year.  The start date is also a field within the view, set up in a custom way that does NOT show the year (I only want the start day to show day/mm, end date does day/mm/year).  However, the argument is working, it does filter the event information to only the year in the argument.  but the error shows up on all pages.

In addition, the error appears on any page which has a block from this view, even if that block has no corresponding argument.  Also, if the view returns three events, three errors appear.  One event, one error, etc.

UPDATE: the error appears anywhere I have a view with a cividate in it, whether I have an argument or not.  Yuck!

I am not quite sure what the solution "try a custom date format" means in my case since I am just pulling dates from standard event fields to show them in blocks within drupal.  But I do need the argument since I am setting up views/panels based on the year of the event.

the error in the handler can be fixed  (if you want to dig into code)

by replacing the contents of the handler <Drupal Modules folder>/civicrm/drupal/modules/views/civicrm/civicrm_handler_field_datetime.inc with the code below

<?php

/*
 * Unchanged anonymous code contribution. No claim.
 *
 * civicrm_handler_field_datetime.inc
 * Converts and displays text to something views friendly.
 *
 */

class civicrm_handler_field_datetime extends views_handler_field_date {

    /*
     * Convert the DATETIME from the database into unixtime then allow
     * views_handler_field_date to render as usual.
     * Also trick php into thinking the time is in the same timezone, no
     * matter the default timezone
     */
    function render($values) {
        // get default time zone form Drupal
        $timezone = variable_get('date_default_timezone', 0);
        $value = $values->{$this->field_alias};

        
        if(is_string($value)) {
            $date = new DateTime($value);
            $gmt = $date->getOffset();  //gives me the offset to GMT
            $value = strtotime($value);
             //set the timestamp to GMT
            $value = $value + $gmt;
            //set the timestamp to site default
            $value = $value - $timezone;

            if($value) {
                $values->{$this->field_alias} = $value;
            }
        }

        return parent::render($values);
    }
}

?>