I'm happy to announce the release of [Insipid](/projekt/insipid/) 2.8.2 - Dragon Chapel.

**Upgrade notes**

Important. There are config changes and DB updates.

    ## version 2.8.2 - Dragon Chapel
      + Add query debug setting to config file.
      See config.default.php for QUERY_DEBUG constant. Add it to your local config.php
      + Add log file path constant to config file.
      See config.default.php for LOGFILE constant. Add it to your local config.php
      + Update your tables with the following SQL statements. Replace #REPLACE_ME# with your current table prefix.

    ALTER TABLE `#REPLACE_ME#_link` ADD INDEX (`created`);
    ALTER TABLE `#REPLACE_ME#_link` ADD INDEX (`status`);
    ALTER TABLE `#REPLACE_ME#_categoryrelation` ADD INDEX (`categoryid`);
    ALTER TABLE `#REPLACE_ME#_tagrelation` ADD UNIQUE `tagid` (`linkid`, `tagid`);
    ALTER TABLE `#REPLACE_ME#_tagrelation` ADD INDEX (`linkid`);
    ALTER TABLE `#REPLACE_ME#_category` ADD INDEX (`name`);

    ALTER TABLE `#REPLACE_ME#_category` DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    ALTER TABLE `#REPLACE_ME#_categoryrelation` DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    ALTER TABLE `#REPLACE_ME#_link` DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    ALTER TABLE `#REPLACE_ME#_tag` DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    ALTER TABLE `#REPLACE_ME#_tagrelation` DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    ALTER TABLE `#REPLACE_ME#_tag` CHANGE `name` `name` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_link` CHANGE `link` `link` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_link` CHANGE `description` `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_link` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_link` CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_link` CHANGE `hash` `hash` CHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_link` CHANGE `search` `search` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;
    ALTER TABLE `#REPLACE_ME#_category` CHANGE `name` `name` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL;

     + Folder and its contents lib/MysqlDump can be removed.

**Changelog**

    version 2.8.2 - Dragon Chapel (2023-09-14)

        + Added LOGFILE and QUERY_DEBUG const to config.php. See update.txt for more details
        + Updated DB table charsets. Needs manual DB updates. See update.txt file.
        + Fixed URL handling at creation
        + Improved DB queries.
        + Add top 5 tag or category relation stats in the tag and category overview
        + Updated license to GNU GENERAL PUBLIC LICENSE Version 3, 29 June 2007
        + Updated error logging and try/catch for mysql
        + Updated from https://github.com/druidfi/mysqldump-php to https://github.com/ifsnop/mysqldump-php since develop
          resumed. Version mysqldump-php v2.11
        + Updated https://github.com/mikehaertl/php-shellcommand to 1.7.0

Download it here: [2.8.2 - Dragon Chapel - (2023-09-14)](/assets/insipid/insipid-2.8.2_Dragon-Chapel.xz),
Checksum [sha1](/assets/insipid/insipid-2.8.2_Dragon-Chapel.xz.sha1sum)

More information [about Insipid can be found here.](https://www.bananas-playground.net/projekt/insipid/)

Sep 14 2023 © https://www.bananas-playground.net 2000 - 2025