unknown
1970-01-01 00:00:00 UTC
$ 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
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