News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Upgrading 2.0.18 -> 2.1 stuck...

Started by dan4ever, March 14, 2021, 02:08:23 PM

Previous topic - Next topic

Sir Osis of Liver

It's crashed again.  Switching to clean install.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Ninja ZX-10RR

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).
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Herman's Mixen

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
Met vriendelijke groet, The Burglar!

 House Mixes | Mixcloud | Any Intelligent fool can make things bigger, more complex, and more violent.
It takes a touch of genius - and a lot of courage - to move in the opposite direction. - Albert Einstein

Former Godfather of our dutch community ;)

Sir Osis of Liver

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).
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

shawnb61

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.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

dan4ever

#46
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
/Dan Olsson, Webmaster at https://www.guldforum.se

Aleksi "Lex" Kilpinen

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.
Slava
Ukraini!


"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

shadav

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:

dan4ever

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
/Dan Olsson, Webmaster at https://www.guldforum.se

Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Ninja ZX-10RR

Would you mind clearing the forum cache? Remember that old bug with corrupt cache nobody ever figured out? Just to rule that bit out :)
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

shawnb61

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,
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Sir Osis of Liver

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, 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, clean files, connected to same db, wsod.  It came up briefly when I was working today, then crashed again.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

shawnb61

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,
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Ninja ZX-10RR

I don't want to bash on a dead horse but seriously how bad can "hosts" be? Even by reading this thread :(
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.

♥ Jess ♥

STOP EDITING MY PROFILE

Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

dan4ever

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
/Dan Olsson, Webmaster at https://www.guldforum.se

Advertisement: