Insipid 2.8.2

Dragon Chapel

Kommentieren Sep 14 2023 .txt, .json, .md

I’m happy to announce the release of 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), Checksum sha1

More information about Insipid can be found here.