[Refdb-devel] [ refdb-Bugs-1544642 ] getref :UR:~ fails

[SourceForge.net <no...@so...>]

Bugs item #1544642, was opened at 2006-08-22 16:52
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1544642&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Nobody/Anonymous (nobody)
Summary: getref :UR:~ fails

Initial Comment:
I'm trying to query references based on the URL.
However, I get a getref failed error message:

>From the command line:


$ refdbc -C getref :UR:~literatur

select failed

The corresponding log says:
SELECT DISTINCT t_refdb.refdb_id, t_refdb.refdb_type,
t_refdb.refdb_pubyear, t_refdb.refdb_startpage,
t_refdb.refdb_endpage, t_refdb.refdb_abstract,
t_refdb.refdb_title, t_refdb.refdb_volume,
t_refdb.refdb_issue, t_refdb.refdb_booktitle,
t_refdb.refdb_city, t_refdb.refdb_publisher,
t_refdb.refdb_title_series, t_refdb.refdb_address,
t_refdb.refdb_issn, t_refdb.refdb_periodical_id,
t_refdb.refdb_pyother_info, t_refdb.refdb_secyear,
t_refdb.refdb_secother_info, t_refdb.refdb_user1,
t_refdb.refdb_user2, t_refdb.refdb_user3,
t_refdb.refdb_user4, t_refdb.refdb_user5,
t_refdb.refdb_misc1, t_refdb.refdb_misc2,
t_refdb.refdb_misc3, t_refdb.refdb_citekey FROM t_refdb
WHERE refdb_type!='DUMMY' AND t_refdb.refdb_url RLIKE
'literatur' ORDER BY t_refdb.refdb_id
1054: Unknown column 't_refdb.refdb_url' in 'where clause'
select failed

However, this query needs to be composed differently as
URLs are stored in the t_link table

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1544642&group_id=26091