Menu
▾
▴
connotea-discuss — Support and discussion for the service at http://www.connotea.org/.
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
(4) |
May
(4) |
Jun
(11) |
Jul
(2) |
Aug
(30) |
Sep
(21) |
Oct
(21) |
Nov
(5) |
Dec
(12) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(21) |
Feb
(52) |
Mar
(17) |
Apr
(45) |
May
(46) |
Jun
(12) |
Jul
(7) |
Aug
(24) |
Sep
(4) |
Oct
(13) |
Nov
(3) |
Dec
(6) |
| 2007 |
Jan
(7) |
Feb
(17) |
Mar
(8) |
Apr
(12) |
May
(9) |
Jun
(8) |
Jul
(17) |
Aug
(8) |
Sep
(3) |
Oct
(3) |
Nov
(15) |
Dec
|
| 2008 |
Jan
(11) |
Feb
(6) |
Mar
(14) |
Apr
(5) |
May
(1) |
Jun
|
Jul
(6) |
Aug
|
Sep
(7) |
Oct
(2) |
Nov
(5) |
Dec
(4) |
| 2009 |
Jan
|
Feb
(8) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: Ian M. <ia...@mu...> - 2009-12-01 00:35:27
|
We need to take the service offline tomorrow, it will probably down for less than two hours. This is necessary for some routine database maintenance. We hope this does not interfere too much. - The Connotea Team |
|
From: Martin F. <ma...@ne...> - 2009-02-10 23:18:13
|
Mustansar Mehmood wrote: > > FULLTEXT KEY `url_ft` (`url`) is missing You need to generate the _search database schema from the regular schema, because it has extra indices. See: http://www.connotea.org/code#mysql > and for Wiki::Tooklkit I created the DB using the setupdb script. I > notice that column name is node_id instead of node... Yes, Wiki::Toolkit is an upgrade from CGI::Wiki. Perhaps try using CGI::Wiki. > I was wondering of there is any latest version a bit more streamlined > version of connotea sitting in some publicly accessible svn/cvs repository. Unfortunately not. You're correct though, the wiki thing might be a problem if CGI::Wiki doesn't solve it. Martin |
|
From: Mustansar M. <mus...@ri...> - 2009-02-10 16:14:20
|
FULLTEXT KEY `url_ft` (`url`) is missing and for Wiki::Tooklkit I created the DB using the setupdb script. I notice that column name is node_id instead of node... I was wondering of there is any latest version a bit more streamlined version of connotea sitting in some publicly accessible svn/cvs repository. Thanks, Mustansar Martin Flack wrote: > > Mustansar Mehmood wrote: >> yes I do have two databases; >> here is the list I have there >> +--------------------+ >> | Database | >> +--------------------+ >> | information_schema | >> | bibliotech | >> | bibliotech_search | >> | clicks | >> | conwiki | >> | mysql | >> | test | >> +--------------------+ > > Can you compare the bibliotech_search.bookmark table to your database. > Note the FULLTEXT KEY and the ENGINE. > > mysql> use bibliotech_search; > Database changed > > mysql> show create table bookmark \G > *************************** 1. row *************************** > Table: bookmark > Create Table: CREATE TABLE `bookmark` ( > `bookmark_id` int(7) unsigned NOT NULL auto_increment, > `url` varchar(255) NOT NULL default '', > `hash` varchar(32) NOT NULL default '', > `article` int(7) unsigned NOT NULL, > `first_user` int(7) unsigned default NULL, > `citation` int(7) unsigned default NULL, > `created` datetime NOT NULL default '0000-00-00 00:00:00', > `updated` datetime NOT NULL default '0000-00-00 00:00:00', > PRIMARY KEY (`bookmark_id`), > UNIQUE KEY `url_idx` (`url`), > KEY `hash_idx` (`hash`), > KEY `citation_idx` (`citation`), > KEY `first_user_idx` (`first_user`), > FULLTEXT KEY `url_ft` (`url`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > 1 row in set (0.00 sec) > >> And there is another error >> >> user mustansar (1) requests /user/mustansar bringing load to 1 with >> db at 1234223876 >> >> http://staff-64-mud48-037.rice.edu//user/mustansar >> >> undef error - DBD::mysql::st execute failed: Unknown column 'node' in >> 'where clause' [for Statement "SELECT metadata_type, metadata_value >> FROM metadata WHERE node='User:mustansar' AND version='0'"] at >> /usr/local/lib/perl5/site_perl/5.10.0/DBIx/ContextualFetch.pm line 52. >> >> btw here is my output for perl wiki >> perl -MWiki::Toolkit -e 'print $Wiki::Toolkit::VERSION, "\n"' >> 0.77 >> seems like schema's out of synch with the code > > Did you create the wiki database with the Wiki::Toolkit 0.77 module? > i.e. by running wiki-toolkit-setupdb that comes with it? > > Martin > > -- Mustansar Mehmood Educational Sys Dev/Integrator Academic & Research Computing Rice University Houston Texas Phone: (713)348 2523 Fax: (713)348 6099 |
|
From: Martin F. <ma...@ne...> - 2009-02-10 04:01:35
|
Mustansar Mehmood wrote:
> yes I do have two databases;
> here is the list I have there
> +--------------------+
> | Database |
> +--------------------+
> | information_schema |
> | bibliotech |
> | bibliotech_search |
> | clicks |
> | conwiki |
> | mysql |
> | test |
> +--------------------+
Can you compare the bibliotech_search.bookmark table to your database.
Note the FULLTEXT KEY and the ENGINE.
mysql> use bibliotech_search;
Database changed
mysql> show create table bookmark \G
*************************** 1. row ***************************
Table: bookmark
Create Table: CREATE TABLE `bookmark` (
`bookmark_id` int(7) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`hash` varchar(32) NOT NULL default '',
`article` int(7) unsigned NOT NULL,
`first_user` int(7) unsigned default NULL,
`citation` int(7) unsigned default NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`bookmark_id`),
UNIQUE KEY `url_idx` (`url`),
KEY `hash_idx` (`hash`),
KEY `citation_idx` (`citation`),
KEY `first_user_idx` (`first_user`),
FULLTEXT KEY `url_ft` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
> And there is another error
>
> user mustansar (1) requests /user/mustansar bringing load to 1 with db
> at 1234223876
>
> http://staff-64-mud48-037.rice.edu//user/mustansar
>
> undef error - DBD::mysql::st execute failed: Unknown column 'node' in
> 'where clause' [for Statement "SELECT metadata_type, metadata_value FROM
> metadata WHERE node='User:mustansar' AND version='0'"] at
> /usr/local/lib/perl5/site_perl/5.10.0/DBIx/ContextualFetch.pm line 52.
>
> btw here is my output for perl wiki
> perl -MWiki::Toolkit -e 'print $Wiki::Toolkit::VERSION, "\n"'
> 0.77
> seems like schema's out of synch with the code
Did you create the wiki database with the Wiki::Toolkit 0.77 module?
i.e. by running wiki-toolkit-setupdb that comes with it?
Martin
|
|
From: Mustansar M. <mus...@ri...> - 2009-02-10 00:58:41
|
yes I do have two databases; here is the list I have there +--------------------+ | Database | +--------------------+ | information_schema | | bibliotech | | bibliotech_search | | clicks | | conwiki | | mysql | | test | +--------------------+ And there is another error user mustansar (1) requests /user/mustansar bringing load to 1 with db at 1234223876 http://staff-64-mud48-037.rice.edu//user/mustansar undef error - DBD::mysql::st execute failed: Unknown column 'node' in 'where clause' [for Statement "SELECT metadata_type, metadata_value FROM metadata WHERE node='User:mustansar' AND version='0'"] at /usr/local/lib/perl5/site_perl/5.10.0/DBIx/ContextualFetch.pm line 52. btw here is my output for perl wiki perl -MWiki::Toolkit -e 'print $Wiki::Toolkit::VERSION, "\n"' 0.77 seems like schema's out of synch with the code Thanks, Mustansar Martin Flack wrote: > Mustansar Mehmood wrote: >> I got arround inital steps but once I tried to search using my on >> installation I got a huge error page >> >> >> >> undef error - DBD::mysql::st execute failed: Can't find FULLTEXT >> index matching the column list [for Statement "SELECT >> ub.user_bookmark_id, > > Have you setup two databases? > http://www.connotea.org/code#mysql > > Martin > > -- Mustansar Mehmood Educational Sys Dev/Integrator Academic & Research Computing Rice University Houston Texas Phone: (713)348 2523 Fax: (713)348 6099 |
|
From: Martin F. <ma...@ne...> - 2009-02-10 00:09:53
|
Mustansar Mehmood wrote: > I got arround inital steps but once I tried to search using my on > installation I got a huge error page > > > > undef error - DBD::mysql::st execute failed: Can't find FULLTEXT index > matching the column list [for Statement "SELECT ub.user_bookmark_id, Have you setup two databases? http://www.connotea.org/code#mysql Martin |
|
From: Mustansar M. <mus...@ri...> - 2009-02-09 23:11:45
|
I got arround inital steps but once I tried to search using my on
installation I got a huge error page
undef error - DBD::mysql::st execute failed: Can't find FULLTEXT index matching the column list [for Statement "SELECT ub.user_bookmark_id, ub.user, ub.bookmark, ub.updated, ub.citation, ub.user_is_author, ub.def_public, ub.private, ub.private_gang, ub.private_until, ub.quarantined, ub.created, u.user_id, u.username, u.openurl_resolver, u.openurl_name, u.updated, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(g.gang_id),':/:',IFNULL(g.name, '+NULL'),':/:',IFNULL(g.owner, '+NULL'),':/:',IFNULL(g.private, '+NULL'),':/:',IFNULL(g.updated, '+NULL') ORDER BY ug.created SEPARATOR '///'), '') AS _u_gangs_packed, b.bookmark_id, b.url, b.hash, b.updated, b.citation, ubd.user_bookmark_id, ubd.title, ubd.description, bd.bookmark_id, bd.title, bd.created, ct.citation_id, ct.title, ct.journal, ct.volume, ct.issue, ct.start_page, ct.end_page, ct.pubmed, ct.doi, ct.asin, ct.ris_type, ct.raw_date, ct.date, ct.last_modified_date, ct.user_supplied, ct.cs_module, ct.cs_type, ct.cs_source, ct.created, j.journal_id, j.name, j.issn, j.coden, j.country, j.medline_code, j.medline_ta, j.nlm_unique_id, cta.citation_author_id, cta.citation, cta.author, cta.displayorder, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(a.author_id),':/:',IFNULL(a.firstname, '+NULL'),':/:',IFNULL(a.forename, '+NULL'),':/:',IFNULL(a.initials, '+NULL'),':/:',IFNULL(a.middlename, '+NULL'),':/:',IFNULL(a.lastname, '+NULL'),':/:',IFNULL(a.suffix, '+NULL'),':/:',IFNULL(a.misc, '+NULL'),':/:',IFNULL(a.postal_address, '+NULL'),':/:',IFNULL(a.affiliation, '+NULL'),':/:',IFNULL(a.email, '+NULL'),':/:',IFNULL(a.user, '+NULL') ORDER BY cta.displayorder SEPARATOR '///'), '') AS _ct_authors_packed, ct2.citation_id, ct2.title, ct2.journal, ct2.volume, ct2.issue, ct2.start_page, ct2.end_page, ct2.pubmed, ct2.doi, ct2.asin, ct2.ris_type, ct2.raw_date, ct2.date, ct2.last_modified_date, ct2.user_supplied, ct2.cs_module, ct2.cs_type, ct2.cs_source, ct2.created, j2.journal_id, j2.name, j2.issn, j2.coden, j2.country, j2.medline_code, j2.medline_ta, j2.nlm_unique_id, cta2.citation_author_id, cta2.citation, cta2.author, cta2.displayorder, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(a2.author_id),':/:',IFNULL(a2.firstname, '+NULL'),':/:',IFNULL(a2.forename, '+NULL'),':/:',IFNULL(a2.initials, '+NULL'),':/:',IFNULL(a2.middlename, '+NULL'),':/:',IFNULL(a2.lastname, '+NULL'),':/:',IFNULL(a2.suffix, '+NULL'),':/:',IFNULL(a2.misc, '+NULL'),':/:',IFNULL(a2.postal_address, '+NULL'),':/:',IFNULL(a2.affiliation, '+NULL'),':/:',IFNULL(a2.email, '+NULL'),':/:',IFNULL(a2.user, '+NULL') ORDER BY cta2.displayorder SEPARATOR '///'), '') AS _ct2_authors_packed, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(t2.tag_id),':/:',IFNULL(t2.name, '+NULL') ORDER BY ubt2.created SEPARATOR '///'), '') AS _ub_tags_packed, COUNT(DISTINCT ub2.user_bookmark_id) as _ub_user_bookmarks_count, COUNT(DISTINCT c2.comment_id) as _ub_comments_count, COUNT(DISTINCT ub3.user_bookmark_id) as _ub_bookmark_is_linked_by_current_user, COUNT(DISTINCT t4.tag_id) as _ub_is_geotagged, MAX(UNIX_TIMESTAMP(ub.created))
FROM
(SELECT MAX(ub.user_bookmark_id) as max_user_bookmark_id, fm.sortvalue as sortvalue
FROM user_bookmark ub
LEFT JOIN bookmark b ON (ub.bookmark=b.bookmark_id)
INNER JOIN (SELECT fmat.user_bookmark_id, MAX(score)*1000000000+UNIX_TIMESTAMP(ub.created) as sortvalue
FROM
(
SELECT user_bookmark_id, MAX(score) as score, 1 as positive FROM (SELECT ubd_s.user_bookmark_id, 100 as score
FROM user_bookmark_details ubd_s
WHERE ubd_s.title = ?
UNION
SELECT ub.user_bookmark_id, 100 as score
FROM bookmark_details bd_s
LEFT JOIN bookmark b_s ON (bd_s.bookmark_id=b_s.bookmark_id)
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE bd_s.title = ? AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 99 as score
FROM citation c_s
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE c_s.title = ? AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 99 as score
FROM citation c_s
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE c_s.title = ? AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE j_s.name = ? AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE j_s.name = ? AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE j_s.medline_ta = ? AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE j_s.medline_ta = ? AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 97 as score
FROM author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE a_s.lastname = ? AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 97 as score
FROM author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE a_s.lastname = ? AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ubd_s.user_bookmark_id, 50 as score
FROM bibliotech_search.user_bookmark_details ubd_s
WHERE MATCH(ubd_s.title) AGAINST (?)
UNION
SELECT ub.user_bookmark_id, 50 as score
FROM bibliotech_search.bookmark_details bd_s
LEFT JOIN bookmark b_s ON (bd_s.bookmark_id=b_s.bookmark_id)
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE MATCH(bd_s.title) AGAINST (?) AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 49 as score
FROM bibliotech_search.citation c_s
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(c_s.title) AGAINST (?) AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 49 as score
FROM bibliotech_search.citation c_s
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(c_s.title) AGAINST (?) AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(j_s.name) AGAINST (?) AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(j_s.name) AGAINST (?) AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(j_s.medline_ta) AGAINST (?) AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(j_s.medline_ta) AGAINST (?) AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 47 as score
FROM bibliotech_search.bookmark b_s
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE MATCH(b_s.url) AGAINST (?) AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ubd_s.user_bookmark_id, 45 as score
FROM bibliotech_search.user_bookmark_details ubd_s
WHERE MATCH(ubd_s.description) AGAINST (?)
UNION
SELECT ub.user_bookmark_id, 44 as score
FROM bibliotech_search.comment c_s
LEFT JOIN user_bookmark_comment ubc_s ON (c_s.comment_id=ubc_s.comment)
LEFT JOIN user_bookmark ub ON (ubc_s.user_bookmark=ub.user_bookmark_id)
WHERE MATCH(c_s.entry) AGAINST (?) AND ubc_s.user_bookmark_comment_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 43 as score
FROM bibliotech_search.author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(a_s.lastname, a_s.forename, a_s.firstname) AGAINST (?) AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 43 as score
FROM bibliotech_search.author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(a_s.lastname, a_s.forename, a_s.firstname) AGAINST (?) AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ubt_s.user_bookmark as user_bookmark_id, 20 as score
FROM tag t_s
LEFT JOIN user_bookmark_tag ubt_s ON (ubt_s.tag=t_s.tag_id)
WHERE t_s.name = ? AND ubt_s.user_bookmark_tag_id IS NOT NULL
UNION
SELECT ubt_s.user_bookmark as user_bookmark_id, 20 as score
FROM bibliotech_search.tag t_s
LEFT JOIN user_bookmark_tag ubt_s ON (ubt_s.tag=t_s.tag_id)
WHERE MATCH(t_s.name) AGAINST (?) AND ubt_s.user_bookmark_tag_id IS NOT NULL
) as fmot1 GROUP BY user_bookmark_id
) as fmat
LEFT JOIN user_bookmark ub ON (fmat.user_bookmark_id=ub.user_bookmark_id)
GROUP BY fmat.user_bookmark_id
HAVING SUM(fmat.positive) = ? AND MIN(fmat.positive) = ?
) as fm ON (ub.user_bookmark_id=fm.user_bookmark_id)
WHERE ub.user_bookmark_id IS NOT NULL AND ((((ub.private = 0 AND ub.private_gang IS NULL) OR (ub.private_until IS NOT NULL AND ub.private_until <= NOW())) AND ub.quarantined IS NULL) OR ub.user = ?)
GROUP BY b.bookmark_id
ORDER BY sortvalue DESC
LIMIT 0, 10) as ubp
LEFT JOIN user_bookmark ub ON (ubp.max_user_bookmark_id=ub.user_bookmark_id)
LEFT JOIN user u ON (ub.user=u.user_id)
LEFT JOIN user_bookmark_tag ubt2 ON (ub.user_bookmark_id=ubt2.user_bookmark)
LEFT JOIN tag t2 ON (ubt2.tag=t2.tag_id)
LEFT JOIN user_bookmark_details ubd ON (ub.user_bookmark_id=ubd.user_bookmark_id)
LEFT JOIN citation ct ON (ub.citation=ct.citation_id)
LEFT JOIN citation_author cta ON (ct.citation_id=cta.citation)
LEFT JOIN author a ON (cta.author=a.author_id)
LEFT JOIN journal j ON (ct.journal=j.journal_id)
LEFT JOIN bookmark b ON (ub.bookmark=b.bookmark_id)
LEFT JOIN bookmark_details bd ON (b.bookmark_id=bd.bookmark_id)
LEFT JOIN citation ct2 ON (b.citation=ct2.citation_id)
LEFT JOIN citation_author cta2 ON (ct2.citation_id=cta2.citation)
LEFT JOIN author a2 ON (cta2.author=a2.author_id)
LEFT JOIN journal j2 ON (ct2.journal=j2.journal_id)
LEFT JOIN user_gang ug ON (u.user_id=ug.user)
LEFT JOIN gang g ON (ug.gang=g.gang_id)
LEFT JOIN bookmark b2 ON (ub.bookmark=b2.bookmark_id)
LEFT JOIN user_bookmark ub2 ON (b2.bookmark_id=ub2.bookmark AND ((((ub2.private = 0 AND ub2.private_gang IS NULL) OR (ub2.private_until IS NOT NULL AND ub2.private_until <= NOW())) AND ub2.quarantined IS NULL) OR ub2.user = ?))
LEFT JOIN user_bookmark_comment ubc2 ON (ub2.user_bookmark_id=ubc2.user_bookmark)
LEFT JOIN comment c2 ON (ubc2.comment=c2.comment_id)
LEFT JOIN user_bookmark ub3 ON (ubc2.user_bookmark=ub3.user_bookmark_id AND ub3.user = ?)
LEFT JOIN user_bookmark_tag ubt4 ON (ub.user_bookmark_id=ubt4.user_bookmark)
LEFT JOIN tag t4 ON (ubt4.tag=t4.tag_id AND t4.name = ?)
WHERE ub.user_bookmark_id IS NOT NULL
GROUP BY ubp.max_user_bookmark_id
ORDER BY sortvalue DESC" with ParamValues: 0="sakai", 1="sakai", 2="sakai", 3="sakai", 4="sakai", 5="sakai", 6="sakai", 7="sakai", 8="sakai", 9="sakai", 10="sakai", 11="sakai", 12="sakai", 13="sakai", 14="sakai", 15="sakai", 16="sakai", 17="sakai", 18="sakai", 19="sakai", 20="sakai", 21="sakai", 22="sakai", 23="sakai", 24="sakai", 25=1, 26=1, 27='1', 28='1', 29='1', 30='geotagged'] at /usr/local/lib/perl5/site_perl/5.10.0/DBIx/ContextualFetch.pm line 52.
SQL is:
----------
SELECT ub.user_bookmark_id, ub.user, ub.bookmark, ub.updated, ub.citation, ub.user_is_author, ub.def_public, ub.private, ub.private_gang, ub.private_until, ub.quarantined, ub.created, u.user_id, u.username, u.openurl_resolver, u.openurl_name, u.updated, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(g.gang_id),':/:',IFNULL(g.name, '+NULL'),':/:',IFNULL(g.owner, '+NULL'),':/:',IFNULL(g.private, '+NULL'),':/:',IFNULL(g.updated, '+NULL') ORDER BY ug.created SEPARATOR '///'), '') AS _u_gangs_packed, b.bookmark_id, b.url, b.hash, b.updated, b.citation, ubd.user_bookmark_id, ubd.title, ubd.description, bd.bookmark_id, bd.title, bd.created, ct.citation_id, ct.title, ct.journal, ct.volume, ct.issue, ct.start_page, ct.end_page, ct.pubmed, ct.doi, ct.asin, ct.ris_type, ct.raw_date, ct.date, ct.last_modified_date, ct.user_supplied, ct.cs_module, ct.cs_type, ct.cs_source, ct.created, j.journal_id, j.name, j.issn, j.coden, j.country, j.medline_code, j.medline_ta, j.nlm_unique_id, cta.citation_author_id, cta.citation, cta.author, cta.displayorder, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(a.author_id),':/:',IFNULL(a.firstname, '+NULL'),':/:',IFNULL(a.forename, '+NULL'),':/:',IFNULL(a.initials, '+NULL'),':/:',IFNULL(a.middlename, '+NULL'),':/:',IFNULL(a.lastname, '+NULL'),':/:',IFNULL(a.suffix, '+NULL'),':/:',IFNULL(a.misc, '+NULL'),':/:',IFNULL(a.postal_address, '+NULL'),':/:',IFNULL(a.affiliation, '+NULL'),':/:',IFNULL(a.email, '+NULL'),':/:',IFNULL(a.user, '+NULL') ORDER BY cta.displayorder SEPARATOR '///'), '') AS _ct_authors_packed, ct2.citation_id, ct2.title, ct2.journal, ct2.volume, ct2.issue, ct2.start_page, ct2.end_page, ct2.pubmed, ct2.doi, ct2.asin, ct2.ris_type, ct2.raw_date, ct2.date, ct2.last_modified_date, ct2.user_supplied, ct2.cs_module, ct2.cs_type, ct2.cs_source, ct2.created, j2.journal_id, j2.name, j2.issn, j2.coden, j2.country, j2.medline_code, j2.medline_ta, j2.nlm_unique_id, cta2.citation_author_id, cta2.citation, cta2.author, cta2.displayorder, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(a2.author_id),':/:',IFNULL(a2.firstname, '+NULL'),':/:',IFNULL(a2.forename, '+NULL'),':/:',IFNULL(a2.initials, '+NULL'),':/:',IFNULL(a2.middlename, '+NULL'),':/:',IFNULL(a2.lastname, '+NULL'),':/:',IFNULL(a2.suffix, '+NULL'),':/:',IFNULL(a2.misc, '+NULL'),':/:',IFNULL(a2.postal_address, '+NULL'),':/:',IFNULL(a2.affiliation, '+NULL'),':/:',IFNULL(a2.email, '+NULL'),':/:',IFNULL(a2.user, '+NULL') ORDER BY cta2.displayorder SEPARATOR '///'), '') AS _ct2_authors_packed, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(t2.tag_id),':/:',IFNULL(t2.name, '+NULL') ORDER BY ubt2.created SEPARATOR '///'), '') AS _ub_tags_packed, COUNT(DISTINCT ub2.user_bookmark_id) as _ub_user_bookmarks_count, COUNT(DISTINCT c2.comment_id) as _ub_comments_count, COUNT(DISTINCT ub3.user_bookmark_id) as _ub_bookmark_is_linked_by_current_user, COUNT(DISTINCT t4.tag_id) as _ub_is_geotagged, MAX(UNIX_TIMESTAMP(ub.created))
FROM
(SELECT MAX(ub.user_bookmark_id) as max_user_bookmark_id, fm.sortvalue as sortvalue
FROM user_bookmark ub
LEFT JOIN bookmark b ON (ub.bookmark=b.bookmark_id)
INNER JOIN (SELECT fmat.user_bookmark_id, MAX(score)*1000000000+UNIX_TIMESTAMP(ub.created) as sortvalue
FROM
(
SELECT user_bookmark_id, MAX(score) as score, 1 as positive FROM (SELECT ubd_s.user_bookmark_id, 100 as score
FROM user_bookmark_details ubd_s
WHERE ubd_s.title = ?
UNION
SELECT ub.user_bookmark_id, 100 as score
FROM bookmark_details bd_s
LEFT JOIN bookmark b_s ON (bd_s.bookmark_id=b_s.bookmark_id)
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE bd_s.title = ? AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 99 as score
FROM citation c_s
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE c_s.title = ? AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 99 as score
FROM citation c_s
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE c_s.title = ? AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE j_s.name = ? AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE j_s.name = ? AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE j_s.medline_ta = ? AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 98 as score
FROM journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE j_s.medline_ta = ? AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 97 as score
FROM author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE a_s.lastname = ? AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 97 as score
FROM author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE a_s.lastname = ? AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ubd_s.user_bookmark_id, 50 as score
FROM bibliotech_search.user_bookmark_details ubd_s
WHERE MATCH(ubd_s.title) AGAINST (?)
UNION
SELECT ub.user_bookmark_id, 50 as score
FROM bibliotech_search.bookmark_details bd_s
LEFT JOIN bookmark b_s ON (bd_s.bookmark_id=b_s.bookmark_id)
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE MATCH(bd_s.title) AGAINST (?) AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 49 as score
FROM bibliotech_search.citation c_s
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(c_s.title) AGAINST (?) AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 49 as score
FROM bibliotech_search.citation c_s
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(c_s.title) AGAINST (?) AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(j_s.name) AGAINST (?) AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(j_s.name) AGAINST (?) AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(j_s.medline_ta) AGAINST (?) AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 48 as score
FROM bibliotech_search.journal j_s
LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(j_s.medline_ta) AGAINST (?) AND c_s.citation_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 47 as score
FROM bibliotech_search.bookmark b_s
LEFT JOIN user_bookmark ub ON (b_s.bookmark_id=ub.bookmark)
WHERE MATCH(b_s.url) AGAINST (?) AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ubd_s.user_bookmark_id, 45 as score
FROM bibliotech_search.user_bookmark_details ubd_s
WHERE MATCH(ubd_s.description) AGAINST (?)
UNION
SELECT ub.user_bookmark_id, 44 as score
FROM bibliotech_search.comment c_s
LEFT JOIN user_bookmark_comment ubc_s ON (c_s.comment_id=ubc_s.comment)
LEFT JOIN user_bookmark ub ON (ubc_s.user_bookmark=ub.user_bookmark_id)
WHERE MATCH(c_s.entry) AGAINST (?) AND ubc_s.user_bookmark_comment_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 43 as score
FROM bibliotech_search.author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.bookmark=b_s.bookmark_id)
WHERE MATCH(a_s.lastname, a_s.forename, a_s.firstname) AGAINST (?) AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ub.user_bookmark_id, 43 as score
FROM bibliotech_search.author a_s
LEFT JOIN citation_author cta_s ON (a_s.author_id=cta_s.author)
LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
LEFT JOIN user_bookmark ub ON (ub.citation=c_s.citation_id)
WHERE MATCH(a_s.lastname, a_s.forename, a_s.firstname) AGAINST (?) AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND ub.user_bookmark_id IS NOT NULL
UNION
SELECT ubt_s.user_bookmark as user_bookmark_id, 20 as score
FROM tag t_s
LEFT JOIN user_bookmark_tag ubt_s ON (ubt_s.tag=t_s.tag_id)
WHERE t_s.name = ? AND ubt_s.user_bookmark_tag_id IS NOT NULL
UNION
SELECT ubt_s.user_bookmark as user_bookmark_id, 20 as score
FROM bibliotech_search.tag t_s
LEFT JOIN user_bookmark_tag ubt_s ON (ubt_s.tag=t_s.tag_id)
WHERE MATCH(t_s.name) AGAINST (?) AND ubt_s.user_bookmark_tag_id IS NOT NULL
) as fmot1 GROUP BY user_bookmark_id
) as fmat
LEFT JOIN user_bookmark ub ON (fmat.user_bookmark_id=ub.user_bookmark_id)
GROUP BY fmat.user_bookmark_id
HAVING SUM(fmat.positive) = ? AND MIN(fmat.positive) = ?
) as fm ON (ub.user_bookmark_id=fm.user_bookmark_id)
WHERE ub.user_bookmark_id IS NOT NULL AND ((((ub.private = 0 AND ub.private_gang IS NULL) OR (ub.private_until IS NOT NULL AND ub.private_until <= NOW())) AND ub.quarantined IS NULL) OR ub.user = ?)
GROUP BY b.bookmark_id
ORDER BY sortvalue DESC
LIMIT 0, 10) as ubp
LEFT JOIN user_bookmark ub ON (ubp.max_user_bookmark_id=ub.user_bookmark_id)
LEFT JOIN user u ON (ub.user=u.user_id)
LEFT JOIN user_bookmark_tag ubt2 ON (ub.user_bookmark_id=ubt2.user_bookmark)
LEFT JOIN tag t2 ON (ubt2.tag=t2.tag_id)
LEFT JOIN user_bookmark_details ubd ON (ub.user_bookmark_id=ubd.user_bookmark_id)
LEFT JOIN citation ct ON (ub.citation=ct.citation_id)
LEFT JOIN citation_author cta ON (ct.citation_id=cta.citation)
LEFT JOIN author a ON (cta.author=a.author_id)
LEFT JOIN journal j ON (ct.journal=j.journal_id)
LEFT JOIN bookmark b ON (ub.bookmark=b.bookmark_id)
LEFT JOIN bookmark_details bd ON (b.bookmark_id=bd.bookmark_id)
LEFT JOIN citation ct2 ON (b.citation=ct2.citation_id)
LEFT JOIN citation_author cta2 ON (ct2.citation_id=cta2.citation)
LEFT JOIN author a2 ON (cta2.author=a2.author_id)
LEFT JOIN journal j2 ON (ct2.journal=j2.journal_id)
LEFT JOIN user_gang ug ON (u.user_id=ug.user)
LEFT JOIN gang g ON (ug.gang=g.gang_id)
LEFT JOIN bookmark b2 ON (ub.bookmark=b2.bookmark_id)
LEFT JOIN user_bookmark ub2 ON (b2.bookmark_id=ub2.bookmark AND ((((ub2.private = 0 AND ub2.private_gang IS NULL) OR (ub2.private_until IS NOT NULL AND ub2.private_until <= NOW())) AND ub2.quarantined IS NULL) OR ub2.user = ?))
LEFT JOIN user_bookmark_comment ubc2 ON (ub2.user_bookmark_id=ubc2.user_bookmark)
LEFT JOIN comment c2 ON (ubc2.comment=c2.comment_id)
LEFT JOIN user_bookmark ub3 ON (ubc2.user_bookmark=ub3.user_bookmark_id AND ub3.user = ?)
LEFT JOIN user_bookmark_tag ubt4 ON (ub.user_bookmark_id=ubt4.user_bookmark)
LEFT JOIN tag t4 ON (ubt4.tag=t4.tag_id AND t4.name = ?)
WHERE ub.user_bookmark_id IS NOT NULL
GROUP BY ubp.max_user_bookmark_id
ORDER BY sortvalue DESC
----------
$VAR1 = {
'freematch' => [
'sakai'
],
'join_ub' => '((((ub.private = 0 AND ub.private_gang IS NULL) OR (ub.private_until IS NOT NULL AND ub.private_until <= NOW())) AND ub.quarantined IS NULL) OR ub.user = ?)',
'order_by' => 'ORDER BY sortvalue DESC',
'having' => '',
'wbind' => [],
'bind_ub' => [
'1'
],
'bind_ub3' => [
'1'
],
'group_by' => 'GROUP BY b.bookmark_id',
'limit' => 'LIMIT 0, 10',
'bind_t4' => [
'geotagged'
],
'select' => [
'MAX(ub.user_bookmark_id)',
'ub.user',
'ub.bookmark',
'ub.updated',
'ub.citation',
'ub.user_is_author',
'ub.def_public',
'ub.private',
'ub.private_gang',
'ub.private_until',
'ub.quarantined',
'ub.created',
'u.user_id',
'u.username',
'u.openurl_resolver',
'u.openurl_name',
'u.updated',
'IFNULL(GROUP_CONCAT(DISTINCT CONCAT(g.gang_id),\':/:\',IFNULL(g.name, \'+NULL\'),\':/:\',IFNULL(g.owner, \'+NULL\'),\':/:\',IFNULL(g.private, \'+NULL\'),\':/:\',IFNULL(g.updated, \'+NULL\') ORDER BY ug.created SEPARATOR \'///\'), \'\') AS _u_gangs_packed',
'b.bookmark_id',
'b.url',
'b.hash',
'b.updated',
'b.citation',
'ubd.user_bookmark_id',
'ubd.title',
'ubd.description',
'bd.bookmark_id',
'bd.title',
'bd.created',
'ct.citation_id',
'ct.title',
'ct.journal',
'ct.volume',
'ct.issue',
'ct.start_page',
'ct.end_page',
'ct.pubmed',
'ct.doi',
'ct.asin',
'ct.ris_type',
'ct.raw_date',
'ct.date',
'ct.last_modified_date',
'ct.user_supplied',
'ct.cs_module',
'ct.cs_type',
'ct.cs_source',
'ct.created',
'j.journal_id',
'j.name',
'j.issn',
'j.coden',
'j.country',
'j.medline_code',
'j.medline_ta',
'j.nlm_unique_id',
'cta.citation_author_id',
'cta.citation',
'cta.author',
'cta.displayorder',
'IFNULL(GROUP_CONCAT(DISTINCT CONCAT(a.author_id),\':/:\',IFNULL(a.firstname, \'+NULL\'),\':/:\',IFNULL(a.forename, \'+NULL\'),\':/:\',IFNULL(a.initials, \'+NULL\'),\':/:\',IFNULL(a.middlename, \'+NULL\'),\':/:\',IFNULL(a.lastname, \'+NULL\'),\':/:\',IFNULL(a.suffix, \'+NULL\'),\':/:\',IFNULL(a.misc, \'+NULL\'),\':/:\',IFNULL(a.postal_address, \'+NULL\'),\':/:\',IFNULL(a.affiliation, \'+NULL\'),\':/:\',IFNULL(a.email, \'+NULL\'),\':/:\',IFNULL(a.user, \'+NULL\') ORDER BY cta.displayorder SEPARATOR \'///\'), \'\') AS _ct_authors_packed',
'ct2.citation_id',
'ct2.title',
'ct2.journal',
'ct2.volume',
'ct2.issue',
'ct2.start_page',
'ct2.end_page',
'ct2.pubmed',
'ct2.doi',
'ct2.asin',
'ct2.ris_type',
'ct2.raw_date',
'ct2.date',
'ct2.last_modified_date',
'ct2.user_supplied',
'ct2.cs_module',
'ct2.cs_type',
'ct2.cs_source',
'ct2.created',
'j2.journal_id',
'j2.name',
'j2.issn',
'j2.coden',
'j2.country',
'j2.medline_code',
'j2.medline_ta',
'j2.nlm_unique_id',
'cta2.citation_author_id',
'cta2.citation',
'cta2.author',
'cta2.displayorder',
'IFNULL(GROUP_CONCAT(DISTINCT CONCAT(a2.author_id),\':/:\',IFNULL(a2.firstname, \'+NULL\'),\':/:\',IFNULL(a2.forename, \'+NULL\'),\':/:\',IFNULL(a2.initials, \'+NULL\'),\':/:\',IFNULL(a2.middlename, \'+NULL\'),\':/:\',IFNULL(a2.lastname, \'+NULL\'),\':/:\',IFNULL(a2.suffix, \'+NULL\'),\':/:\',IFNULL(a2.misc, \'+NULL\'),\':/:\',IFNULL(a2.postal_address, \'+NULL\'),\':/:\',IFNULL(a2.affiliation, \'+NULL\'),\':/:\',IFNULL(a2.email, \'+NULL\'),\':/:\',IFNULL(a2.user, \'+NULL\') ORDER BY cta2.displayorder SEPARATOR \'///\'), \'\') AS _ct2_authors_packed',
'IFNULL(GROUP_CONCAT(DISTINCT CONCAT(t2.tag_id),\':/:\',IFNULL(t2.name, \'+NULL\') ORDER BY ubt2.created SEPARATOR \'///\'), \'\') AS _ub_tags_packed',
'COUNT(DISTINCT ub2.user_bookmark_id) as _ub_user_bookmarks_count',
'COUNT(DISTINCT c2.comment_id) as _ub_comments_count',
'COUNT(DISTINCT ub3.user_bookmark_id) as _ub_bookmark_is_linked_by_current_user',
'COUNT(DISTINCT t4.tag_id) as _ub_is_geotagged',
'MAX(UNIX_TIMESTAMP(ub.created)) AS sortvalue'
],
'join_ub2' => '((((ub2.private = 0 AND ub2.private_gang IS NULL) OR (ub2.private_until IS NOT NULL AND ub2.private_until <= NOW())) AND ub2.quarantined IS NULL) OR ub2.user = ?)',
'where' => 'ub.user_bookmark_id IS NOT NULL',
'join_ub3' => 'ub3.user = ?',
'join_t4' => 't4.name = ?',
'class' => 'Bibliotech::User_Bookmark',
'hbind' => [],
'bind_ub2' => $VAR1->{'bind_ub'}
};
$VAR2 = [
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
'sakai',
1,
1,
'1',
'1',
'1',
'geotagged'
];
dont know where to take it from there.
Best Regards,
Mustansar
>
>
> Hope that helps,
> Martin
>
> Mustansar Mehmood wrote:
>> Hello,
>> I am trying to install a local version of connotea and after
>> following the direction carefully I cannot start the web server and
>> get this error
>>
>>
>> [Thu Feb 05 16:03:00 2009] [error] error from configuration reader
>> (/etc/bibliotech.conf): declaration redefinition for 'CITATION' at
>> /etc/bibliotech.conf line 246.\nBEGIN failed--compilation aborted at
>> /var/www/perl/connotea_code/Bibliotech/Apache.pm line
>> 11.\nCompilation failed in require at (eval 2) line 3.\n
>> [Thu Feb 05 16:03:00 2009] [error] Can't load Perl module
>> Bibliotech::Apache for server www.codesmith.org:0, exiting...
>> Any help to move past this problem is appreciated..
>> Thanks in advance,
>> Mustansar
>
>
--
Mustansar Mehmood
Educational Sys Dev/Integrator
Academic & Research Computing
Rice University
Houston Texas
Phone: (713)348 2523
Fax: (713)348 6099
|
|
From: Martin F. <ma...@ne...> - 2009-02-09 21:02:20
|
Mustansar,
Run this command on the server:
perl -MConfig::Scoped -e 'print $Config::Scoped::VERSION."\n"'
It should say at least 0.11 or higher; if not, upgrade Config::Scoped.
Then look at /etc/bibliotech.conf and search for "CITATION". Your
various citation module blocks should look something like the following,
where they are each outside any other block, properly closed, and not
nested into each other.
CITATION AMAZON {
AWSID = 'redacted'
}
CITATION DOI {
CR_USER = 'redacted'
CR_PASSWORD = 'redacted'
}
CITATION HIGHWIRE {
SCI_USER = 'redacted'
SCI_PASSWORD = 'redacted'
}
Hope that helps,
Martin
Mustansar Mehmood wrote:
> Hello,
> I am trying to install a local version of connotea and after
> following the direction carefully I cannot start the web server and get
> this error
>
>
> [Thu Feb 05 16:03:00 2009] [error] error from configuration reader
> (/etc/bibliotech.conf): declaration redefinition for 'CITATION' at
> /etc/bibliotech.conf line 246.\nBEGIN failed--compilation aborted at
> /var/www/perl/connotea_code/Bibliotech/Apache.pm line 11.\nCompilation
> failed in require at (eval 2) line 3.\n
> [Thu Feb 05 16:03:00 2009] [error] Can't load Perl module
> Bibliotech::Apache for server www.codesmith.org:0, exiting...
> Any help to move past this problem is appreciated..
> Thanks in advance,
> Mustansar
|
|
From: Mustansar M. <mus...@ri...> - 2009-02-05 22:44:34
|
Hello,
I am trying to install a local version of connotea and after
following the direction carefully I cannot start the web server and get
this error
[Thu Feb 05 16:03:00 2009] [error] error from configuration reader
(/etc/bibliotech.conf): declaration redefinition for 'CITATION' at
/etc/bibliotech.conf line 246.\nBEGIN failed--compilation aborted at
/var/www/perl/connotea_code/Bibliotech/Apache.pm line 11.\nCompilation
failed in require at (eval 2) line 3.\n
[Thu Feb 05 16:03:00 2009] [error] Can't load Perl module
Bibliotech::Apache for server www.codesmith.org:0, exiting...
Any help to move past this problem is appreciated..
Thanks in advance,
Mustansar
--
Mustansar Mehmood
Educational Sys Dev/Integrator
Academic & Research Computing
Rice University
Houston Texas
Phone: (713)348 2523
Fax: (713)348 6099
|
|
From: Mulvany, I. <i.m...@na...> - 2008-12-23 14:16:46
|
Hi Brian, Yes, we noticed the concite service is down. It should be back up after the holiday. I hope it doesn't cause too much of a problem for you in the meantime. - Ian -- Ian Mulvany i.m...@na... +44(0)2078434756 www.nature.com www.connotea.org -- ******************************************************************************** DISCLAIMER: This e-mail is confidential and should not be used by anyone who is not the original intended recipient. If you have received this e-mail in error please inform the sender and delete it from your mailbox or any other storage mechanism. Neither Macmillan Publishers Limited nor any of its agents accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Macmillan Publishers Limited or one of its agents. Please note that neither Macmillan Publishers Limited nor any of its agents accept any responsibility for viruses that may be contained in this e-mail or its attachments and it is your responsibility to scan the e-mail and attachments (if any). No contracts may be concluded on behalf of Macmillan Publishers Limited or its agents by means of e-mail communication. Macmillan Publishers Limited Registered in England and Wales with registered number 785998 Registered Office Brunel Road, Houndmills, Basingstoke RG21 6XS ******************************************************************************** |
|
From: Mulvany, I. <i.m...@na...> - 2008-12-19 14:50:37
|
Markus Heckner from the university of Regensburg contacted me looking for volunteers to participate in a survey on the use of social bookmarking systems. They are looking for people who have at least 20 papers tagged in their Connotea library, if you are interested in helping out then head on over to http://pc51010.uni-r.de/limesurvey/index.php?sid=63888&lang=en. The full call for participation is below. Participants needed for Social Web research project The number of social tagging systems like Connotea is increasing and the systems are enjoying rising popularity. However, communication patterns within these systems are not yet fully understood and are beginning to attract attention from researchers. The Media Computing Department and the Media Educational Science department of the University of Regensburg (Germany) are conducting an interdisciplinary research study of social tagging system usage. We are looking for participants who are willing to spare the time to fill out a short online survey and answer several questions about how they use Connotea. Unfortunately we cannot offer any compensation. However, filling out the survey should not take much longer than 5 minutes and would greatly help us gain a better understanding of social tagging systems. Requirements: The only requirement for participants is that they have at least 20 papers in their Connotea bibliography. If you are interested, please help us by filling out the following online survey: http://pc51010.uni-r.de/limesurvey/index.php?sid=63888&lang=en (To start the survey simply follow the link above and click the ³Next² button). We are aiming to share our results with the community by posting a link to our work in this Connotea Blog as soon as we have finished and published our paper. Thank you very much for your participation! Should you have any further questions please feel free to contact us: Markus Heckner, M.A. mar...@pa... Media Educational Science http://www-campus.uni-r.de/edu1/ Michael Heilemann, M.A. mic...@pa... Educational Science Prof. Dr. Christian Wolff chr...@sp... Media Computing http://www-medieninformatik.uni-regensburg.de/ University of Regensburg ******************************************************************************** DISCLAIMER: This e-mail is confidential and should not be used by anyone who is not the original intended recipient. If you have received this e-mail in error please inform the sender and delete it from your mailbox or any other storage mechanism. Neither Macmillan Publishers Limited nor any of its agents accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Macmillan Publishers Limited or one of its agents. Please note that neither Macmillan Publishers Limited nor any of its agents accept any responsibility for viruses that may be contained in this e-mail or its attachments and it is your responsibility to scan the e-mail and attachments (if any). No contracts may be concluded on behalf of Macmillan Publishers Limited or its agents by means of e-mail communication. Macmillan Publishers Limited Registered in England and Wales with registered number 785998 Registered Office Brunel Road, Houndmills, Basingstoke RG21 6XS ******************************************************************************** |
|
From: Mulvany, I. <i.m...@na...> - 2008-12-19 14:31:20
|
Well, after installing Connotea on our new hardware and testing it this week, we are going to transition the main site over to the new machines on Sunday. We will be putting the service into read only mode for a while, and then the site will be down for a few moments as we switch over. If the transition goes smoothly we will be back up with a much improved performance. I know we have been having major problems over the last two months, but the new hardware has significantly more memory and so the query bottlenecks that we have been experiencing should ease off. It may take us a little while in the new year to get the most optimal server settings, but the new horsepower should help from the get go. - Ian ******************************************************************************** DISCLAIMER: This e-mail is confidential and should not be used by anyone who is not the original intended recipient. If you have received this e-mail in error please inform the sender and delete it from your mailbox or any other storage mechanism. Neither Macmillan Publishers Limited nor any of its agents accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Macmillan Publishers Limited or one of its agents. Please note that neither Macmillan Publishers Limited nor any of its agents accept any responsibility for viruses that may be contained in this e-mail or its attachments and it is your responsibility to scan the e-mail and attachments (if any). No contracts may be concluded on behalf of Macmillan Publishers Limited or its agents by means of e-mail communication. Macmillan Publishers Limited Registered in England and Wales with registered number 785998 Registered Office Brunel Road, Houndmills, Basingstoke RG21 6XS ******************************************************************************** |
|
From: Benjamin G. <go...@in...> - 2008-12-03 22:27:41
|
I wonder if anyone here might wish to comment on these two posts http://betascience.blogspot.com/2008/12/two-thumbs-up-for-citeulike.html http://betascience.blogspot.com/2008/11/sorry-connotea-its-not-you-its-me.html As a long time Connotea user and advocate I hope (and suspect) that the concerns this blogger raises are being addressed as we speak. It might be a good time for a NPG blog post describing planned improvements to the Connotea service... just a suggestion. cheers -Ben |
|
From: Mitch A. G. <mi...@be...> - 2008-11-19 23:17:45
|
You could try exporting your connotea database, and opening it in notepad and then search using notepad. It obviously isn't convenient, but if it takes 5 mins the other way, you'll probably save time overall if you do more than one search. Mitch <quote who="Juan Camilo Ruiz"> > Hello eveybody, > > My library contains 700 + entries. I've realized that lately all the > searches of my library are taking some where around 5+ mins, is there a > good practice for tagging that I can apply to make my searches faster? > Have > you guys done any infrastructure changes? > > Thanks, > > > -- > Juan Camilo Ruiz > San Francisco, CA > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Connotea-discuss mailing list > Con...@li... > https://lists.sourceforge.net/lists/listinfo/connotea-discuss > |
|
From: Martin F. <ma...@ne...> - 2008-11-19 22:56:46
|
Hi Juan, Juan Camilo Ruiz wrote: > My library contains 700 + entries. I've realized that lately all the > searches of my library are taking some where around 5+ mins, is there a > good practice for tagging that I can apply to make my searches faster? Have > you guys done any infrastructure changes? Connotea has been under heavier than normal load for the past few days. We are looking into it. There is no tagging strategy that would make the search box faster per se, but if you know the tag in you library that you'd like to visit, it is certainly faster to use the tag cabinet on the left side of your library page to type or click the tag name. Martin |
|
From: Juan C. R. <jc...@gm...> - 2008-11-19 22:28:02
|
Hello eveybody, My library contains 700 + entries. I've realized that lately all the searches of my library are taking some where around 5+ mins, is there a good practice for tagging that I can apply to make my searches faster? Have you guys done any infrastructure changes? Thanks, -- Juan Camilo Ruiz San Francisco, CA |
|
From: anne w. <awi...@gm...> - 2008-11-13 17:49:51
|
Hello We have successfully set up EPrints on a UNIX machine and now we are trying to get Connotea installed... however we have followed the set up description, Connotea now appears with our repositority pages, it seems to log in.... But does not appear to save tags . Do you have any advice? Kinds regards A Williams |
|
From: Duncan H. <dun...@cs...> - 2008-11-04 12:04:31
|
hello we recently published a short review of connotea (and related work) in PLoS Computational Biology Might be of interest Hull, D., S. R. Pettifer, and D. B. Kell (2008, October). Defrosting the digital library: Bibliographic tools for the next generation web. PLoS Comput Biol 4 (10), e1000204+. http://dx.doi.org/10.1371/journal.pcbi.1000204 http://pubmed.gov/18974831 Ian Mulvany has raised some issues about the buggotea comments, I'll respond to these on the PLoS comments page, hopefully sometime this week. Duncan --- http://duncan.hull.name |
|
From: Martin F. <ma...@ne...> - 2008-10-01 01:07:53
|
Aha, Brian, I think the problem is simply that the Connotea Code release out there isn't updated for Wiki::Toolkit. We've made the change internally for connotea.org. The /code page is ahead of the release. I've attached a patch that makes a minimal change to Wiki.pm to update it for Wiki::Toolkit. Martin Brian wrote: > Apache refuses to load Bibliotech::Apache unless CGI::Wiki is installed. > But isn't that deprecated? I am not familiar with perl and I've spent a > lot of time trying to understand this problem, fyi.. The directions in > Connotea Code are easy to follow and I feel that I have. > > The following is the last few lines of my apache error.log after trying > to load grey.colorado.edu/connotea <http://grey.colorado.edu/connotea> > without CGI::Wiki installed and with Wiki::Toolkit installed. Installing > CGI::Wiki fixes this problem, but I still get the aforementioned error > with `node' and `node_id': > > [Tue Sep 30 15:18:07 2008] [error] Can't locate CGI/Wiki.pm in @INC > (@INC contains: /usr/local/connotea /etc/perl > /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 > /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 > /usr/local/lib/site_perl . /etc/apache2) at > /usr/local/connotea/Bibliotech/Component/Wiki.pm line 12.\nBEGIN > failed--compilation aborted at > /usr/local/connotea/Bibliotech/Component/Wiki.pm line > 12.\nCompilation failed in require at > /usr/local/connotea/Bibliotech/Component/List.pm line 20.\nBEGIN > failed--compilation aborted at > /usr/local/connotea/Bibliotech/Component/List.pm line > 20.\nCompilation failed in require at > /usr/local/connotea/Bibliotech/Page.pm line 23.\nBEGIN > failed--compilation aborted at > /usr/local/connotea/Bibliotech/Page.pm line23.\nCompilation failed > in require at (eval 1316) line 3.\n\t...propagated at > /usr/share/perl/5.8/base.pm <http://base.pm> line 84.\nBEGIN > failed--compilation aborted at > /usr/local/connotea/Bibliotech/Page/Standard.pm line > 12.\nCompilation failed in require at > /usr/local/connotea/Bibliotech/Apache.pm line 19.\nBEGIN > failed--compilation aborted at > /usr/local/connotea/Bibliotech/Apache.pm line 19.\nCompilation > failed in require at (eval 2) line 3.\n > > [Tue Sep 30 15:18:07 2008] [error] Can't load Perl module > Bibliotech::Apache for server grey.colorado.edu:0 > <http://grey.colorado.edu:0>, exiting... > > > > On Mon, Sep 29, 2008 at 5:24 PM, Brian <Bri...@co... > <mailto:Bri...@co...>> wrote: > > Martin, I made sure I have the latest Wiki::Toolkit, including > installing it from source myself. I used wiki-toolkit-setupdb (in > /usr/local on my system) to create the database each time, and it's > always created the `node_id' column. Where is the code that is > generating the query which looks for a column named `node'? I can't > find it.. > > Error exception report: > > visitor requests /user/test bringing load to 1 with db at 1222473608 > > http://grey.colorado.edu/connotea/user/test > > > undef error - DBD::mysql::st execute failed: Unknown column 'node' in 'where clause' [for Statement "SELECT metadata_type, metadata_value FROM metadata WHERE node='User:test' AND version='0'"] at /usr/local/share/perl/5.8.8/DBIx/ContextualFetch.pm line 54. > > > Thanks much for your replies > > /Brian > > > On Sat, Sep 27, 2008 at 3:46 PM, Martin Flack <ma...@ne... > <mailto:ma...@ne...>> wrote: > > This is a Wiki::Toolkit thing. It used to be "node" back when it > was CGI::Wiki, and then they changed it. Is your wiki database > the result of running /usr/bin/wiki-toolkit-setupdb? You might > have upgraded it since, or should do, via CPAN, and then maybe > drop the wiki database and rebuild it. > > > Brian wrote: > > There is a specific database error that you get when you try > to load a user library. For example: > > http://grey.colorado.edu/connotea/user/test > > I was able to fix this in a mysql shell by replacing 'node' > with 'node_id'. Is that a bug? > > > > > > -- > (Not sent from my iPhone) > > > > > -- > (Not sent from my iPhone) |
|
From: Heejin P. <pap...@in...> - 2008-10-01 00:20:19
|
*** Forgive cross-posting, and distribute as you see fit *** Hello, My name is Heejin Park. I am a PhD student at the School of Library, Archival and Information Studies, University of British Columbia. I am conducting a study to fulfill the research component of my degree, and I am sending this note to ask for volunteers. In my research, I am interested in the use of Connotea (www.connotea.org) and looking for participants who will share their experiences with the system. The purpose of this study is to explore how you use Connotea in order to access, share, and navigate Web information. If you agree to participate in this study, I will ask you to complete an e-mail questionnaire and to keep an electronic diary which records your use of Connotea. The e-mail questionnaire and diary process will take approximately two to three hours of your time over a one to two week period. Participation in this research is voluntary, and participants are ensured confidentiality. The completed questionnaire will be accessible only to the researcher named below, and will be kept in strict confidence. The Connotea user name on the questionnaire is for data management purposes only. As soon as the responses are coded, information linking data to respondent will be destroyed. Please consider participating. To show our appreciation for your participation in this study, you will receive an honorarium in the amount of $20 in the form of an Amazon.com gift card. If you would like to participate, to support the research or because you would like to help out a colleague, please respond to this email address [pap...@in...]. If you do not wish to participate, but can recommend someone who can participate, please forward this message to that person. If you decide to participate, I will email information that includes a link to the interview questions and a form of the electronic diaries, and my contact information. Please note that I have listed my e-mail account and my phone number below. Do not hesitate to ask any questions about the study. Thank you very much. Heejin Park pap...@in... Principal Investigators Edie Rasmussen, Professor School of Library, Archival and Information Studies University of British Columbia; Joseph Tennis, Assistant Professor The Information School of the University of Washington |
|
From: Martin F. <ma...@ne...> - 2008-09-27 21:55:36
|
This is a Wiki::Toolkit thing. It used to be "node" back when it was CGI::Wiki, and then they changed it. Is your wiki database the result of running /usr/bin/wiki-toolkit-setupdb? You might have upgraded it since, or should do, via CPAN, and then maybe drop the wiki database and rebuild it. Brian wrote: > There is a specific database error that you get when you try to load a > user library. For example: > > http://grey.colorado.edu/connotea/user/test > > I was able to fix this in a mysql shell by replacing 'node' with > 'node_id'. Is that a bug? |
|
From: Martin F. <ma...@ne...> - 2008-09-27 00:01:26
|
Brian wrote: > Hi Martin - I've gotten past all of my apache config problems I believe. > However, the installation is unusable. If you create an account here and > try to go to your user library, or try to use the search engine, you can > see the problems I'm encountering. Ok I just got the verification email and yes I think there you simply need to create a getting_started.inc file. We probably need to add a placeholder file for the open source release. Martin |
|
From: Martin F. <ma...@ne...> - 2008-09-27 00:00:05
|
Hi Brian, The search function looks like it just doesn't have the secondary database setup. We used the old Slashdot approach which is to have a main database as InnoDB because it has faster joins and better foreign key support, and a replicated slave as MyISAM to serve as a search database because MyISAM has fulltext index support. Refer to the section here: http://www.connotea.org/code#mysql and check the DBI_SEARCH option in bibliotech.conf. Regarding registration, I was able to get a thankyou page from your server and I'm waiting on the email. And on your other question, yes unfortunately getting_started should be created by you. I very much hope you don't mind I'm cc'ing the list to answer these questions for all. ;-) Martin Brian wrote: > Hi Martin - I've gotten past all of my apache config problems I believe. > However, the installation is unusable. If you create an account here and > try to go to your user library, or try to use the search engine, you can > see the problems I'm encountering. > > http://grey.colorado.edu/connotea/ > > Cheers, > Brian |
|
From: Martin F. <ma...@ne...> - 2008-09-26 23:55:49
|
Hopefully this will help some people setting up Connotea.
On our development server we have several instances of Connotea Code
running on the standard single vendor installation of Apache. I've
pulled out the configuration for codename "unstable", which is one of
these instances, which I've documented below. (It is named unstable to
remind everyone that we are allowed to break it, but it starts fine.) So
several other instances are omitted from the Apache configuration, and
there are more symlinks, and I've modified a couple things for privacy,
etc., but if this were all there it should run the first instance.
In /etc/httpd/conf.d/connotea.conf:
<VirtualHost _default_:80>
DocumentRoot /var/www/html
PerlOptions +Parent
PerlSwitches -I/var/www/perl/unstable
AddOutputFilterByType DEFLATE text/html text/xml text/css
# development branch follows:
PerlModule Bibliotech::Apache
PerlModule Bibliotech::AuthCookie
<Location /unstable>
SetHandler perl-script
PerlHandler Bibliotech::Apache
PerlAuthenHandler Bibliotech::AuthCookie::authen_handler
AuthName Bibliotech
AuthType basic
require valid-user
#ErrorDocument 503 /unstable/paused.html
#ErrorDocument 503 /unstable/unavailable.html
ErrorDocument 503 /unstable/readonly.html
</Location>
</VirtualHost>
(This is setup in a VirtualHost... I'm not certain that this is a
requirement - is that the part people are having problems with?)
In /var/www/perl:
Symlink unstable -> /var/local/project/work/unstable
In /var/www/html:
Symlink unstable -> ../perl/unstable/site/default
In /var/local/project/work/unstable:
(Bibliotech code and bibliotech.conf)
Most of the GENERAL block from bibliotech.conf:
GENERAL {
SITE_NAME = 'Connotea Dev'
SITE_EMAIL = 'con...@na...'
DOCROOT = '/var/www/html/unstable'
LOCATION = 'http://xxxxx.connotea.org/unstable/'
PREPATH = '/unstable';
BIBUTILS_PATH = '/var/www/perl/unstable/bibutils/'
MOD_PERL_WORKAROUND = true
EXPLAIN_HTTP_CODES = false
EXCEPTION_ERROR_REPORTS_TO = '**'
DBI_CONNECT = 'dbi:mysql:connotea'
DBI_USERNAME = 'bibliotech'
DBI_PASSWORD = '**'
DBI_SEARCH = 'connotea_search'
MEMCACHED_SERVERS = [ '127.0.0.1:11211' ]
TEMPLATE_ROOT = ''
PID_FILE = '/var/run/httpd.pid'
SENDMAIL = '/usr/lib/sendmail'
USER_COOKIE_SECRET = '**'
USER_VERIFYCODE_SECRET = '**'
FORGOTTEN_PASSWORD_SECRET = '**';
CLIENT_SIDE_HTTP_CACHE = true
TIME_ZONE_ON_DB_HOST = 'local'
TIME_ZONE_PROVIDED = 'Europe/London'
FRESH_VISITOR_LAZY_UPDATE = 180
LOG_FILE = '/var/log/connotea.log'
}
|
|
From: Martin F. <ma...@ne...> - 2008-09-26 23:55:43
|
Hello Brian, Brian wrote: > Connotea is awesome and I can't wait to get it going - just wanted to get > that out of the way before I start complaining :) Thank you, glad to have you installing it. Sorry for the quietness of response, some people are currently away. > Installing the perl modules was a huge undertaking, `cpan' seems incapable > of it (i used cpanplus), and the list of modules to be installed is > incomplete by roughly ten items. That said, I managed to get through it all. Was it automatically fetching dependencies as well? The list is mostly the literally "use'd" modules, probably missing dependent modules that the cpan utility can get for you. If there are a few more missing I'd love to add them - I see you've sent a follow up email on this. > Right now my installation is nearly ready but I am having issues with the > apache configuration. First, I don't use a VirtualHost as this web server is > not specific to Connotea, so I can't follow your configuration exactly. > Second, I can't tell if it is configured correctly but I'm having some kind > of authentication issue. So hopefully someone here can look at what i've got > in apache2.conf in addition to our live connotea directory and give me some > tips! > > Live connotea directory: http://grey.colorado.edu/connotea/ > > Apache2.conf. If I remove the <Directory> section my server issues the 403 > Forbidden status code. If I leave it in I can view the directory but I get a > directory listing and not a page. So I'm not sure what to do here. > > PerlOptions +Parent > PerlSwitches -I/usr/local/connotea > PerlModule Bibliotech::Apache > PerlModule Bibliotech::AuthCookie > > Alias /connotea /usr/local/connotea/site/default > <Location /usr/local/connotea/site/default> > SetHandler perl-script > PerlHandler Bibliotech::Apache > PerlAuthenHandler Bibliotech::AuthCookie::authen_handler > AuthName Bibliotech > AuthType basic > require valid-user > </Location> I believe a <Location> specifier should be in the URI space, so /usr/local... can't be right. We've got a development server that runs four instances of Connotea Code on one instance of Apache 2. Let me take a look at that configuration and send a follow up. Martin Flack |
14 messages has been excluded from this view by a project administrator.
