Bug #7244 Updated: Problem with LOAD DATA LOCAL INFILE

ID: 7244 Updated by: sniper Reported By: c.schmidt-koester@gmx.net Old Status: Open Status: Feedback Bug Type: MySQL related Operating System: Win 98 PHP Version: 4.0.8 New Comment: Could you please add a diff to the php.ini-dist against the php.in you're running PHP with? Previous Comments: ------------------------------------------------------------------------ [2001-11-26 14:01:53] c.schmidt-koester@gmx.net In privious releases addslashes() was not necessary. Even phpMyAdmin got problems and had to be changed. ------------------------------------------------------------------------ [2001-11-25 18:21:39] sniper@php.net I'm just wondering why is using addslashes() 'temporary solution' ?? ------------------------------------------------------------------------ [2001-11-25 08:14:04] c.schmidt-koester@gmx.net Like I wrote in my first bug report on 2000-10-16 mysql_error() and mysql_errno() say something like this "File 'e:TempphpA154.TMP' not found (Errcode: 2)" You can see that all slashes in the temporary filename are removed what causes a problem. ------------------------------------------------------------------------ [2001-11-24 21:03:40] mfischer@php.net What was the problem with the RC? And, this is query, but what is the actual *ERROR* you get? mysql_error() might tell you more. Feedback. ------------------------------------------------------------------------ [2001-11-24 14:30:46] c.schmidt-koester@gmx.net > Can you please test if the problem still persists with > latest RC? > http://phpuk.org/~james/php-4.1.0RC3-win32.zip I'm sorry, but I wasn't able to get this version running. I tried with the latest stable release 4.0.8 and the problem was still there. > If not, can you provide more details (like the actual > query you are using). The query is: LOAD DATA LOCAL INFILE '$textfile' INTO TABLE $table ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/?id=7244 Edit this bug report at http://bugs.php.net/?id=7244&edit=1