Topic "Temporary files, when uploading?"

Author Message
Dakota

Guest


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'.
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24991
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
Advertisements

You can post new topics in this forum






Search Site

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!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License