Re: Cannot add reference.

Wei-Wei Guo <[email protected]> Tue, 05 May 2009 22:52:39 +0800

Newsgroups	gmane.text.refdb.general
Message-ID	<[email protected]>

Markus Hoenicka 写道:
> Wei-Wei Guo writes:
>  > Do you mean patches for refdb-0.9.9-1.tar.gz? I can do that.
>  > 
> 
> I've appended a simple patch for one of the source files to provide
> additional debug output. Please apply the patch to the sources with a
> command like:
> 
> patch < refdbdref.c.patch
> 

The patch cannot be applied, so I open refdbdref.c and changed it by hand.

$ patch < refdbdref.c.patch
patching file refdbdref.c
Hunk #1 succeeded at 2114 (offset 1 line).
Hunk #2 FAILED at 2142.
1 out of 2 hunks FAILED -- saving rejects to file refdbdref.c.rej


> from within the src subdirectory of the source tree. Then please
> rebuild this directory and install it, or (whichever is easier for
> you), run the server as a regular app from the src directory, like
> this:
> 
> ./refdbd -s [other options]
> 

Cause I don't know how make install will affect the system consistence,
I just repack the refdb-0.9.9-1.tar.gz with the modified refdbdref.c and
rebuild it by Gentoo emerge. And I run refdb by "/etc/init.d refdb start".
Is what I have done ok?


> Then repeat your "add references" test from another xterm, and send
> the refdbd log. Just ask if anything is unclear, I'll be happy to
> help.

I repeat the process I did before. The refdbd.log is gotten by remove the
old one first and run the test second. It's verbose than the ones get in
previous tests. See the attachment.

BTW. I'm moving flat in those days, so my feedback might be a little late.
Sorry for that.


Best wishes,
Wei-Wei

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com

_______________________________________________
Refdb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/refdb-users

refdbd.log (text/plain, 37.6 KB)

7:pid=2885:Tue May 05 14:37:54 2009:dbi_driver_dir went to:
7:pid=2885:Tue May 05 14:37:54 2009:
7:pid=2885:Tue May 05 14:37:54 2009:dbi is up using default driver dir
6:pid=2885:Tue May 05 14:37:54 2009:Available libdbi database drivers:
6:pid=2885:Tue May 05 14:37:54 2009:sqlite3
6:pid=2885:Tue May 05 14:37:54 2009:Requested libdbi driver found
6:pid=2885:Tue May 05 14:37:54 2009:Database directory:
6:pid=2885:Tue May 05 14:37:54 2009:/home/wwguo/studio/science/biblio
6:pid=2885:Tue May 05 14:37:54 2009:application server started
6:pid=2885:Tue May 05 14:37:54 2009:share extended notes by default
7:pid=2885:Tue May 05 14:37:54 2009:use /tmp/refdbd_fifo2885 as fifo
6:pid=2885:Tue May 05 14:37:54 2009:server waiting n_max_fd=5
6:pid=2885:Tue May 05 14:38:41 2009:adding client 127.0.0.1 on fd 6
6:pid=2885:Tue May 05 14:38:41 2009:server waiting n_max_fd=6
7:pid=3233:Tue May 05 14:38:41 2009:try to read from client
6:pid=3233:Tue May 05 14:38:41 2009:serving client on fd 6 with protocol version 6
7:pid=3233:Tue May 05 14:38:41 2009:201-75-34-40
7:pid=3233:Tue May 05 14:38:41 2009:send pseudo-random string to client
7:pid=3233:Tue May 05 14:38:41 2009:createdb wwguodb -u root
6:pid=3233:Tue May 05 14:38:41 2009:dbi is up
7:pid=3233:Tue May 05 14:38:41 2009:localhost
7:pid=3233:Tue May 05 14:38:41 2009:root
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:sqlite3
7:pid=3233:Tue May 05 14:38:41 2009:/home/wwguo/studio/science/biblio
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:refdb
7:pid=3233:Tue May 05 14:38:41 2009:connected to database server using database:
7:pid=3233:Tue May 05 14:38:41 2009:refdb
6:pid=3233:Tue May 05 14:38:41 2009:updated version file:
3:pid=3233:Tue May 05 14:38:41 2009:/home/wwguo/studio/science/biblio/DB_VERSION
7:pid=3233:Tue May 05 14:38:41 2009:Main database looks ok:
7:pid=3233:Tue May 05 14:38:41 2009:refdb
7:pid=3233:Tue May 05 14:38:41 2009:localhost
7:pid=3233:Tue May 05 14:38:41 2009:root
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:sqlite3
7:pid=3233:Tue May 05 14:38:41 2009:/home/wwguo/studio/science/biblio
7:pid=3233:Tue May 05 14:38:41 2009:UTF-8
7:pid=3233:Tue May 05 14:38:41 2009:refdb
7:pid=3233:Tue May 05 14:38:41 2009:connected to database server using database:
7:pid=3233:Tue May 05 14:38:41 2009:refdb
4:pid=3233:Tue May 05 14:38:41 2009:database engine does not support per-database character encodings, used default encoding instead
7:pid=3233:Tue May 05 14:38:41 2009:localhost
7:pid=3233:Tue May 05 14:38:41 2009:root
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:
7:pid=3233:Tue May 05 14:38:41 2009:sqlite3
7:pid=3233:Tue May 05 14:38:41 2009:/home/wwguo/studio/science/biblio
7:pid=3233:Tue May 05 14:38:41 2009:UTF-8
7:pid=3233:Tue May 05 14:38:41 2009:wwguodb
7:pid=3233:Tue May 05 14:38:41 2009:connected to database server using database:
7:pid=3233:Tue May 05 14:38:41 2009:wwguodb
7:pid=3233:Tue May 05 14:38:41 2009:CREATE TABLE t_meta (meta_app VARCHAR(20),meta_type VARCHAR(20),meta_version VARCHAR(20),meta_dbversion SMALLINT,meta_create_date DATETIME,meta_modify_date DATETIME)
7:pid=3233:Tue May 05 14:38:41 2009:CREATE TABLE t_refdb (refdb_id INTEGER PRIMARY KEY,refdb_citekey TEXT UNIQUE,refdb_type TEXT,refdb_pubyear SMALLINT,refdb_secyear SMALLINT,refdb_startpage TEXT,refdb_endpage TEXT,refdb_abstract TEXT,refdb_title TEXT,refdb_volume TEXT,refdb_issue TEXT,refdb_booktitle TEXT,refdb_city TEXT,refdb_publisher TEXT,refdb_title_series TEXT,refdb_address TEXT,refdb_issn TEXT,refdb_pyother_info TEXT,refdb_secother_info TEXT,refdb_periodical_id BIGINT,refdb_user1 TEXT,refdb_user2 TEXT,refdb_user3 TEXT,refdb_user4 TEXT,refdb_user5 TEXT,refdb_typeofwork TEXT,refdb_area TEXT,refdb_ostype TEXT,refdb_degree TEXT,refdb_runningtime TEXT,refdb_classcodeintl TEXT,refdb_classcodeus TEXT,refdb_senderemail TEXT,refdb_recipientemail TEXT,refdb_mediatype TEXT,refdb_numvolumes TEXT,refdb_edition TEXT,refdb_computer TEXT,refdb_conferencelocation TEXT,refdb_registrynum TEXT,refdb_classification TEXT,refdb_section TEXT,refdb_pamphletnum TEXT,refdb_chapternum TEXT)
7:pid=3233:Tue May 05 14:38:41 2009:CREATE INDEX i_refdb_pubyear ON t_refdb (refdb_pubyear)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE UNIQUE INDEX i_refdb_citekey ON t_refdb (refdb_citekey)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_author (author_id INTEGER PRIMARY KEY,author_name TEXT NOT NULL,author_lastname TEXT,author_firstname TEXT,author_middlename TEXT,author_suffix TEXT)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_author_name ON t_author (author_name)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_keyword (keyword_id INTEGER PRIMARY KEY,keyword_name TEXT NOT NULL)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_keyword_name ON t_keyword (keyword_name)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_periodical (periodical_id INTEGER PRIMARY KEY,periodical_name TEXT,periodical_abbrev TEXT,periodical_custabbrev1 TEXT,periodical_custabbrev2 TEXT)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_periodical_name ON t_periodical (periodical_name)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_periodical_abbrev ON t_periodical (periodical_abbrev)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_periodical_custabbrev1 ON t_periodical (periodical_custabbrev1)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_periodical_custabbrev2 ON t_periodical (periodical_custabbrev2)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_note (note_id INTEGER PRIMARY KEY,note_key TEXT UNIQUE,note_title TEXT,note_content_type TEXT,note_content_xmllang TEXT,note_user_id BIGINT,note_date DATE,note_share SMALLINT,note_content TEXT)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_note_title ON t_note (note_title)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_note_note_userid ON t_note (note_user_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_note_date ON t_note (note_date)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_user (user_id INTEGER PRIMARY KEY,user_name TEXT NOT NULL)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_user_name ON t_user (user_name)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_link (link_id INTEGER PRIMARY KEY,link_url TEXT NOT NULL)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_link_url ON t_link (link_url)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_xauthor (xauthor_id INTEGER PRIMARY KEY,author_id BIGINT NOT NULL,refdb_id BIGINT NOT NULL,xauthor_type SMALLINT DEFAULT 1,xauthor_role TEXT,xauthor_position INTEGER)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xauthor_autid ON t_xauthor (author_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xauthor_refid ON t_xauthor (refdb_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_xkeyword (xkeyword_id INTEGER PRIMARY KEY,xkeyword_type TEXT,keyword_id BIGINT NOT NULL,xref_id BIGINT NOT NULL)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xkeyword_kwid ON t_xkeyword (keyword_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xkeyword_xrefid ON t_xkeyword (xref_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_xuser (xuser_id INTEGER PRIMARY KEY,user_id BIGINT NOT NULL,refdb_id BIGINT NOT NULL,xuser_reprint TEXT DEFAULT 'NOT IN FILE',xuser_date DATE,xuser_avail TEXT,xuser_notes TEXT)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xuser_userid ON t_xuser (user_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xuser_refid ON t_xuser (refdb_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_xnote (xnote_id INTEGER PRIMARY KEY,note_id BIGINT NOT NULL,xref_id BIGINT NOT NULL,xnote_type TEXT DEFAULT 'REFERENCE')
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xnote_noteid ON t_xnote (note_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xnote_xrefid ON t_xnote (xref_id)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE INDEX i_xnote_xnotetype ON t_xnote (xnote_type)
7:pid=3233:Tue May 05 14:38:42 2009:CREATE TABLE t_xlink (xlink_id INTEGER PRIMARY KEY,link_id BIGINT NOT NULL,xref_id BIGINT NOT NULL,user_id BIGINT DEFAULT 0,xlink_type TEXT DEFAULT 'URL',xlink_source TEXT DEFAULT 'REFERENCE')
7:pid=3233:Tue May 05 14:38:43 2009:CREATE INDEX i_xlink_linkid ON t_xlink (link_id)
7:pid=3233:Tue May 05 14:38:43 2009:CREATE INDEX i_xlink_xrefid ON t_xlink (xref_id)
7:pid=3233:Tue May 05 14:38:43 2009:CREATE INDEX i_xlink_xlinktype ON t_xlink (xlink_type)
7:pid=3233:Tue May 05 14:38:43 2009:CREATE INDEX i_xlink_xlinksource ON t_xlink (xlink_source)
7:pid=3233:Tue May 05 14:38:43 2009:INSERT INTO t_meta (meta_app,meta_type,meta_version,meta_dbversion,meta_create_date,meta_modify_date) VALUES ('refdb', 'risx', '0.9.9-1', '4', '2009-05-05 14:38:43', '2009-05-05 14:38:43')
7:pid=3233:Tue May 05 14:38:43 2009:command processing done, finish dialog now
6:pid=3233:Tue May 05 14:38:43 2009:child finished client on fd 6
6:pid=2885:Tue May 05 14:38:41 2009:parent removing client on fd 6
6:pid=2885:Tue May 05 14:38:41 2009:server waiting n_max_fd=5
6:pid=2885:Tue May 05 14:38:43 2009:child exited with code 0
6:pid=2885:Tue May 05 14:38:43 2009:server waiting n_max_fd=5
6:pid=2885:Tue May 05 14:39:04 2009:adding client 127.0.0.1 on fd 6
6:pid=2885:Tue May 05 14:39:04 2009:server waiting n_max_fd=6
7:pid=3239:Tue May 05 14:39:04 2009:try to read from client
6:pid=3239:Tue May 05 14:39:04 2009:serving client on fd 6 with protocol version 6
7:pid=3239:Tue May 05 14:39:04 2009:102-75-77-27
7:pid=3239:Tue May 05 14:39:04 2009:send pseudo-random string to client
7:pid=3239:Tue May 05 14:39:04 2009:addref  -u wwguo -d wwguodb -A ris -E UTF-8 -G /usr/share/refdb/css/refdb.css
6:pid=3239:Tue May 05 14:39:04 2009:dbi is up
7:pid=3239:Tue May 05 14:39:04 2009:localhost
7:pid=3239:Tue May 05 14:39:04 2009:wwguo
7:pid=3239:Tue May 05 14:39:04 2009:
7:pid=3239:Tue May 05 14:39:04 2009:wwguodb
7:pid=3239:Tue May 05 14:39:04 2009:
7:pid=3239:Tue May 05 14:39:04 2009:sqlite3
7:pid=3239:Tue May 05 14:39:04 2009:/home/wwguo/studio/science/biblio
7:pid=3239:Tue May 05 14:39:04 2009:UTF-8
7:pid=3239:Tue May 05 14:39:04 2009:refdb
7:pid=3239:Tue May 05 14:39:04 2009:connected to database server using database:
7:pid=3239:Tue May 05 14:39:04 2009:refdb
7:pid=3239:Tue May 05 14:39:04 2009:Main database looks ok:
7:pid=3239:Tue May 05 14:39:04 2009:refdb
7:pid=3239:Tue May 05 14:39:04 2009:localhost
7:pid=3239:Tue May 05 14:39:04 2009:wwguo
7:pid=3239:Tue May 05 14:39:04 2009:
7:pid=3239:Tue May 05 14:39:04 2009:wwguodb
7:pid=3239:Tue May 05 14:39:04 2009:
7:pid=3239:Tue May 05 14:39:04 2009:sqlite3
7:pid=3239:Tue May 05 14:39:04 2009:/home/wwguo/studio/science/biblio
7:pid=3239:Tue May 05 14:39:04 2009:UTF-8
7:pid=3239:Tue May 05 14:39:04 2009:wwguodb
7:pid=3239:Tue May 05 14:39:04 2009:SELECT meta_app,meta_type,meta_dbversion FROM t_meta WHERE meta_type='risx'
7:pid=3239:Tue May 05 14:39:04 2009:connected to database server using database:
7:pid=3239:Tue May 05 14:39:04 2009:wwguodb
7:pid=3239:Tue May 05 14:39:04 2009:no character encoding conversion required
7:pid=3239:Tue May 05 14:39:04 2009:database encoding is:
7:pid=3239:Tue May 05 14:39:04 2009:UTF-8
7:pid=3239:Tue May 05 14:39:04 2009:localhost
7:pid=3239:Tue May 05 14:39:04 2009:wwguo
7:pid=3239:Tue May 05 14:39:04 2009:
7:pid=3239:Tue May 05 14:39:04 2009:wwguodb
7:pid=3239:Tue May 05 14:39:04 2009:
7:pid=3239:Tue May 05 14:39:04 2009:sqlite3
7:pid=3239:Tue May 05 14:39:04 2009:/home/wwguo/studio/science/biblio
7:pid=3239:Tue May 05 14:39:04 2009:UTF-8
7:pid=3239:Tue May 05 14:39:04 2009:refdb
7:pid=3239:Tue May 05 14:39:04 2009:connected to database server using database:
7:pid=3239:Tue May 05 14:39:04 2009:refdb
7:pid=3239:Tue May 05 14:39:04 2009:BEGIN
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_user (user_name) VALUES ('wwguo')
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,1)
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=1
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_note (note_key, note_title, note_user_id, note_date, note_share) VALUES ('wwguo-wwguo', 'wwguo-wwguo', 1, '2009-05-05', 0)
7:pid=3239:Tue May 05 14:39:04 2009:new n_list_id went to 1
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id from t_refdb WHERE refdb_citekey='DUMMYwhiz3239'
7:pid=3239:Tue May 05 14:39:04 2009:SELECT xnote_id FROM t_xnote WHERE note_id=1 AND xnote_type='REFERENCE' AND xref_id=1
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xnote (note_id, xref_id, xnote_type) VALUES (1, 1, 'REFERENCE')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT author_id FROM t_author WHERE author_name='Wang,J.P.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_author (author_name, author_lastname, author_firstname, author_middlename, author_suffix) VALUES ('Wang,J.P.','Wang','J','P',NULL)
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xauthor (author_id, refdb_id, xauthor_type, xauthor_position, xauthor_role) VALUES (1, 1, 1, 0, 'author')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT author_id FROM t_author WHERE author_name='Chang,L.C.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_author (author_name, author_lastname, author_firstname, author_middlename, author_suffix) VALUES ('Chang,L.C.','Chang','L','C',NULL)
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xauthor (author_id, refdb_id, xauthor_type, xauthor_position, xauthor_role) VALUES (2, 1, 1, 1, 'author')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT author_id FROM t_author WHERE author_name='Raung,S.L.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_author (author_name, author_lastname, author_firstname, author_middlename, author_suffix) VALUES ('Raung,S.L.','Raung','S','L',NULL)
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xauthor (author_id, refdb_id, xauthor_type, xauthor_position, xauthor_role) VALUES (3, 1, 1, 2, 'author')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT author_id FROM t_author WHERE author_name='Hsu,M.F.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_author (author_name, author_lastname, author_firstname, author_middlename, author_suffix) VALUES ('Hsu,M.F.','Hsu','M','F',NULL)
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xauthor (author_id, refdb_id, xauthor_type, xauthor_position, xauthor_role) VALUES (4, 1, 1, 3, 'author')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT author_id FROM t_author WHERE author_name='Huang,L.J.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_author (author_name, author_lastname, author_firstname, author_middlename, author_suffix) VALUES ('Huang,L.J.','Huang','L','J',NULL)
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xauthor (author_id, refdb_id, xauthor_type, xauthor_position, xauthor_role) VALUES (5, 1, 1, 4, 'author')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT author_id FROM t_author WHERE author_name='Kuo,S.C.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_author (author_name, author_lastname, author_firstname, author_middlename, author_suffix) VALUES ('Kuo,S.C.','Kuo','S','C',NULL)
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xauthor (author_id, refdb_id, xauthor_type, xauthor_position, xauthor_role) VALUES (6, 1, 1, 5, 'author')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT name FROM t_journal_words WHERE name='BIOCHEM'
7:pid=3239:Tue May 05 14:39:04 2009:SELECT name FROM t_journal_words WHERE name='PHARMACOL'
7:pid=3239:Tue May 05 14:39:04 2009:SELECT periodical_id FROM t_periodical WHERE periodical_abbrev='Biochem.Pharmacol.'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_periodical (periodical_abbrev) VALUES ('Biochem.Pharmacol.')
7:pid=3239:Tue May 05 14:39:04 2009:UPDATE t_refdb SET refdb_periodical_id=1 WHERE refdb_id = 1
7:pid=3239:Tue May 05 14:39:04 2009:UPDATE t_xuser SET xuser_reprint = 'NOT IN FILE' WHERE refdb_id=1 AND user_id=1
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id FROM t_refdb WHERE refdb_citekey='Wang2002'
4:pid=3239:Tue May 05 14:39:04 2009:406:1:Wang2002

7:pid=3239:Tue May 05 14:39:04 2009:UPDATE t_refdb SET refdb_pubyear=2002, refdb_secyear=0, refdb_pyother_info='///Feb 15', refdb_secother_info=NULL, refdb_citekey='Wang2002', refdb_user1=NULL, refdb_user2=NULL, refdb_user3=NULL, refdb_user4=NULL, refdb_user5=NULL, refdb_typeofwork=NULL, refdb_area=NULL, refdb_ostype=NULL, refdb_degree=NULL, refdb_runningtime=NULL, refdb_classcodeintl=NULL, refdb_classcodeus=NULL, refdb_senderemail=NULL, refdb_recipientemail=NULL, refdb_mediatype=NULL, refdb_numvolumes=NULL, refdb_edition=NULL, refdb_computer=NULL, refdb_conferencelocation=NULL, refdb_registrynum=NULL, refdb_classification=NULL, refdb_section=NULL, refdb_pamphletnum=NULL, refdb_chapternum=NULL, refdb_issn=NULL, refdb_issue='4', refdb_publisher=NULL, refdb_city=NULL, refdb_volume='63', refdb_endpage='85', refdb_startpage='577', refdb_type='JOUR', refdb_abstract='3-(5''-Hydroxymethyl-2''-furyl)-1-benzyl indazole (YC-1), a soluble guanylyl cyclase (sGC) activator, inhibited formyl-methionyl-leucyl-phenylalanine (fMLP)-induced superoxide anion (O(2)*(-)) generation and O(2) consumption in rat neutrophils (IC(50) values of 12.7+/-3.1 and 17.7+/-6.9 microM, respectively). Inhibition of O(2)*(-) generation by YC-1 was partially reversed by the cyclic GMP-lowering agent 6-anilinoquinoline-5,8-quinone (LY83583) and by the Rp isomer of 8-(4-chlorophenylthio)guanosine-3'',5''-monophosphorothioate (Rp-8-pCPT-cGMPS), a cyclic GMP-dependent protein kinase inhibitor. In cell-free systems, YC-1 failed to alter O(2)*(-) generation during dihydroxyfumaric acid autoxidation, phorbol 12-myristate 13-acetate (PMA)-activated neutrophil particulate NADPH oxidase preparation, and arachidonic acid-induced NADPH oxidase activation. YC-1 increased cellular cyclic GMP levels through the activation of sGC and the inhibition of cyclic GMP-hydrolyzing phosphodiesterase activity. The plateau phase, but not the initial spike, of fMLP-induced [Ca(2+)](i) changes was inhibited by YC-1 (IC(50) about 15 microM). fMLP- but not PMA-induced phospholipase D activation was inhibited by YC-1 (IC(50) about 28 microM). Membrane-associated ADP-ribosylation factor and Rho A in cell activation was also reduced by YC-1 at a similar concentration range. Neither cytosolic protein kinase C (PKC) activity nor PKC membrane translocation was altered by YC-1. YC-1 did not affect either fMLP-induced phosphatidylinositol 3-kinase activation or p38 mitogen-activated protein kinase phosphorylation, but slightly attenuated the phosphorylation of extracellular signal-regulated kinase. Collectively, these results indicate that the inhibition of the fMLP-induced respiratory burst by YC-1 is mediated by cyclic GMP-dependent and -independent signaling mechanisms.', refdb_title='Inhibition of superoxide anion generation by YC-1 in rat neutrophils through cyclic GMP-dependent and -independent mechanisms', refdb_address='Department of Education and Research, Taichung Veterans General Hospital, 160 Chung Kang Road, Sec. 3, 407, ROC, Taichung, Taiwan. [email protected]' WHERE refdb_id=1
7:pid=3239:Tue May 05 14:39:04 2009:COMMIT
6:pid=3239:Tue May 05 14:39:04 2009:dataset added successfully
7:pid=3239:Tue May 05 14:39:04 2009:BEGIN
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:04 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:04 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:04 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:04 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:04 2009:BEGIN
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:04 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:04 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:04 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:04 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:04 2009:BEGIN
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:04 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:04 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:04 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:04 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:04 2009:BEGIN
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:04 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:04 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:04 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:04 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:04 2009:BEGIN
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:04 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:04 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:04 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:04 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:04 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:04 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:04 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:04 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_citekey='smith1975metalloporphyrins'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_citekey='Lewicki1995natriureticpeptidefamily'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:05 2009:BEGIN
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:05 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:05 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:05 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:05 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:05 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:05 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:05 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:05 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:06 2009:BEGIN
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:06 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:06 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:06 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:06 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:06 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:06 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:06 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:06 2009:BEGIN
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:06 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:06 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:06 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:06 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:06 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:06 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:06 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:06 2009:BEGIN
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:06 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:06 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:06 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:06 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:06 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:06 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:06 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:06 2009:BEGIN
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:06 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:06 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:06 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:06 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:06 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:06 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:06 2009:failed processing dataset
7:pid=3239:Tue May 05 14:39:06 2009:BEGIN
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES ('DUMMY','DUMMYwhiz3239')
7:pid=3239:Tue May 05 14:39:06 2009:SELECT user_id FROM t_user WHERE user_name='wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2)
7:pid=3239:Tue May 05 14:39:06 2009:SELECT refdb_id, refdb_citekey FROM t_refdb WHERE refdb_id=2
7:pid=3239:Tue May 05 14:39:06 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3239:Tue May 05 14:39:06 2009:n_list_owner_id went to 0
7:pid=3239:Tue May 05 14:39:06 2009:not owner of this list
4:pid=3239:Tue May 05 14:39:06 2009:inserting reference data failed
7:pid=3239:Tue May 05 14:39:06 2009:ROLLBACK
4:pid=3239:Tue May 05 14:39:06 2009:failed processing dataset
6:pid=3239:Tue May 05 14:39:06 2009:chunk added successfully
7:pid=3239:Tue May 05 14:39:06 2009:UPDATE t_meta SET meta_modify_date='2009-05-05 14:39:06' WHERE meta_type='risx'
7:pid=3239:Tue May 05 14:39:06 2009:command processing done, finish dialog now
7:pid=3239:Tue May 05 14:39:06 2009:localhost
7:pid=3239:Tue May 05 14:39:06 2009:wwguo
7:pid=3239:Tue May 05 14:39:06 2009:
7:pid=3239:Tue May 05 14:39:06 2009:wwguodb
7:pid=3239:Tue May 05 14:39:06 2009:
7:pid=3239:Tue May 05 14:39:06 2009:sqlite3
7:pid=3239:Tue May 05 14:39:06 2009:/home/wwguo/studio/science/biblio
7:pid=3239:Tue May 05 14:39:06 2009:UTF-8
7:pid=3239:Tue May 05 14:39:06 2009:wwguodb
7:pid=3239:Tue May 05 14:39:06 2009:SELECT meta_app,meta_type,meta_dbversion FROM t_meta WHERE meta_type='risx'
7:pid=3239:Tue May 05 14:39:06 2009:connected to database server using database:
7:pid=3239:Tue May 05 14:39:06 2009:wwguodb
7:pid=3239:Tue May 05 14:39:06 2009:SELECT * FROM t_keyword
6:pid=3239:Tue May 05 14:39:06 2009:child finished client on fd 6