Here we will learn how to resolve the error that we come across while updating MySQL 5.5 to MySQL 5.7 on ubuntu 14.04.
After the upgradating, I was trying to login my CakePHP application, but every time I was trying to login I was facing the warning and an error mentioned below.
Warning (2): PDOStatement::execute(): Unknown type 245 sent by the server. Please send a report to the developers [CORE/Cake/Model/Datasource/DboSource.php, line 461]
Error: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
To avoid the above error make sure that after upgradation, run the following command on your command line interface.
sudo apt-get install php5-mysql
sudo service apache2 restart
The above command will update the PHP component libmysql that communicate with MySQL.