Información de depuración: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%3E45
)
)
ORDER BY ' at line 15
SELECT
C.*,
(
SELECT CFD.value
FROM str_customfield_data AS CFD
JOIN str_customfield_field AS CFF ON CFF.shortname = "creacion" AND CFF.id = CFD.fieldid
WHERE CFD.instanceid = C.id
) AS creacion
FROM str_course AS C WHERE C.id != 1 AND C.category = ? AND C.lang = ? AND C.visible = 1
AND (C.id IN (
SELECT C.id
FROM str_course AS C
JOIN str_customfield_data AS CFD ON CFD.instanceid = C.id
JOIN str_customfield_field AS CFF ON CFF.shortname = 'duracion' AND CFF.id = CFD.fieldid
WHERE CFD.value >= %3E45
)
)
ORDER BY creacion DESC LIMIT 0,12
-- line 125 of /local/course_catalog/classes/util.php: call to mysqli_native_moodle_database->get_records_sql()
-- line 89 of /local/course_catalog/index.php: call to local_course_catalog\util::get_courses()
[array (
0 => '4',
1 => 'es',
)]
Error code: dmlreadexception
)
)
ORDER BY ' at line 15
SELECT
C.*,
(
SELECT CFD.value
FROM str_customfield_data AS CFD
JOIN str_customfield_field AS CFF ON CFF.shortname = "creacion" AND CFF.id = CFD.fieldid
WHERE CFD.instanceid = C.id
) AS creacion
FROM str_course AS C WHERE C.id != 1 AND C.category = ? AND C.lang = ? AND C.visible = 1
AND (C.id IN (
SELECT C.id
FROM str_course AS C
JOIN str_customfield_data AS CFD ON CFD.instanceid = C.id
JOIN str_customfield_field AS CFF ON CFF.shortname = 'duracion' AND CFF.id = CFD.fieldid
WHERE CFD.value >= %3E45
)
)
ORDER BY creacion DESC LIMIT 0,12
-- line 125 of /local/course_catalog/classes/util.php: call to mysqli_native_moodle_database->get_records_sql()
-- line 89 of /local/course_catalog/index.php: call to local_course_catalog\util::get_courses()
[array (
0 => '4',
1 => 'es',
)]
Error code: dmlreadexception
Trazado de la pila (stack):
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
- line 1273 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
- line 125 of /local/course_catalog/classes/util.php: call to mysqli_native_moodle_database->get_records_sql()
- line 89 of /local/course_catalog/index.php: call to local_course_catalog\util::get_courses()