Dobrý den,
snažím se dostat z databáze jednoduchý limitovaný výpis. Ovšem k mému limitu Moodle automaticky připojí svůj. Nevíte, jak "automatiku" obejít?
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 ''1', 20 LIMIT 2, 18446744073709551615' at line 1
SELECT * FROM mdl_dotaznik_vyplneno WHERE dotaznik = ? ORDER by cas_odevzdani DESC LIMIT ?, 20 LIMIT 2, 18446744073709551615
[array (
0 => '1',
1 => 1,
)]
Error code: dmlreadexception
Stack trace:
-
line 441 of /lib/dml/moodle_database.php: dml_read_exception thrown
-
line 996 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
-
line 47 of /mod/dotaznik/respondenti.php: call to mysqli_native_moodle_database->get_records_sql()
-
line 89 of /mod/dotaznik/odpovedi.php: call to require_once()