Menu
▾
▴
connotea-discuss
|
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: 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: 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-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-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-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 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 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 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X