CiviCRM Community Forums (archive)

I can't create an event properly with civicrm_event_create. Any date fields, such as 'start_date' get replaced with zeroes.

For example, I'm setting $params['start_date'] with a string in the form of '2008-05-09 18:00:00' but the in the created event, it ends up as '0000-00-00 00:00:00'. I've also tried setting $params['start_date'] as a DateTime object.

Even this doesn't work, which should make an exact copy of an existing event:

<code>
$event = civicrm_event_get($p);

$cloned_event = $event;
unset($cloned_event['id']);

civicrm_event_create($cloned_event);
</code>

(Yes, I've initialized, included the v2/ file, and set $p with a valid event ID.)

The resulting event is an exact copy, except all the fields that should contains dates contain 0000-00-00 00:00:00 instead.

This sure looks like a bug in the API, unless I'm really missing something.

Any help?

For more example for event create api, you can check following test cases.

http://fisheye.civicrm.org/browse/~raw,r=12855/CiviCRM/trunk/test-new/SimpleTest/api-v2/EventCreate.php

kurund

Also, while we're looking at  counter-intuitive expectations of the Event api,

civicrm_event_delete($params) expects params as ('event_id' => $id), while the rest of the event api functions expect ('id' => $id )

Of course backward compatibility should be preserved, but these functions should be made smarter to deal with formats that match the database along with any current internal formatting.

Also, functions like _get and _delete should accept a single integer as an argument, as an alternative to the array, since only the ID matters anyway.

Ah, very interesting about mysql... feature... :-)

To justify my whining, here's a patch for _get and _delete to do what I suggested for these.

Just apply to /api/v2/Event.php

I wasn't sure if the date formatting issue should be addressed here, or in Core ?