Issue Details (XML | Word | Printable)

Key: MDL-18336
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: moodle.com
Reporter: Gleidson Lacerda
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

ORA-00911: invalid character

Created: 21/Feb/09 02:44 AM   Updated: 23/Mar/09 08:29 AM
Return to search
Component/s: Database SQL/XMLDB, Messages
Affects Version/s: 1.9.4
Fix Version/s: None

Environment: SunOS geia 5.10 Generic_118833-36 sun4v, Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8i PHP/5.2.6 DAV/2, oci8 1.2.5 $Revision: 1.269.2.16.2.43 $, Oracle Enterprise 10

Database: Oracle
URL: http://exemple.com/moodle/message/index.php
Participants: Gleidson Lacerda and moodle.com
Security Level: None
Affected Branches: MOODLE_19_STABLE


 Description  « Hide
This debug error is showed at pop-up, insted messages and contacts:

ORA-00911: invalid character

SELECT u.id, u.firstname, u.lastname, u.picture, u.imagealt, u.lastaccess, count(m.id) as messagecount FROM m_message_contacts mc JOIN m_user u ON u.id = mc.contactid LEFT OUTER JOIN m_message m ON m.useridfrom = mc.contactid AND m.useridto = 3 WHERE mc.userid = 3 AND mc.blocked = 0 GROUP BY u.id, u.firstname, u.lastname, u.picture, u.imagealt, u.lastaccess ORDER BY u.firstname ASC;

    * line 686 of lib/dmllib.php: call to debugging()
    * line 54 of message/lib.php: call to get_recordset_sql()
    * line 87 of message/index.php: call to message_print_contacts()

ORA-00911: invalid character

SELECT u.id, u.firstname, u.lastname, u.picture, u.imagealt, u.lastaccess, count(m.id) as messagecount FROM m_message m JOIN m_user u ON u.id = m.useridfrom LEFT OUTER JOIN m_message_contacts mc ON mc.contactid = m.useridfrom AND mc.userid = m.useridto WHERE mc.id IS NULL AND m.useridto = 3 GROUP BY u.id, u.firstname, u.lastname, u.picture, u.imagealt, u.lastaccess ORDER BY u.firstname ASC;

    * line 686 of lib/dmllib.php: call to debugging()
    * line 84 of message/lib.php: call to get_recordset_sql()
    * line 87 of message/index.php: call to message_print_contacts()

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Gleidson Lacerda made changes - 21/Feb/09 02:47 AM
Field Original Value New Value
Priority Minor [ 4 ] Major [ 3 ]
Dan Poltawski made changes - 23/Mar/09 08:29 AM
Component/s Database SQL/XMLDB [ 10131 ]