Getting error General error: 2014 with facet() about yii2-sphinx

[pahanini]

Its because yii tries to call SHOW TABLES while populating active record but at this moment not all the results are read from dataReader.

Here is the dirty workaround:

        Item::findOne(1); // <--- It will call SHOW TABLES
        $query = Item::find();
        $query->addFacets(['category_id']);
        $result = $query->search();

[klimov-paul]

Have you tried to enable PDO::MYSQL_ATTR_USE_BUFFERED_QUERY?

[pahanini]

Yes, It does not help.

I tried to enable it in this way (config/main.php)

        'sphinx' => [
            'username' => '',
            'password' => '',
            'attributes' => [
                \PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true
            ],
        ],

[klimov-paul]

Issue confirmed.

Yes, It does not help.

PDO::MYSQL_ATTR_USE_BUFFERED_QUERY should be set to PDOStatement instance - not the PDO, but still it can not help: if set the followig error occurs:

PDOException: SQLSTATE[IM001]: Driver does not support this function: This driver doesn't support setting attributes

[klimov-paul]

Issue resolved by commit 6e6b7d5

[klimov-paul]

Fix adjusted to be more reliable: 3104802