Re: Problem with LOAD_FILE

[leyonchung chun]

There could be several reasons for the error dialog that says Software caused socket write error: Connection abort. Most often this error is caused by an incorrect setting for the url parameter. According to the HTTP specification any special characters contained in a URL should be properly escaped or they should be url encoded. Many webmasters attempt to pass additional parameters to the upload handler without taking steps to ensure that the data is properly encoded.

Thus urls such as the ones listed below are all invalid because they contain special characters.

The solution however is trivial. Most web based programming langauges provide function that can properly encode this data for you. For example this function is urlencode() in PHP and URLConnection.encode() in java.

The second major cause of this error is that the connection is disrupted while file upload is in progress. This can happen due to network outages. In some instances this error may be caused by the server closing the connection before upload is complete. This in turn is most often caused by attempting to upload files that exceed the servers configured limits.