Query > Submit query : Error 500

[williamdes]

Steps to reproduce 1

1. https://demo.phpmyadmin.net/master-config/db_multi_table_query.php?db=world
2. Submit query

Steps to reproduce 1bis

1. https://demo.phpmyadmin.net/master-config/db_multi_table_query.php?db=world
2. Select table
3. Submit query

Expected behaviour

Case 1: Show a warning or do like https://demo.phpmyadmin.net/QA_4_8/db_multi_table_query.php?db=world
Case 1bis: Update and submit the query

Actual behaviour

Error 500

Server configuration

phpMyAdmin version: 5.0.0

[aroralakshya]

I can't reproduce in 5.0.0-dev, also, you mentioned version 5.0.0 in the server configuration whereas the links you posted are of the demo server using 4.8.0.

[williamdes]

@nulll-pointer The 4.8.0 link shows the "expected" behavior.

Gifs:

Can you reproduce using those videos ?

[aroralakshya]

@williamdes, thanks for the video explanation.
In my case, it gives the following error-

[aroralakshya]

I have found a workaround for this but I'm unsure if it's the best solution.
I've added
if (empty($sqlQuery)) { Message::error( __( 'No sql query provided.' ) )->display(); exit; }
In libraries/classes/Database/MultiTableQuery.php in fuction displayResults.
Also, include the class Message in this page at the top.

[williamdes]

I know why you have a blank page, see https://stackoverflow.com/a/13934612/5155484
If you use nginx, in /etc/php/7.2/fpm/pool.d/www.conf, add (or remove) :

php_flag[display_errors] = on

[aroralakshya]

I'm not using nginx,
Server configuration : Apache/2.4.29
php version : 7.1.14
I double checked the php configuration file and I have set display errors to be on everywhere.
Still seeing the blank page.

[williamdes]

set them to off and you will have the same behavior as on my server.

[MauricioFauth]

Closed by 87bf7c3