[Refdb-users] phpweb interface HAS a problem for me, and for you ?

[<ste...@jo...>]

This time, i've done extensive tests but without more luck for getting=20
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=20
to avoid any database interference problem

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

4 - using the phpweb interface (i've checked my phpini parameters were=20
there using phpinfo, apache has the good setup for refdb, i used=20
mod_php5 + php_session), i can use some functions:
	* i can do some search (for instance Wang,J.P.) if the match is exact=20
(it seems :AU:=3DWang,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=20
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,=20
t_refdb.refdb_pubyear, t_refdb.refdb_startpage, t_refdb.refdb_endpage,=20
t_refdb.refdb_abstract, t_refdb.refdb_title, t_refdb.refdb_volume,=20
t_refdb.refdb_issue, t_refdb.refdb_booktitle, t_refdb.refdb_city,=20
t_refdb.refdb_publisher, t_refdb.refdb_title_series,=20
t_refdb.refdb_address, t_refdb.refdb_issn, t_refdb.refdb_periodical_id,=20
t_refdb.refdb_pyother_info, t_refdb.refdb_secyear,=20
t_refdb.refdb_secother_info, t_refdb.refdb_user1, t_refdb.refdb_user2,=20
t_refdb.refdb_user3, t_refdb.refdb_user4, t_refdb.refdb_user5,=20
t_refdb.refdb_misc1, t_refdb.refdb_misc2, t_refdb.refdb_misc3,=20
t_refdb.refdb_citekey FROM t_refdb WHERE refdb_type!=3D'DUMMY' AND ALL=20
: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=3D4

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
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=20
t_author.author_id=3Dt_xauthor.author_id AND t_xauthor.xauthor_type=3D1 A=
ND=20
t_author.author_name =3D 'Wang,J.P.'
An invalid or out-of-range index was passed to libdbi
SELECT DISTINCT t_refdb.refdb_id, t_refdb.refdb_type,=20
t_refdb.refdb_pubyear, t_refdb.refdb_startpage, t_refdb.refdb_endpage,=20
t_refdb.refdb_abstract, t_refdb.refdb_title, t_refdb.refdb_volume,=20
t_refdb.refdb_issue, t_refdb.refdb_booktitle, t_refdb.refdb_city,=20
t_refdb.refdb_publisher, t_refdb.refdb_title_series,=20
t_refdb.refdb_address, t_refdb.refdb_issn, t_refdb.refdb_periodical_id,=20
t_refdb.refdb_pyother_info, t_refdb.refdb_secyear,=20
t_refdb.refdb_secother_info, t_refdb.refdb_user1, t_refdb.refdb_user2,=20
t_refdb.refdb_user3, t_refdb.refdb_user4, t_refdb.refdb_user5,=20
t_refdb.refdb_misc1, t_refdb.refdb_misc2, t_refdb.refdb_misc3,=20
t_refdb.refdb_citekey FROM t_refdb WHERE refdb_type!=3D'DUMMY' AND=20
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=3D4
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

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=20
post them on the list until needed.

I've included as attachment some further information (the above logs +=20
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=20
for refdb ;-)

St=E9phane

--=20
St=E9phane T=E9letch=E9a, PhD.                  http://www.steletch.org
Unit=E9 Math=E9matique Informatique et G=E9nome http://migale.jouy.inra.f=
r/mig
INRA, Domaine de Vilvert                  T=E9l : (33) 134 652 891
78352 Jouy-en-Josas cedex, France         Fax : (33) 134 652 901