General developer forum

Error dmlreadexception al leer la base de datos

 
Oscar Arturo:-:México
Error dmlreadexception al leer la base de datos
 

Amigos de moodle.org:

Hoy en mi sitio empecé a ver una leyenda con el siguiente mensaje: 

Error reading from database

Por lo que procedí a habilitar esto: To get more information about the error you should enable Debugging in Settings > Site administration > Development > Debugging.

Esto que ven aquí fue el resultado del Debugging:

Debug info: 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 ')

GROUP BY filter

HAVING MAX(f.active * ctx.depth) > -' at line 5

SELECT active.filter, fc.name, fc.value

FROM (SELECT f.filter, MAX(f.sortorder) AS sortorder

FROM mood_filter_active f

JOIN mood_context ctx ON f.contextid = ctx.id

WHERE ctx.id IN ()

GROUP BY filter

HAVING MAX(f.active * ctx.depth) > -MIN(f.active * ctx.depth)

) active

LEFT JOIN mood_filter_config fc ON fc.filter = active.filter AND fc.contextid = 376

ORDER BY active.sortorder

[array (

)]

Error code: dmlreadexception

Stack trace:

  • line 479 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 1114 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 974 of /lib/filterlib.php: call to mysqli_native_moodle_database->get_recordset_sql()
  • line 122 of /lib/filterlib.php: call to filter_get_active_in_context()
  • line 189 of /lib/filterlib.php: call to filter_manager->load_filters()
  • line 270 of /lib/filterlib.php: call to filter_manager->get_text_filters()
  • line 1267 of /lib/weblib.php: call to filter_manager->setup_page_for_filters()
  • line 2326 of /course/renderer.php: call to format_text()
  • line 205 of /theme/essential/classes/core_course_renderer.php: call to coursecat_helper->get_course_formatted_summary()
  • line 1108 of /course/renderer.php: call to theme_essential_core_course_renderer->coursecat_coursebox_content()
  • line 1273 of /course/renderer.php: call to core_course_renderer->coursecat_coursebox()
  • line 1978 of /course/renderer.php: call to core_course_renderer->coursecat_courses()
  • line 265 of /index.php: call to core_course_renderer->frontpage_available_courses()


¿A alguien ya le ha pasado?, ¿Cómo lo puedo solucionar?, Ayuda. 


Gracias

 
Average of ratings: -
Picture of Darko Miletić
Re: Error dmlreadexception al leer la base de datos
Core developersParticularly helpful Moodlers

In this forum we only use English. If you need support in Spanish please visit the appropriate place.

https://moodle.org/mod/forum/view.php?id=695

 
Average of ratings: -
Oscar Arturo:-:México
Re: Error dmlreadexception al leer la base de datos
 

Ok, thank´s

 
Average of ratings: -