phpMyAdmin 4.0.5导出错误错误 - 任何人知道如果它被解决？ [英] phpMyAdmin 4.0.5 export error bug - anyone know if it is being addressed?
问题描述
phpMyAdmin已经宣布，在2013年9月1日的几天，他们正在关闭其他资源，如邮件列表和论坛，并推迟我们使用StackOverflow / StackExchange。
我在一个小型的cPanel托管服务提供一般支持，我的部分职责包括频繁的数据库导出在phpMyAdmin，还显示托管客户如何从phpMyAdmin其cPanel中作为备份工具导出他们的数据库。
很多年来，在许多服务器/ cPanel版本/ PHP版本/ mysQL版本中工作正常。
之后我们最近升级到phpMyAdmin 4.0.5最后（我们使用WHM的EasyApache保持PHP和其他服务器模块定期更新）我们遇到一个明显的错误，不能导出数据库。 p>
任何尝试导出数据库超过一定大小（尚未确定，但似乎约为20MB），而不是通常下载提示，只需立即失败。
如果在FireFox中尝试导出，错误如下所示：
Firefox无法在https://example.example.net:2083/cpsess1210889896/3rdparty/phpMyAdmin/export.php
$找到该文件b
$ b
如果在Internet Explorer中尝试导出只是说网站不能显示页面，当更多的信息被点击说： / p>
此错误（HTTP 500内部服务器错误）表示您访问的网站存在服务器问题，导致无法显示该网页。
自从升级到4.0.5刚开始发生的数据库，我已经通过phpMyAdmin导出
我尝试在WHM / cPanel中增加一些内存限制，例如最大内存cPanel会话可以使用，但它不帮助。另外，关于cPanel论坛的几个讨论似乎声称这个问题源于phpMyAdmin中的一个错误，而不是cPanel或PHP的问题。
任何人都可以丢弃任何对这个问题有更多的看法吗？
有没有人从phpMyAdmin知道这个特定问题是否得到解决？
非常感谢任何人在这里愿意提供的任何帮助或反馈。
只是为了防止这里的一般服务器环境：
cPanel / WHM 11.38.2（build 6）
Apache 2.2.25
PHP 5.4.18
mySQL 5.5.32- cll
RHEL 5 64位
运行suPHP
编辑 - 我忘了提及无论是执行直接的快速SQL导出和/或自定义压缩导出（例如gzip），都会出现问题。无论如何，快速或压缩，我们不能导出大于20MB的数据库。
UPDATE / FIX - Marc Delisle的代码更改phpMyAdmin 4.0.6修复此错误，并在cPanel 11.38.2.7发布在我的服务器上的问题。谢谢Marc和PMA团队！
这里是我为即将到来的4.0.6- rc2，请确认：
https://github.com/phpmyadmin/phpmyadmin/ commit / 5298602f8edb4475fce5d299532c7780e0e314a5.patch
phpMyAdmin has announced that in a few days on Sept 1st 2013 they're closing down their other resources such as mailing list and forums and are deferring us to use StackOverflow / StackExchange.
I provide general support at a small cPanel hosting service and part of my duties include doing frequent DB Exports in phpMyAdmin and also showing hosting customers how to export their databases from phpMyAdmin within their cPanel as a backup tool.
Been working fine for many years and across many servers / cPanel versions / PHP versions / mysQL versions.
But after we recently upgraded to phpMyAdmin 4.0.5 final (we use WHM's EasyApache to keep PHP and other server modules updated regularly) we're encountering an apparent bug and cannot Export databases.
Any attempt to Export a DB over a certain size (haven't determined exactly yet, but seems to be around 20MB) instead of getting the usual download prompt, it simply immediately fails.
If the Export is attempted in FireFox the error looks like this:
Firefox can't find the file at https://example.example.net:2083/cpsess1210889896/3rdparty/phpMyAdmin/export.php
If the Export is attempted in Internet Explorer simply says "The website cannot display the page" and when more info is clicked says:
This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
Since upgrading to 4.0.5 that just started happening with DB's that I've been exporting through phpMyAdmin for years, literally, with no problem before.
I tried raising some memory limits within WHM / cPanel such as the max memory cPanel session can use, but it doesn't help. Also a couple of discussions on the cPanel forums seem to be claiming that this problem stems from a bug in phpMyAdmin, not a problem with cPanel or PHP.
Can anyone shed any more light on this problem?
Is there anyone from phpMyAdmin who knows if this specific issue is being addressed?
Thanks very much for any help or feedback that anyone here is willing to provide. This is putting me in a bit of a jam with our clients.
Just in case it matters here is the general server environment:
cPanel/WHM 11.38.2 (build 6)
Apache 2.2.25
PHP 5.4.18
mySQL 5.5.32-cll
RHEL 5 64bit
running suPHP
EDIT - I forgot to mention that the problem occurs whether doing a straight "Quick" SQL export and/or a "Custom" compressed export (such as a gzip). Either way, quick or compressed we can't export databases larger than around 20MB.
UPDATE / FIX - Marc Delisle's code changes in phpMyAdmin 4.0.6 fixes this bug, and after cPanel 11.38.2.7 "Release" came out recently it has resolved the issues on my servers. Thank you Marc and the PMA team!
Here is a fix I propose for the upcoming 4.0.6-rc2, please confirm: https://github.com/phpmyadmin/phpmyadmin/commit/5298602f8edb4475fce5d299532c7780e0e314a5.patch
这篇关于phpMyAdmin 4.0.5导出错误错误 - 任何人知道如果它被解决？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
