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
Heiko August
32acfc0b9e
Change: add a try-catch block for a database transaction (upgrade starting with 20220517.1 or 20220529.1)
...
All changes for an upgrade, starting with version 20220517.1 or 20220529.1, are stored in a database transaction. This ensures, that the upgrade will succeed of will fail completely without leaving the forum in an unusable interim state.
2024-03-18 20:22:23 +01:00
Heiko August
e3e8466c05
Change: reformatting of the list of files to upgrade (upgrade starting with 20220508.1)
2024-03-18 20:22:23 +01:00
Heiko August
b29c4d1aab
Change: add a try-catch block for a database transaction (upgrade starting with 20220508.1)
...
All changes for an upgrade, starting with version 20220508.1, are stored in a database transaction. This ensures, that the upgrade will succeed of will fail completely without leaving the forum in an unusable interim state.
2024-03-18 20:22:23 +01:00
Heiko August
16c634aa5d
Change: reorder the list of files again and add further information
...
Upgrade is starting with version 2.4.99.1
2024-03-18 20:22:23 +01:00
Heiko August
862927bc45
Change: reorder the list of files again and add further information (pt. 2)
...
Upgrade is starting with versdion 2.4.99.0
2024-03-18 20:22:23 +01:00
Heiko August
722b7334a3
Change: reorder the list of files again and add further information
...
Upgrade starting with a version between 2.4.19 and 2.4.24
2024-03-18 20:22:23 +01:00
Heiko August
45a8950e4c
Change: reformatting of the list of files to upgrade (upgrade starting with 2.4.99.2 or 2.4.99.3)
2024-03-18 20:22:23 +01:00
Heiko August
d84e0b52a7
Change: add a try-catch block for a database transaction (upgrade starting with 2.4.99.2 or 2.4.99.3)
...
All changes for an upgrade, starting with version 2.4.99.1, are stored in a database transaction. This ensures, that the upgrade will succeed of will fail completely without leaving the forum in an unusable interim state.
2024-03-18 20:22:23 +01:00
Heiko August
05695ce4ba
Change: reformatting of the list of files to upgrade (upgrade starting with 2.4.99.1)
2024-03-18 20:22:23 +01:00
Heiko August
4d08b4d83b
Change: add a try-catch block for a database transaction (upgrade starting with 2.4.99.1)
...
All changes for an upgrade, starting with version 2.4.99.1, are stored in a database transaction. This ensures, that the upgrade will succeed of will fail completely without leaving the forum in an unusable interim state.
2024-03-18 20:22:23 +01:00
Heiko August
fb86713d03
Change: reformatting of the list of files to upgrade (upgrade starting with 2.4.99.0)
2024-03-18 20:22:23 +01:00
Heiko August
fb77d4b52a
Change: add a try-catch block for a database transaction (upgrade starting with 2.4.99.0)
...
All changes for an upgrade, starting with version 2.4.99.0, are stored in a database transaction. This ensures, that the upgrade will succeed of will fail completely without leaving the forum in an unusable interim state.
2024-03-18 20:22:23 +01:00
