Moodle

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.9.5
• Fix Version/s: 1.9.6
• Component/s: Messages
• Labels:

  None
• Environment:

  Moodle 1.9.5+ on Linux running PHP 5.2.10, Apache 2, database is Oracle 10.1

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.

1. 

   lib.php

   12/Oct/09 7:04 PM

   40 kB

   Michael Hughes

• Assignee:

  Dan Marsden

  Reporter:

  Michael Hughes

  Tester:

  Nobody

  Participants:

  Dan Marsden, Michael Hughes

• Created:

  12/Oct/09 7:04 PM

  Updated:

  13/Dec/10 6:38 PM

  Resolved:

  27/Jun/10 4:21 PM