From 064535489be44c6955b09785615fa257d0f39ea7 Mon Sep 17 00:00:00 2001
From: Sashi20
Date: Tue, 24 Sep 2019 15:26:34 +0530
Subject: Modify column names to fix errors

---
 full_download.inc | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/full_download.inc b/full_download.inc
index 8d7fe3f..e7aca68 100755
--- a/full_download.inc
+++ b/full_download.inc
@@ -27,7 +27,7 @@ function lab_migration_download_full_experiment()
     while ($solution_row = $solution_q->fetchObject())
       {
         $CODE_PATH = 'CODE' . $solution_row->code_number . '/';
-        $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.soultion_id = :solution_id", array(':solution_id' => $solution_row->id));
+        $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.solution_id = :solution_id", array(':solution_id' => $solution_row->id));
         while ($solution_files_row = $solution_files_q->fetchObject())
           {
             $zip->addFile($root_path . $solution_files_row->directory_name. '/' . $solution_files_row->filepath, $APPROVE_PATH . $EXP_PATH . $CODE_PATH . $solution_files_row->filename);
@@ -42,7 +42,7 @@ function lab_migration_download_full_experiment()
     while ($solution_row = $solution_q->fetchObject())
       {
         $CODE_PATH = 'CODE' . $solution_row->code_number . '/';
-        $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.soultion_id = :solution_id", array(':solution_id' => $solution_row->id));
+        $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.solution_id = :solution_id", array(':solution_id' => $solution_row->id));
         while ($solution_files_row = $solution_files_q->fetchObject())
           {
             $zip->addFile($root_path . $solution_files_row->directory_name . '/' . $solution_files_row->filepath, $PENDING_PATH . $EXP_PATH . $CODE_PATH . $solution_files_row->filename);
-- 
cgit