update from d8 to d9

[naienko]

I'm slow, I know.
Anyway, the update won't go. It says
Can't use an undefined value as a HASH reference at /dw/cgi-bin/DW/User/DVersion/Migrate8To9.pm line 40.
Compilation failed in require at /dw/bin/upgrading/d8d9-userpicrename.pl line 27.
BEGIN failed--compilation aborted at /dw/bin/upgrading/d8d9-userpicrename.pl line 27.

Plus, the update page no longer allows users to select a userpic for their entry, which I'm thinking is somehow related. nevermind, somehow that fixed itself. I don't know.

Comments

[naienko]

Okay. I seem to have made some kind of difference in the error. I tracked the error down to the specific lines, and on the tables in question I removed the auto_increment from the structure, saved, then reapplied it. Then I ran $LJHOME/bin/upgrading/update-db.pl -r -p --innodb again, and it worked properly. I don't know if this is going to be a permanent fix or not.

[fu]

You'll probably need to check that there's no tpropid with the value of 518 in talkprops (not just talkproplist).

On dev environments, we can work around it by restarting the db in between each update db, so that the auto increment resets. This may/may not be workable for you.