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

I don't think this was meant, so I'll just point out the obvious (and leave it there, because I can't access CVS from here):

+      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.

3 things about that, first of all "unprivilged accounts" has a typo ;) secondly, that sentence isn't correct, I'd change "doesn't" to "don't" Then there's also the third and final comment on this from me; I think the wording of that piece of info sounds... well... wrong... it's mainly the "which isn't good" part that ticks me off... hope others agree, - tul Nuno Lopes wrote:

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;