Heiko August
2b6abc25d4
Change: add the files to replace to the upgrade script
2025-03-23 18:51:59 +01:00
Heiko August
6541b2bf5b
Change: make mlf2_entries.pid, .tid, .category and .views unsigned in the installation and upgrade script
2025-03-10 21:53:46 +01:00
Heiko August
b98c007113
Change: add the changes to unsigned integer columns to the upgrade block for version 20241215.1
2025-03-10 21:53:46 +01:00
Heiko August
3442d08140
Change: add a foreign key that points to mlf2_userdata.user_id when altering the table mlf2_uploads
2025-03-10 21:53:46 +01:00
Heiko August
5f35c9d8b5
Change: add a foreign key that points to mlf2_userdata.user_id when creating the table mlf2_uploads
...
If a user gets deleted, the matching value in the column "uploader" automatically will be changed to NULL.
2025-03-10 21:53:46 +01:00
Heiko August
a30c0df76c
Change: determine the table name prefix for all upgrade cases at once
2025-03-10 21:53:46 +01:00
Heiko August
4b9692666e
Change: mark MLF version 20241215.1 to be an upgrade target
2025-03-10 21:53:46 +01:00
Heiko August
7dd2b3af0a
Change: add the files to update when upgrading from version 20241215.1
2025-03-10 21:53:46 +01:00
Heiko August
783658994b
Fix: remove the alter statement
...
It only repeats the charset conversion from the CREATE statement in the same upgrade step
2025-03-10 21:53:46 +01:00
Heiko August
1b30324722
Change: adapt the changes in the uploads table to the installation and the other upgrade steps
2025-03-10 21:53:46 +01:00
Heiko August
5c1366668f
Fix: it makes no sense to allow NULL values if the column gets a unique index afterwards
2025-03-10 21:53:46 +01:00
Heiko August
d6ca049f5e
Change: alter the uploads table when updating MLF 20241215.1
...
- delete duplicate file name entries (keep first entry)
- enlarge the column filename and rename it to pathname
- add unique index pathname to column pathname, if it not exists
2025-03-10 21:53:46 +01:00
Heiko August
1b295cf13b
Change: new structure for updating MLF version 20241215.1
2025-03-10 21:53:46 +01:00
Heiko August
ecc1e640e9
Change: resize mlf2_uploads.filename from 64 to 128 bytes, add a unique key to the column
2025-03-10 21:53:46 +01:00
Heiko August
f957b60365
Change: make mlf2_useronline.user_id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
15b89b3ece
Change: make mlf2_tags.id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
e6df1416a4
Change: make mlf2_smilies.id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
5230c55f9c
Change: make mlf2_pages.id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
a62336c381
Change: make mlf2_categories.id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
26d0db86dc
Change: make mlf2_bookmarks.id, .user_id and .posting_id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
a8e22e937c
Change: make mlf2_entries.id, .edited_by and .user_id unsigned in the installation and upgrade scripts
2025-03-10 20:51:38 +01:00
Heiko August
e305782f72
Change: make mlf2_userdata.user_id unsigned in the installation and upgrade scripts
...
Attention: When upgrading from 2.4.x it must be done before creating the new tables.
2025-03-10 20:51:38 +01:00
Heiko August
7e9371323c
Fix: configure the MySQL error reporting
2024-12-22 14:24:54 +01:00
Heiko August
a5704d99b9
Fix: use the exception object to display MySQL error information
2024-12-22 14:24:54 +01:00
Heiko August
47e146061c
Change: add the version 20240827.1 to the list of upgradable versions
2024-12-15 23:01:28 +01:00
Heiko August
8263af3bf2
Change: add date handling with NULL values to the upgrade blocks for 20240729.1 and 20240827.1
...
There was errors in some cases. This steps excludes the last error possibilities
2024-12-15 23:01:28 +01:00
Heiko August
b8640b3615
Change<. adapt the entries for files ti upgrade to the blocks for the previous versions
2024-12-15 23:01:28 +01:00
Heiko August
794a8470a3
Change: add the block for upgrading from version 20240827.1
2024-12-15 23:01:28 +01:00
Michael Lösler
a812ecca3e
Date ( #762 )
...
- WHERE clause `= '0000-00-00 00:00:00'` replaced by `<= STR_TO_DATE('1900-01-01','%Y-%d-%m')`
2024-11-25 21:39:47 +01:00
Heiko August
d9b657df6a
Fix: add arabic and italian language files to the list of files to upload
2024-08-27 15:09:45 +00:00
Heiko August
34c3e5d95c
Fix: provide the new version number for displaying in the template
2024-08-27 15:09:45 +00:00
Heiko August
16bd83a564
Change: add version 20240729.1 to the list of upgradable versions
2024-08-27 15:09:45 +00:00
Heiko August
d0515bc711
Change: add the files to upload to the former upgrade blocks
2024-08-27 15:09:45 +00:00
Heiko August
06cd50b032
Change: add the block for an upgrade from version 20240729.1 to the upgrade file
2024-08-27 15:09:45 +00:00
Heiko August
ee38b24a47
Fix: the self defined function should have the same return values as the original function
2024-08-21 19:15:38 +00:00
Heiko August
8b2eec6897
Fix: collect the table names in $db_settings
...
I was assuming them to exist when writing the affected query even the entries in $db_settings in reality wasn't present. Now the script collects the existing entries only for use in the query.
2024-08-21 19:15:38 +00:00
Heiko August
779d44cb35
Change: introduce function str_ends_with to PHP versions prior to version 8.0
...
This is for the specific use case of check $db_settings elements for table names.
2024-08-21 19:15:38 +00:00
Michael Lösler
eb85d2b66f
SQL stm ( #736 )
...
- Quotes in SQL stms fixed
- Exception message added because the current error message looks like "0, " and is not helpful
2024-08-15 17:27:40 +02:00
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
