PHP 4.0 Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE

ID: 7244 Updated by: eschmid Reported By: c.schmidt-koester@gmx.net 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@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