PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE
| From: | derick@php.net | Date: | Thu, 04 Jan 2001 15:52:10 +0000 |
| Subject: | PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-42941@lists.php.net to get a copy of this message | ||
ID: 7244
Updated by: derick
Reported By: c.schmidt-koester@gmx.net
Old-Status: Open
Status: Closed
Bug Type: MySQL related
Assigned To:
Comments:
User reported that it works if he does:
$file = addslashes ($file)
So this was a user error.
Previous Comments:
---------------------------------------------------------------------------
[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