With

$file = addslashes ($file);

it works.

User reported that it works if he does:

$file = addslashes ($file)



So this was a user error.

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

-Egon

did you switch by any chance from php.ini-dist to php.ini-optimized when you upgraded your PHP to 4.0.3?

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.

Does this happen with PHP 4.0.5 ?

Yes, it also happens with PHP 4.0.5

Can you please test if the problem still persists with latest RC?

http://phpuk.org/~james/php-4.1.0RC3-win32.zip

If not, can you provide more details (like the actual query you are using).

Feedback.

> 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

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.

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.

I'm just wondering why is using addslashes() 'temporary solution' ??

In privious releases addslashes() was not necessary. Even phpMyAdmin got problems and had to be changed.

Could you please add a diff to the php.ini-dist against the php.in
you're running PHP with?

I just tried with the original php.ini-dist and the problem is still there. Only the error message changes in "File 'c:win98tempphp130.tmp' not found (Errcode: 2)" due to the missing alternate upload_dir.

Same problem with PHP 4.1.0, Apache 1.3.22 and MySQL 3.21.29a under Win 98.
Action made with phpMyAdmin 2.2.2 and phpMyAdmin 2.0.3.

Please update PHP Version if you've tested with newer version :)

Is this still a problem with PHP 4.2.1?

Derick

Rather try the latest CVS snapshot build:

http://snaps.php.net/win32/php4-win32-latest.zip

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I am having a problem wich is likewise I think
Loading data from a windows host to a linux server

echo "<input type=\"hidden\" name=\"file1\" value=\"D:\gegevens.txt\">";

$file1 = str_replace("\\" , "\\\\", $file1);

$result=mysql_query ("LOAD DATA LOCAL INFILE '$file1' INTO TABLE agenda (plaats, activiteit)");

returns this: File 'D:\\gegevens.txt' not found (Errcode: 2)

If I do the same on the mysql server wich runs on windows at home and type in the mysql monitor:

load data local infile 'D:\\gegevens.txt' into table agenda;

everything works fine.

So the location with the extra backslash should work....


I spend a lot of time on this and tried about everything and can't figure it out.

I had the same problem, and this works me:

LOAD DATA LOCAL INFILE "c:/MYSQL/file.txt" INTO TABLE $table FIELDS TERMINATED BY ';'