Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Warning : Unknown type 245 sent by the server

    @pushpendra.rawat
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 3.01k
    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.

    Unknown type 245 sent by the server Warning Unknown type 245 sent by the server Cannot execute queries while other unbuffered queries are active
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: