#30955 [NEW]: PATCH: setting TEMP so SQLite will work on Windows

From: danielc at analysisandsolutions dot com Operating system: Windows PHP version: Irrelevant PHP Bug Type: Documentation problem Bug description: PATCH: setting TEMP so SQLite will work on Windows 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 bug report at http://bugs.php.net/?id=30955&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30955&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30955&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30955&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30955&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30955&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30955&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30955&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30955&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30955&r=support Expected behavior: http://bugs.php.net/fix.php?id=30955&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30955&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30955&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30955&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30955&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30955&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30955&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30955&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30955&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30955&r=mysqlcfg