[Refdb-users] cannot add records!

[Diwaker G. <dg...@cs...>]

Hello,

I'm running refdb 0.9.3 using MySQL 4.0.22 as the backend. I installed 
and tested the installation as given in the manual without any problems. 
However, there are some issues:

1. I can add styles, and I can check (using raw sql) that the styles are 
indeed added to the CITSTYLE table. However, when I issue a liststyle, I 
get nothing. Ditto for listuser

2. Whenever I try to add a reference, I get an error from refdb saying:

refdbc: addref /tmp/diwaker/test.ris
try to add set as reference 2
update TY failed
Processing set 0 failed
0 dataset(s) added, 0 skipped, 1 failed
1 dataset(s) sent.

The log gives an error message like:
6:pid=24231:Tue Jan 20 02:24:15 2004:dbi is up
4:pid=24231:Tue Jan 20 02:24:15 2004:update TY failed
4:pid=24231:Tue Jan 20 02:24:15 2004:failed processing dataset
6:pid=24231:Tue Jan 20 02:24:15 2004:no IDs found for keyword scan

At other times, it gives an error saying "cannot lock tables"

3. I am facing several problems with the web interface. First of all, 
all the html files in refdb have absolute URLs (like 
"/refdbquery.html"). If I create an alias /refdb to refdb's html files, 
then no links work. Further, sometimes I get an error saying "error 
loading cgi templates"

I can use all the help! :)

Thanks
-- 
Diwaker Gupta
Graduate Student, Computer Sc. and Engg.
University of California, San Diego
<http://www.cse.ucsd.edu/users/dgupta>