• Support

  • Cannot have more than one discussion in a tag

AR1VU that is a 500 internal server error, you need to check the error logs of the website or contact support. Something is amiss.

    AR1VU First, have you "clear cache" after uninstall? Second, maybe you can try to uninstall the extension by deleting its files and edit the composer.json file. If none of these works, please post the error.log file, perhaps I could offer some more help.
    Emm, the very last but always-works solution is to uninstall and re-install the whole Flarum website, remember to backup the data if you have already created something on the website. If the problem still occur even after this grand re-install, the only two reasons I can come up with is that either the Flarum package InfinityFree provides has something wrong, or the host itself was mistakenly configured. 😂

      This is the error message with Debug turned on

      GET https://*******/api/discussions

      PDOException: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in /home/vol1000_5/epizy.com/epiz_30960903/*******/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117

        AR1VU this is not standard mysql behavior as vanilla flarum works just fine with mariadb and mysql. I'd highly recommend asking your hosting provider why this is happening, they might have put limitations in place.

          I did some more testing and only some tags have this issue while other tags work perfectly fine

          Ive ended up just reinstalling flarum and everything works now

            5 days later

            Same problem came in the reinstalled version 😭

            GET https://*****/api/discussions
            PDOException: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in

              That’s very odd. I hope you figure out the cause soon as I’ve never had that issue. When you do get it figured out please post the solution here in case someone else down the road has the same issue maybe your solution will help them out.

              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:

              1. the added change is within the database part or it won't do anything.
              2. 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 🙏

                  6 days later

                  luceos I implemented the code and it fixed the problem
                  The discussions load in the tags and can be displayed

                  But now the discussions themselves don’t load 😭
                  Clicking on them opens the page but just continues with a loading circle (same even if loading the page directly through url)

                      AR1VU

                      😄I had something similar happening a couple of days ago, while testing codes to remove the Secondary Nav/Side Nav.

                        AR1VU please post your php flarum info or at least your database version so we can trace this further.

                          15 days later

                          luceos Is this issue caused by InfinityFree's unique remote SQL? I'm running a "Matomo" web analytics on an InfinityFree's server, and it got a lot of SQL errors that I have never met before either. 😂😅😭