SQL query dies

[elearningdienst]

Additionally that query in results.php dies with MySql 8, don't know why and dont know how to debug:

$result = $db->query('SELECT p.id, p.title, p.speaker, p.link, COUNT(pq.id)
	FROM presentations p
	INNER JOIN presentation_questions pq ON pq.presentationid = p.id
	WHERE secret = "' . $db->escape_string($_GET['secret']) . '"')
	or die(translate('dberr') . '58148.');

[lgommans]

Testing with MariaDB 10.3 (MariaDB is a fork of MySQL, created due to "concerns over [MySQL's] acquisition by Oracle") and PHP 7.3, it works in my setup. The secret GET parameter being empty should just yield an empty result set and not crash. I'm not quite sure what the issue might be.

You can debug this by replacing the last line with this:

or die(translate('dberr') . '58148.' . $db->error);

That will add the actual error message from MySQL/MariaDB to the error that is shown in the feedback tool.

I'm curious what the issue is!