Re: PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE
| From: | Christiane Schmidt-Köster | Date: | Fri, 12 Jan 2001 18:14:37 +0000 |
| Subject: | Re: PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-43910@lists.php.net to get a copy of this message | ||
No, I didn't.
I've also got an old version of PHP 4.0.2 installed and I can switch
between both versions via ScriptAlias in httpd.conf (php.ini is still the
same). With PHP 4.0.2 it's all working fine but with PHP 4.0.4 there is
that problem.
Christiane
----- Original Message -----
From: "Bug Database" <php-dev@lists.php.net>
To: <c.schmidt-koester@gmx.net>
Sent: Friday, January 12, 2001 2:14 PM
Subject: PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE
> ID: 7244
> Updated by: cynic
> Reported By: c.schmidt-koester@gmx.net
> Old-Status: Open
> Status: Feedback
> Bug Type: MySQL related
> Assigned To:
> Comments:
>
> did you switch by any chance from php.ini-dist to php.ini-optimized when
you upgraded your PHP to 4.0.3?
>
> Previous Comments:
> ------------------------------------------------------------------------
---
>
> [2001-01-04 11:02:07] eschmid@php.net
> No, the original problem persists. Adding addslashes is only a temporary
solution. This breaks some existing programs.
>
> -Egon
>
> ------------------------------------------------------------------------
---
>
> [2001-01-04 10:52:10] derick@php.net
> User reported that it works if he does:
> $file = addslashes ($file)
>
> So this was a user error.
>
> ------------------------------------------------------------------------
---
>
> [2001-01-04 10:41:56] c.schmidt-koester@gmx.net
> With
>
> $file = addslashes ($file);
>
> it works.
>
> ------------------------------------------------------------------------
---
>
> [2000-10-16 10:51:25] c.schmidt-koester@gmx.net
> I'm using Win98, Apache 1.3.9, MySQL 3.23-beta and PHP4.0.3.
>
> Since PHP4.0.3 there is a problem with import data to MySQL (LOAD DATA
LOCAL INFILE). It seems that PHP is filtering out all slashes of the file
path, so MySQL can't find the file.
>
> mysql_error() and mysql_errno() say something like this
>
> "File 'e:TempphpA154.TMP' not found (Errcode: 2)"
>
> LOAD DATA INFILE (without LOCAL) seems to be ok.
>
> ------------------------------------------------------------------------
---
>
>
> Full Bug description available at: http://bugs.php.net/?id=7244
>