Change the Schedule/Send a Hike Change Notice

string(4944) "Database Error; SQL: SELECT DISTINCT `t`.* FROM `wp_43357e2ca3_posts` AS `t` LEFT JOIN `wp_43357e2ca3_podsrel` AS `rel_group_scheduled` ON `rel_group_scheduled`.`field_id` = 912 AND `rel_group_scheduled`.`item_id` = `t`.`ID` LEFT JOIN `wp_43357e2ca3_posts` AS `group_scheduled` ON `group_scheduled`.`ID` = `rel_group_scheduled`.`related_item_id` LEFT JOIN `wp_43357e2ca3_podsrel` AS `rel_group_scheduled_hike_coordinator_1` ON `rel_group_scheduled_hike_coordinator_1`.`field_id` = 3780 AND `rel_group_scheduled_hike_coordinator_1`.`item_id` = `group_scheduled`.`ID` LEFT JOIN `wp_43357e2ca3_users` AS `group_scheduled_hike_coordinator_1` ON `group_scheduled_hike_coordinator_1`.`ID` = `rel_group_scheduled_hike_coordinator_1`.`related_item_id` LEFT JOIN `wp_43357e2ca3_usermeta` AS `group_scheduled_hike_coordinator_3_display_name` ON `group_scheduled_hike_coordinator_3_display_name`.`meta_key` = 'display_name' AND `group_scheduled_hike_coordinator_3_display_name`.`user_id` = `group_scheduled_hike_coordinator_3`.`ID` LEFT JOIN `wp_43357e2ca3_podsrel` AS `rel_group_scheduled_hike_coordinator_2` ON `rel_group_scheduled_hike_coordinator_2`.`field_id` = 24276 AND `rel_group_scheduled_hike_coordinator_2`.`item_id` = `group_scheduled`.`ID` LEFT JOIN `wp_43357e2ca3_users` AS `group_scheduled_hike_coordinator_2` ON `group_scheduled_hike_coordinator_2`.`ID` = `rel_group_scheduled_hike_coordinator_2`.`related_item_id` LEFT JOIN `wp_43357e2ca3_podsrel` AS `rel_group_scheduled_hike_coordinator_3` ON `rel_group_scheduled_hike_coordinator_3`.`field_id` = 24277 AND `rel_group_scheduled_hike_coordinator_3`.`item_id` = `group_scheduled`.`ID` LEFT JOIN `wp_43357e2ca3_users` AS `group_scheduled_hike_coordinator_3` ON `group_scheduled_hike_coordinator_3`.`ID` = `rel_group_scheduled_hike_coordinator_3`.`related_item_id` LEFT JOIN `wp_43357e2ca3_podsrel` AS `rel_hike_leader_1` ON `rel_hike_leader_1`.`field_id` = 1176 AND `rel_hike_leader_1`.`item_id` = `t`.`ID` LEFT JOIN `wp_43357e2ca3_users` AS `hike_leader_1` ON `hike_leader_1`.`ID` = `rel_hike_leader_1`.`related_item_id` LEFT JOIN `wp_43357e2ca3_usermeta` AS `hike_leader_2_display_name` ON `hike_leader_2_display_name`.`meta_key` = 'display_name' AND `hike_leader_2_display_name`.`user_id` = `hike_leader_2`.`ID` LEFT JOIN `wp_43357e2ca3_podsrel` AS `rel_hike_leader_2` ON `rel_hike_leader_2`.`field_id` = 3633 AND `rel_hike_leader_2`.`item_id` = `t`.`ID` LEFT JOIN `wp_43357e2ca3_users` AS `hike_leader_2` ON `hike_leader_2`.`ID` = `rel_hike_leader_2`.`related_item_id` LEFT JOIN `wp_43357e2ca3_postmeta` AS `schedule_status` ON `schedule_status`.`meta_key` = 'schedule_status' AND `schedule_status`.`post_id` = `t`.`ID` LEFT JOIN `wp_43357e2ca3_postmeta` AS `hike_date` ON `hike_date`.`meta_key` = 'hike_date' AND `hike_date`.`post_id` = `t`.`ID` WHERE ( ( (`group_scheduled_hike_coordinator_1`.`display_name` = '' OR `group_scheduled_hike_coordinator_2`.`display_name` = '' OR `group_scheduled_hike_coordinator_3`.`display_name` = '' OR (`hike_leader_1`.`display_name`= '' OR `hike_leader_2`.`display_name`= '') OR '' = 'administrator') AND `schedule_status`.`meta_value`='Published' AND (CAST(`hike_date`.`meta_value` as DATE) BETWEEN CURDATE() and '2025-12-31') ) AND ( `t`.`post_type` = 'schedule_entry' ) AND ( `t`.`post_status` IN ( 'publish' ) ) ) ORDER BY `hike_date`.`meta_value` ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`; Response: Unknown column 'group_scheduled_hike_coordinator_3.ID' in 'on clause'"

(Only valid for future published hikes.)

Steps:

  1. To change the schedule entry, click on the Hike Date link for that entry, fill in the form, and save it.
  2. Click again on the menu item “Change Schedule/Send Hike Change Notice”.
  3. View the Hike Change Notice by clicking on the Hike Name in the column “Hike Change Notice for”.
  4. If the Hike Change Notice looks right, click on “Send” in that row. If not, go back to Step 1.