Upgrading 2.0.18 -> 2.1 stuck...

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

Previous topic - Next topic

dan4ever

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

Kindred

Use the download from github.

There are over 2000 changes between the rc3 on this site versus the almost rc4 on github
Сл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."

dan4ever

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

dan4ever

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

Kindred

Did you not take a full backup of files and database before starting?
Сл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

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

                                     - R. Waters

dan4ever

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!



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

dan4ever

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

Sir Osis of Liver

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

                                     - R. Waters

dan4ever

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

Sir Osis of Liver

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

                                     - R. Waters

Sir Osis of Liver

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

                                     - R. Waters

dan4ever

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

Illori

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.

live627

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.

Sir Osis of Liver

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.

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

                                     - R. Waters

dan4ever

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

Sir Osis of Liver

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

                                     - R. Waters

dan4ever

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

Sir Osis of Liver

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

                                     - R. Waters

Advertisement: