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

Hi,

Stéphane Téletchéa writes:
 > 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.

Both of these work here. Where did you type these queries in?

 > sqlite
[...]
 > 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

I'm afraid this query was somehow entered incorrectly into the web
interface as the syntax of the SQL is all wrong. Moreover, if you use
SQLite as backend, the SQL syntax for a regular expression match is
"LIKE", not "~". 

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

This warning is somewhat familiar, but I thought we got rid of it long
ago. Which libdbi version do you use?

regards,
Markus

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-------------------------------------------------------------------------
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