+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Intermittent "Unable to select the specified database" on MySQL upgrade (/showthread.php?tid=61003)
Intermittent "Unable to select the specified database" on MySQL upgrade - El Forum - 08-25-2014
[eluser]besson3c[/eluser]
Hello,
Since upgrading to a 5.6.x version of MySQL I'm getting these CodeIgniter error messages intermittently. I don't seem to be having problems with WordPress on the same server, nor the same application running an older version of MySQL on another server. Refreshing the page a few times will make this error message go away for a while, it seems completely intermittent and random. I'm using the mysqli dbdriver with pconnect set to true.
Do you guys have any suggestions for what I might want to look at for addressing this issue? I could downgrade MySQL, but I'd like to know if there is a known issue with CI and MySQL 5.6 (and PHP 5.4)?
This *might* be the same issue:
http://stackoverflow.com/questions/14544669/after-updatring-to-mysql-5-6-9-localhost-does-not-work-anymore
and I'm intrigued by this too, but I don't know what the Yield class is supposed to do and whether it is relevant to my problem?
http://dillieodigital.wordpress.com/2014/05/30/quick-tip-how-to-running-codeigniter-on-php-5-5-and-mysql-5-6/
Thanks in advance for any help you can offer!