changelog | [dreamwidth/dw-free] 2a4f05: Support Ubuntu 20.04 and MySQL 8

Branch: refs/heads/update-dbs Home: https://github.com/dreamwidth/dw-free Commit: 2a4f05c3b69e09351eb4c9674b7beae6f199e056 https://github.com/dreamwidth/dw-free/commit/2a4f05c3b69e09351eb4c9674b7beae6f199e056 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-29 (Fri, 29 Jan 2021)

Changed paths: A bin/dump-data.pl A bin/dump-tablecreates.pl R bin/dumpsql.pl M bin/upgrading/base-data.sql M bin/upgrading/moods.dat A bin/upgrading/proplists-local.dat M bin/upgrading/proplists.dat M bin/upgrading/update-db-general.pl M cgi-bin/DW/Auth/Challenge.pm M cgi-bin/DW/VirtualGiftTransaction.pm M cgi-bin/LJ/Global/Defaults.pm M cgi-bin/LJ/User/Account.pm M cgi-bin/LJ/User/Administration.pm A doc/dependencies-system-20.04 M t/console-moodthemes.t M t/post.t M t/userpic-keyword-select.t

Log Message:

Support Ubuntu 20.04 and MySQL 8

This modernizes a few things to support more recent versions of MySQL and Ubuntu. DO NOT RUN IN PRODUCTION YET.

Commit: 6cdf7c7d9e135f2bc7e7895a26ec9ae27d2b84f8 https://github.com/dreamwidth/dw-free/commit/6cdf7c7d9e135f2bc7e7895a26ec9ae27d2b84f8 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-29 (Fri, 29 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl M cgi-bin/LJ/DB.pm

Log Message:

The has_subs table is unused

Commit: b3df38bedbb17a75db7e7164ae99b7d50a39ec22 https://github.com/dreamwidth/dw-free/commit/b3df38bedbb17a75db7e7164ae99b7d50a39ec22 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-29 (Fri, 29 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl

Log Message:

Use latin1 encoding, even with binary collation columns

Commit: 65f05d2f236a1652277a4c469202b7f8191bfd11 https://github.com/dreamwidth/dw-free/commit/65f05d2f236a1652277a4c469202b7f8191bfd11 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-29 (Fri, 29 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl M cgi-bin/LJ/DB.pm

Log Message:

Remove unused tables subsprop, subsproplist

Commit: db79b8c502016f4cd6f883e1088233407f28a3d1 https://github.com/dreamwidth/dw-free/commit/db79b8c502016f4cd6f883e1088233407f28a3d1 Author: Mark Smith mark@dreamwidth.org Date: 2021-01-29 (Fri, 29 Jan 2021)

Changed paths: M cgi-bin/LJ/Subscription.pm

Log Message:

Fix absolutely ANCIENT bug

Using $u->prepare and $sth->execute doesn't set the _dberr on the user, so calling $u->err would never work. Needs to use $u->do.

Commit: 3864f240e23f1da901e3c8b663f52d4009599bae https://github.com/dreamwidth/dw-free/commit/3864f240e23f1da901e3c8b663f52d4009599bae Author: Mark Smith mark@dreamwidth.org Date: 2021-01-29 (Fri, 29 Jan 2021)

Changed paths: M bin/upgrading/update-db-general.pl

Log Message:

Fix ESN queries

Compare: https://github.com/dreamwidth/dw-free/compare/68f43fdca33c...3864f240e23f