I am having a problem with some legacy code that won't work properly due to a mysql error
This code is used once a month to upload sales data on my dedicated server. Last month it worked fine. Since then I have updated my server using cpanel. My system shows that I am using mysql 3.23.49 and PHP 4.3.10
I get the error = line 165 Can't get stat of '/home/xxxxxx/public_html/PHP/Brick/xxx Sales Feb05.txt' (Errcode: 13)
The file is there and the file permissions are set to 777
The code is:
$result_load_file= mysql_query("LOAD DATA INFILE '/home/xxxxx/public_html/PHP/xxx/$file_nm' INTO TABLE $db.ld_data ($td)",$conn) or die(" line 165 ".mysql_error());
$file_nm holds the correct file name.
I have to assume that this is due to a change in my mysql version. It worked fine last month. I upload the files for several organizations. Because of differences in the data structure of their files, I use a separate program for each. All fail at this same code.
I could only find some references to this problem from 2000 and 2001 when I searched the forums.
If you have a fix or suggestion, I would really appreciate getting it.
Brian
