Server Error

Connotea is currently experiencing technical difficulties.

Error exception report:

visitor requests /rss/search?q=Knowledge-Management bringing load to 11 with db at 1258836589

http://www.connotea.org/rss/search

DBD::mysql::st execute failed: Table './connotea_search/user_article_details' is marked as crashed and should be repaired [for Statement "SELECT ua.user_article_id, ua.user, ua.article, ua.bookmark, ua.updated, ua.citation, ua.user_is_author, ua.def_public, ua.private, ua.private_gang, ua.private_until, ua.quarantined, ua.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, a.article_id, a.hash, a.citation, a.created, a.updated, b.bookmark_id, b.url, b.hash, b.article, b.citation, b.first_user, b.created, b.updated, uad.user_article_id, uad.title, uad.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.cs_score, ct.created, j.journal_id, j.name, j.issn, j.coden, j.country, j.medline_code, j.medline_ta, j.nlm_unique_id, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(au.author_id),':/:',IFNULL(au.firstname, '+NULL'),':/:',IFNULL(au.forename, '+NULL'),':/:',IFNULL(au.initials, '+NULL'),':/:',IFNULL(au.middlename, '+NULL'),':/:',IFNULL(au.lastname, '+NULL'),':/:',IFNULL(au.suffix, '+NULL'),':/:',IFNULL(au.misc, '+NULL'),':/:',IFNULL(au.postal_address, '+NULL'),':/:',IFNULL(au.affiliation, '+NULL'),':/:',IFNULL(au.email, '+NULL'),':/:',IFNULL(au.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.cs_score, ct2.created, j2.journal_id, j2.name, j2.issn, j2.coden, j2.country, j2.medline_code, j2.medline_ta, j2.nlm_unique_id, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(au2.author_id),':/:',IFNULL(au2.firstname, '+NULL'),':/:',IFNULL(au2.forename, '+NULL'),':/:',IFNULL(au2.initials, '+NULL'),':/:',IFNULL(au2.middlename, '+NULL'),':/:',IFNULL(au2.lastname, '+NULL'),':/:',IFNULL(au2.suffix, '+NULL'),':/:',IFNULL(au2.misc, '+NULL'),':/:',IFNULL(au2.postal_address, '+NULL'),':/:',IFNULL(au2.affiliation, '+NULL'),':/:',IFNULL(au2.email, '+NULL'),':/:',IFNULL(au2.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 uat2.created SEPARATOR '///'), '') AS _ua_tags_packed, COUNT(DISTINCT ua2.user_article_id) as _ua_user_articles_count, COUNT(DISTINCT c2.comment_id) as _ua_comments_count, COUNT(DISTINCT ua3.user_article_id) as _ua_article_is_linked_by_current_user, COUNT(DISTINCT t4.tag_id) as _ua_is_geotagged,  MAX(UNIX_TIMESTAMP(ua.created))
FROM 
(SELECT MAX(ua.user_article_id) as max_user_article_id, fm.sortvalue as sortvalue
FROM user_article ua
LEFT JOIN bookmark b ON (ua.bookmark=b.bookmark_id)
INNER JOIN (SELECT fmat.user_article_id, MAX(score)*1000000000+UNIX_TIMESTAMP(ua.created) as sortvalue
FROM
(
SELECT user_article_id, MAX(score) as score, 1 as positive FROM (SELECT   uad_s.user_article_id, 100 as score
FROM     user_article_details uad_s
WHERE    uad_s.title = ?
UNION
SELECT   ua.user_article_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_article ua ON (b_s.article=ua.article)
WHERE    bd_s.title = ? AND b_s.bookmark_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 99 as score
FROM     citation c_s
         LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
         LEFT JOIN user_article ua ON (ua.article=b_s.article)
WHERE    c_s.title = ? AND b_s.bookmark_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 99 as score
FROM     citation c_s
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    c_s.title = ? AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_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 article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    j_s.name = ? AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 98 as score
FROM     journal j_s
         LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    j_s.name = ? AND c_s.citation_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_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 article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    j_s.medline_ta = ? AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 98 as score
FROM     journal j_s
         LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    j_s.medline_ta = ? AND c_s.citation_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 97 as score
FROM     author au_s
         LEFT JOIN citation_author cta_s ON (au_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 article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    au_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 a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 97 as score
FROM     author au_s
         LEFT JOIN citation_author cta_s ON (au_s.author_id=cta_s.author)
         LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    au_s.lastname = ? AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   uad_s.user_article_id, 50 as score
FROM     connotea_search.user_article_details uad_s
WHERE    MATCH(uad_s.title) AGAINST (? IN BOOLEAN MODE)
UNION
SELECT   ua.user_article_id, 50 as score
FROM     connotea_search.bookmark_details bd_s
         LEFT JOIN bookmark b_s ON (bd_s.bookmark_id=b_s.bookmark_id)
         LEFT JOIN user_article ua ON (b_s.article=ua.article)
WHERE    MATCH(bd_s.title) AGAINST (? IN BOOLEAN MODE) AND b_s.bookmark_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 49 as score
FROM     connotea_search.citation c_s
         LEFT JOIN bookmark b_s ON (b_s.citation=c_s.citation_id)
	 LEFT JOIN article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    MATCH(c_s.title) AGAINST (? IN BOOLEAN MODE) AND b_s.bookmark_id IS NOT NULL AND a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 49 as score
FROM     connotea_search.citation c_s
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    MATCH(c_s.title) AGAINST (? IN BOOLEAN MODE) AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 48 as score
FROM     connotea_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 article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    MATCH(j_s.name) AGAINST (? IN BOOLEAN MODE) AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 48 as score
FROM     connotea_search.journal j_s
         LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    MATCH(j_s.name) AGAINST (? IN BOOLEAN MODE) AND c_s.citation_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 48 as score
FROM     connotea_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 article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    MATCH(j_s.medline_ta) AGAINST (? IN BOOLEAN MODE) AND c_s.citation_id IS NOT NULL AND b_s.bookmark_id IS NOT NULL AND a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 48 as score
FROM     connotea_search.journal j_s
         LEFT JOIN citation c_s ON (c_s.journal=j_s.journal_id)
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    MATCH(j_s.medline_ta) AGAINST (? IN BOOLEAN MODE) AND c_s.citation_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 47 as score
FROM     connotea_search.bookmark b_s
         LEFT JOIN article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (a_s.article_id=ua.article)
WHERE    MATCH(b_s.url) AGAINST (? IN BOOLEAN MODE) AND a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   uad_s.user_article_id, 45 as score
FROM     connotea_search.user_article_details uad_s
WHERE    MATCH(uad_s.description) AGAINST (? IN BOOLEAN MODE)
UNION
SELECT   ua.user_article_id, 44 as score
FROM     connotea_search.comment c_s
         LEFT JOIN user_article_comment uac_s ON (c_s.comment_id=uac_s.comment)
         LEFT JOIN user_article ua ON (uac_s.user_article=ua.user_article_id)
WHERE    MATCH(c_s.entry) AGAINST (? IN BOOLEAN MODE) AND uac_s.user_article_comment_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 43 as score
FROM     connotea_search.author au_s
         LEFT JOIN citation_author cta_s ON (au_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 article a_s ON (b_s.article=a_s.article_id)
         LEFT JOIN user_article ua ON (ua.article=a_s.article_id)
WHERE    MATCH(au_s.lastname, au_s.forename, au_s.firstname) AGAINST (? IN BOOLEAN MODE) 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 a_s.article_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   ua.user_article_id, 43 as score
FROM     connotea_search.author au_s
         LEFT JOIN citation_author cta_s ON (au_s.author_id=cta_s.author)
         LEFT JOIN citation c_s ON (c_s.citation_id=cta_s.citation)
         LEFT JOIN user_article ua ON (ua.citation=c_s.citation_id)
WHERE    MATCH(au_s.lastname, au_s.forename, au_s.firstname) AGAINST (? IN BOOLEAN MODE) AND cta_s.citation_author_id IS NOT NULL AND c_s.citation_id IS NOT NULL AND ua.user_article_id IS NOT NULL
UNION
SELECT   uat_s.user_article as user_article_id, 20 as score
FROM     tag t_s
         LEFT JOIN user_article_tag uat_s ON (uat_s.tag=t_s.tag_id)
WHERE    t_s.name = ? AND uat_s.user_article_tag_id IS NOT NULL
UNION
SELECT   uat_s.user_article as user_article_id, 20 as score
FROM     connotea_search.tag t_s
         LEFT JOIN user_article_tag uat_s ON (uat_s.tag=t_s.tag_id)
WHERE    MATCH(t_s.name) AGAINST (? IN BOOLEAN MODE) AND uat_s.user_article_tag_id IS NOT NULL
) as fmot1 GROUP BY user_article_id
) as fmat
LEFT JOIN user_article ua ON (fmat.user_article_id=ua.user_article_id)
GROUP BY fmat.user_article_id
HAVING SUM(fmat.positive) = ? AND MIN(fmat.positive) = ?
) as fm ON (ua.user_article_id=fm.user_article_id)

WHERE ua.user_article_id IS NOT NULL AND ua.def_public = 1
GROUP BY b.article

ORDER BY sortvalue DESC
LIMIT 0, 10) as uap

LEFT JOIN user_article ua ON (uap.max_user_article_id=ua.user_article_id)
LEFT JOIN user u ON (ua.user=u.user_id)
LEFT JOIN user_article_tag uat2 ON (ua.user_article_id=uat2.user_article)
LEFT JOIN tag t2 ON (uat2.tag=t2.tag_id)
LEFT JOIN user_article_details uad ON (ua.user_article_id=uad.user_article_id)
LEFT JOIN citation ct ON (ua.citation=ct.citation_id)
LEFT JOIN citation_author cta ON (ct.citation_id=cta.citation)
LEFT JOIN article a ON (ua.article=a.article_id)
LEFT JOIN journal j ON (ct.journal=j.journal_id)
LEFT JOIN bookmark b ON (ua.bookmark=b.bookmark_id)
LEFT JOIN bookmark_details bd ON (b.bookmark_id=bd.bookmark_id)
LEFT JOIN citation ct2 ON (a.citation=ct2.citation_id)
LEFT JOIN citation_author cta2 ON (ct2.citation_id=cta2.citation)
LEFT JOIN author au2 ON (cta2.author=au2.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 article a2 ON (b.article=a2.article_id)
LEFT JOIN user_article ua2 ON (a2.article_id=ua2.article AND ua2.def_public = 1)
LEFT JOIN user_article_comment uac2 ON (ua2.user_article_id=uac2.user_article)
LEFT JOIN comment c2 ON (uac2.comment=c2.comment_id)
LEFT JOIN user_article ua3 ON (uac2.user_article=ua3.user_article_id AND ua3.user = ?)
LEFT JOIN user_article_tag uat4 ON (ua.user_article_id=uat4.user_article)
LEFT JOIN tag t4 ON (uat4.tag=t4.tag_id AND t4.name = ?)
LEFT JOIN author au ON (cta2.author=au.author_id)
WHERE ua.user_article_id IS NOT NULL
GROUP BY uap.max_user_article_id
ORDER BY sortvalue DESC" with ParamValues: 0="Knowledge-Management", 1="Knowledge-Management", 2="Knowledge-Management", 3="Knowledge-Management", 4="Knowledge-Management", 5="Knowledge-Management", 6="Knowledge-Management", 7="Knowledge-Management", 8="Knowledge-Management", 9="Knowledge-Management", 10="Knowledge-Management", 11="Knowledge-Management", 12="Knowledge-Management", 13="Knowledge-Management", 14="Knowledge-Management", 15="Knowledge-Management", 16="Knowledge-Management", 17="Knowledge-Management", 18="Knowledge-Management", 19="Knowledge-Management", 20="Knowledge-Management", 21="Knowledge-Management", 22="Knowledge-Management", 23="Knowledge-Management", 24="Knowledge-Management", 25=1, 26=1, 27=0, 28='geotagged'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52.

The information above has been sent to our developers. If you would like to add additional information to help them diagnose the problem, please do so using the form below.