Found the solution:

doctrine:
    dbal:
        driver:   "%database_driver%"
        host:     "%database_host%"
        port:     "%database_port%"
        dbname:   "%database_name%"
        user:     "%database_user%"
        password: "%database_password%"
        charset:  UTF8
        options:
            1002: "SET NAMES utf8"  #initial query
            1000: true              #PDO::MYSQL_ATTR_USE_BUFFERED_QUERY

Now it works well.

+1

+1

not work for me

@health901 Which driver do you use ?

Close your sql cursor like here:

$stmt = $this->container->get('doctrine.orm.entity_manager')->getConnection()->prepare($content);
$stmt->execute();
$stmt->closeCursor();

Then, you can use your conection to do more queries.

Illuminate\Database\QueryExceptionSQLSTATE[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. (SQL: update chats set status ='2' WHERE sender_id = 6 and receiver_id = 15 and status = 1 )

I need help on this error

@Otech2018: thank you for reaching out.

This tracker is meant for tracking bugs and feature requests. If you are looking for support, you'll get faster responses by using one of our official support channels:

• StackOverflow: https://stackoverflow.com/questions/tagged/symfony
• Slack: https://symfony.com/slack

See https://symfony.com/support for more support options.

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while there are pending result sets. Consider unsetting the previous PDOStatement

This error is always happens while there were two executions at a same time for example:

1. CASE 1

   if(!$query->execute())

   die("SQL FAILED");
   

   else

   $query->execute(); // **DELETE THIS ONE**
   

Solution: Second execution is no needed, remove second one, the first execution is already executed.

2. if the first case is not working, USE this Solution call this function after $query=$handler->prepare($sql);

   $query->closeCursor();

I hope this Solution is helpful