After selecting a database:
Notice in ./libraries/Header.class.php#227
Undefined index: collation_connection
Backtrace
./libraries/Header.class.php#257: PMA_Header->getJsParams()
./libraries/Header.class.php#208: PMA_Header->getJsParamsCode()
./libraries/Header.class.php#136: PMA_Header->_addDefaultScripts()
./libraries/Response.class.php#102: PMA_Header->construct()
./libraries/Response.class.php#131: PMA_Response->construct()
./libraries/common.inc.php#1065: PMA_Response::getInstance()
./index.php#12: require_once(./libraries/common.inc.php)
Notice in ./index.php#212
Undefined variable: collation_connection
Backtrace
Also, I did tick "Automatically send report next time" but it's still asking me..
Olaf,
can you reproduce this at will? I cannot.
It does happen every single time on one particular machine, making pMA totally unusable.
Doesn't happen on another machine. Perhaps it's related to MySQL / PHP versions?
5.5.40-0+wheezy1
5.4.35-0+deb7u2
Well, this notice is output due to error displaying activated, either in php.ini or in phpMyAdmin configuration. Aside from the message, are there problems with phpMyAdmin usage on this machine.
I don't think it's PHP displaying the error.
pMA is totally unusable as I can't select a DB.
Olaf,
I believe that this happens on a machine that has no config.inc.php, can you confirm?
No, a config file does exist:
--- config.sample.inc.php 2014-12-21 12:41:09.000000000 +0100
+++ config.inc.php 2014-12-13 14:37:14.809195388 +0100
@@ -14,7 +14,7 @@
* This is needed for cookie based authentication to encrypt password in
* cookie
/
-$cfg['blowfish_secret'] = ''; / YOU MUST FILL IN THIS FOR COOKIE AUTH! /
+$cfg['blowfish_secret'] = 'a8b7c6d'; / YOU MUST FILL IN THIS FOR COOKIE AUTH! */
/
* Servers configuration
@@ -26,7 +26,7 @@
/
$i++;
/ Authentication type /
-$cfg['Servers'][$i]['auth_type'] = 'cookie';
+$cfg['Servers'][$i]['auth_type'] = 'http';
/ Server parameters /
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
Last edit: Olaf van der Spek 2014-12-26
Olaf,
please try the attached patch (tested on 4.3.3).
I have merged my patch; waiting for feedback.
https://github.com/phpmyadmin/phpmyadmin/commit/38bb19ffb66f0c78116f0916b7478d6c0d9f1e4d
Would you like me to try the patch file or the bigger git patch?
In practice it's the same; the bigger one is bigger only because of the unit tests.
Still broken in 4.3.4:
Notice in ./libraries/Header.class.php#227
Undefined index: collation_connection
Backtrace
./libraries/Header.class.php#257: PMA_Header->getJsParams()
./libraries/Header.class.php#208: PMA_Header->getJsParamsCode()
./libraries/Header.class.php#136: PMA_Header->_addDefaultScripts()
./libraries/Response.class.php#102: PMA_Header->construct()
./libraries/Response.class.php#131: PMA_Response->construct()
./libraries/common.inc.php#1064: PMA_Response::getInstance()
./index.php#12: require_once(./libraries/common.inc.php)
Notice in ./index.php#212
Undefined variable: collation_connection
Backtrace
Olaf,
please try this second patch.
I have the same errors after upgrading from 4.2.13.1 to 4.3.4, but it only happended on first log in after upgrade. Then it would not happen again until I cleared all cache and history in Firefox browser, then it happen again.
But everything seems to work correctly. I temporary solved the problem by setting "SendErrorReports" in config.inc.php to value: never - after doing that it does not show those errors anymore.
If it helps I am running PHP 5.6.4 as mod_php with mod_ruid2
I am getting this when I try to login. And I cannot login. I'm always presented with "Cannot log in to the MySQL server"
Notice in ./libraries/Header.class.php#227
Undefined index: collation_connection
Backtrace
./libraries/Header.class.php#257: PMA_Header->getJsParams()
./libraries/Header.class.php#208: PMA_Header->getJsParamsCode()
./libraries/Header.class.php#136: PMA_Header->_addDefaultScripts()
./libraries/Response.class.php#102: PMA_Header->construct()
./libraries/Response.class.php#131: PMA_Response->construct()
./libraries/plugins/auth/AuthenticationCookie.class.php#67: PMA_Response::getInstance()
./libraries/plugins/auth/AuthenticationCookie.class.php#710: AuthenticationCookie->auth()
./libraries/DatabaseInterface.class.php#2446: AuthenticationCookie->authFails()
./libraries/common.inc.php#987: PMA_DatabaseInterface->connect(
string *,
string *,
boolean false,
)
./index.php#12: require_once(./libraries/common.inc.php)
To aommundsen and Chris Hallgren: did you try my second patch (attached above) ?
@Marc, sorry I did not test you patch. But I have tested it now, and it works and completely solve the problem for me. No more errors with patch bug4655-b.patch. Thanks!
Errors disappeared even before applying the patch but it's still not working.
Whatever I click, I keep getting returned to the home screen.
Olaf,
please clarify. You no longer see the notice about collation_connection on this particular machine?
@Olaf, please note that you will only see the error the first time you log in, then you will not see the error again until you clear cache in your web browser.
For me the patch works perfectly, and I can recreate the bug if I remove the patch, then the errors come back, and i re-apply the patch, and the errors are gone. Also everything seems to work correct for me. So maybe Olaf has another completely different bug not relate to the reported error, that is my guess.
@Marc
No, I don't, don't know why. But the problem is still the same, I can't get past the home screen.
@Olaf did you try to clear your browser cache as suggested by aommundsen?
Did you look at your web server's error log to find a clue there?