Post a reply

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: Temporary files, when uploading?

I'm not exacly sure what you mean. Can you write me the steps that you do that lead to this? Log file can be useful also.
Dakota

Temporary files, when uploading?

I have the feeling, that WinSCP does not copy contents to a temporary file and then replace the original file when uploading.

Today I changed one PHP script.

Before:
//$first=0;
...
$query = "SELECT ... FROM tbl1 s INNER JOIN tbl2 e ON s.sid=e.sid";
...


After:
$first=0;
...
$query = "SELECT ... FROM tbl1 s INNER JOIN tbl2 e ON s.sid=e.sid";
...


The only difference is the removal of two slashes of comment: //$first.

So, exactly when I uploaded the script, someone visited it, and received the following MySQL error:

SELECT ... FROM tbl1 s INNER JOIN tbl2 e ON s.sid=d=e.sid
1054: Unknown column 'd' in 'on clause'


As you can see, in the original query, I don't have a table 'd', and obviously I don't have a construct like 's.sid=d=e.sid'...So, the the only reason that I have in mind is that the query string was 2 signs right before the update and the symbols 'd=' were taken from the end of 's.sid=' producing as a result 's.sid=d=e.sid'.