victorg
committed
on 22 Apr 07
Adding missing ">"
openacs-4/.../upgrade/upgrade-0.8.5-0.9.sql (+1 -1)
102 102
103 103         acs_object.delete(weblogger_channel.delete.channel_id);
104 104
105 105     end delete;
106 106
107 107 end weblogger_channel;
108 108 /
109 109 show errors
110 110
111 111 -- Remove the new parameter rss_file_name and update the old one
112 112 -- We do this since the APM does not know that the old parameter
113 113 -- has been replaced and we want to retain the values of the old parameter
114 114 declare
115 115     v_parameter_id integer;
116 116 begin
117 117
118 118   select parameter_id into v_parameter_id
119 119   from apm_parameters
120 120   where parameter_name = 'rss_file_name';
121 121
122     select apm.unregister_parameter(v_parameter_id) from dual;
  122   apm.unregister_parameter(v_parameter_id);
123 123
124 124 end;
125 125 /
126 126 show errors
127 127
128 128 update apm_parameters
129 129         set parameter_name = 'rss_file_name',
130 130             description = 'What name should we advertise the RSS feed under, relative to the blog mount point. Leave blank if no RSS feed.',
131 131             default_value = 'rss.xml'
132 132         where parameter_name = 'rss_file_url';