[PHP-DEV] PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE From: eschmid <email protected>
Date: 01/04/01

ID: 7244
Updated by: eschmid
Reported By: c.schmidt-koester <email protected>
Old-Status: Closed
Status: Open
Bug Type: MySQL related
Assigned To:
Comments:

No, the original problem persists. Adding addslashes is only a temporary solution. This breaks some existing programs.

-Egon

Previous Comments:
---------------------------------------------------------------------------

[2001-01-04 10:52:10] derick <email protected>
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 <email protected>
With

$file = addslashes ($file);

it works.

---------------------------------------------------------------------------

[2000-10-16 10:51:25] c.schmidt-koester <email protected>
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 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>