phpMyAdmin

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;

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.

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.

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 ...

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)

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

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

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

I can confirm that the workaround from Phil Hinterbars works.

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.

Fixed in 4.19.0