This may be a Signup issue. The commits for "date" say this function "wasn't being used anywhere". Does this mean there was no code for this function? I'm wondering why the Signup module calls it and if the fix needs to be in the date module or the signup module. The error in signup is:

Call to undefined function date_field_get_sql_handler() in C:\wamp\www\drupal2\sites\all\modules\signup\includes\date.inc on line 330.

Signup uses this in several functions to get the timezone and to know when to send reminders for events people sign up for.

// Get a DateAPI SQL handler class for this field.
$handler = date_field_get_sql_handler($field, $compare_tz);

// Extract the correct SQL to represent the start time.
$start_time = $handler->sql_field($start_field);

// Create SQL to represent the time we should start sending reminders, based
// on the SQL for the start time and the reminder_days_before field.
$reminder_start = $handler->sql_date_math($start_time, 'SUB', 's.reminder_days_before', 'DAY');
$reminder_stop = $handler->sql_date_math($start_time, 'ADD', 1, 'HOUR');

How can this issue be fixed?

Comments

steven jones’s picture

steven jones commented
Status: Active » Closed (duplicate)

Duplicate of #1459668: date_field_get_sql_handler() removal broke Signup-7.x-1.x-dev

flightrisk’s picture

flightrisk commented
Status: Closed (duplicate) » Active

I am re-opening this here in hopes Karen or someone will answer. The maintainers here will not see the issue in the open issues for another module. I need to know what the new proper way is to get the same functionality from the old date_field_get_sql_handler() routine that was deleted. Since removing this broke the Signup module, what is the approved way to now handle the date + timezone calculations? Is there anything currently in date to replace it, or is the proper way to fix this to just copy the old function and insert it into the broken module because date doesn't handle this anymore?

If there IS a way in date to do this, can someone just outline the steps necessary, maybe even with a little pseudo code of how to begin to tackle the problem? Thanks!

steven jones’s picture

steven jones commented

#1459668: date_field_get_sql_handler() removal broke Signup-7.x-1.x-dev is an issue on date module, this is a duplicate issue.

greenwork’s picture

greenwork commented

This is actually causing my Cron to break as well. I had to disable signup module to allow cron and updates

arlinsandbulte’s picture

arlinsandbulte commented
Status: Active » Closed (duplicate)