ID: 30955 User updated by: danielc at analysisandsolutions dot com Reported By: danielc at analysisandsolutions dot com -Status: Feedback +Status: Open Bug Type: Documentation problem Operating System: Windows PHP Version: Irrelevant New Comment:
I'm talking about Windows 2000 Pro and XP Pro. TEMP _might_ be set if the web server is running under the SYSTEM account. But if the web server service is running under an unprivilged user account TEMP isn't automatically available. If TEMP isn't set, the sqlite extension goes to write the temporary files into the windows directory. Not a good idea. Previous Comments: ------------------------------------------------------------------------ [2004-12-02 18:59:53] [EMAIL PROTECTED] But windows *always* set the TEMP var by default, doesn't it? I never had such problems on windows... To which version of windows are you refering to? Windows 9x? ------------------------------------------------------------------------ [2004-12-02 02:45:47] danielc at analysisandsolutions dot com Description: ------------ If the TEMP environment variable isn't set and the computer in question has some semblance of security, the following error comes up: malformed database schema - unable to open a temporary database file for storing temporary tables This is a common problem that has been asked in various forums. Here is a documentation patch to explain what needs to be done in order to get SQLite to work on secure Windows machines: http://www.analysisandsolutions.com/php/sqlitetemp.diff Thanks. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30955&edit=1