cvs: phpdoc /en/reference/sqlite reference.xml

nlopess Tue Feb 15 13:29:05 2005 EDT Modified files: /phpdoc/en/reference/sqlite reference.xml Log: fix #30955: TMP windows envar. based on patch by danielc at analysisandsolutions dot com http://cvs.php.net/diff.php/phpdoc/en/reference/sqlite/reference.xml?r1=1.14&r2=1.15&ty=u Index: phpdoc/en/reference/sqlite/reference.xml diff -u phpdoc/en/reference/sqlite/reference.xml:1.14 phpdoc/en/reference/sqlite/reference.xml:1.15 --- phpdoc/en/reference/sqlite/reference.xml:1.14 Sun Feb 13 23:13:16 2005 +++ phpdoc/en/reference/sqlite/reference.xml Tue Feb 15 13:29:02 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <reference id="ref.sqlite"> <title>SQLite Functions</title> <titleabbrev>SQLite</titleabbrev> @@ -42,6 +42,43 @@ In PHP 5, the SQLite extension and the engine itself are bundled and compiled by default. </para> + <note> + <title>Windows installation for unprivilged accounts</title> + <para> + On Windows operating systems, unprivilged accounts doesn't have the + <varname>TMP</varname> environment variable set by default. This will + make sqlite create temporary files in the windows directory, which isn't + good. So, you should set the <varname>TMP</varname> environment variable + for the web server or the user account the web server is running under. + If Apache is your web server, you can accomplish this via a + <command>SetEnv</command> directive in your &httpd.conf; file. For + example: + <informalexample> + <programlisting role="apache-conf"> +<![CDATA[ +SetEnv TMP c:/temp +]]> + </programlisting> + </informalexample> + If you are unable to establish this setting at the server + level, you can implement the setting in your script: + <informalexample> + <programlisting role="php"> +<![CDATA[ +putenv('TMP=C:/temp'); +]]> + </programlisting> + </informalexample> + The setting must refer to a directory that the web server + has permission to create files in and subsequently write + to and delete the files it created. + Otherwise, you may receive the following error message: + <computeroutput> + malformed database schema - + unable to open a temporary database file for storing temporary tables + </computeroutput> + </para> + </note> </section> <section id="sqlite.requirements"> &reftitle.required;