Advertisement:

Author Topic: Upgrading 2.0.18 -> 2.1 stuck...  (Read 3658 times)

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Upgrading 2.0.18 -> 2.1 stuck...
« 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....
Code: [Select]
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
/Dan Olsson, Admin at https://www.guldforum.se

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,232
  • Gender: Male
    • Kindred-999 on GitHub
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #1 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
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."

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #2 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
/Dan Olsson, Admin at https://www.guldforum.se

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #3 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
/Dan Olsson, Admin at https://www.guldforum.se

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 60,232
  • Gender: Male
    • Kindred-999 on GitHub
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #4 on: March 29, 2021, 12:26:46 PM »
Did you not take a full backup of files and database before starting?
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."

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #5 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.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #6 on: March 29, 2021, 05:35:20 PM »
Did you not take a full backup of files and database before starting?


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



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

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #7 on: March 29, 2021, 05:40:03 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...)
/Dan Olsson, Admin at https://www.guldforum.se

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #8 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.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #9 on: March 31, 2021, 01:09:09 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
/Dan Olsson, Admin at https://www.guldforum.se

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #10 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.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #11 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'.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #12 on: April 01, 2021, 04:22:55 AM »
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
/Dan Olsson, Admin at https://www.guldforum.se

Offline Illori

  • Lead Support Specialist
  • SMF Legend
  • *
  • Posts: 52,866
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #13 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.

Offline live627

  • Developer
  • SMF Hero
  • *
  • Posts: 5,921
  • Gender: Male
    • live627 on Facebook
    • live627 on GitHub
    • live627 on LinkedIn
    • @live627 on Twitter
    • livemods
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #14 on: April 01, 2021, 02:47:23 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.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #15 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.

“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #16 on: April 04, 2021, 02:18:25 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
/Dan Olsson, Admin at https://www.guldforum.se

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #17 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.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns

Offline dan4ever

  • Jr. Member
  • **
  • Posts: 128
  • Gender: Male
  • SMF 2.0.18
    • dan.ohlsson on Facebook
    • dan4ever on GitHub
    • Guldforum.se
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #18 on: April 06, 2021, 03:10:47 AM »
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
/Dan Olsson, Admin at https://www.guldforum.se

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,949
  • We were all equal in the end.
Re: Upgrading 2.0.18 -> 2.1 stuck...
« Reply #19 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?
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns