Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 1.9.4
-
Fix Version/s: None
-
Component/s: Database SQL/XMLDB, Messages
-
Labels: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
-
Affected Branches:MOODLE_19_STABLE
Description
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()
Thanks for reporting this issue.
We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.
If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.
Michael d;
lqjjLKA0p6