I can, but doesn't there exists an another way?
> I believe you can specify the directory in which temporary files will be > created. This is done with pragma temp_store_directory. I think you > can also set this in compilation. > > Artur Reilin wrote: >> >>> >>> On 19 Nov 2009, at 8:05am, Artur Reilin wrote: >>> >>>> My host have sqlite support vor sqlite 2.8.17 and i can use it. But i >>>> have >>>> to give chMod 0777 to the directory where i use sqlite. Not only on >>>> the >>>> directory, that contains the sqlite database. let me show it: >>>> >>>> /index.php (uses sqlite database) >>>> /data/data.sqlite (sqlite database) >>>> >>>> If i give chMod 0777 to /data/ and the files in this folder, it >>>> wouldn't >>>> work and get me an "malformed database - cannot create temp tables". >>>> >>>> I need to gibe chMod to the directory which contains the index.php >>>> file. >>>> That's a big security risk and i don't want to give chMod to the main >>>> directory. >>>> >>>> Is this normal and can i change this? >>> >>> You do not actually need 0777. Your problem is that the user which is >>> creating and using the database is the user that runs Apache, not >>> yourself. So find out which user Apache runs under. This might be >>> perhaps www or _www or _apache. Make sure that that user has the >>> rights >>> over this directory. Then Apache (running the .php script) which have >>> enough access to use the database file. >>> >>> Simon. >> >> The user which runs php (or has the highest rights) is called nobody. >> The >> support said me, that i need to set the directory to this user, but it >> also don't work. I get the same error as before. I can try it again, but >> the last time it didn't work. >> >> I also wondering why my oop version of my script didn't work, but the >> prozedural one does. They have pdo drivers like mine xampp server, but >> they don't have the sqlite3 drivers. Perhaps this also happens because >> of >> the malformed database error... >> >> With best wishes >> >> Artur Reilin >> sqlite.yuedream.de Artur Reilin sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users