|
|
|
File Attachments:
|
1.
lib.php (40 kB)
|
|
Environment:
|
Moodle 1.9.5+ on Linux running PHP 5.2.10, Apache 2, database is Oracle 10.1
|
|
| Database: |
Oracle
|
| Participants: |
Michael Hughes and moodle.com
|
| Security Level: |
None
|
| Difficulty: |
Easy
|
| Affected Branches: |
MOODLE_19_STABLE
|
|
The messaging box throws an Oracle error when trying to list contacts:
ORA-00911: invalid character
this is due to semi-colons ; added to SQL, oracle does not like these.
with bug reporting turned off the contact list is just shown as empty even if contacts have been added.
Fix: edit /message/lib.php and remove ; from SQL
Edit /message/lib.php:
line 52:
- ORDER BY u.firstname ASC;";
+ ORDER BY u.firstname ASC";
line 82:
- ORDER BY u.firstname ASC;";
+ ORDER BY u.firstname ASC";
Corrected lib.php is attached.
|
|
Description
|
The messaging box throws an Oracle error when trying to list contacts:
ORA-00911: invalid character
this is due to semi-colons ; added to SQL, oracle does not like these.
with bug reporting turned off the contact list is just shown as empty even if contacts have been added.
Fix: edit /message/lib.php and remove ; from SQL
Edit /message/lib.php:
line 52:
- ORDER BY u.firstname ASC;";
+ ORDER BY u.firstname ASC";
line 82:
- ORDER BY u.firstname ASC;";
+ ORDER BY u.firstname ASC";
Corrected lib.php is attached. |
Show » |
| There are no comments yet on this issue.
|
|
Bug
Open
Major
Oracle error in message popup
