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

Bugs item #1544642, was opened at 2006-08-22 16:52
Message generated for change (Comment added) made by mhoenicka
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: refdbd
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Markus Hoenicka (mhoenicka)
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

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

>Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-08-26 14:20

Message:
Logged In: YES 
user_id=85809

The UR and L1-L4 queries are fixed in SVN (repository
version 140)


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

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

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642