Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: FluFFeh on December 27, 2018, 08:15:13 AM

Title: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on December 27, 2018, 08:15:13 AM
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?
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Deaks on December 27, 2018, 08:52:58 AM
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
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on December 27, 2018, 08:56:32 AM
Just white page with the error message.
And yeah, I wanted to update, but it worked fine.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: vbgamer45 on December 27, 2018, 09:12:08 AM
Does it say a line number or file?

Also how many posts does your forum?
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on December 27, 2018, 09:15:40 AM
No, just one error message, no line or file.
I don't know exactly, but there is many.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Kindred on December 27, 2018, 09:18:36 AM
What did you do just before the error started happening?
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on December 27, 2018, 09:24:04 AM
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.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Illori on December 27, 2018, 09:28:50 AM
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.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Kindred on December 27, 2018, 09:47:24 AM
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?)
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on December 27, 2018, 09:59:36 AM
I changed some lines under template_body_above on FTP.

Btw I wrote to the host.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Shambles on December 27, 2018, 01:49:13 PM
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
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Arantor on December 27, 2018, 01:55:41 PM
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)
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: 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?
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Kindred on January 04, 2019, 01:39:23 PM
your host is an idiot.... and is probably an overseller.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Arantor on January 04, 2019, 01:42:07 PM
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.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on January 12, 2019, 07:48:42 AM
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.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Illori on January 12, 2019, 09:24:44 AM
how did you export the database? how did you import the database?
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on January 12, 2019, 01:03:31 PM
All both with phpmyadmin, latin1 charset. But its just happens in 2.0.15 version
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Illori on January 12, 2019, 01:32:38 PM
you need to check if your tables are using latin1, i bet they are utf-8.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on January 12, 2019, 01:45:24 PM
(https://i.imgur.com/0GBiBxj.png)
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: Arantor on January 12, 2019, 02:16:20 PM
That's for the tables - check the individual columns inside them.
Title: Re: [2.0.11] I can't reach any pages in my forum
Post by: FluFFeh on January 12, 2019, 03:03:17 PM
latin1 here too.