wiki:ReleasesNotes

Version 12 (modified by pierre-alain, 2 years ago) (diff)

--

Releases notes

  • 2015-05-20 0.3a1
    • Closed ticket #29 : Add a plugin system
    • Closed ticket #34 : Prevent multiple feed name
    • Default interface is now responsive, thanks to Bootstrap
    • Added a theme manager
    • Added Memcache support
    • Added UTF8mb4 support
    • Removed addthis share social service, replaced by a plugin based on Share42.com
    • Fixed drag'n'drop of feeds not working correctly
    • Added server-side check to avoid marking news as read when interface (=> user) is not up-to-date
    • Added stats of dead streams
    • When double-clicking (or middle click) on news, it will mark it as read
    • Removed OpenID obsolete feature
    • Added functionality to display CLI logs (admin only)
    • Upgrade from 0.2.x :
      • Keep a backup copy before doing anything (files and database)
      • Replace all files from your previous installation with the content of the archive
      • Copy your previous configuration file and add those 2 lines after line 41 :
        define('OWR_THEMES_PATH', HOME_PATH . 'Includes' . DIRECTORY_SEPARATOR . 'Themes' . DIRECTORY_SEPARATOR);
        define('OWR_PLUGINS_PATH', HOME_PATH . 'Includes' . DIRECTORY_SEPARATOR . 'Plugins' . DIRECTORY_SEPARATOR);
        
      • Update MySQL database :
        • Execute queries from file install/owr_migrate_utf8mb4.sql :
          ALTER DATABASE openwebreader CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
          ALTER TABLE news CHANGE title title VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE news CHANGE link link VARCHAR(350) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE news CHANGE hash hash VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE news CHANGE author author TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE news_contents CHANGE contents contents longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE news_tags CHANGE name name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE objects CHANGE type type VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE sessions CHANGE id id VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE sessions CHANGE ip ip VARCHAR(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL;
          ALTER TABLE sessions CHANGE data data TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams CHANGE url url VARCHAR(350) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams CHANGE favicon favicon VARCHAR(350) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams CHANGE hash hash VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams_contents CHANGE src src longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams_contents CHANGE contents contents longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams_groups CHANGE name name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE streams_relations_name CHANGE name name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users CHANGE login login VARCHAR(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users CHANGE passwd passwd VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users CHANGE lang lang VARCHAR(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fr_FR';
          ALTER TABLE users CHANGE email email VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users CHANGE timezone timezone VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Europe/Paris';
          ALTER TABLE users CHANGE config config longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users_tokens CHANGE token token VARCHAR(96) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users_tokens CHANGE action action VARCHAR(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE users_tokens CHANGE token_key token_key VARCHAR(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
          ALTER TABLE news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE news_contents CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE news_relations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE news_relations_tags CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE news_tags CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE objects CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE sessions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE streams CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE streams_contents CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE streams_groups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE streams_relations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE streams_relations_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          ALTER TABLE users_tokens CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
          
        • Execute those queries :
          ALTER TABLE news CHANGE `lastupd` `lastupd` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
          
          ALTER TABLE users DROP `openid`;
          
      • Remove folder /install/
      • Make the directories /OWR/cache and /OWR/logs writeable by web server and delete files from cache folder if any
  • 2013-04-13 0.2.2
    • IMPORTANT : SECURITY FIX : prevents system over load and zombies processes
    • Closed ticket #32 : Clearing a stream or category deletes it
    • Closed ticket #33 : Add a link displaying all news regardless their category or stream
    • SQL optimizations
    • Adding the possibility to display cli logs (admin only)
    • Fix minor bugs in core and interface
  • 2010-04-23 0.2.1
    • Closed ticket #30 : full text list items
    • Adding quick statistics
    • Adding the ability to move to prev/next page and to mark news as read simultaneously
    • CSS enhancing
  • 2010-02-14 0.2
    • Closed ticket #3 : Add item tagging (and/or scoring)
    • Closed ticket #5 : Add specific config details by user
    • Closed ticket #15 : Translate displayed error(s)
    • Closed ticket #25 : Add a button/link to close the new or go back to top
    • Closed ticket #26 : Feed address change
    • Closed ticket #28 : Improve favicon detection
    • Upgrade from 0.1 : you will have to do those things in this order to get OpenWebReader to work :
      • Keep a backup copy before doing anything (files and database)
      • Replace all files from your previous installation with the content of the archive
      • Copy your previous configuration file
      • Remove folder /install/
      • Make the directories /OWR/cache and /OWR/logs writeable by web server and delete files from cache folder if any
      • Update MySQL database
      • Full example :
        # go to your OpenWebReader installation
        cd /path/to/OpenWebReader/
        # backup database
        mysqldump dbname_openwebreader > owr.sql.backup
        # backup files
        tar czvf owr_backup.tar.gz *
        cd /path/to/
        mv OpenWebReader/owr_backup.tar.gz .
        cp OpenWebReader/OWR/cfg.php .
        cd OpenWebReader
        # delete every files, get the sources and uncompress
        rm -rf *
        wget "http://openwebreader.org/get?v=0.2&t=tar.gz"
        tar xzvf "get?v=0.2&t=tar.gz"
        # delete directory /install/, not required but adviced
        rm -rf ./install/
        # copy your previous configuration file
        cp ../cfg.php OWR/
        # make the cache and logs directories writeable by the web server
        chown www-data OWR/cache/ && chown www-data OWR/logs && chown www-data OWR/logs/cli.log
        # delete cache files if any
        rm -rf OWR/cache/*
        
      • In MySQL :
        ALTER TABLE users ADD `config` longtext NOT NULL;
        
        UPDATE users SET config='a:2:{s:6:"nbnews";i:10;s:8:"blockimg";b:1;}'; 
        
        DELETE FROM sessions;
        
        CREATE TABLE `news_tags` (
            `id` int(11) NOT NULL,
            `uid` int(11) NOT NULL,
            `name` varchar(255) NOT NULL,
            UNIQUE KEY `uniq_key` (`uid`,`name`),
            KEY `uid` (`uid`),
            KEY `id` (`id`),
            CONSTRAINT `news_tags_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE,
            CONSTRAINT `news_tags_ibfk_2` FOREIGN KEY (`id`) REFERENCES `objects` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
        
        CREATE TABLE `news_relations_tags` (
            `newsid` int(11) NOT NULL,
            `uid` int(11) NOT NULL,
            `tid` int(11) NOT NULL,
            UNIQUE KEY `uniq_key` (`newsid`,`tid`),
            KEY `uid` (`uid`),
            KEY `tid` (`tid`),
            CONSTRAINT `news_relations_tags_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE,
            CONSTRAINT `news_relations_tags_ibfk_2` FOREIGN KEY (`newsid`) REFERENCES `news` (`id`) ON DELETE CASCADE,
            CONSTRAINT `news_relations_tags_ibfk_3` FOREIGN KEY (`tid`) REFERENCES `news_tags` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
        
  • 2010-01-14 0.1
    • This is the first stable release !
    • Fixed bug #27 : Addthis adding a div at the top of the page
  • 2009-12-16 0.1b1
    • Closed ticket #20 : Improve OPML parsing to allow category not defined as type="folder"
    • Closed ticket #4 : Add search by category or stream
    • Closed ticket #18 : Add button to hide/show the board
    • Closed ticket #19 : Improve overflow on the left side
    • Closed ticket #24 : Article status toggle
    • Fixed bug #17 : Add user relations in all Logic::view()
    • The interface is now valid XHTML
  • 2009-11-22 v0.1a2
    • Fixed bug #1 : Complete REST integration
    • Fixed bug #2 : Fix security in OWR\REST\Request
    • Fixed bug #7 : Bugged installation file
    • Fixed bug #8 : Uri not well generated when uri style is set to 'index'
    • Fixed bug #9 : Importing an OPML file into a specific category is not respected if OPML contains folder(s)
    • Fixed bug #10 : User creation fails when no OpenID is given and when another user with no OpenID exists
    • Fixed bug #11 : Javascript not stopping action of category adding form
    • Fixed bug #12 : First user registered is not auth automaticly after editing his account
    • Fixed bug #13 : Number of threads is not limited
    • Fixed bug #14 : PHP segfault on importing OPML
  • 2009-11-16 v0.1a1
    • Initial release.