Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: dan4ever on March 14, 2021, 02:08:23 PM

Title: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on March 14, 2021, 02:08:23 PM
Hi

Trying to upgrade my forum from 2.0.18 to 2.1.
I download from this site and it started to get error about wrong language file, but continued in english.
Then it stop att smileys something....
Incorrect string value: '\xE4ttnin...' for column 'value' at row 1

And now I can't do anything.
If I read the upgrade_2-0_mysql.php,  it stoped at row 2066 (very strange). Everything after didn't exequte but before yes!

So, what to do?
I have $maintenance = 0;   in settings.

/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Kindred on March 14, 2021, 06:06:54 PM
Use the download from github.

There are over 2000 changes between the rc3 on this site versus the almost rc4 on github
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on March 17, 2021, 10:07:51 AM
Have to install backup for the database (it stoped upgrade after half way).


Any suggestions on how I can most easily change "backup_smf_admin_info_files" to "smf_admin_info_files" on very many files? so just delete "backup_" in PhpMyAdmin?


/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on March 29, 2021, 05:53:44 AM
Al the profile-pic are now in "custom_avatar"-folder and with different name.
Is it possibly to change back?


Also problem to see the post in a category.


Thanks in advance.
Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Kindred on March 29, 2021, 12:26:46 PM
Did you not take a full backup of files and database before starting?
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on March 29, 2021, 12:44:34 PM
You can replace table prefix in phpmyadmin by checking all tables and using 'With selected' dropmenu.

No offense, but judging from your questions you really shouldn't be attempting upgrade to RC.  Stay with 2.0 until 2.1 goes final.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on March 29, 2021, 05:35:20 PM
Quote from: Kindred on March 29, 2021, 12:26:46 PM
Did you not take a full backup of files and database before starting?


Only the Database via the installer. A big stupid mistake!



Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on March 29, 2021, 05:40:03 PM
Quote from: Sir Osis of Liver on March 29, 2021, 12:44:34 PM
You can replace table prefix in phpmyadmin by checking all tables and using 'With selected' dropmenu.

No offense, but judging from your questions you really shouldn't be attempting upgrade to RC.  Stay with 2.0 until 2.1 goes final.


Yes I did work throu the database with the prefix so I think its working now.
And the post can be seen now after changing al the files.


But still the profil pic are still not working.


/Dan.  (yes, I will keep 2.0.18...)
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on March 29, 2021, 10:16:44 PM
If the database is good, upload clean 2.0.18 files from large upgrade package.  You'll lose any mods or customizations, but content should be intact.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on March 31, 2021, 01:09:09 PM
Quote from: Sir Osis of Liver on March 29, 2021, 10:16:44 PM
If the database is good, upload clean 2.0.18 files from large upgrade package.  You'll lose any mods or customizations, but content should be intact.


Yes I have done that now but the profil pic are al gone..
They are in a catalog "custom_avatar" with different name.  Strange!!!!
I don't know how to get it back...?


/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on March 31, 2021, 01:20:46 PM
That's not a core directory, must have been added by a mod.  Only one I can find is this -

https://custom.simplemachines.org/mods/index.php?mod=1034

But it's very old and wasn't updated past 1.1.4.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on March 31, 2021, 01:26:27 PM
Hmm, maybe all you have to do is change the avatar path to custom directory.

Admin -> Attachments and Avatars -> Avatar Settings

Update 'Avatars directory' and 'Avatars URL'.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 01, 2021, 04:22:55 AM
Quote from: Sir Osis of Liver on March 31, 2021, 01:26:27 PM
Hmm, maybe all you have to do is change the avatar path to custom directory.

Admin -> Attachments and Avatars -> Avatar Settings

Update 'Avatars directory' and 'Avatars URL'.


no, didn't work.
It have change the name too.  from 16838_15fcdfe280448d86f243537754e8eec5ecbd69e3 to avatar_2_1555451875.png
And now al are .png.

Easer to tell evrybody to put in new ones.  Doesn't look like there is any help for this...

/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Illori on April 01, 2021, 04:58:58 AM
the names should be hashed, this is for security and to keep you from having duplicates if someone uploads one that has the same name as someone else.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: live627 on April 01, 2021, 02:47:23 PM
Quote from: Sir Osis of Liver on March 31, 2021, 01:20:46 PM
That's not a core directory, must have been added by a mod.
Um, yeah, Krash? I recommend that you familiarize yourself with 2.1 soon. That actually IS a core directory.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 01, 2021, 03:44:54 PM
He's back to 2.0.18 after borked upgrade to 2.1.  Didn't have db backup, restored backup_ tables, so there may be mixed tables.  That's my understanding, anyway, haven't seen install.

Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 04, 2021, 02:18:25 PM
Quote from: Sir Osis of Liver on April 01, 2021, 03:44:54 PM
He's back to 2.0.18 after borked upgrade to 2.1.  Didn't have db backup, restored backup_ tables, so there may be mixed tables.  That's my understanding, anyway, haven't seen install.


Yes, (but I haven't mixed tables ::) [size=78%]). [/size]
Profile pic, and attachment looks like they have different name. 
Are there a way to Get them back in business ?


/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 04, 2021, 10:03:40 PM
If you have a custom_avatar directory that would have been created when you attempted upgrade to 2.1.  Unless it was added by 2.0 mod, you can't use it in 2.0 install.  Would need cpanel access to help you with this.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 06, 2021, 03:10:47 AM
Quote from: Sir Osis of Liver on April 04, 2021, 10:03:40 PM
If you have a custom_avatar directory that would have been created when you attempted upgrade to 2.1.  Unless it was added by 2.0 mod, you can't use it in 2.0 install.  Would need cpanel access to help you with this.


I really need some help to make this back in glory.   Can you help me?   PM me


/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 08, 2021, 05:06:57 PM
<sigh>

OP has well over 10,000 attachments (2.4gb), all of which have .dat extension added to hash, making filenames invalid.  No idea how this happened, or how to fix it.  Is there any way to mass delete extensions on server without having to d/l the whole thing and do it locally?
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Illori on April 09, 2021, 04:55:56 AM
that is why a full back up should be performed before you do any upgrade. the .dat extension is applied during the upgrade to 2.1.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: ozp on April 09, 2021, 05:41:45 AM
Can't you just write a php script that renames all files in the dir?
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: m4z on April 09, 2021, 06:14:00 AM
Linux server? Shell access? There's "rename".
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Kindred on April 09, 2021, 11:38:14 AM
it happened because the upgrade was performed....   SMF major upgrades are not intended to be reversed. This is why we always say "TAKE A BACKUP"

In order to undo ALL of the stuff that happens behind the scenes of the upgrade from 2.0 to 2.1 -- you are going to have to manually do a truck-load -- nay, a freighter-load -- of work
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 09, 2021, 01:47:06 PM
Quote from: Illori on April 09, 2021, 04:55:56 AM
that is why a full back up should be performed before you do any upgrade. the .dat extension is applied during the upgrade to 2.1.

Thanks, Illori, I think he knows that now. ::)

Quote from: m4z on April 09, 2021, 06:14:00 AM
Linux server? Shell access? There's "rename".

It's Hostgator :P, doesn't give me access.  This appears to be the least of his problems.

Quote from: ozp on April 09, 2021, 05:41:45 AM
Can't you just write a php script that renames all files in the dir?

That's not a bad idea.  Don't know if it would run to completion, there are approx. 13,000 files and it's on Hostgator.

Quote from: Kindred on April 09, 2021, 11:38:14 AM
it happened because the upgrade was performed....   SMF major upgrades are not intended to be reversed. This is why we always say "TAKE A BACKUP"

In order to undo ALL of the stuff that happens behind the scenes of the upgrade from 2.0 to 2.1 -- you are going to have to manually do a truck-load -- nay, a freighter-load -- of work

Reading back on this thread, OP tried to restore db by replacing 2.1 tables with backup_ tables that were created prior to borked upgrade.  Database seems to be ok, I have it running in clean 2.0.18 install.  I've copied /attachments and /custom_avatar from old install, all other files are clean.  Prod install was wsod, had it working briefly then crashed again.  HG pushed him up to php 7.4, some of the mods were logging deprecated errors.  It's an old forum, looks like one of the mods may have caused wsod.  Attachments and custom avatars are still screwed up, working on that.  Slow going because of time difference (he's in Sweden, I'm in NY).
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 09, 2021, 02:19:34 PM
Quote from: ozp on April 09, 2021, 05:41:45 AM
Can't you just write a php script that renames all files in the dir?

That worked, saved me a lot of time.  Thanks. (http://www.thekrashsite.com/pics/thu.gif)
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 09, 2021, 04:34:13 PM
Hi again


Now the attachments are working but not the custom_avatars (uploaded profil-picture!!!)
Tryed to upload a new one,  come to the attachment folder.
Made a copie of al custom_avatars pic and put in attachment folder,  did not work out that simple....
Have used "repair_settings" and looks good.
It should work  O:)

/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 09, 2021, 09:45:19 PM
What does 2.1 upgrade do to custom_avatar?
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 12:27:34 AM
Hmm, been dicking around with the avatar problem, this is what we have:

- There are 527 files in /custom_avatar, most are pngs and look like this -
   avatar_138_1390472290.png

- No avatar is displayed in profile for id_member 138, but you can view it here -
   http://www.guldforum.se/forum/custom_avatar/avatar_138_1390472290.png

- In smf_attachments we have
   id_attach = 2075
   id_member = 138
   attachment_type = 0
   filename = avatar_138_1390472290.png
   file_hash = 8cd2d4c66ccc5ceba98ef699952df793a3e26ccd
   file_type = png

   There is no attachment 2075_8cd2d4c66ccc5ceba98ef699952df793a3e26ccd

- In Avatar Settings, Avatars URL = https://www.guldforum.se/forum/custom_avatar

- repair_settings shows Custom Avatar URL:  http://www.guldforum.se/forum/custom_avatar

It's a clean 2.0.18 install running database that was borked by failed 2.1 upgrade.  Database was restored from backup_ tables and appears to be undamaged.  Core 2.0 does not have /custom_avatar.  2.1 install creates this directory but it's empty.  I guess that leaves me with two questions:

1. - Does 2.1 upgrade find avatars in /attachments and move them to /custom_avatar?

2. - That being the case, is there any way to reverse it?

I suppose a third question would be:

3. - Am I just having another bad night and missing something obvious? :P

Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 12:40:59 AM
Quote from: Sir Osis of Liver on April 11, 2021, 12:27:34 AM
1. - Does 2.1 upgrade find avatars in /attachments and move them to /custom_avatar?

Oh crap. >:(  That's exactly what it does.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 11, 2021, 06:38:25 AM
Another question:

Does repair_settings making bad settings on a 2.0.18 install because /custom_avatar dir are there?

And it should not be any problem to rename /custom_avatar???

/Dan
PS.  Thanks everybody for helping me (incl al the "backup before.....").    DS.

Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 11, 2021, 02:05:12 PM
As of this post, that forum is a white page and there's a mix of http and https in the links you posted. The avatar you linked returned a 404 for me.

Now that's what I call sticky situation, or a mess. There's a LOT of "why" that come to mind with very few answers, but not much to add other than the above and what's already been said in previous posts :(
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 11, 2021, 04:00:27 PM
Its not a white page in Sweden!!!


Here it work, exept from uploaded photo-avatar.


/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 04:04:43 PM
Getting wsod here in NY.  Could be a hostgator problem.  Was working fine last night, all http.  Some of the settings keep reverting to https, don't know why, but that's not what crashed the forum.  A theme and a mod were installed after I got off, but just restored package backup and still wsod.  Think I'll do another clean install.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 04:15:58 PM
Clean files no help.  Not logging any server errors.  Doing clean install in new directory.

Don't change anything Dan.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 11, 2021, 04:35:06 PM
It's no longer a white page on my end at least, but it was earlier.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 04:36:48 PM
New install is running.  Had to manually change some https paths to http, they came up mixed again.  Best guess there's a problem with your SSL certificate.  You have a Lets Encrypt cert installed for that domain, should work unless it's misconfigured.  Cpanel is not giving me access to domain settings.  Will try reverting tp previous install again, see if I can get it working.  Contact hostgator support, ask if they can fix the cert (good luck).  You really should move to a better host.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shawnb61 on April 11, 2021, 04:44:50 PM
A hint: the installer creates settings based on how it is invoked...  I.e., if you invoke http://install.php, the settings will all use http://.  If you invoke https://install.php, the settings will use https://.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 11, 2021, 04:45:25 PM
Do you have something like:
RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.guldforum.se/$1 [R,L]

in the .htaccess?
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 04:53:14 PM
.htaccess in /public_html, none in /forum -



RewriteEngine on
Options All -Indexes
DirectoryIndex index.php index.html index.htm

<IfModule mod_rewrite.c>
RewriteEngine off
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$
RewriteCond %{REQUEST_URI} !^/\.well-known/cpanel-dcv/[0-9a-zA-Z_-]+$
RewriteCond %{REQUEST_URI} !^/\.well-known/pki-validation/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteRule ^ index.php [L]
</IfModule>

<IfModule mod_security.c>
# Turn off mod_security filtering. SMF is a big boy, it does not need its hands held.
SecFilterEngine Off

# The below probably isn't needed, but better safe than sorry.
SecFilterScanPOST Off
</IfModule>

# php -- BEGIN cPanel-generated handler, do not edit
# Set the “ea-php74” package as the default “PHP” programming language.
<IfModule mime_module>
  AddHandler application/x-httpd-ea-php74 .php .php7 .phtml
</IfModule>
# php -- END cPanel-generated handler, do not edit


Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 05:00:04 PM
It's crashed again.  Switching to clean install.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 11, 2021, 05:40:49 PM
Throw that bit I posted in the htaccess too, it forces http visits to https version. I use it on all https sites I ever touch, very nifty, it auto-redirects people who bookmarked the http version too.
In fact, this is the one I use specifically:
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$
RewriteCond %{REQUEST_URI} !^/\.well-known/cpanel-dcv/[0-9a-zA-Z_-]+$
RewriteCond %{REQUEST_URI} !^/\.well-known/pki-validation/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

And tells Google it's a 301 permanent redirect, so it doesn't even harm SEO (mighty forum SEO).
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 05:46:09 PM
Will try that if we continue having problems.  I'm running newest clean install in http.  Cpanel shows SSL cert installed.  Forum loads as http or https.  Can usually force https in domain settings but HG cpanel doesn't access domain.  Looks like previous install crashed after Dan installed SMFPacks CMS.  Paid mod, not supported here.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Herman's Mixen on April 11, 2021, 09:04:45 PM
Quote from: Sir Osis of Liver on March 31, 2021, 01:20:46 PM
That's not a core directory, must have been added by a mod.  Only one I can find is this -


That;s Part off 2.1
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 11, 2021, 11:22:39 PM
Yes, well, we know that.  If you read through the topic, you'll see that the borked 2.1 upgrade created the /custom_avatar directory and moved/renamed avatars from /attachments to /custom_avatar.  Working on a script to undo that, but so far it's a bit over my head (the old dog thing).
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shawnb61 on April 12, 2021, 12:43:57 AM
Quote from: Sir Osis of Liver on April 11, 2021, 11:22:39 PM
Yes, well, we know that.  If you read through the topic, you'll see that the borked 2.1 upgrade created the /custom_avatar directory and moved/renamed avatars from /attachments to /custom_avatar.  Working on a script to undo that, but so far it's a bit over my head (the old dog thing).

I would go all in the other way.  Moving to custom_avatars is fully supported by 2.0, and provided a performance improvement.  Check out this post:
https://www.simplemachines.org/community/index.php?topic=197938.0

You may get away with just configuring the custom avatars directory in 2.0.  If your avatars have already been moved, there is likely no need to do that step.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 12, 2021, 02:57:22 AM
I took a look at the db...smf_settings -> smfVersion 2.0.6   but i have 2.0.18 installed!!!

The installer have NOT complained when I upgrade. Or is it only the this settings, not the entire db?
Must be a bug!!! not to complain.

/Dan

[edit] size tags removed to enhance readability -illori
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Aleksi "Lex" Kilpinen on April 12, 2021, 03:28:28 AM
Quote from: dan4ever on April 12, 2021, 02:57:22 AM

I took a look at the db...
smf_settings -> smfVersion 2.0.6   but i have 2.0.18 installed!!!
If an update doesn't include any needed DB-changes, it will not do any DB-changes at all, so that version number may not be updated when patching.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shadav on April 12, 2021, 04:00:31 AM
Quote from: Aleksi "Lex" Kilpinen on April 12, 2021, 03:28:28 AM
Quote from: dan4ever on April 12, 2021, 02:57:22 AM

I took a look at the db...
smf_settings -> smfVersion 2.0.6   but i have 2.0.18 installed!!!
If an update doesn't include any needed DB-changes, it will not do any DB-changes at all, so that version number may not be updated when patching.
:laugh: you could read that?
I mean, I know I need new glasses but I think I need the hubble telescope to read that  :laugh:
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 12, 2021, 04:05:51 AM
Quote from: dan4ever on April 12, 2021, 02:57:22 AM

I took a look at the db..
smf_settings -> smfVersion 2.0.6   but i have 2.0.18 installed!!!

The installer have NOT complained when I upgrade. Or is it only the this settings, not the entire db?
Must be a bug!!! not to complain.

/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 12, 2021, 12:20:45 PM
Forum is crashed again, was fine when I left it last night.  No server errors.  Don't see anything changed, looks like Hostgator problem.  I've recommended moving to better host, no luck so far.

Quote from: shawnb61 on April 12, 2021, 12:43:57 AM
I would go all in the other way.  Moving to custom_avatars is fully supported by 2.0, and provided a performance improvement.  Check out this post:
https://www.simplemachines.org/community/index.php?topic=197938.0

You may get away with just configuring the custom avatars directory in 2.0.  If your avatars have already been moved, there is likely no need to do that step.

The problem is the 2.1 upgrade moved 527 existing avatars to /custom_avatar and renamed them to original filename.  2.0.18 database is looking for the files in /attachments with hashed filenames.  Pointing avatar settings to /custom_avatar doesn't work for obvious reasons.  As you know, I'm tinkering with a script to restore hashed filenames and move them back to /attachments.  Maybe I'll get lucky ::), but first have to determine why clean install keeps crashing.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 12, 2021, 03:03:19 PM
Would you mind clearing the forum cache? Remember that old bug with corrupt cache nobody ever figured out? Just to rule that bit out :)
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shawnb61 on April 12, 2021, 04:09:40 PM
We use HG for our prod forum, & I have a test account there.  Renaming 13K files shouldn't be a problem.  HG has issues, but they're not THAT bad...

Just a couple notes from our experiences...  They have been changing infrastructure around a bit.  They forced an upgrade to php7.4 & also at one point they completely changed their php muli-select tool.  The new one behaves differently, and leaves different artifacts around than the old one.  This is a time bomb that can blow up at the time the php version really changes...

So...  Two pointers I have for working within HG...
-  There are multiple apache error logs...  There is one visible from cpanel, and there is at least one in the file system.  Depending on the nature of the error, some errors will be in a file in the forum directory (where Settings.php is) & some errors may be further up the directory structure (e.g., under public_html).  All the files I've seen are named 'error_log' (no extension).
- When they changed php tools, the old tool left artifacts around in various .htaccess files that conflicted with the current tool & php version.  So...  Look at the .htaccess files.  All of them...

In both cases, start with the forum directory, then look at every parent folder up the hierarchy...  Look at the .htaccess files & look for error_log files.  I suspect you'll see .htaccess referencing now non-existent directories, e.g., php54 - like we did...

Hope this helps,
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 12, 2021, 09:00:32 PM
Quote from: Ninja ZX-10RR on April 12, 2021, 03:03:19 PM
Would you mind clearing the forum cache?

Done that several times, no help.

Quote from: shawnb61 on April 12, 2021, 04:09:40 PM
We use HG for our prod forum, & I have a test account there.  Renaming 13K files shouldn't be a problem.  HG has issues, but they're not THAT bad...

Did that couple nights ago with php script, attachments are working.

Quote
Just a couple notes from our experiences...  They have been changing infrastructure around a bit.  They forced an upgrade to php7.4 & also at one point they completely changed their php muli-select tool.  The new one behaves differently, and leaves different artifacts around than the old one.  This is a time bomb that can blow up at the time the php version really changes...

So...  Two pointers I have for working within HG...
-  There are multiple apache error logs...  There is one visible from cpanel, and there is at least one in the file system.  Depending on the nature of the error, some errors will be in a file in the forum directory (where Settings.php is) & some errors may be further up the directory structure (e.g., under public_html).  All the files I've seen are named 'error_log' (no extension).
- When they changed php tools, the old tool left artifacts around in various .htaccess files that conflicted with the current tool & php version.  So...  Look at the .htaccess files.  All of them...

In both cases, start with the forum directory, then look at every parent folder up the hierarchy...  Look at the .htaccess files & look for error_log files.  I suspect you'll see .htaccess referencing now non-existent directories, e.g., php54 - like we did...

Hope this helps,


Not logging any relevant errors, not in cpanel errors, not in error_log.  I'll check .htaccess now.  Did a clean install with new database earlier today here (http://www.guldforum.se/forumtest/index.php), installer had problems connecting to database with generated passwords, worked with simpler password.  Forum came up running, connected it to prod db, you can see it's working.  Prod forum is here (http://www.guldforum.se/forum/index.php), clean files, connected to same db, wsod.  It came up briefly when I was working today, then crashed again.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 12, 2021, 09:31:06 PM
No .htaccess in /forum or /forumtest.  public_html has this -



RewriteEngine on
Options All -Indexes
DirectoryIndex index.php index.html index.htm

<IfModule mod_rewrite.c>
RewriteEngine off
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^/\.well-known/acme-challenge/[0-9a-zA-Z_-]+$
RewriteCond %{REQUEST_URI} !^/\.well-known/cpanel-dcv/[0-9a-zA-Z_-]+$
RewriteCond %{REQUEST_URI} !^/\.well-known/pki-validation/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteRule ^ index.php [L]
</IfModule>

<IfModule mod_security.c>
# Turn off mod_security filtering. SMF is a big boy, it does not need its hands held.
SecFilterEngine Off

# The below probably isn't needed, but better safe than sorry.
SecFilterScanPOST Off
</IfModule>

# php -- BEGIN cPanel-generated handler, do not edit
# Set the “ea-php74” package as the default “PHP” programming language.
<IfModule mime_module>
  AddHandler application/x-httpd-ea-php74 .php .php7 .phtml
</IfModule>
# php -- END cPanel-generated handler, do not edit



Above public_html is this -



# Use PHP71 as default
AddHandler application/x-httpd-php71 .php



No change if both are deleted.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shawnb61 on April 12, 2021, 10:12:23 PM
I suspect part of the problem is the conflict between 7.1 in the higher-level and the 7.4 in public_html.  I am pretty sure the 7.4 one is required. 

I think the 7.1 one is left around from their old setup and needs to go.  I had a 5.4 & 7.4 conflict exactly like this & my forum would not come up until it was resolved.  (HG support informed me of this back when I had issues converting to 7.4...)

I would also check in cPanel under Domains, Add-on Domains & Redirects to see if there is anything there that would hinder the use of a subfolder.   **Also that nothing is defaulting to https, since the forum is http...**

Longshot, but I would also delete all my cookies & make sure localCookies is set to 1 for both forums.  Two forums in two folders...

Just some things to try...  Hope this helps,
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 12, 2021, 10:28:37 PM
Unable to dump database with phpmyadmin, no backup utility in cpanel.  396 tables/596mb.  Dumped just current smf_ tables, importing into new install on my server.  Will see how it runs there.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 12, 2021, 11:19:19 PM
I don't want to bash on a dead horse but seriously how bad can "hosts" be? Even by reading this thread :(
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 12, 2021, 11:39:34 PM
Trust me, there are really bad hosts.  I have the prod database running on a clean install on my host, no problems so far.  Bearing in mind this started out as a user error, attempting to upgrade 2.0.18 forum to 2.1RC with no backups.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 13, 2021, 10:45:38 AM
Before I tryed to upgrade I tryed to back up my database from SMF but it "timed out" al the time,  didn't work.
I did do the bakup from the installer (Thank God...).    This is also an issue...


I have HostGator for 4-5 year now and with NO problem or downtime.     Just saying...




/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Aleksi "Lex" Kilpinen on April 13, 2021, 10:49:20 AM
Quote from: dan4ever on April 13, 2021, 10:45:38 AM
Before I tryed to upgrade I tryed to back up my database from SMF but it "timed out" al the time,  didn't work.
I did do the bakup from the installer (Thank God...).    This is also an issue...
This, in short, is a collection of known limitations in what you can do through PHP. The built in backup functionality is an attempt to offer an option, and generally works ok for small forums (depending on the exact server configuration, mind you) - but it will inevitably break when the forum grows. It is always better to invest some time in researching what proper backup methods you have available elsewhere.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shadav on April 13, 2021, 12:44:19 PM
Quote from: dan4ever on April 13, 2021, 10:45:38 AM
Before I tryed to upgrade I tryed to back up my database from SMF but it "timed out" al the time,  didn't work.
I did do the bakup from the installer (Thank God...).    This is also an issue...


I have HostGator for 4-5 year now and with NO problem or downtime.     Just saying...




/Dan
you should do a backup from within your hosting account this way you get a full backup of your entire site (not just the database but the files and any email and ftp settings)
but from my understanding your host doesn't offer backups which makes it a crappy host because even free hosts offer backups
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: shawnb61 on April 13, 2021, 03:38:53 PM
Hostgator does backups, though there are limitations...  Up to 10GB, they do weekly full backups & nightly incrementals.  10-20GB, they only do the weeklies, not the incrementals.  Beyond 20GB, you need to work with them for some other strategy, typically involving a more expensive package.

Up until a few years ago, I was actually a big fan of HG.  We had *ZERO* unplanned downtime or performance degradations observed for years.  The few times I called support, they were outstanding. 

Lately, though, operations & support are spotty at best...  E.g., since ~January, our site has been getting 503 errors - bad gateway.  Sometimes up to 300 a day...  Site inaccessible, sometimes for a few seconds, sometimes for 45 minutes. We've opened multiple tickets, and received nothing but delay tactics, blame, denial, etc. 

They tried blaming SMF - even though the 503s would happen trying to access cPanel or their billing portal...   :o

I think they are making massive infrastructure changes, standardizing things in their backend, etc.  And their Ops guys, I'm sure, have instructed everyone the changes will be "transparent to the users".  I've heard that from Ops guys many times before, and it's almost never true... ::)

This week, for the first time ever, cPanel for my two accounts (one very old) are identical...  And unexpectedly new...
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 13, 2021, 03:48:32 PM
The HG account does not have a backup utility, phpmyadmin could not dump the database.  It's not that large, but has a lot of tables (396 tables / 596mb).  Was able to dump 202 current smf_ tables (lot of mod tables) imported to clean install on my host, running fine here (https://www.thekrashsite.com/guldforum/index.php).  Production forum with clean files is still offline here (http://www.guldforum.se/forum/index.php).  Clean test install is running in HG account here (http://www.guldforum.se/forumtest/index.php) connected to same prod database.  Haven't repaired settings so links all go to prod forum and wsod.  Prod install has come back up briefly over past several days while I've been working with this account, then crashes again.  It's erratic, and I've seen this before on HG forums.  Solution has been to move to better host, which I've recommended several times.

I've been able to reverse changes made by 2.1 upgrade to 13,000 attachments and 500 avatars, database appears to be undamaged, just can't get the damn thing to run on HG.  This is a host issue.


Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Aleksi "Lex" Kilpinen on April 13, 2021, 04:08:25 PM
Hosts to avoid (Every host in this list is actually bought out by the same company, EIG, with a well known bad track record of ruining hosts they acquire. )
(https://researchasahobby.com/shared/EIGHosting.jpg)
Presented by ResearchAsAHobby.com (https://researchasahobby.com/full-list-eig-hosting-companies-brands/)
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 13, 2021, 04:17:14 PM
Interesting list.  Hostcentric was my first host back in the 90's (originally Virtualscape -> Vscape -> Hostcentric).  Bigger they got, the worse they got, until 2016 when they dropped off a cliff.  After 25 years had to move to better host, found Crocweb.   IIRC, Network Solutions was the original domain registrar when there was only one.  In later years they couldn't even do that right, had to move my domains elsewhere.  Sad how many service providers EIG has ruined.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 13, 2021, 04:32:25 PM
A list of god one now!
A have a forum, store and wiki.   

/Dan
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 13, 2021, 04:42:34 PM
You're currently using 21.26gb, looks like the forum, store, and wiki are all in the same account.  Would be no problem to move everything to my host (Crocweb).  50gb account would cost you $150 for 3 years.  Support would do the migration for you, they're excellent.  Have a look here (https://www.crocweb.com/web-hosting.php).  Forum is running fine in my CW account.


Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Ninja ZX-10RR on April 13, 2021, 04:49:38 PM
Quote from: Sir Osis of Liver on April 13, 2021, 04:42:34 PM
You're currently using 21.26gb, looks like the forum, store, and wiki are all in the same account.  Would be no problem to move everything to my host (Crocweb).  50gb account would cost you $150 for 3 years.  Support would do the migration for you, they're excellent.  Have a look here (https://www.crocweb.com/web-hosting.php).  Forum is running fine in my CW account.
That's a pretty good price in fact :O

However, GoDaddy is awesome as domain registrar. Just avoid their hosting servers ;D

Not to get sidetracked too much... Any news?
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 13, 2021, 04:54:51 PM
I'm copying /attachments, /attachments2, /custom_avatar from prod install to clean install connected to prod database in /forumtest, then will flip directories and make it /forum.  Tried this already, ran for a while then crashed.  Just about done, will give it a go.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: Sir Osis of Liver on April 13, 2021, 05:33:01 PM
Ok Dan, I have clean install running at http://www.guldforum.se/forum/index.php, Mutant Curve theme, attachments and avatars are fixed.  None of your mods are installed.  Don't change anything, let's see if it'll run for a while without crashing.  You can check everything, see if anything's broken or missing.
Title: Re: Upgrading 2.0.18 -> 2.1 stuck...
Post by: dan4ever on April 13, 2021, 05:34:21 PM
Quote from: Sir Osis of Liver on April 13, 2021, 04:42:34 PM
You're currently using 21.26gb, looks like the forum, store, and wiki are all in the same account.  Would be no problem to move everything to my host (Crocweb).  50gb account would cost you $150 for 3 years.  Support would do the migration for you, they're excellent.  Have a look here (https://www.crocweb.com/web-hosting.php).  Forum is running fine in my CW account.


That sounds like a symfoni.


/Dan