Advertisement:

Author Topic: [2.0.11] I can't reach any pages in my forum  (Read 1152 times)

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
[2.0.11] I can't reach any pages in my forum
« 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?

Offline Deaks

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 22,161
  • Gender: Male
Re: [2.0.11] I can't reach any pages in my forum
« Reply #1 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

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #2 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.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,624
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: [2.0.11] I can't reach any pages in my forum
« Reply #3 on: December 27, 2018, 09:12:08 AM »
Does it say a line number or file?

Also how many posts does your forum?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #4 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.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,565
  • Gender: Male
    • Kindred-999 on GitHub
Re: [2.0.11] I can't reach any pages in my forum
« Reply #5 on: December 27, 2018, 09:18:36 AM »
What did you do just before the error started happening?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #6 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.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,434
Re: [2.0.11] I can't reach any pages in my forum
« Reply #7 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.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,565
  • Gender: Male
    • Kindred-999 on GitHub
Re: [2.0.11] I can't reach any pages in my forum
« Reply #8 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?)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #9 on: December 27, 2018, 09:59:36 AM »
I changed some lines under template_body_above on FTP.

Btw I wrote to the host.


Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,845
    • StoryBB/StoryBB on GitHub
Re: [2.0.11] I can't reach any pages in my forum
« Reply #11 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)
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #12 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?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,565
  • Gender: Male
    • Kindred-999 on GitHub
Re: [2.0.11] I can't reach any pages in my forum
« Reply #13 on: January 04, 2019, 01:39:23 PM »
your host is an idiot.... and is probably an overseller.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,845
    • StoryBB/StoryBB on GitHub
Re: [2.0.11] I can't reach any pages in my forum
« Reply #14 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.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #15 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.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,434
Re: [2.0.11] I can't reach any pages in my forum
« Reply #16 on: January 12, 2019, 09:24:44 AM »
how did you export the database? how did you import the database?

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #17 on: January 12, 2019, 01:03:31 PM »
All both with phpmyadmin, latin1 charset. But its just happens in 2.0.15 version

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,434
Re: [2.0.11] I can't reach any pages in my forum
« Reply #18 on: January 12, 2019, 01:32:38 PM »
you need to check if your tables are using latin1, i bet they are utf-8.

Offline FluFFeh

  • Semi-Newbie
  • *
  • Posts: 10
Re: [2.0.11] I can't reach any pages in my forum
« Reply #19 on: January 12, 2019, 01:45:24 PM »