search

bdecentgmbh / moodle-block_dash

The interface and report builder for moodle
https://bdecent.de/dash
6 stars 4 forks source link

SQL error on PostgreSQL: missing FROM-clause entry for table "c" #81

Closed mudrd8mz closed 1 year ago

mudrd8mz commented 3 years ago

image

ERROR:  missing FROM-clause entry for table "c"
LINE 1: SELECT COUNT(DISTINCT u.id) FROM m_user u  WHERE c.id = $1 A...
                                                         ^
SELECT COUNT(DISTINCT u.id) FROM m_user u  WHERE c.id = $1 AND u.deleted = 0  
[array (
  0 => '2',
)]
Error code: dmlreadexception
* line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
* line 329 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
* line 920 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
* line 1624 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
* line 1697 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
* line 1907 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
* line 281 of /blocks/dash/classes/local/data_grid/sql_data_grid.php: call to moodle_database->count_records_sql()
* line 121 of /blocks/dash/classes/local/data_grid/data_grid.php: call to block_dash\local\data_grid\sql_data_grid->get_count()
* line 149 of /blocks/dash/classes/local/data_grid/paginator.php: call to block_dash\local\data_grid\data_grid->block_dash\local\data_grid\{closure}()
* line 158 of /blocks/dash/classes/local/data_grid/paginator.php: call to block_dash\local\data_grid\paginator->get_record_count()
* line 291 of /blocks/dash/classes/local/layout/abstract_layout.php: call to block_dash\local\data_grid\paginator->get_page_count()
* line 277 of /blocks/dash/classes/local/data_source/abstract_data_source.php: call to block_dash\local\layout\abstract_layout->export_for_template()
* line 140 of /blocks/dash/classes/output/renderer.php: call to block_dash\local\data_source\abstract_data_source->export_for_template()
* line 120 of /blocks/dash/classes/external.php: call to block_dash\output\renderer->render_data_source()
* line 261 of /lib/externallib.php: call to block_dash\external::get_block_content()
* line 81 of /lib/ajax/service.php: call to external_api::call_external_function()
mudrd8mz commented 3 years ago

image

stefanscholz commented 1 year ago

Issue was fixed a long time ago, doing some housekeeping and closing issues.