Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.3.2, 2.4.5, 2.5.1
-
Component/s: External Tool (IMS-LTI)
-
Labels:
-
Environment:Ubuntu Server 11.10 32 bits
PHP : 5.3.6
BD : Oracle 10.2.0.1.0
-
Database:Oracle
-
Testing Instructions:
-
Workaround:
-
Affected Branches:MOODLE_23_STABLE, MOODLE_24_STABLE, MOODLE_25_STABLE
-
Fixed Branches:MOODLE_24_STABLE, MOODLE_25_STABLE
-
Pull from Repository:
-
Pull Master Branch:
-
Pull Master Diff URL:
Description
When try to edit a LTI type, fails database and display an error.
Replication steps:
- Log in as admin/teacher
- Navigate to a course
- Turn editing on
- Add an External tool activity
- Add a name for the activity
- Click the + next to External tool type
- Add the following details
Tool name New tool type Tool Base URL http://www.imsglobal.org/developers/BLTI/tool.php Shared secret secret Consumer key 12345 - Save changes to the new type - you should be returned to the activity config
- Click Save and return to course
- Edit the activity
- Try to edit the new type (click the configuration icon next to the new type)
Expected result: You should be able to edit the type configuration
Actual result: An error is shown (Oracle only)
External Tool Configuration
|
|
Error reading from database
|
|
More information about this error
|
Debug info: ORA-01790: expression must have same datatype as corresponding expression
|
SELECT name, value
|
FROM m_lti_types_config
|
WHERE typeid = :o_typeid1
|
UNION ALL
|
SELECT 'toolurl' AS name, baseurl AS value
|
FROM m_lti_types
|
WHERE id = :o_typeid2
|
[array (
|
'o_typeid1' => 1,
|
'o_typeid2' => 1,
|
)]
|
Error code: dmlreadexception
|
Stack trace:
|
|
line 424 of \lib\dml\moodle_database.php: dml_read_exception thrown
|
line 274 of \lib\dml\oci_native_moodle_database.php: call to moodle_database->query_end()
|
line 1101 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
|
line 508 of \mod\lti\locallib.php: call to oci_native_moodle_database->get_records_sql()
|
line 789 of \mod\lti\locallib.php: call to lti_get_type_config()
|
line 124 of \mod\lti\instructor_edit_tool_type.php: call to lti_get_type_type_config()
|