Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Warning : Unknown type 245 sent by the server

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 1.13k
    Comment on it

    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.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: