Advertisement:

Author Topic: 2.1 upgrde fail  (Read 661 times)

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
2.1 upgrde fail
« on: February 07, 2019, 12:52:57 PM »
Incorrectdate value: '1948-00-00' for column 'birthdate' at row 68

Offline d3vcho();

  • Sempiterno
  • Lead Localizer
  • SMF Hero
  • *
  • Posts: 3,971
  • Gender: Male
    • frandominguez03 on GitHub
Re: 2.1 upgrde fail
« Reply #1 on: February 07, 2019, 01:12:03 PM »
Is that the full error message?

"Greeting Death as an old friend, they departed this life as equals."

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #2 on: February 07, 2019, 01:14:51 PM »
yes

Offline d3vcho();

  • Sempiterno
  • Lead Localizer
  • SMF Hero
  • *
  • Posts: 3,971
  • Gender: Male
    • frandominguez03 on GitHub
Re: 2.1 upgrde fail
« Reply #3 on: February 07, 2019, 01:16:04 PM »
Can you give us more details? Anything that can help... Mods installed, PHP Version, from which version were you upgrading, steps you followed...

"Greeting Death as an old friend, they departed this life as equals."

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #4 on: February 07, 2019, 01:22:11 PM »
ok two files failed to upload

I can't seem to be able to create the custom_avatar folder and upload the two files in that folder.

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #5 on: February 07, 2019, 01:28:31 PM »
ok, I went back to a large upgrade 2.0.15 and got the board back up and running,,... uploaded 2.1 again... minus the custom_avatar folder and files and ran upgrade again..  this time it ran part of the script but failed again with the same message.

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #6 on: February 07, 2019, 01:34:26 PM »
15 - 20 were still installed all others were uninstaled

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: 2.1 upgrde fail
« Reply #7 on: February 07, 2019, 01:52:25 PM »
The date can't be processed properly because MySQL changed the rules on what dates were allowed.

You'd need to go into the database, find that member and reset their birthdate to 1004-01-01.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #8 on: February 07, 2019, 04:19:49 PM »
The date can't be processed properly because MySQL changed the rules on what dates were allowed.

You'd need to go into the database, find that member and reset their birthdate to 1004-01-01.

deleted offending member

but now script is hanging on

Please wait while your database is converted to UTF-8. For large forums this may take some time!
Completed 45 out of 177 tables.

Current Table: "fc_config_instances"




Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: 2.1 upgrde fail
« Reply #9 on: February 07, 2019, 04:35:42 PM »
I didn't say to delete them, I said to fix them - now you have more problems.

I don't know what fc_config_instances is, though, it's not a table I recognise from SMF.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #10 on: February 07, 2019, 04:44:21 PM »
ok all of the fc tables were left over from Flash Chat! Remember Flash Chat?

deleted all of those useless tables and the install finished up and the forum is up and running....

still work to be done but I'm breathing again!

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #11 on: February 07, 2019, 04:45:53 PM »
I didn't say to delete them, I said to fix them - now you have more problems.

I don't know what fc_config_instances is, though, it's not a table I recognise from SMF.

just one old member with no post and not active in decades...

Offline woolly bugger

  • Jr. Member
  • **
  • Posts: 172
    • Blue Ridge Fly Fisherman's Forum
Re: 2.1 upgrde fail
« Reply #12 on: February 07, 2019, 04:55:57 PM »
for some reason FileZilla would not create the custom_avatar directory, I had add a directory customavatar and then rename it to add the underscore and then upload the files...

Thanks to all that worked on 2.1 !

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,739
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: 2.1 upgrde fail
« Reply #13 on: February 08, 2019, 12:31:32 AM »
The date can't be processed properly because MySQL changed the rules on what dates were allowed.

You'd need to go into the database, find that member and reset their birthdate to 1004-01-01.
Stupid question, is this something we could fix in the upgrader itself?
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"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

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 591
Re: 2.1 upgrde fail
« Reply #14 on: February 08, 2019, 01:31:27 AM »
The upgrade already do stuff around this topic: https://github.com/SimpleMachines/SMF2.1/blob/cebf1c4a3b982225f6fe571a67b688ada4982aab/other/upgrade_2-1_mysql.sql#L8

To find cases like this is hard.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: 2.1 upgrde fail
« Reply #15 on: February 08, 2019, 03:07:28 AM »
I think the only way you could fix this would be to go through every row by hand and validate it in PHP, updating where necessary.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,739
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: 2.1 upgrde fail
« Reply #16 on: February 08, 2019, 06:09:38 AM »
That's too bad, but alright. Good to know.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"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