Heiko August
8842bb8bae
Change: clarify the instructions to remove files
...
This affects upgrades from the stable versions of the 2.5-branch because some or all files might be removed previously.
2024-08-04 11:58:44 +00:00
Heiko August
59b05f74fe
Change: add a block to recreate the banlist table with column "name" as PK
2024-07-29 20:18:07 +00:00
Heiko August
ff3348076d
Change: add the interim testing version 20240308.1 to the list of updateable versions
2024-07-28 20:22:29 +00:00
Heiko August
5e86e642c1
Change: set dates and timestamps with zero values to NULL in the entries table
...
Affected are the values '0000-00-00' and '0000-00-00 00:00:00'.
2024-07-28 20:22:29 +00:00
Heiko August
f6f19934cd
Change: set dates and timestamps with zero values to NULL in the userdata table
...
Affected are the values '0000-00-00' and '0000-00-00 00:00:00'.
2024-07-28 20:22:29 +00:00
Heiko August
a98630e9c6
Fix: define a few date(time) columns as NULL-able in the entries table
...
This affects only very old installations, made with a version older than version 2.3.5.
2024-07-28 20:22:29 +00:00
Heiko August
e2e1fba7ae
Fix: define a few date(time) columns as NULL-able in the userdata table
...
This affects only very old installations, made with a version older than version 2.3.5.
2024-07-28 20:22:29 +00:00
Heiko August
b26f8a3ddc
Fix: move the entry to remove the flash processing code from $update[items] to $update[delete]
2024-07-21 13:55:30 +00:00
Heiko August
4fb4a24711
Change: add the files to upgrade to the blocks of upgrades from earlier versions
2024-07-21 13:55:30 +00:00
Heiko August
80c1554dc3
Change: add the block of database changes for an upgrade from 20240308.1
2024-07-21 13:55:30 +00:00
Heiko August
9cdeed3bb2
Fix: remove LIKE from the query, was a remnant of a former change
2024-07-21 13:55:30 +00:00
Heiko August
89faaa54c2
Fix: redefine column user_name after converting the table to utf8mb4
...
Defining of column user_email is not necessary because the definition matches with the conversion of the table.
2024-05-29 19:50:47 +00:00
Heiko August
7910a45d52
Fix: state explicit, that the content of the column user_email has to be not NULL
2024-05-29 19:50:47 +00:00
Heiko August
4eba711ad1
Fix: esure, that only the indexes user_type and user_name get deleted
2024-05-29 19:50:47 +00:00
Heiko August
7293af046a
Fix: in an upgrade from version 2.4.99.1 the index key_user_name was added for the non existing column key_user_name
2024-05-29 19:50:47 +00:00
Heiko August
aee5e2a9dd
Fix: add missing index key_user_type and delete outdated index user_type, when present
2024-05-29 19:50:47 +00:00
Heiko August
4dd9a4b4dd
Fix: corrected table name, was a further copy'n'paste error
...
This caused no error because the named column (spam) in the wrong table (mlf2_userdata) does not exist. So the query did simply nothing. The only effect was that the index was still missing after execution.
2024-05-29 19:50:47 +00:00
Heiko August
6723fca78a
Fix: remove superfluous comma, it's a copy'n'paste syntax error
2024-05-29 19:50:47 +00:00
Heiko August
6c7cacccf6
Change: retire the function compare_versions and use PHPs native version_compare instead
2024-03-21 22:16:18 +01:00
Heiko August
be29fc66b2
Fix: added queries for adding indexes to table mlf2_akismet_rating
...
Adding the indexes might be forgotten in earlier update scripts. Check for existence of the indexes and add them, if necessary.
2024-03-18 20:22:23 +01:00
Heiko August
44fef3f35d
Fix: correct wrong order of queries
...
Put query for userdata table after comment line for entries table and vice versa
2024-03-18 20:22:23 +01:00
Heiko August
85b38d2d60
Change: taking over the files to upload and remove for the changes after the release of version 20220803.1 to previous starting points
2024-03-18 20:22:23 +01:00
Heiko August
bf9e22d836
Fix: broken and forgotten queries to set a new default source for loading MathJax
...
This adapts some of the changes in #674 , authored by @fcaspar
2024-03-18 20:22:23 +01:00
Heiko August
b979e18971
Change: taking over the changes fro removing bad behavior to the other upgrade blocks
2024-03-18 20:22:23 +01:00
Heiko August
d584a71b14
Change: add the block for changes in an upgrade, starting from version 20220803.1
2024-03-18 20:22:23 +01:00
Heiko August
6eca946cba
Fix: enlarge the column mlf2_useronline.ip from 15 to 128 Bytes
...
The column was not able to store IPv6 addresses before. That lead to HTTP-status 500 messages or to blank pages.
2024-03-18 20:22:23 +01:00
Heiko August
e1ca5d40dd
Fix: restrict the column mlf2_logincontrol.ip to 128 bytes
...
This is enough to store IPv6 addresses and is the same lenght as the corresponding columns in the other tables
2024-03-18 20:22:23 +01:00
Heiko August
d5f8a2ae8e
Change: delete the old upgrade script update_2.4.19.1-2.5.php
2024-03-18 20:22:23 +01:00
Heiko August
a82d340a16
Change: rename update_2.4.19.1-2.5.dev.php to update_2.4.19-2.5.php
2024-03-18 20:22:23 +01:00
Heiko August
3767524018
Change: put files to delete into an own array and merge it to the end of the list of files to be updated
2024-03-18 20:22:23 +01:00
Heiko August
80d6b449d6
Fix: set the collation and charset also for the tables, introduced with v2.5
2024-03-18 20:22:23 +01:00
Heiko August
fb2659e70e
Fix: alter the collation of the uploads table to utf8mb4_bin in every single upgrade step
2024-03-18 20:22:23 +01:00
Heiko August
785d11f32c
Fix: correct a copy'n'paste error on top of a copy'n'paste error
2024-03-18 20:22:23 +01:00
Heiko August
deba37269d
Change: set the size of mlf2_b8_wordlist.token back to 255 bytes as it was initially when introducing B8
2024-03-18 20:22:23 +01:00
Heiko August
913484bac8
Change: remove the special case of charset utf8(mb3) for the column mlf2_userdata.user_email
2024-03-18 20:22:23 +01:00
Heiko August
24df928fea
Change: set the charset to utf8mb4 and the collation to utf8mb4_bin in the new tables while creating them
...
… and add the keys in mlf2_b8_rating when creating the table and not afterwards.
2024-03-18 20:22:23 +01:00
Heiko August
56a6f5447b
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the user online table
2024-03-18 20:22:23 +01:00
Heiko August
2a227e7f43
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the temporary information table
2024-03-18 20:22:23 +01:00
Heiko August
26fa69a945
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the subscriptions table
2024-03-18 20:22:23 +01:00
Heiko August
aa0b84786c
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the smilies table
2024-03-18 20:22:23 +01:00
Heiko August
a8ca416948
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the read entries table
2024-03-18 20:22:23 +01:00
Heiko August
9470172f6a
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the logincontrol table
2024-03-18 20:22:23 +01:00
Heiko August
b2988e44ab
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the entry tags table
2024-03-18 20:22:23 +01:00
Heiko August
f29e90ff7b
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the bookmark tags table
2024-03-18 20:22:23 +01:00
Heiko August
07ade7a701
Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the settings table
2024-03-18 20:22:23 +01:00
Heiko August
19bb31f3ff
Fix: remove regex flag g and use the correct variable name
...
Replace wrong $dbVersion with correct $serverVersion.
2024-03-18 20:22:23 +01:00
Heiko August
fce456c283
Change: replace the variables $databaseVersion with versionInfo
2024-03-18 20:22:23 +01:00
Heiko August
c4c8f8b93f
Change: do not unnecessarily copy the variable into another one
2024-03-18 20:22:23 +01:00
Heiko August
d648efbd1c
Fix: the result contains every variable in a separate row, loop through the result
2024-03-18 20:22:23 +01:00
Heiko August
2ba0fafaba
Change: reformatting of the list of files to upgrade (upgrade starting with 20220517.1 or 20220529.1)
2024-03-18 20:22:23 +01:00
