-
Bug
-
Resolution: Fixed
-
Minor
-
3.0.5, 3.1.1, 3.2
-
MOODLE_30_STABLE, MOODLE_31_STABLE, MOODLE_32_STABLE
-
MOODLE_30_STABLE, MOODLE_31_STABLE
-
MDL-55886-master -
If the database is Oracle, the name of the feeds are not displayed if they are haven't preferredtitle. With Oracle, a space (' ') is stored in preferredtitle instead of empty string (''). Thats why the following SQL sentence in /blocks/rss_client/edit_form.php file is not working for us:
{{
$titlesql = "CASE WHEN preferredtitle = '' THEN {$DB->sql_compare_text('title', 64)} ELSE preferredtitle END";
}}
To make it work with any database it would be necessary to replace the previous line with the following:
{{
$titlesql = "CASE WHEN preferredtitle = '' OR TRIM(preferredtitle) IS NULL THEN {$DB->sql_compare_text('title', 64)} ELSE preferredtitle END";
}}
With ORACLE the behaviour of TRIM is different from MySQL and returns NULL instead ''. So its necessary to mantein the current check and to add the correct one for Oracle to make code compatible with any database system.
- is a regression caused by
-
MDL-52599 Configure remote RSS feeds page lists "Array" if no user or shared feeds but existing feeds
-
- Closed
-