2.4.24 --> 20220803.1 --> 20240308.1 Upgrade Notes (Development)

by Joe I, Thursday, March 28, 2024, 19:56 (31 days ago) @ Auge

As noted in the previous post, our current forum is 2.4.24, so this one was a 2-step upgrade to get to 20240308.1.

I made a copy of the site and removed any duplicate user emails before proceeding, as I believe the upgrade to 20220803.1 would crash otherwise.
I then performed a successful upgrade to 20220803.1
I then performed a successful upgrade to 20240308.1, using the code located in GitHub/master.

Some Notes:
1) This script did not crash on the same CREATE TABLE step as the direct upgrade from 2.4.24. I am guessing this is because the b8_rating_table was already created during the upgrade to 20220803.1, but I do see several DROP TABLE commands prior to the CREATE TABLE in Lines 290-294. The comment on the DROP TABLE commands says it was for pre-release testing. Since Im not exactly sure if these lines (290-294) are working as designed, I'm just making a note to you.

2) In your original comments, you note that this upgrade doesn't include any much discussed database performance fixes. Our site DB is quite large (~500,000 posts), and runs very slowly on any 2.5 version of MLF due to the performance of some read queries which JOIN on the new Spam tables. I had previously dug into improving performance for our site when running 20220803.1, but never did come up with an acceptable solution. I am willing to look into this further if appropriate, and also wanted to see if you know of any potential improvements that I could test out on our site running 20220803.1 or 20240308.1.

Regards,

Joe


Complete thread:

 RSS Feed of thread