2.0.15 (fei)

date: 2011/05/25

Fehler

//editPublication?ckey=f19ab80fd456ef480655a0b8519224de with referer http://www.bibsonomy.org/editPublication?intraHashToUpdate=d6060dd860a17fa5e1a0fddfb0c8d44f
org.bibsonomy.common.exceptions.ValidationException: Could not find a post with hash 'd6060dd860a17fa5e1a0fddfb0c8d44f'.
        at org.bibsonomy.database.DBLogic.createDocument(DBLogic.java:1410)

http://www.bibsonomy.org/bibtex/2d6060dd860a17fa5e1a0fddfb0c8d44f/quantentunnel liefert die richtigen redirections
http://www.bibsonomy.org/bibtex/2d6060dd860a17fa5e1a0fddfb0c8d44f liefert 404
http://www.bibsonomy.org/export/bibtex/28e2504687185db5c93aaa6bb2ec8299f/userservice.neps
- alle Export-Formate ausser BibTeX liefen UnsupportedOperationException

//bibtex?null with referer http://www.bibsonomy.org/export/bibtex/28e2504687185db5c93aaa6bb2ec8299f/userservice.neps
java.lang.UnsupportedOperationException
        at java.util.AbstractList.set(AbstractList.java:115)
        at java.util.AbstractList$ListItr.set(AbstractList.java:412)
        at java.util.Collections.sort(Collections.java:163)
        at org.bibsonomy.model.util.BibTexUtils.sortBibTexList(BibTexUtils.java:677)
        at org.bibsonomy.webapp.controller.ResourceListController.postProcessAndSortList(ResourceListController.java:227)
        at org.bibsonomy.webapp.controller.SingleResourceListController.postProcessAndSortList(SingleResourceListController.java:36)
        at org.bibsonomy.webapp.controller.BibtexPageController.workOn(BibtexPageController.java:143)
        at org.bibsonomy.webapp.controller.BibtexPageController.workOn(BibtexPageController.java:30)
        at org.bibsonomy.webapp.util.spring.controller.MinimalisticControllerSpringWrapper.handleRequestinternalal(MinimalisticControllerSpringWrapper.java:191)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
...

released

Review-Funktionalität (sdo,dzo)? (Backend, die BibTeX Tabelle bleibt unberührt, Daniel gibt an, an welchen Stellen die Webapp übernommern werden kann ohne die Reviews sichtbar zu machen.)
compressed and merged JavaScript files (using YUI compressor Maven plugin) (done, rja)
TimeZone handling (rja)
first version of synchronisation (wla)
- nur das DB-Backend
user search via AJAX (bse)
- migrated getUsersBySearch (löschen)
Daniels' Aufräum-Aktion im database-/rest-client (dzo)
den Titel im <title> -Tag TeX-bereinigen (done, fei)
Jahr/Monat/Tag korrekt angezeigt in Publikationslisten - siehe bibsonomy-discuss Posts (rja)
cron-triggered lucene index generation (fei)
(VERSCHOBEN) SWORD freischalten? (sst)
- was ist Stand des Tests
- noch laufen die Tests nicht
minor SWORD changes (sst)
erweiterte WURFL-Brower-Kennung (dzo) - ist schon released (dbe)
NEW: sortPage=year|month|day (vorher ging nur year) (dbe)
erweiterte Sortiermöglichkeiten (dbe)
- sortPage=month|day|note
- Sortierung bleibt jetzt auch bei Jabref-Layouts erhalten

Necessary Changes

Benutzer "dblp" die Rolle "SYNC" zuweisen

Database

Repository fuer OpenAccess

CREATE TABLE `repository` (
  `inter_hash` char(32) NOT NULL default '',
  `intra_hash` char(32) NOT NULL default '',
  `repository_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `user_name` varchar(30) NOT NULL,
  `repository_name` varchar(30) NOT NULL,
  );

Reviews

--
-- Table structure for table `reviews`
--

DROP TABLE IF EXISTS `reviews`;
SET @saved_cs_client     = @@character_set_client;
CREATE TABLE `reviews` (
  `interHash` varchar(32) NOT NULL DEFAULT '',
  `text` varchar(255) DEFAULT NULL,
  `user_name` varchar(30) NOT NULL DEFAULT '',
  `date` timestamp NULL DEFAULT NULL,
  `rating` double DEFAULT NULL,
  `helpful_count` int(11) DEFAULT '0',
  `not_helpful_count` int(11) DEFAULT '0',
  `change_date` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`interHash`,`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `reviews_helpful`
--

DROP TABLE IF EXISTS `reviews_helpful`;
SET @saved_cs_client     = @@character_set_client;
CREATE TABLE `reviews_helpful` (
  `interHash` varchar(32) DEFAULT NULL,
  `user_name` varchar(16) DEFAULT NULL,
  `mark_user_name` varchar(16) DEFAULT NULL,
  `helpful` tinyint(1) DEFAULT '0',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `log_reviews_helpful`
--

DROP TABLE IF EXISTS `log_reviews_helpful`;
SET @saved_cs_client     = @@character_set_client;
CREATE TABLE `log_reviews_helpful` (
  `interHash` varchar(32) DEFAULT NULL,
  `user_name` varchar(16) DEFAULT NULL,
  `mark_user_name` varchar(16) DEFAULT NULL,
  `helpful` tinyint(1) DEFAULT '0',
  `date` timestamp NULL DEFAULT NULL,
  `log_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;


--
-- Table structure for table `log_reviews`
--

DROP TABLE IF EXISTS `log_reviews`;
SET @saved_cs_client     = @@character_set_client;
CREATE TABLE `log_reviews` (
  `interHash` varchar(32) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `user_name` varchar(30) DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `change_date` timestamp NULL DEFAULT NULL,
  `rating` double DEFAULT NULL,
  `helpful_count` int(11) DEFAULT NULL,
  `not_helpful_count` int(11) DEFAULT NULL,
  `log_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `review_ratings_cache`
--

DROP TABLE IF EXISTS `review_ratings_cache`;
SET @saved_cs_client     = @@character_set_client;
CREATE TABLE `review_ratings_cache` (
  `interHash` varchar(32) NOT NULL DEFAULT '',
  `number_of_ratings` int(11) DEFAULT NULL,
  `rating_arithmetic_mean` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`interHash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

OAuth

neue Datenbank (bibsonomy_opensocial)
neuer user fuer bibsonomy_opensocial mit entsprechenden Rechten

GRANT SELECT,INSERT,UPDATE,DELETE ON bibsonomy_opensocial.* TO 'bibsonomy_os'@'localhost' IDENTIFIED BY '<password>'

neue Datenbankverbindung ueber context.xml konfigurieren

    <Resource
       name="jdbc/bibsonomy_opensocial"
       type="javax.sql.DataSource"
       auth="Container"
       driverClassName="com.mysql.jdbc.Driver"
       url="127.0.0.1:6033/bibsonomy_opensocial?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8&amp;zeroDateTimeBehavior=convertToNull"
       username="bibsonomy_os"
       password="<password>"
       maxIdle="50"
       maxActive="260"
       maxWait="10000"
       removeAbandoned="true"
       removeAbandonedTimeout="300"
           logAbandoned="true"
       factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
       />

--
-- Table structure for table `oauth_provider_store`
--

DROP TABLE IF EXISTS `oauth_provider_store`;
CREATE TABLE `oauth_provider_store` (
  `gadget_url` text,
  `server` text,
  `consumer_key` varchar(255) DEFAULT NULL,
  `consumer_secret` text,
  `key_type` tinyint(2) DEFAULT NULL,
  `key_name` varchar(255) DEFAULT NULL,
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `title` varchar(255) DEFAULT NULL,
  `summary` text,
  `description` text,
  `thumbnail` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL                                                                                                                                                                                                                                             
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--                                                                                                                                                                                                                                                                             
-- Table structure for table `oauth_provider_tokens`                                                                                                                                                                                                                           
--

DROP TABLE IF EXISTS `oauth_provider_tokens`;                                                                                                                                                                                                                                  
CREATE TABLE `oauth_provider_tokens` (                                                                                                                                                                                                                                         
  `gadget_url` text,                                                                                                                                                                                                                                                           
  `server` text,                                                                                                                                                                                                                                                               
  `viewer` varchar(50) DEFAULT NULL,                                                                                                                                                                                                                                           
  `access_token` text NOT NULL,                                                                                                                                                                                                                                                
  `token_secret` text,                                                                                                                                                                                                                                                         
  `consumer_key` text,                                                                                                                                                                                                                                                         
  `container` varchar(50) DEFAULT NULL,                                                                                                                                                                                                                                        
  `oauth_version` varchar(10) DEFAULT NULL,                                                                                                                                                                                                                                    
  `callback_token` text,                                                                                                                                                                                                                                                       
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,                                                                                                                                                                                    
  `callback_url` varchar(255) DEFAULT NULL,                                                                                                                                                                                                                                    
  `is_authorized` tinyint(1) NOT NULL DEFAULT '0',                                                                                                                                                                                                                             
  `token_type` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`access_token`(70))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `oauth_store`
--

DROP TABLE IF EXISTS `oauth_store`;
CREATE TABLE `oauth_store` (
  `gadget_url` text,
  `server` text,
  `consumer_key` varchar(255) DEFAULT NULL,
  `consumer_secret` text,
  `key_type` tinyint(2) DEFAULT NULL,
  `key_name` varchar(255) DEFAULT NULL,
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `oauth_tokens`
--

DROP TABLE IF EXISTS `oauth_tokens`;
CREATE TABLE `oauth_tokens` (
  `gadget_url` text NOT NULL,
  `server` text NOT NULL,
  `viewer` varchar(50) NOT NULL DEFAULT '',
  `access_token` text,
  `token_secret` text,
  `session_handle` text,
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `expiration_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`gadget_url`(50),`server`(50),`viewer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Wiki

BibSonomy / documentation / releases / 2011 / 2.0.15

2.0.15 (fei)

Fehler

released

Necessary Changes

Database

Repository fuer OpenAccess

Reviews

OAuth