#462 export produces a blank page

[Anonymous]

Everything was working normally with PhpMyAdmin 2.4.0
but I wanted to upgrade to 2.5.3.

Everything works fine in 2.5.3 except for exporting
tables. I do not get an error message. I just get a blank
page.

I am running:
MySQL 4.0.16
PHP 4.3.4

With version 2.5.3 I can no longer export a table or copy
a table. I have tried all the various options for exporting
data only, structure only, sql, xml, csv, etc... but they
all produce a blank page. I have compression set to
none.

I have tried in different browsers, from IE to Netscape.
They all produce a blank page. But the old (2.4.0)
version exports just fine.

I saw the note in the FAQ [Server] about disabling
OBGZip in the config file and zlib compression in the
php.ini file. But that hasn't fixed it...

Any ideas?

[Nobody/Anonymous]

Logged In: NO

Sorry I didn't include my email...
joanna at 76design dot com

[Nobody/Anonymous]

Logged In: NO

Please let me know if you require any futher details.
Sorry I forgot to add my email to the main post.
joanna at 76design dot com

[Garvin Hicking]

Logged In: YES
user_id=473563

Did you use a fresh installation and modified the original
config.inc.php, or did you use your old one?

If you open up the source code of the "blank page", is that
one empty as well? Is loading finished, or does your browser
indicate that it's still loading?

Could you try the latest version 2.5.6 or 2.6.0-alpha1 and
see if the problem persists? 2.5.3 is already quite outdated...

Is the rest of your installation working, apart from export?
Browsing, inserting etc. all works?

[Nobody/Anonymous]

Logged In: NO

I downloaded 2.5.6 and installed it. The config.inc.php is the
one included with the 2.5.6 distribution and the only things I
have modified are the user, pwd, only_db and PmaAbsoluteUri.
Everything works, browsing, inserts, everything that is,
except Export.

I figured out why I was getting a blank page and no errors -
display_errors in the php.ini file was off. D'oh.

So now I at least get an error that we can work with:

Warning: main(./libraries/export/sql.php): failed to open
stream: No such file or directory
in /magma/users/u60/c130j/public_html/database/export.php
on line 22

Fatal error: main(): Failed opening
required './libraries/export/sql.php'
(include_path='.:/magma/software/tools/php-4.3.4/lib/php')
in /magma/users/u60/c130j/public_html/database/export.php
on line 22

I don't have access to the include_path mentionned here -
(include_path='.:/magma/software/tools/php-4.3.4/lib/php')
that's controlled by my hosting company.

I'm just using the php.ini file they supplied me with. Do I need
to edit it again? The include_path is commented out in my
php.ini file

Thanks

p.s. I have version 2.4.0 of phpmyadmin working fully on the
same server (including exports)

[Garvin Hicking]

Logged In: YES
user_id=473563

This looks like you are missing the mentioned file. Did you
look in your phpMyAdmin directory
(/magma/users/u60/c130j/public_html/database/libraries/export/sql.php)
if that exact path and file exists? Maybe the uncompression
of the file failed or its suffix is .php3?

[Nobody/Anonymous]

Logged In: NO

Thanks so much for your help. For some reason I cannot get
the export folder to upload! Very bizarre. Anyway, so I
manually created the export folder and then was able to
upload the files into it. Ahd now it works!!! Yeah!

[Garvin Hicking]

Logged In: YES
user_id=473563

You're welcome :)