[MDL-31546] Semicolon in SQL breaks wiki 'Administration' tab on Oracle - Moodle Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 2.1.4
Fix Version/s: 2.1.5, 2.2.2
Component/s: Wiki (2.x)
Labels:
- patch
- triaged

Database:

Oracle
Affected Branches:
MOODLE_21_STABLE
Fixed Branches:
MOODLE_21_STABLE, MOODLE_22_STABLE
Pull from Repository:
git://github.com/danpoltawski/moodle.git
Pull Master Branch:
~~MDL-31546~~-master
Pull Master Diff URL:
https://github.com/danpoltawski/moodle/compare/MDL-31546-master
Difficulty:
Easy
Testing Instructions:

Hide

1/ Create a wiki activity in a course
2/ Add a page
3/ Click the administration tab
Expected Result:
Admin page with menu and list of orphaned apge
Actual Result
Oracle DB error

Show
1/ Create a wiki activity in a course 2/ Add a page 3/ Click the administration tab Expected Result: Admin page with menu and list of orphaned apge Actual Result Oracle DB error

Description

A semicolon at the end of the SQL query in wiki_get_orphaned_pages() causes an exception on Oracle. Patch attached.

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

MDL-31546-stray-semicolon.patch
0.7 kB
08/Feb/12 6:11 PM

Activity

People

Assignee:: Dan Poltawski

Reporter:: Jonathon Fowler

Peer reviewer:: Dan Poltawski

Integrator:: Eloy Lafuente (stronk7)

Tester:: Aparup Banerjee

Participants:: Aparup Banerjee, Dan Poltawski, Eloy Lafuente (stronk7), Jonathon Fowler, Michael de Raadt

Component watchers:: Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona)

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 08/Feb/12 6:09 PM

Updated:: 02/Mar/12 3:43 AM

Resolved:: 02/Mar/12 3:43 AM

Fix Release Date:: 12/Mar/12