How can I change the "repeating date" in the date field? [#2348575]

Hi Everyone,

How can I change the "repeating date" in the date field? It's switched to "No" at the moment and I cannot change it to "Yes" as the field is greyed out.

Best Regards
Viki

Comments

Comment #1

vikicica22 CreditAttribution: vikicica22 commented 2 October 2014 at 00:05

Component:

Code

» Date Field

Comment #2

caspervoogt CreditAttribution: caspervoogt at Plethora commented 20 January 2017 at 22:58

The problem is that your date field already has data in it. The way I solve this is to temporarily remove all date from that field's table and its revision table. So if my field is called field_event, these two tables would be affected;

field_data_field_date
field_revision_field_date

Use phpmyadmin or command line tools to export the data from those two tables, then truncate those two tables. It also would be wise to back up the entire DB first, just in case.

Then, go back and edit your field in Drupal's field admin. Now you can change the Repeat settings. Make that change and then import the SQL export (containing the date field data) back into your database.