Adsense
Popular Posts
- Code update from PHP 7.4 to PHP 8.1 - PhpSpreadsheet
- MySQL workbench -"Could not decrypt password cache"
- Code update from PHP 7.4 to PHP 8.1 - Worksheet/Iterator.php
- Rendering HTML tags inside textarea
- axios handle blob type data
- Unix Utils and wget in Windows
- increase mysql query speed
- Setup vi syntax for PHP
- Get WAMP running on EC2
- EXCEL return to the next line in the same cell
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