Bug #58263
Error code: 200 since 4.18
100%
Description
The extension is not running at typo3 4.7 and 6.2!
In backend the Database tree is loading everless and the following message is visible:
Error in Processing Request
Error code: 200
Error text: OK
Version 4.17 works fine with typo3 4.7 (not possible with 6.2)
Provider : domain Factory.
Greetings
Dirk
History
#1
Updated by Carsten Biebricher over 5 years ago
The same problem here.
TYPO3: 6.1.9 MySQL-Client: 5.1.61 / MySQL-Server: 5.5.29 PHP: 5.3.26
I updated the phpMyadmin Ext from the working version 4.17.0 to 4.18.2.
Now, if I want to use the phpMyAdmin extension I get the message:
Error in Processing Request Error code: 200 Error text: OK
I hope this helps,
Carsten
Edit:
If phpMyAdmin fails and I click on the third Icon (query window) above the table-select dropdown then I can enter a select query in the window like
SELECT * FORM {db_name}.tt_content WHERE 1=1;
and a new phpMyAdmin Tab opens with the result.
#2
Updated by Andreas Beutel over 5 years ago
- Is Regression set to No
Carsten Biebricher wrote:
The same problem here.
[...]
I updated the phpMyadmin Ext from the working version 4.17.0 to 4.18.2.
Now, if I want to use the phpMyAdmin extension I get the message:
[...]
I hope this helps,
Carsten
I did a short investigation on the pMA Code: This error is shown as wrapper for fatal server errors. Seems it is thrown in the AJAX response script. Can you please check for AJAX requests in your browser and what request results in the message? The request should be available in Web Developer Tools or Google Chrome/Safari DevTools.
#3
Updated by Carsten Biebricher over 5 years ago
- File navigation.php.ajax_request.js added
Hi,
I watch the calls with Firebug and find this ajax-request:
http://[SERVER_NAME]/typo3conf/ext/phpmyadmin/res/phpMyAdmin-4.0.10-all-languages/navigation.php?ajax_request=1&token=aa4ce9e589aae01b6142e8e9d3651913&phpMyAdmin=35be4564859c1e92d3e422fb3ad3ebe3&aPath=cm9vdA%3D%3D.ZGIxNTk4MjNfMzI2&vPath=cm9vdA%3D%3D.ZGIxNTk4MjNfMzI2&pos=0&pos2_name=&pos2_value=&searchClause=&searchClause2=&_nocache=1406786141049794260
The server-answer is attached.
I think this is the full tabletree of my typo3-database for the navigation-frame.
#4
Updated by Stefan Neufeind over 5 years ago
Hmm, how come the 6.2-compat-version (4.18.0) does not work on 6.2? I just experienced the same after updating TYPO3 and also EXT:phpmyadmin in that move. Haven't further looked into debugging this issue though. Downgrading to 4.17.0 helped for the moment.
#5
Updated by Andreas Beutel over 5 years ago
Unfortunately the extension works on every test server and host I could get hands on (PHP 5.3 to 5.4). I'll once again try to reproduce the error.
#6
Updated by Stefan Neufeind over 5 years ago
Thanks. I'll also try to look into it when time permits. We just had the issue on a customer-webserver, where unfortunately debugging-possibilities are a bit limited ...
#7
Updated by Bodo Eichstädt over 5 years ago
I can confirm this bug!
TYPO3 6.2.3
phpMyAdmin 4.18.x broken, 4.17 works
Hint
Could the problem be the version missmatch mysql-client <-> mysql-server??
As this is a managed Root-Server of a Customer I can not do much in this.
From phpinfo¶
PHP 5.4.16¶
mysql¶
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.61
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/local/mysql/include
MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient
Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent Off Off
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
mysqli¶
MysqlI Support enabled
Client API library version mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
From phpMyAdmin Module¶
Server: TYPO3 DB Host (xxx.xxx.com via TCP/IP)
Software: MySQL
Software-Version: 5.6.19-67.0-log - Source distribution
Protokoll-Version: 10
Benutzer: xxxx@127.0.0.3
Server Zeichensatz: (utf8)
#8
Updated by Stefan Froemken about 5 years ago
Hello,
same problem here.
It seems that on some servers an additional hidden field was attached to the JSON-String:
<input type="hidden" name="phpMyAdmin" value="a9a8d28299787d439f8d56d09ec93183" /> --> Col 136
As you can see here and in the attached js-file the quotes (") are not escaped. I have edited PMA_getHiddenFields and changed all quotes " to \'. OK...it works for all other hidden fields, but not the mentioned one. The row above was not generated on my lokal machine. So something else must add this hidden field.
I will have a deeper look into it now.
Stefan
#9
Updated by Stefan Froemken about 5 years ago
Hello,
this additional param is the session.name (set by session_name()). So I have searched how to hide the session_id in URLs and I found following setting in php.ini:
session.use_trans_sid = 1
Please check this value and set it to "Off" or remove it completely. After restarting the webserver all session data was sended by cookie and not via URL anymore. And now PhpMyAdmin works again.
Stefan
#10
Updated by Phil Hinterbars about 5 years ago
Thanks Frank!
Putting the following line in .htaccess in root-folder did it for me (no webserver restart)
php_flag session.use_trans_sid off
#11
Updated by Markus Kappe about 5 years ago
I can confirm that the workaround from Phil Hinterbars works.
#12
Updated by Gregor Hermens about 5 years ago
Phil Hinterbars wrote:
Putting the following line in .htaccess in root-folder did it for me (no webserver restart)
This only works with mod_php, but will lead to a 500 server error in FastCGI/FPM setups.
I inserted
ini_set('session.use_trans_sid', 0);
as first line of
typo3conf/ext/phpmyadmin/res/phpMyAdmin-4.0.10.5-all-languages/config.inc.php
That solved the problem for me and should work in both setups.
#13
Updated by Andreas Beutel over 4 years ago
- Status changed from New to Resolved
- Assignee set to Andreas Beutel
- Target version changed from 4.18.x to 4.19.x
- % Done changed from 0 to 100
#14
Updated by Andreas Beutel over 4 years ago
Fixed in 4.19.0