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: Feedback Status: Open Bug Type: MySQL related Assigned To: Comments: user feedback: 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. Previous Comments: --------------------------------------------------------------------------- [2001-01-12 08:14:06] cynic@php.net did you switch by any chance from php.ini-dist to php.ini-optimized when you upgraded your PHP to 4.0.3? --------------------------------------------------------------------------- [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. --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. Full Bug description available at: http://bugs.php.net/?id=7244