phpmyadmin界面上的数据库链接出现问题 [英] Problems with database links on phpmyadmin interface
问题描述
我的phpmyadmin存在很多问题.我使用该工具已有多年,直到上周再也没有任何问题,但是自那以后,我无法使其正常工作.我没有对系统,apache,php,mysql和phpmyadmin进行任何更改,在出现问题之前未进行任何更改.
I'm having a bunch of problems with my phpmyadmin. I have been using this tool for years and never had any problems until last week, but since, I can't manage to make it work properly. I didn't do any changes to the system, apache, php, mysql and phpmyadmin where not touched/changed before the problems started.
实际症状:
- 数据库列表上的链接上的单词无效.如果我单击数据库的名称,则屏幕中间会显示黄色背景的正在加载..."文本,但是什么也没有发生,而且它永远不会消失.
- 如果单击数据库列表上的"+"号,则数据库将展开,并且可以看到表,新表和索引选项.但是只有在我没有首先单击数据库名称的情况下.
- 从顶部菜单中,数据库"链接有时有效,有时却无效.
- 如果我从屏幕左侧列表中的数据库中复制链接并在浏览器的地址栏上添加标题,它会尝试采用其他地址,例如,此链接" http://phpmyadmin.local/db_structure.php?server = 1& db = cosa& ; token = 20b203d3e8b93424798c61ddb6af844e "将带我到" http://www.phpmyadmin.local/db_structure.php?server = 1& db = cosa& token = 20b203d3e8b93424798c61ddb6af844e "
- 如果我单击数据库列表的"+"号,则从该数据库中获取表,如果单击列"链接,则列的列表将按预期显示在窗口的主要区域,但是,如果我选择一个或多个表,然后单击放置"链接/操作,则phpmyadmin消失. URL为" http://phpmyadmin.local/tbl_structure.php ",消息为连接被重置". (我现在正在使用Firefox). Cookies 未禁用.
- Words on the links on the database list don't work. If I click the name of the database, the "loading..." text in yellow background appears on the middle of the screen, but nothing happens, and it never dissappear.
- If I click the "+" sign on the database list, The database expands and I can see the tables, the new table, and the indexes options. But only if I haven't clicked the name of the database first.
- From the top menu, the "databases" link some times work and some times doesn't.
- If I copy the link from a database on the list at the left of the screen and pate it on the address bar of the browser, it tries to take to a different address, for instance, this link "http://phpmyadmin.local/db_structure.php?server=1&db=cosa&token=20b203d3e8b93424798c61ddb6af844e" will take me to "http://www.phpmyadmin.local/db_structure.php?server=1&db=cosa&token=20b203d3e8b93424798c61ddb6af844e"
- If I click on the "+" sign of the databases list I get the tables from that database, if I click the "Columns" link, the list of columns appear, as expected, on the main area of the windows, but if I select one or more tables and then click the "drop" link/action, phpmyadmin dissapears. The URL is "http://phpmyadmin.local/tbl_structure.php" and the message is "The connection was reset". (I'm using firefox right now). Cookies are not disabled.
我可以使用mysql-workbench或从命令行访问和操作数据库,而不会出现问题.
I can access and operate the database with mysql-workbench or from the command line without problems.
目前尚无其他症状.固定?
- 这也给我带来一些连接和保持登录状态的麻烦.我一直使用http auth_type,但我也尝试使用cookie和config.但是,在最后一次清理并重新安装之后,与登录和令牌相关的所有内容似乎都已修复.
- 错误:令牌不匹配
phpmyadmin版本:
- 4.1.6
- 4.0.7
- 3.5.8.2
浏览器已测试:
- firefox 26(常规和私人标签)
- seamonkey 2.22.1(常规和私有选项卡)
- opera 12.16(常规和私人标签)
我当然已经清除了缓存和cookie.
Of course I have cleared cache and cookies.
系统:
- apache 2.2.25
- php 5.5.7
- mariadb 5.5.32
- mysql 5.1.70和5.5.32
- mysql-workbench 5.2.47
- xdebug 2.2.3
- 系统:Linux patito 3.10.7-gentoo#7 SMP Sun Sep 29 10:24:32 MYT 2013 x86_64 Intel(R)Core(TM)i5-3330 CPU @ 3.00GHz纯正英特尔GNU/Linux
- apache 2.2.25
- php 5.5.7
- mariadb 5.5.32
- mysql 5.1.70 and 5.5.32
- mysql-workbench 5.2.47
- xdebug 2.2.3
- system: Linux patito 3.10.7-gentoo #7 SMP Sun Sep 29 10:24:32 MYT 2013 x86_64 Intel(R) Core(TM) i5-3330 CPU @ 3.00GHz GenuineIntel GNU/Linux
更新
我发现是对xdebug设置进行更改的罪魁祸首,我正在针对该发现发布问题的答案,还将尝试在xdebug跟踪系统上发布此问题的链接以供参考.希望它有助于调试情况.
I found that a change on xdebug settings was the culprit, I'm posting an answer to my question with that finding, also will try to post on the xdebug tracking system with a link to this question for reference. Hope it helps to debug the situation.
推荐答案
似乎问题在于此xdebug设置:
It seems that the problem is this xdebug setting:
xdebug.collect_return="1"
如果我将其更改为:
xdebug.collect_return="0"
一切正常.
这可能与xdebug跟踪中已报告的此错误有关系统,但是我没有时间和知识来测试它.
It may have to do with this bug already reported on the xdebug tracking system, but I don't have the time and knowledge to test it.
这篇关于phpmyadmin界面上的数据库链接出现问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!