Hey there!
Suddenly my forum is not working well, I can't reach any pages.
There is only 1 error message: TheSELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
What can I do with it?
what do you mean you cant reach any of your pages, does it show white page or an error message?
Also you shou0ld update to 2.0.15
Just white page with the error message.
And yeah, I wanted to update, but it worked fine.
Does it say a line number or file?
Also how many posts does your forum?
No, just one error message, no line or file.
I don't know exactly, but there is many.
What did you do just before the error started happening?
I edited the index.template file, but when I saved nothing bad happened.
After a few minutes I couldn't open the forum and the error message appeared.
But I don't think the index.template file has the problem cuz I changed back to the normal file.
have you reached out to your host to see if they changed anything? send them the error message and see what happens, they should be able to fix the issue.
what change did you make to the index.template.php file?
How did you make the change (ftp? cpanel file manager? within SMF template editor?)
I changed some lines under template_body_above on FTP.
Btw I wrote to the host.
If you consider your file edits to be regressed, did you have a look elsewhere on SMF.org for other causes of this error?
https://www.simplemachines.org/community/index.php?action=search2;search=The+SELECT+would+examine
>>>>
https://www.simplemachines.org/community/index.php?topic=513319.msg3628058#msg3628058
https://www.simplemachines.org/community/index.php?topic=524300.msg3712257#msg3712257
https://www.simplemachines.org/community/index.php?topic=553011.msg3920182#msg3920182
https://www.simplemachines.org/community/index.php?topic=556530.msg3944473#msg3944473
Unless you put database queries into the template (seems a little unlikely), the error wouldn't happen because of a template change and only because of outgrowing preconfigured limits on the server. Definitely time to ask the host (and maybe get which query it is that's causing trouble)
They said my page reached the sql server variable limit, and may i can fix it if i make more multiple sql queries, but i dont know, its possible?
your host is an idiot.... and is probably an overseller.
Quote from: FluFFeh on January 04, 2019, 11:09:44 AM
They said my page reached the sql server variable limit, and may i can fix it if i make more multiple sql queries, but i dont know, its possible?
If your host can't tell you which query causes this problem, time to find a new, better host.
Well, I found a better host, but when I import the database, the special characters does not appear correctly, just a "?".
I looked for that problem, I tried to fix it but nothing worked.
how did you export the database? how did you import the database?
All both with phpmyadmin, latin1 charset. But its just happens in 2.0.15 version
you need to check if your tables are using latin1, i bet they are utf-8.
(https://i.imgur.com/0GBiBxj.png)
That's for the tables - check the individual columns inside them.
latin1 here too.