![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
![[site community profile]](https://www.dreamwidth.org/img/comm_staff.png){kind=small}
[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