Sorting Member List Causes Server Timeouts

[Scooter Trash]

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 

[Kindred]

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

[Arantor]

I'd be interested to know how many member accounts there are.

[Scooter Trash]

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

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

[Scooter Trash]

I'd be interested to know how many member accounts there are.

phpMyAdmin is showing 2077 members in the database

[shawnb61]

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.

[Scooter Trash]

2.0.19 supports php 8.

# of members is a good question.

Also - Which version of mysql?

2077 members
Version 5.6.49

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.

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.

[shawnb61]

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:
You cannot view this attachment.


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:

Code Select Expand

      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...

[Scooter Trash]

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?

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:
You cannot view this attachment.


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:

Code Select Expand

      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...

[shawnb61]

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.

[Scooter Trash]

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.

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?

[Scooter Trash]

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.

[shawnb61]

Sorry to hear that.

Yep, it's hard work.  If you change your mind, we're here to help.

[Steve]

I 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.

[Doug Heffernan]

I'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.

[Scooter Trash]

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.

[Aleksi "Lex" Kilpinen]

Sorry, but you said it yourself.

GoDaddy