Template:JourneyMaterialsDebug
From Dune Awakening DB
The query SELECT data_journey_objectives.journey_id,data_journey_task_components.resource_id,data_journey_task_components.qty FROM `data_journey_task_components` JOIN `data_journey_objectives` ON ((data_journey_tasks.objective_id = data_journey_objectives.id)) JOIN `data_journey_tasks` ON ((data_journey_task_components.task_id = data_journey_tasks.id)) WHERE data_journey_objectives.journey_id=4 is invalid (Error 1054: Unknown column 'data_journey_tasks.objective_id' in 'ON' Function: EDConnectorRdbms::fetch Query: SELECT data_journey_objectives.journey_id,data_journey_task_components.resource_id,data_journey_task_components.qty FROM `data_journey_task_components` JOIN `data_journey_objectives` ON ((data_journey_tasks.objective_id = data_journey_objectives.id)) JOIN `data_journey_tasks` ON ((data_journey_task_components.task_id = data_journey_tasks.id)) WHERE data_journey_objectives.journey_id=4 ).