Simple Machines Community Forum

SMF Support => SMF 2.1.x Support => Topic started by: woolly bugger on February 07, 2019, 12:52:57 PM

Title: 2.1 upgrde fail
Post by: woolly bugger on February 07, 2019, 12:52:57 PM
Incorrectdate value: '1948-00-00' for column 'birthdate' at row 68
Title: Re: 2.1 upgrde fail
Post by: d3vcho(); on February 07, 2019, 01:12:03 PM
Is that the full error message?
Title: Re: 2.1 upgrde fail
Post by: woolly bugger on February 07, 2019, 01:14:51 PM
yes
Title: Re: 2.1 upgrde fail
Post by: d3vcho(); 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...
Title: Re: 2.1 upgrde fail
Post by: woolly bugger 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.
Title: Re: 2.1 upgrde fail
Post by: woolly bugger 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.
Title: Re: 2.1 upgrde fail
Post by: woolly bugger on February 07, 2019, 01:34:26 PM
15 - 20 were still installed all others were uninstaled
Title: Re: 2.1 upgrde fail
Post by: Arantor 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.
Title: Re: 2.1 upgrde fail
Post by: woolly bugger 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"



Title: Re: 2.1 upgrde fail
Post by: Arantor 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.
Title: Re: 2.1 upgrde fail
Post by: woolly bugger 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!
Title: Re: 2.1 upgrde fail
Post by: woolly bugger 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...
Title: Re: 2.1 upgrde fail
Post by: woolly bugger 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 !
Title: Re: 2.1 upgrde fail
Post by: Aleksi "Lex" Kilpinen 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?
Title: Re: 2.1 upgrde fail
Post by: albertlast 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.
Title: Re: 2.1 upgrde fail
Post by: Arantor 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.
Title: Re: 2.1 upgrde fail
Post by: Aleksi "Lex" Kilpinen on February 08, 2019, 06:09:38 AM
That's too bad, but alright. Good to know.