Issue with exporting using Firefox or Safari (or PHP8.1.4 issue) - file is not saved because of issue with reading source file

[Draghmar]

Describe the bug

Not sure if it's FF or phpMyAdmin or something completely different but recently whenever I want to export anything (doesn't matter if it's sql or csv and if it's compressed or not) I'm getting weird message about FF not being able to read source file, which results in file not being downloaded/saved. The file placeholder is created at the destination but it's removed right after hitting confirmation on the window:

The message in the window can be translated as:

Downloading ...
File ... can not be saved because source file is not readable.
You should try later or contact server administrator.

I also tried that on older FF version (98dev) and there was no message but the file was empty.
Using View output as file works properly.

Also affects Safari: hestiacp/hestiacp#2529 (comment)

To Reproduce

Steps to reproduce the behavior:

1. Go to any table.
2. Click on Export.
3. Choose to save as file.
4. See error.

Server configuration

• Operating system: ArchLinux
• Web server: Apache/2.4.52
• Database version: doesn't matter, tried this on few
• PHP version: 8.1.4
• phpMyAdmin version: 5.1.3

Client configuration

• Browser: Firefox 99.0b5
• Operating system: Win10

[kamil-tekiela]

Do you encounter this issue in Firefox Safe mode as well? It sounds more like a client issue. Have you tried reinstalling and resetting all Firefox settings?
Would you be able to tell us what you see in the Network tab? Press F12 and monitor the Network tab when trying the export. Take some screenshots of the response headers if possible.

[Draghmar]

I've made additional tests from different server with the same phpMyAdmin version but it had PHP 8.1.3. It worked there. But after updating to 8.1.4 the same issue showed up. After seeing that I also checked this on Chrome and there's the same result, which is empty file because of the "network issue". That would suggest it's related to PHP 8.1.4 somehow...

As for the headers, this is when trying to export as sql:

HTTP/2 200 OK
x-powered-by: PHP/8.1.4
x-ob_mode: 1
content-encoding: gzip
vary: Accept-Encoding
expires: Fri, 18 Mar 2022 14:44:04 +0000
cache-control: no-store, no-cache, must-revalidate,  pre-check=0, post-check=0, max-age=0
pragma: no-cache
content-description: File Transfer
content-disposition: attachment; filename="REMOVED.sql"
content-transfer-encoding: binary
set-cookie: REMOVED; path=/; secure; HttpOnly; SameSite=Strict
set-cookie: REMOVED path=/; secure; HttpOnly; SameSite=Strict
last-modified: Fri, 18 Mar 2022 14:44:04 GMT
content-type: text/x-sql;charset=utf-8
date: Fri, 18 Mar 2022 14:44:03 GMT
server: Apache/2.4.52 (Unix) OpenSSL/1.1.1m
X-Firefox-Spdy: h2

And this one is for csv:

HTTP/2 200 OK
x-powered-by: PHP/8.1.4
x-ob_mode: 1
content-encoding: gzip
vary: Accept-Encoding
expires: Fri, 18 Mar 2022 14:47:43 +0000
cache-control: no-store, no-cache, must-revalidate,  pre-check=0, post-check=0, max-age=0
pragma: no-cache
content-description: File Transfer
content-disposition: attachment; filename="REMOVED.csv"
content-transfer-encoding: binary
set-cookie: REMOVED path=/; secure; HttpOnly; SameSite=Strict
set-cookie: REMOVED path=/; secure; HttpOnly; SameSite=Strict
last-modified: Fri, 18 Mar 2022 14:47:43 GMT
content-type: text/comma-separated-values;charset=utf-8
date: Fri, 18 Mar 2022 14:47:42 GMT
server: Apache/2.4.52 (Unix) OpenSSL/1.1.1m
X-Firefox-Spdy: h2

[kamil-tekiela]

Related php/php-src#8218

[ophian]

Just to confirm this now being solved.
I had this export issue on 5.1.3 and PHP 8.1.4 with Firefox versions too on windows.
Adding the patch #17447 export runs well again,

[bessone]

I had the same problem with PhpMyAdmin 5.1.3 and PHP 8.0.17, both using Firefox and Chrome.

Applying the patch the problem disappeared.

[DarceyLloyd]

Same issue, tried in win: chrome/firefox/opera/edge & ubuntu firefox).
Network error, if download is forced you end up with a html dump in a sql file.

Issue occurs on:

1. Windows xampp, phpmyadmin 5.1.3, PHP 8.1.4
2. Ubuntu 20.x LTS, phpmyadmin 5.1.3, PHP 8.1.4

Also tried phpMyAdmin-5.2.0-rc1, same result.

Alternate route advised:
Reverse engineered database's via DbSchema (Maria) & MySQL Workbench (MySQL) and use DBeaver to do the rest.

[williamdes]

Hi everybody, can you try the latest 5.1 version in development (phpMyAdmin 5.1+snapshot) and let me know if it works fine afterwards ?

[matthiasradde]

Checked with (phpMyAdmin 5.1+snapshot) -> successful!
Exporting to file is possible again with PHP 8.1.4
(Tested with Win10 + FF98.0.2 + Chrome 100.0.4896.60 + Apache 2.4.53 + PHP 8.1.4 - 64bit where possible)

Thanks all for investigating and solving this issue.

[VFAndrew]

Exports are working again for me. Thanks.

[tylerkowalchuk]

I was having this problem with PHP 8.0.17 as well. With PMA 5.1+snapshot, exports are working again for me.

[soloincc]

Using PHP 8.1.4 and PMA 5.1.3 exports weren't working. They are now working using PMA 5.1+snapshots

[DarceyLloyd]

Confirmed working with phpMyAdmin 5.1+snapshot, tested on:

• Windows Xampp - Apache, PHP 8.1.4, MariaDb - Chrome & Firefox
• Ubuntu 20.04 LTS Server - Nginx, PHP 8.1.4, MariaDb - Chrome & Firefox

Nice 1

[mtovmassian]

On my side I had to downgrade Docker image to phpmyadmin:5.1.1 to have the export feature work properly.

[williamdes]

On my side I had to downgrade Docker image to phpmyadmin:5.1.1 to have the export feature work properly.

Yeah, this is because the image switched to PHP 8 in phpmyadmin/docker@7c28533 before 5.1.2 was released and build in the docker image :)

[fd6130]

Hi everybody, can you try the latest 5.1 version in development (phpMyAdmin 5.1+snapshot) and let me know if it works fine afterwards ?

Yay, it is working again in php 8.0.17 ubuntu 20.04 mariadb 10.6.7

[nelsonprsousa]

Is it possible to test phpMyAdmin 5.1+snapshot as a docker image?

[williamdes]

Is it possible to test phpMyAdmin 5.1+snapshot as a docker image?

Yes, are you able to build docker images on your setup ?
You may want to copy, tweak and remove some security rules from this file https://github.com/phpmyadmin/docker/blob/master/apache/Dockerfile

[nelsonprsousa]

Is it possible to test phpMyAdmin 5.1+snapshot as a docker image?

Yes, are you able to build docker images on your setup ? You may want to copy, tweak and remove some security rules from this file https://github.com/phpmyadmin/docker/blob/master/apache/Dockerfile

I'll see. Thanks :)

[williamdes]

Fixed by 51f26fa

[MuhammadUsman0304]

I always find that (Network Failed) error every time I export a database from PHPMyAdmin using XAMPP. my php version 8.0.18
any solution?

[matthiasradde]

@thesoftwaresquad please provide more details - in addition to the PHP-version the PHPMyAdmin-version and the browser you are using might be helpful.
For me using the snapshot-version https://www.phpmyadmin.net/downloads/#snapshot_5.1+snapshot was working for me with PHP 8.1.x and Firefox and Chrome.

[rudiedirkx]

According to the changelog this is a "Firefox or Safari" issue, but it isn't just. It probably shouldn't say that.

[gitderekz]

This is what I did,
While you export you will find Quick is selected,
->you need to select custom, then
-->go to Output section and do the following
--->select, save output to file
---->on compression category, select zipped

Then go on download your table as a zipped file.

[DRF24k]

Hi all! I have this same error. Glad to see there is a patch that fixes it. ...where do I find patch #17447? Clicking on the link gets me to a thread where a test case is discussed, but I don't see where to download or implement the patch anywhere.

[matthiasradde]

@DRF24k You can use phpMyAdmin 5.2.0 (or any newer version - if available) or the nightly builds which include this patch. If you really need to stay an phpMyAdmin 5.1 then you can find the patch at the URL you have linked - there you go to the tab "files" to see what exactly was modified in which file: https://github.com/phpmyadmin/phpmyadmin/pull/17447/files

[DRF24k]

Thank you for the link, but I am afraid I can't tell what I'm looking at. Is it color coded for something?

I'm using the phpMyAdmin that came installed with XAMPP. It's 5.1.3, it seems. I tried replacing the folder with a new verison, but then I couldn't log in. Thank you. I will give it another try.

WOHOO! Turns out all I had to do was copy the configuration file over to the new folder! Ha ha! Thank you for all your help!!