unknown
2008-04-28 02:47:00 UTC
**** REFDBD OUTPUT FROM GETREF -T BIBTEX COMMAND: ****
adding client 127.0.0.1 on fd 5
server waiting n_max_fd=5
try to read from client
parent removing client on fd 5
server waiting n_max_fd=4
serving client on fd 5 with protocol version 6
012-47-22-83
send pseudo-random string to client
getref -u 123 -w 102037101 -d djdphd -t "bibtex" -R
/data/private/djd/Library -E UTF-8 -G
/data/private/djd/binary/share/refdb/css/refdb.css 10
dbi is up
localhost
123
123
djdphd
sqlite3
/data/private/djd/Library/ReferenceDatabaseSqlite3/
UTF-8
refdb
connected to database server using database:
refdb
Main database looks ok:
refdb
localhost
123
123
djdphd
sqlite3
/data/private/djd/Library/ReferenceDatabaseSqlite3/
UTF-8
djdphd
SELECT meta_app,meta_type,meta_dbversion FROM t_meta WHERE
meta_type='risx'
connected to database server using database:
djdphd
no character encoding conversion required
output encoding is:
UTF-8
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_typeofwork, t_refdb.refdb_area, t_refdb.refdb_ostype,
t_refdb.refdb_degree, t_refdb.refdb_runningtime,
t_refdb.refdb_classcodeintl, t_refdb.refdb_classcodeus,
t_refdb.refdb_senderemail, t_refdb.refdb_recipientemail,
t_refdb.refdb_mediatype, t_refdb.refdb_numvolumes, t_refdb.refdb_edition,
t_refdb.refdb_computer, t_refdb.refdb_conferencelocation,
t_refdb.refdb_registrynum, t_refdb.refdb_classification,
t_refdb.refdb_section, t_refdb.refdb_pamphletnum, t_refdb.refdb_chapternum,
t_refdb.refdb_citekey FROM t_refdb WHERE refdb_type!='DUMMY' AND
t_refdb.refdb_id>'0' ORDER BY t_refdb.refdb_id
SELECT
t_author.author_name,t_author.author_lastname,t_author.author_firstname,t_author.author_middlename,t_author.author_suffix,t_xauthor.xauthor_role,
t_xauthor.author_id FROM t_author INNER JOIN t_xauthor ON
t_author.author_id=t_xauthor.author_id WHERE t_xauthor.xauthor_type=2 AND
t_xauthor.xauthor_role='author' AND t_xauthor.refdb_id=1 ORDER BY
t_xauthor.xauthor_position
SELECT
t_author.author_name,t_author.author_lastname,t_author.author_firstname,t_author.author_middlename,t_author.author_suffix,t_xauthor.xauthor_role,
t_xauthor.author_id FROM t_author INNER JOIN t_xauthor ON
t_author.author_id=t_xauthor.author_id WHERE t_xauthor.xauthor_type=2 AND
t_xauthor.xauthor_role='editor' AND t_xauthor.refdb_id=1 ORDER BY
t_xauthor.xauthor_position
SELECT
t_author.author_name,t_author.author_lastname,t_author.author_firstname,t_author.author_middlename,t_author.author_suffix,t_xauthor.xauthor_role,
t_xauthor.author_id FROM t_author INNER JOIN t_xauthor ON
t_author.author_id=t_xauthor.author_id WHERE t_xauthor.xauthor_type=3 AND
t_xauthor.refdb_id=1 ORDER BY t_xauthor.xauthor_position
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='URL' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='PDF' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='FULLTEXT' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='RELATED' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='IMAGE' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='DOI' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
command processing done, finish dialog now
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4
----------------------------------------------------------------------
Comment By: Markus Hoenicka (mhoenicka)
Date: 2008-04-27 21:47
Message:
Logged In: YES
user_id=85809
Originator: NO
Are you still using reference databases created with RefDB 0.9.8 or
earlier? As I cannot reproduce this problem here, I suspect your reference
database was not properly upgraded when moving from 0.9.8 to the current
version. The internal data representation has changed somewhat, and this
would nicely explain the problems you see. Please check carefully the
UPGRADING file which explains the background and the proper procedure to
upgrade. Let me know if the problem persists, or if you can reproduce it
with a fresh database created with 0.9.9 or later.
regards,
Markus
----------------------------------------------------------------------
Comment By: Damien Jade Duff (damienjadeduff)
Date: 2008-04-25 17:05
Message:
Logged In: YES
user_id=2066694
Originator: YES
Hi
I just noticed that this applies also to BOOK ris types (always) and GEN
ris types (when the author is inside the risx publication tag) - bibtex
generation is not giving back the author. Hope this is useful..
Peace
Damien
mycomp% refdbd -v
refdbd 1.0.0-pre1 built from svn revision 613 ***@mhoenicka.de
You may redistribute and modify this software under the terms of the GNU
General Public License.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1951049&group_id=26091
adding client 127.0.0.1 on fd 5
server waiting n_max_fd=5
try to read from client
parent removing client on fd 5
server waiting n_max_fd=4
serving client on fd 5 with protocol version 6
012-47-22-83
send pseudo-random string to client
getref -u 123 -w 102037101 -d djdphd -t "bibtex" -R
/data/private/djd/Library -E UTF-8 -G
/data/private/djd/binary/share/refdb/css/refdb.css 10
dbi is up
localhost
123
123
djdphd
sqlite3
/data/private/djd/Library/ReferenceDatabaseSqlite3/
UTF-8
refdb
connected to database server using database:
refdb
Main database looks ok:
refdb
localhost
123
123
djdphd
sqlite3
/data/private/djd/Library/ReferenceDatabaseSqlite3/
UTF-8
djdphd
SELECT meta_app,meta_type,meta_dbversion FROM t_meta WHERE
meta_type='risx'
connected to database server using database:
djdphd
no character encoding conversion required
output encoding is:
UTF-8
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_typeofwork, t_refdb.refdb_area, t_refdb.refdb_ostype,
t_refdb.refdb_degree, t_refdb.refdb_runningtime,
t_refdb.refdb_classcodeintl, t_refdb.refdb_classcodeus,
t_refdb.refdb_senderemail, t_refdb.refdb_recipientemail,
t_refdb.refdb_mediatype, t_refdb.refdb_numvolumes, t_refdb.refdb_edition,
t_refdb.refdb_computer, t_refdb.refdb_conferencelocation,
t_refdb.refdb_registrynum, t_refdb.refdb_classification,
t_refdb.refdb_section, t_refdb.refdb_pamphletnum, t_refdb.refdb_chapternum,
t_refdb.refdb_citekey FROM t_refdb WHERE refdb_type!='DUMMY' AND
t_refdb.refdb_id>'0' ORDER BY t_refdb.refdb_id
SELECT
t_author.author_name,t_author.author_lastname,t_author.author_firstname,t_author.author_middlename,t_author.author_suffix,t_xauthor.xauthor_role,
t_xauthor.author_id FROM t_author INNER JOIN t_xauthor ON
t_author.author_id=t_xauthor.author_id WHERE t_xauthor.xauthor_type=2 AND
t_xauthor.xauthor_role='author' AND t_xauthor.refdb_id=1 ORDER BY
t_xauthor.xauthor_position
SELECT
t_author.author_name,t_author.author_lastname,t_author.author_firstname,t_author.author_middlename,t_author.author_suffix,t_xauthor.xauthor_role,
t_xauthor.author_id FROM t_author INNER JOIN t_xauthor ON
t_author.author_id=t_xauthor.author_id WHERE t_xauthor.xauthor_type=2 AND
t_xauthor.xauthor_role='editor' AND t_xauthor.refdb_id=1 ORDER BY
t_xauthor.xauthor_position
SELECT
t_author.author_name,t_author.author_lastname,t_author.author_firstname,t_author.author_middlename,t_author.author_suffix,t_xauthor.xauthor_role,
t_xauthor.author_id FROM t_author INNER JOIN t_xauthor ON
t_author.author_id=t_xauthor.author_id WHERE t_xauthor.xauthor_type=3 AND
t_xauthor.refdb_id=1 ORDER BY t_xauthor.xauthor_position
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='URL' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='PDF' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='FULLTEXT' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='RELATED' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='IMAGE' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
SELECT DISTINCT t_link.link_url FROM t_user,t_link INNER JOIN t_xlink ON
t_link.link_id=t_xlink.link_id WHERE t_xlink.xlink_type='DOI' AND
t_xlink.xlink_source='REFERENCE' AND t_xlink.xref_id=1 AND
((t_xlink.user_id=t_user.user_id AND t_user.user_name='123') OR
t_xlink.user_id=0)
command processing done, finish dialog now
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4
----------------------------------------------------------------------
Comment By: Markus Hoenicka (mhoenicka)
Date: 2008-04-27 21:47
Message:
Logged In: YES
user_id=85809
Originator: NO
Are you still using reference databases created with RefDB 0.9.8 or
earlier? As I cannot reproduce this problem here, I suspect your reference
database was not properly upgraded when moving from 0.9.8 to the current
version. The internal data representation has changed somewhat, and this
would nicely explain the problems you see. Please check carefully the
UPGRADING file which explains the background and the proper procedure to
upgrade. Let me know if the problem persists, or if you can reproduce it
with a fresh database created with 0.9.9 or later.
regards,
Markus
----------------------------------------------------------------------
Comment By: Damien Jade Duff (damienjadeduff)
Date: 2008-04-25 17:05
Message:
Logged In: YES
user_id=2066694
Originator: YES
Hi
I just noticed that this applies also to BOOK ris types (always) and GEN
ris types (when the author is inside the risx publication tag) - bibtex
generation is not giving back the author. Hope this is useful..
Peace
Damien
mycomp% refdbd -v
refdbd 1.0.0-pre1 built from svn revision 613 ***@mhoenicka.de
You may redistribute and modify this software under the terms of the GNU
General Public License.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1951049&group_id=26091