SQL error when creating new Content Type/Calendar using Date Tools Wizard

Have the same error, but WHERE 109 = unsupported...

I too am having a similar issue after adding a new date wizard, i gave it a different name to the standard and cannot find any solution now.

Mee too

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type for db_type_placeholder' at line 1 query: UPDATE blocks SET module = 'calendar', delta = '0', theme = 'deco', status = 1, weight = -1, region = 'left', title = '' WHERE 31 = unsupported type for db_type_placeholder in /home/rmanola/www/drupal_travou/includes/common.inc on line 3467.

I have this problem too - with the addition of a problem with field pages too.

# user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type for db_type_placeholder' at line 1 query: UPDATE blocks SET module = 'calendar', delta = '0', theme = 'garland', status = 1, weight = -1, region = 'left', title = '' WHERE 21 = unsupported type for db_type_placeholder in C:\drupal\includes\common.inc on line 3468.
# user warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (module, delta, theme, status, weight, region, custom, throttle, visibility, title, cache) VALUES ('views', 'calendar_event-calendar_block_1', 'garland', 1, -1, 'left', 0, 0, 0, '', 1) in C:\drupal\includes\common.inc on line 3468.
# user warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (module, delta, theme, status, weight, region, custom, throttle, visibility, title, cache) VALUES ('views', 'calendar_event-block_1', 'garland', 1, -1, 'left', 0, 0, 0, '', 1) in C:\drupal\includes\common.inc on line 3468.

Has anyone come up with a workaround? or even better a fix!

Any update on this problem? I'm having the same issue.

When creating a calendar block via the date tools wizard the date_tools_wizard_add_block was passing the block id (bid) instead of the actual field name to drupal_write_record. This only occurs on an update.

The attached patch changes line 812 in date/date_tools/date_tools.module from drupal_write_record('blocks', $block, array($block->bid)) to drupal_write_record('blocks', $block, 'bid').

thanks colinsherry , i couldn't apply it with the patch tool for some reason (didn't spoend any time figuring out why) did it manually and worked like a charm

Committed. Thanks :)