Wiki
Clone wikiBibSonomy / 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)
- 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&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8&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