Topic "Temporary files, when uploading?"

Author Message


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.

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

$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'.
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 26572
Location: Prague, Czechia
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.
Martin Prikryl

You can post new topics in this forum


What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License