Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Scooter Trash on April 06, 2022, 06:32:02 PM

Title: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 06:32:02 PM
Greetings;

I'm running SMF 2.0.19 on a GoDaddy shared server with PHP 8.0.  It's worked well for years, but yesterday, I attempted to sort the Member List newest to oldest, and got a 404 page not found, and then server timeouts when trying to load any page on the site that isn't cached in the browser. The link to sort the list is https://mysite.com/forum/index.php?action=mlist;sort=registered;start=0

I contacted GoDaddy, and they recommended that I check with SMF developers.

I completely deleted the old installation. Then downloaded a fresh copy from SMF and installed it using the existing database. Same issue. Whenever I try to sort the member list, I get server timeout error messages. I get them for 20 minutes or so, and then can load pages again until I attempt to sort the user list.

I CAN sort the user list ascending or descending chronologically in phpMyAdmin, but not in SMF.

FWIW, I'm running WordPress on the same server, and there was an automatic update 2 nights ago. Not sure if that's what caused this issue.

Any help/suggestions?

Thanks 
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Kindred on April 06, 2022, 06:53:13 PM
I don't believe that 2.0.19 fully supports running on php8.0

But it sounds more like godaddy is screwing you over by throttling your account
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Arantor on April 06, 2022, 06:59:33 PM
I'd be interested to know how many member accounts there are.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 07:06:12 PM
Quote from: Kindred on April 06, 2022, 06:53:13 PMI don't believe that 2.0.19 fully supports running on php8.0

But it sounds more like godaddy is screwing you over by throttling your account

I reverted to an earlier version of PHP, and had the same issue.
According to this though, 2.0.19 should be compatible with php 8.0?  https://download.simplemachines.org/requirements.php
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 07:09:48 PM
Quote from: Arantor on April 06, 2022, 06:59:33 PMI'd be interested to know how many member accounts there are.

phpMyAdmin is showing 2077 members in the database
Title: Re: Sorting Member List Causes Server Timeouts
Post by: shawnb61 on April 06, 2022, 07:14:12 PM
2.0.19 supports php 8.

# of members is a good question.

Also - Which version of mysql?

Next thing to figure out is whether the table structure is complete - specifically whether all of the indexes are there.

After that - I'd run the actual query in pma to see what's happening.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 07:35:27 PM
Quote from: shawnb61 on April 06, 2022, 07:14:12 PM2.0.19 supports php 8.

# of members is a good question.

Also - Which version of mysql?

2077 members
Version 5.6.49

QuoteNext thing to figure out is whether the table structure is complete - specifically whether all of the indexes are there.

After that - I'd run the actual query in pma to see what's happening.


What's the best way to go about completing those 2 tasks please?

Edit: BTW, When I go to the Memberlist in SMF, it's showing the first 20 or 25 members. When I use the alphabetical letters, I can navigate between pages in the member list. It's only when I try to view ascending/descending that I have the issue.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: shawnb61 on April 06, 2022, 09:13:59 PM
To check the indexes, look at the table structure in phpMyAdmin.  Scroll down to where it shows you the indexes.  It should look like this:
memb_struct.png


Above, it looks like you were sorting by date registered.  The base query is actually very simple.  I would try running this in the SQL tab in pma:
      SELECT mem.id_member
      FROM smf_members AS mem
      WHERE mem.is_activated = 1
      ORDER BY mem.date_registered ASC
      LIMIT 0, 30

If that works, we'll query the detail next...



Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 09:46:08 PM
I'm really unfamiliar with the database stuff, so you're gonna have to explain it to me like I'm 5 years old lol.
What is PMA?
This is what my Forums database looks like in phpMyAdmin. Where should I go from here?

(https://i.imgur.com/g6LhDtd.jpg)

Quote from: shawnb61 on April 06, 2022, 09:13:59 PMTo check the indexes, look at the table structure in phpMyAdmin.  Scroll down to where it shows you the indexes.  It should look like this:
memb_struct.png


Above, it looks like you were sorting by date registered.  The base query is actually very simple.  I would try running this in the SQL tab in pma:
      SELECT mem.id_member
      FROM smf_members AS mem
      WHERE mem.is_activated = 1
      ORDER BY mem.date_registered ASC
      LIMIT 0, 30

If that works, we'll query the detail next...




Title: Re: Sorting Member List Causes Server Timeouts
Post by: shawnb61 on April 06, 2022, 09:53:20 PM
Pma = phpmyadmin for lazy folk

To run the query, just click on the SQL tab you see in pma, then paste it & execute.

To see the structure for one of the tables in pma, click on the table name in pma (like in your screenshot above), THEN click on the structure tab.  Below the list of columns will be the list of indexes.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 10:12:22 PM
Quote from: shawnb61 on April 06, 2022, 09:53:20 PMPma = phpmyadmin for lazy folk

To run the query, just click on the SQL tab you see in pma, then paste it & execute.

To see the structure for one of the tables in pma, click on the table name in pma (like in your screenshot above), THEN click on the structure tab.  Below the list of columns will be the list of indexes.


DUH! I should have been able to figure that acronym out lol. I've been working on this since early this morning and I'm a bit rummy. 

I placed your code in the SQL query box and this was what I got?

(https://i.imgur.com/uo57tyV.jpg)
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 06, 2022, 10:24:16 PM
Actually.. Thanks for the help - but fek it.
I went to the forums and there was a recently-registered spam troll using the forums. I tried the ban feature and the forums hung. I'm tired of dealing with the SMF administration and the bots and trolls and all of it. I'm just going to delete the forums.
Thanks.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: shawnb61 on April 06, 2022, 10:42:41 PM
Sorry to hear that.

Yep, it's hard work.  If you change your mind, we're here to help.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Steve on April 07, 2022, 05:42:11 AM
Quote from: Scooter Trash on April 06, 2022, 06:32:02 PMI contacted GoDaddy, and they recommended that I check with SMF developers.
Better to change to a better host and clean out your forum than to give up on it. Depending on how long you've been running it, you'll miss it. Going to mark this solved since you've decided to give it up. :(


Title: Re: Sorting Member List Causes Server Timeouts
Post by: Doug Heffernan on April 07, 2022, 06:43:32 AM
Quote from: Scooter Trash on April 06, 2022, 10:24:16 PMI'm just going to delete the forums.

I am sorry to hear that too. A word of advice, if I may. Make a full backup of the database before you delete it. Like that you can always bring your forum back later when/if you have a change of heart.

Title: Re: Sorting Member List Causes Server Timeouts
Post by: Scooter Trash on April 13, 2022, 11:27:57 PM
So.. I deleted the forum directory. deleted the database. Installed phpBB. It worked fine. I actually liked it. But I had 12 years worth of stuff that I really didn't want to give up on. So I decided to try ONE MORE TIME.
I created a new database and installed a fresh copy of Simple Machines 2.0.19 into a directory with a different name (forumsold.) Everything worked fine. So I renamed the phpBB directory and renemaed the SMF directory "forum." Then, of course the theme and everything was wonky because of the paths, so I downloaded the Settings.php file and fixed the paths, and then uploaded it and set the default theme. Everything was working fine, so I went into phpMyAdmin and imported a database backup from April of 2020. Everything is working fine now. I've lost a year, but I can live with that.

I have no idea why it wouldn't work last time I did a clean install with a new, freshly-created  database.. but it's all working now. I can sort the memberlist ascending or descending, and the other actions that were causing problems before. I'm afraid to try using a more recent database backup. I can live with this.
Title: Re: Sorting Member List Causes Server Timeouts
Post by: Aleksi "Lex" Kilpinen on April 13, 2022, 11:41:14 PM
Sorry, but you said it yourself.
Quote from: Scooter Trash on April 06, 2022, 06:32:02 PMGoDaddy