AR1VU I am going to suggest you to do something that we've never had to suggest to anyone 😊
In your config.php you see an array of data that define your database connection, from username to password etc, mine (in development) looks like this:
<?php return array (
'debug' => true,
'database' =>
array (
'driver' => 'mysql',
'host' => 'localhost',
'port' => 3306,
'database' => 'flarum',
'username' => 'root',
'password' => NULL,
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => NULL,
'strict' => false,
'engine' => 'InnoDB',
'prefix_indexes' => true,
),
'url' => 'http://flarum.test',
'paths' =>
array (
'api' => 'api',
'admin' => 'admin',
),
'headers' =>
array (
'poweredByHeader' => true,
'referrerPolicy' => 'same-origin',
),
);
Edit this file by adding the following in this file:
'options' => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET SESSION SQL_BIG_SELECTS=1',
),
Like so:
<?php return array (
'debug' => true,
'database' =>
array (
'driver' => 'mysql',
'host' => 'localhost',
'port' => 3306,
'database' => 'flarum',
'username' => 'root',
'password' => NULL,
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => NULL,
'strict' => false,
'engine' => 'InnoDB',
'prefix_indexes' => true,
'options' => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET SESSION SQL_BIG_SELECTS=1',
),
),
'url' => 'http://flarum.test',
'paths' =>
array (
'api' => 'api',
'admin' => 'admin',
),
'headers' =>
array (
'poweredByHeader' => true,
'referrerPolicy' => 'same-origin',
),
);
Make sure:
- the added change is within the
database part or it won't do anything.
- the line above (
'prefix_indexes' => true,) ends with a comma
An explicit WARNING to other people. Don't do this unless you run into exactly the same error as OP and once this is proven to resolve the issue.
@AR1VU please do let me know if this resolves the issue 🙏
