wiki:ReleasesNotes

Version 13 (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 to support utf8mb4 :
        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.