[Refdb-users] Cannot add reference.

[Wei-Wei G. <ww...@gm...>]

Dear all,

I'm stuck in the first step when trying to get my RefDB working.
I cannot add reference.

I doesn't meet any error when run the command 'refdbc'.

Here is part of the log info. Every entry has a part of this.

    7:pid=3326:Sun Apr 26 16:51:49 2009:BEGIN
    7:pid=3326:Sun Apr 26 16:51:49 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=6
    6:pid=3326:Sun Apr 26 16:51:49 2009:ignore numerical ID
    7:pid=3326:Sun Apr 26 16:51:49 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3326')
    7:pid=3326:Sun Apr 26 16:51:49 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
    7:pid=3326:Sun Apr 26 16:51:49 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,3)
    7:pid=3326:Sun Apr 26 16:51:49 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=3
    7:pid=3326:Sun Apr 26 16:51:49 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
    4:pid=3326:Sun Apr 26 16:51:49 2009:inserting reference data failed
    7:pid=3326:Sun Apr 26 16:51:49 2009:ROLLBACK
    4:pid=3326:Sun Apr 26 16:51:49 2009:failed processing dataset

I tried the database with

    $ sqlite3 /home/wwguo/biblio/wwguodb
    sqlite> INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3326');

And it's works.

Here is my 'refdbdrc':

    # refdbdrc
    refdblib /usr/share/refdb
    main_db	refdb
    serverip	localhost
    dbsport		
    dbserver	sqlite3
    dbpath		/home/wwguo/studio/science/biblio
    port	9734
    logfile /var/log/refdbd.log
    logdest file
    loglevel debug
    pidfile		/var/run/refdbd.pid
    remoteadmin f
    remoteconnect f
    keep_pnames t
    keyword_scan t
    db_encoding	UTF-8
    in_encoding	UTF-8

My 'refdbcrc':

    # refdbcrc
    serverip	127.0.0.1
    port	9734
    pager	less
    username	wwguo
    passwd
    defaultdb	wwguodb
    logdest file
    loglevel info
    logfile /var/log/refdbc.log
    cssurl /usr/share/refdb/css/refdb.css
    fromencoding UTF-8
    toencoding UTF-8


Please give some help! Any suggestion is appreciated.

Best wishes,
Wei-Wei