Incorrect Oracle syntax in conversion script for Profile2
GENERAL
TESTING
GENERAL
TESTING
Description
The following SQL commands in the Sakai 2.7->2.8 Oracle conversion script are incorrect:
– add the new staff and student info columns and copy old ACADEMIC_INFO value into them to maintain privacy () [...] alter table PROFILE_PRIVACY_T drop ACADEMIC_INFO;
– remove search privacy setting () alter table PROFILE_PRIVACY_T drop SEARCH;
The correct commands are:
alter table PROFILE_PRIVACY_T drop column ACADEMIC_INFO; alter table PROFILE_PRIVACY_T drop column SEARCH;
The following SQL commands in the Sakai 2.7->2.8 Oracle conversion script are incorrect:
– add the new staff and student info columns and copy old ACADEMIC_INFO value into them to maintain privacy ()
[...]
alter table PROFILE_PRIVACY_T drop ACADEMIC_INFO;
– remove search privacy setting ()
alter table PROFILE_PRIVACY_T drop SEARCH;
The correct commands are:
alter table PROFILE_PRIVACY_T drop column ACADEMIC_INFO;
alter table PROFILE_PRIVACY_T drop column SEARCH;