On Jun 10, 2008, at 5:24 PM, maximi wrote: > > Hi > im using php in a webapp to access a sqlite database. now since > hours i'm > confronted with a weird error: > > i can access my database just fine, as long as i use commands as > simple as > "select * from testtable where a='b'" > as soon as there comes any 'distinct' or 'order by' or 'group by' > into play, > i always get the error "unable to open database file", error number > is 14 > (which should be just that) and there is another error code: hy000 > > anybody an idea?? >
Probably it is unable to open a temporary file in /tmp or /var/tmp or wherever temporary files are suppose to live on your system. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users