phpweb interface HAS a problem for me, and for you ?

This time, i've done extensive tests but without more luck for getting 
all phpweb functions working.

Here is in detail the procedure:
1 - I've uncompressed and installed refdb

2 - i've used the manual setup to install it, using SQLITE as a client 
to avoid any database interference problem

3 - using refdba and refdbc i can connect to my refdb database (foo) and 
perform searches, adding and deletions.

4 - using the phpweb interface (i've checked my phpini parameters were 
there using phpinfo, apache has the good setup for refdb, i used 
mod_php5 + php_session), i can use some functions:
	* i can do some search (for instance Wang,J.P.) if the match is exact 
(it seems :AU:=Wang,J.P works, :AU:~Wang,J.P doesn't)
	* i'm not able to add references, edit them or remove them.

On the web server log, i see 'select failed'.

I tried to run the refdbc in a debug mode (as staed in the manual) and 
here are two logs where the query failed or was correct:
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Failed query:
$$$$$$$$$$$$$
sqlite
/usr/local/var/lib/refdb/db

foo
SELECT meta_app,meta_type,meta_dbversion from t_meta
connected to database server using database:
foo
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_misc1, t_refdb.refdb_misc2, t_refdb.refdb_misc3, 
t_refdb.refdb_citekey FROM t_refdb WHERE refdb_type!='DUMMY' AND ALL 
:AU:~Wang ORDER BY t_refdb.refdb_id


select failed
child finished client on fd 5
child exited with code 1
server waiting n_max_fd=4

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Correct query:
$$$$$$$$$$$$$$

sqlite
/usr/local/var/lib/refdb/db

foo
SELECT meta_app,meta_type,meta_dbversion from t_meta
connected to database server using database:
foo
no character encoding conversion required
output encoding is:
UTF-8
SELECT DISTINCT t_xauthor.refdb_id FROM t_xauthor, t_author WHERE 
t_author.author_id=t_xauthor.author_id AND t_xauthor.xauthor_type=1 AND 
t_author.author_name = 'Wang,J.P.'
An invalid or out-of-range index was passed to libdbi
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_id IN (1) ORDER BY t_refdb.refdb_id
An invalid or out-of-range index was passed to libdbi
command processing done, finish dialog now
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

In both case, there is the warning :
""An invalid or out-of-range index was passed to libdbi""

But i may have missed something else ...

If you find something more, i have all the logs, but i don't want to 
post them on the list until needed.

I've included as attachment some further information (the above logs + 
refdbc trace, installed rpm for apache) just in case.

Any hint ?

BTW, since it is not a packaging issue, i'll release very soon the rpm 
for refdb ;-)

Stéphane

-- 
Stéphane Téletchéa, PhD.                  http://www.steletch.org
Unité Mathématique Informatique et Génome http://migale.jouy.inra.fr/mig
INRA, Domaine de Vilvert                  Tél : (33) 134 652 891
78352 Jouy-en-Josas cedex, France         Fax : (33) 134 652 901

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV