Wiki

Clone wiki

BibSonomy / documentation / releases / 2011 / 2.0.15

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)

<!-- -->

//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;

Updated