Wednesday, November 20, 2013

Some bugs when migrating to canhealth for copy research projects





 copy manage_review_assignments.php under research/projects
cop research/_lib/projects/tools.inc.php. rp_manage_review_assignment.php
DELETE FROM cnsh_research_projects.review_slot_reviewers WHERE review_slot_id=0;
DELETE FROM cnsh_research_projects.review_slot_subjects  WHERE review_slot_id=0;
DELETE FROM cnsh_research_projects.subject_assets WHERE asset_id=0 ;
DELETE  FROM  cnsh_research_projects.survey_questions WHERE survey_id=0;
DELETE  FROM cnsh_research_projects.test_questions WHERE test_id=0;

Finally to solve extra subjects under last reviewers using:
DELETE  FROM cnsh_research_projects.review_slot_reviewers;
DELETE FROM cnsh_research_projects.review_slot_reviewers;
DELETE FROM cnsh_research_projects.review_slot_subjects;

http://139.173.32.21:8081/research/projects/view_project.php?pid=12
custom group is not transfer properly.
This is due to that  in table cnsh_research_projects.test_schedule_groups
if  custom_group  =1, group_id should use c_group_id in custom group.
admin/research_projects/copy_rp.php.  line 479 change
             if($key == 'group_id'){
                              $s3[] = "group_id=".$group_match[$row3['group_id']] ;
                continue;
             }

to
             if($key == 'group_id'){
                if($row3['custom_group']==1) $s3[] = "group_id=".$c_group_match[$row3['group_id']] ;
                else
                $s3[] = "group_id=".$group_match[$row3['group_id']] ;
                continue;
             }

http://139.173.32.21:8081/research/projects/upload_subject_data.php,
subject is not attached.
research/projects/upload_subject_asset.php copy from cesei

No comments:

Post a Comment