Upgrading 2.0.18 -> 2.1 stuck...

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

Previous topic - Next topic

Illori

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.

ozp

Can't you just write a php script that renames all files in the dir?

m4z

Linux server? Shell access? There's "rename".
"Faith is what you have in things that don't exist."
--Homer Simpson

Es gibt hier im Forum ein deutsches Support-Board!

Kindred

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
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Sir Osis of Liver

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

                                     - R. Waters

Sir Osis of Liver

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

                                     - R. Waters

dan4ever

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

Sir Osis of Liver

What does 2.1 upgrade do to custom_avatar?
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Sir Osis of Liver

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

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Sir Osis of Liver

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

                                     - R. Waters

dan4ever

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.

/Dan Olsson, Webmaster at https://www.guldforum.se

Ninja ZX-10RR

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 :(
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

dan4ever

Its not a white page in Sweden!!!


Here it work, exept from uploaded photo-avatar.


/Dan
/Dan Olsson, Webmaster at https://www.guldforum.se

Sir Osis of Liver

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

                                     - R. Waters

Sir Osis of Liver

Clean files no help.  Not logging any server errors.  Doing clean install in new directory.

Don't change anything Dan.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Ninja ZX-10RR

It's no longer a white page on my end at least, but it was earlier.
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

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

                                     - R. Waters

shawnb61

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

Ninja ZX-10RR

Do you have something like:
RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.guldforum.se/$1 [R,L]

in the .htaccess?
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

.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


Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Advertisement: