Adsense
Popular Posts
- MySQL workbench -"Could not decrypt password cache"
- peer review (3)
- PHP, dump varailbes in a format way
- "Unusual traffic from your computer network" from blogger
- Install APXS in Redhat Linux
- JavaScript, remove trailing insignificant zeros after toFixed function
- Update member directory
- Set Windows path command line
- JavaScript: add days to current date
- DataTable table order by numeric, not by text
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment