Converting multivalue date and time field to smart date recur
Smart date recur
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘field_findit_opportunity_dates_end_value’ at row 1: INSERT INTO “node__field_findit_opportunity_dates” (“bundle”, “deleted”, “entity_id”, “revision_id”, “langcode”, “delta”, “field_findit_opportunity_dates_value”, “field_findit_opportunity_dates_end_value”, “field_findit_opportunity_dates_duration”, “field_findit_opportunity_dates_rrule”, “field_findit_opportunity_dates_rrule_index”, “field_findit_opportunity_dates_timezone”) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_ 2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeho lder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_pl aceholder_10, :db_insert_placeholder_11); Array ( [:db_insert_placeholder_0] => findit_event [:db_insert_placeholder_1] => 0 [:db_insert_placeholder_2] => 8289 [:db_insert_placeholder_3] => 44925 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 1586167200 [:db_insert_placeholder_7] => 253402254000 [:db_insert_placeholder_8] => 4196934780 [:db_insert_placeholder_9] => [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => )
SELECT bundle, entity_id, field_findit_opportunity_dates_value, field_findit_opportunity_dates_end_value, field_findit_opportunity_dates_duration FROM node__field_findit_opportunity_dates;
Shows that all the programs and a good bunch of the events came in just fine:
+----------------+-----------+--------------------------------------+------------------------------------------+-----------------------------------------+
| bundle | entity_id | field_findit_opportunity_dates_value | field_findit_opportunity_dates_end_value | field_findit_opportunity_dates_duration |
+----------------+-----------+--------------------------------------+------------------------------------------+-----------------------------------------+
| findit_event | 38 | 1446526800 | 1446526800 | 0 |
| findit_program | 66 | 1538366400 | 1559879940 | 358559 |
| findit_program | 67 | 1538452800 | 1559879940 | 357119 |
| findit_event | 74 | 1473193800 | 1473199200 | 90 |
| findit_event | 74 | 1473798600 | 1473804000 | 90 |
| findit_event | 74 | 1474403400 | 1474408800 | 90 |
| findit_event | 74 | 1475008200 | 1475013600 | 90 |
| findit_event | 74 | 1475613000 | 1475618400 | 90 |
| findit_event | 74 | 1476217800 | 1476223200 | 90 |
| findit_event | 74 | 1476822600 | 1476828000 | 90 |
| findit_event | 74 | 1477427400 | 1477432800 | 90 |
| findit_event | 76 | 1486925100 | 1486930500 | 90 |
| findit_event | 76 | 1487529900 | 1487535300 | 90 |
| findit_event | 76 | 1488134700 | 1488140100 | 90 |
| findit_event | 76 | 1488739500 | 1488744900 | 90 |
| findit_event | 76 | 1489340700 | 1489346100 | 90 |
| findit_event | 76 | 1489945500 | 1489950900 | 90 |
| findit_event | 76 | 1490550300 | 1490555700 | 90 |
| findit_event | 76 | 1491155100 | 1491160500 | 90 |
| findit_program | 81 | 1475726400 | 1493956740 | 303839 |
| findit_event | 110 | 1530453600 | 1530464400 | 180 |
| findit_event | 110 | 1530972000 | 1530982800 | 180 |
| findit_event | 110 | 1531576800 | 1531587600 | 180 |
| findit_event | 110 | 1532181600 | 1532192400 | 180 |
| findit_event | 110 | 1532786400 | 1532797200 | 180 |
| findit_event | 110 | 1533391200 | 1533402000 | 180 |
| findit_program | 119 | 1561953600 | 1565409540 | 57599 |
| findit_program | 139 | 1593403200 | 1598068740 | 77759 |
| findit_event | 158 | 1467739800 | 1467755100 | 255 |
| findit_event | 158 | 1467826200 | 1467841500 | 255 |
| findit_event | 158 | 1467912600 | 1467927900 | 255 |
| findit_event | 158 | 1467999000 | 1468014300 | 255 |
| findit_event | 158 | 1468258200 | 1468273500 | 255 |
| findit_event | 158 | 1468344600 | 1468359900 | 255 |
| findit_event | 158 | 1468431000 | 1468446300 | 255 |
| findit_event | 158 | 1468517400 | 1468532700 | 255 |
| findit_event | 158 | 1468603800 | 1468619100 | 255 |
| findit_event | 158 | 1468863000 | 1468878300 | 255 |
| findit_event | 158 | 1468949400 | 1468964700 | 255 |
| findit_event | 158 | 1469035800 | 1469051100 | 255 |
| findit_event | 158 | 1469122200 | 1469137500 | 255 |
| findit_event | 158 | 1469208600 | 1469223900 | 255 |
| findit_event | 158 | 1469467800 | 1469483100 | 255 |
| findit_event | 158 | 1469554200 | 1469569500 | 255 |
| findit_event | 158 | 1469640600 | 1469655900 | 255 |
The alleged end date timestamp cannot be converted by the popular online 253402254000
even though it is, according to math 253402254000÷(365×24×60×60), a mere 8,000 years in the future.
Looks like this one may be my problem child, found at the bottom of the results from MySQL [db]> SELECT bundle, entity_id, field_findit_dates_value, field_findit_dates_end_value FROM node__field_findit_dates ORDER BY field_findit_dates_end_value;
| findit_event | 8289 | 2020-04-06T10:00:00 | 9999-12-31T11:00:00 |