VIDEN Hi there! I'm currently having an issue with the "All Discussions" page. It wont load correctly. More about the issue: The problem has always been there sense I started using flarum. The problem occur randomly from 3 times a day to maybe 3 times every week. It always fixes itself within 1 to 12 hours after occurring. What I mean with "wont load correctly" is that only the top part of the page is shown, no posts or left navigation buttons. Sometimes the left navigation buttons will be displayed but no posts. A red message at the button left corner says: "Oops! Something went wrong. Please reload the page and try again." Reloading the page will not help. Other pages have always worked correctly. Only occurs at the "All Discussions" page. Logs: Next Illuminate\Database\QueryException: 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 (SQL: select * from flrm_posts where flrm_posts.id in (21, 22, 23, 26, 29, 34, 35, 36, 39, 41, 42, 46, 47, 56, 57, 67, 70, 94, 95, 96) and type in (discussionTagged, discussionStickied, discussionLocked, comment, discussionRenamed)) in /customers/e/f/a/curvearchitect.com/httpd.www/forum/vendor/illuminate/database/Connection.php:712 Additional information: PHP version: 8.2.23 Flarum version: 1.8.5 I host the forum at one.com. Link to the flarum forum: https://curvearchitect.com/forum/public/
VIDEN Thanks for the answer! I have applied the temp fix you suggested in the config.php file. Can't say if it works or not yet because the problem went way before I added it. Hopefully it works 🙂
